In the left panel, click Cubes. To display PDF bookmarks with the correct font, the language pack must be installed on the viewer's machine. STEPS TO REPRODUCE: 1. x. Creating Intelligent Cubes is as easy as creating reports. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. 15K. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. You can also apply this security when users create reports that connect to an Intelligent Cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. The fact that the Intelligent Cube resides on the. For example, for a project, result caches on each node that has. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. In order to set this limit, log on to MicroStrategy Desktop/Developer, right click on the desired project, and select “Project Configuration…” Navigate to Intelligent Cubes >> General, and enter your desired limit. Creating an Intelligent cube is similar to creating a report. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. This copy of report data is stored in Intelligence Server memory only. Select the Intelligent Cubes tab. To Create an Intelligent Cube Using Freeform SQL or Query Builder. If you are upgrading to MicroStrategy 11. Intelligent cubes are generated automatically when a new report is run against the data warehouse. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. In MicroStrategy Developer, log in to a project source with administrative privileges. Good Understanding of Intelligent cubes and Data mart design. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. Number of Views 1. MicroStrategy will monitor the data repository and/or cube memory requirement of the Enterprise Manager and/or Platform Analytics. For more details on enabling the setting. x a new concept is introduced called Intelligent Cubes. Browse to an Intelligent Cube, select it, and then click OK. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. This can improve the performance of. From the Edit menu, select Training Metric Wizard. In HTML View and PDF View, a dashboard is displayed as a static document. In MicroStrategy 9. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. In MicroStrategy Developer, log in to a project source with administrative privileges. INTELLIGENT_CUBE_MAX_NO: The maximum number of Intelligent Cubes allowed in the project, returned as an integer. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. Choose File > New > Report. In versions prior to MicroStrategy Intelligence Server 9. metrics in the intelligent cube or in the MicroStrategy schema and application objects. Refresh. Users don’t have to mention the cube to which they want to connect. The Intelligent Cube Monitor is displayed. The Query Engine runs the SQL required to refresh the data in the Intelligent Cube. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. Administering MicroStrategy: Managing the Intelligence Platform Securing user privileges and data access Monitoring and tracking the analytics system. If the Intelligent Cube must be re-processed based on a metric. It depends on the cube. Administer Caches. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 4. "Maintaining data access security. Import and filter data from a OlapCube, SuperCube or Report into a Pandas DataFrame (see code. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. Have full control over result, element, and object caches in a project. An Intelligent Cube is an In-Memory data structure which holds. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Maximum memory usage for Intelligent Cubes (MB) Defines the amount of data required for all Intelligent Cubes to limit the amount of Intelligent Cube data stored in Intelligence Server memory at one time for a project. MicroStrategyMicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 4. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. Export to CSV, Export to PDF, etc). An Enhancement Request for implementing this functionality is. This command will list the table information only when the intelligent cube is a super cube. 1 and 10. However, the images in the report display properly when the report is executed in. DerivedMetrics 182 Creatingaderivedmetric 184 Editingderivedmetrics 203 In MicroStrategy 9. Required Status to Perform Action. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . If you are upgrading to MicroStrategy 11. The ability to view or edit certain settings is determined by a user's privileges. In the Navigation pane, click Applications. Dedicate a machine for the metadata repository. For example, an Intelligent Cube includes Year and Quarter. Publishing Intelligent Cubes. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. 0: PDF export comparison. 6 and higher. The Report Editor opens with all of the objects of the Intelligent Cube. You can add data for your Intelligent. The Intelligence Server generates a query based on the requested information and the received definition. Please contact MicroStrategy Technical Support for an update on this issue. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent. Explain an Intelligent Cube? Instead of returning data from the data warehouse for a single report ,we can return sets of data from our data warehouse and save them directly to Microstrategy. Depending on location set at the project level, one or none of the Intelligence server nodes will be able. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. 2 billion row limit for Intelligent Cubes (240GB cube)Linear scalabilityReduce dependency Sub 5 second response time. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. Subsequently the requests made by other users can. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The first column provides the Intelligent Cube name, and the second column provides the full path to the Command Manager script files used to publish the. Upgrade to those versions to take advantage of the fix. Name the different export. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. For detailed information about Intelligent Cubes. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Allows the user to. Every time that a user does something in MicroStrategy, like. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. What are advantages of cubes? It perform fast It Schedule the Cube It is used for Drilling It helps in Data Sharing. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. They also provide the ability to use ROLAP by drilling into the full set of data outside of the Intelligent Cube. Currently, project duplication does not involve Intelligent Cube File Directory. Intelligent cubes support time zone based reporting. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. If the Intelligent Cube must be re-processed based on a metric. x releases, and the new Multi-table Data Import (MTDI) cubes. However, there are some differences in security filter resolution for reports that connect to Intelligent Cubes as compared to reports that directly access the. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. This provides ROLAP-type analysis without having to re-execute against the data warehouse. mstr file is too large. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. idx file is cleaned up. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. This property can only be enabled through Workstation. You can use Integrity Manager to perform a before and after test to identify which reports actually connect to a suggested Intelligent Cube and also to test data integrity. 4. Intelligent Cubes act as the layer between the data warehouse and MicroStrategy reports that analyze and display. Managing Intelligent Cubes. 0. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is executed in. Privilege. In MicroStrategy Developer, browse to an Intelligent Cube. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. This option allows users to collaborate and develop an application schema over time by merging smaller, independent datasets into one Intelligent Cube. Slice and dice features are awesome. An Intelligent Cube is. The Cube API supports DDA cubes and MDX cubes, in addition to Intelligent cubes. Replace a slice of data in an Intelligent cube using a single incremental cube refresh step. 11 on Unix/Linux Number of Views 2. Build a cube of customer data that’s relevant to all employees and publish it. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. x -10. " If you try to edit these MicroStrategy Connector cubes, you may be. • Meta data that is very scalable and can reach beyond 1TB. 4. 4, MSTR file is an available export format for individual Visual Insight dashboards from MicroStrategy Web and MicroStrategy Desktop. Open the Workstation window. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. Expand Intelligent Cubes, and then select General. View reports vs Cubes as datasetsTo unpublish an Intelligent Cube. Providing Intelligent Cube data. x-2021 Update 1 in a clustered Intelligence servers environment, the following message is seen. Navigate to the Data Refresh category. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. 0. This can be seen in the screenshot below. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. x. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. 3. Open the cube report in Design View. Confidential, Hyderabad, India Dec 03 to. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Par défaut, elle est définie sur 32 000. If the welcome page is shown, review the information and click Next. 1 and 10. Preview Feature: View revamped workflows for object migration. • Optimizi ng performance with Intelligent Cubes • Determining the order of calculation • Sharing reports using export, print, or by subscribing to report deliveries 1. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. 88K KB41697: "The Intelligent Cube must be published before this report can be executed. Number of Views 1. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Intelligent Cubes as datasets. 4. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The Intelligent Cube Options dialog box opens. The Intelligent Cube Options dialog box opens. Choose one of the following options: Full Refresh: This is the default. To enable or disable dynamic sourcing for an Intelligent Cube. As of MicroStrategy Secure Enterprise 10. Main features of mstrio-py allows to access MicroStrategy data: Connect to your MicroStrategy environment using Connection class (see code_snippets) Note: to log into Library and use mstrio-py user needs to have UseLibrary privilege. An Intelligent Cube is a set of data that can be shared as a single in-memory copy, among many different reports created by multiple users. Email subscriptions deliver a report or document to one or more email addresses. INTELLIGENT_CUBE_MAX_RAM: The maximum size in memory of all Intelligent. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. The cube population process could be expensive in time and memory if the cube is large. LIST PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "<intelligent_cube_name>" | GUID <instance_guid>) FOR PROJECT "<project_name>"; An enhancement request has been raised to have the ability to use “cube as trigger”. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Select the Data Partition category. Administer database connections. Published: 4월 6, 2017. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Defining the partition for Super Cubes. x clustered environments. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube must be updated for only one. MicroStrategy Library. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Cube Advisor opens. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. Together with the Reports API, this API is often referred to as the JSON Data API. After upgrading to MicroStrategy 2019 Update 2 or above, republishing a cube created by the MicroStrategy connector may fail and produce the error, "Refreshing dataset failed. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. If you are upgrading to MicroStrategy 11. Appendixes The MicroStrategy Intelligence Server 9. In this video I will explain the different cube refresh options and show you how to refresh Intelligent Cubes using incremental refresh reports in MicroStrat. 1 and 10. CONTENTS 1. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. Because the filters are applied to the master data in the Intelligent. In MicroStrategy 2020, the password can be found in the Default_Accounts. 3. You can also define when Intelligent Cubes. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. x. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. x - 10. Right-click the dataset, and choose Schedule. table_name: is the name of a table. 39. 1 and 10. Integrity Manager can test the SQL of Intelligent Cubes even if they have not been published, but cannot test Intelligent Cube reports based on an unpublished Intelligent Cube. To effectively create a HyperIntelligence dataset, your data must have attributes with either one-to-one relationships or many-to-one relationships. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. Select the data set and click Prepare Data. With Oracle 11g, the integration with Oracle OLAP Cubes is transparent to MicroStrategy, because now cubes can be defined as Materialized Views (MV) and Oracle will rewrite SQL queries to these MV. Select a schedule from the Schedule drop-down list. The Intelligent Cube Monitor is displayed. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions = 12. Consider the following example based on the MicroStrategy Tutorial project. The ability to view or edit certain settings is determined by a user's privileges. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. Users of Intelligent Cubes in MicroStrategy 9. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Create Cube1 with the Region attribute and the metric created in step 1. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. Provides the last cube row count. x. KB485673: When "Create Intelligent Cubes by database connection" is enabled, the cube published with the latest data can't… Number of Views 157 KB484562: Intelligence Cubes are not published via subscriptions to both nodes of cluster in MicroStrategy 2019 and later. 6, users now have the option to select MSTR as the Delivery format for email and file subscriptions as shown below: MicroStrategy Intelligence Server. MicroStrategy 9. x releases, and the new Multi-table Data Import (MTDI) cubes. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. 7 or later, non-distributive metrics do not return correct data because the Engine does double aggregation due to the optimization done in DE81833. KB30072: New feature in MicroStrategy Integrity Manager 9. With OLAP Services features, your report designers can create Intelligent Cube reports. Decision Maker、Intelligent E-Business、Personalized Intelligence Portal、Query Tone、Rapid Application Development、MicroStrategy Intelligent Cubes、The Foundation For Intelligent E-Business 、The Integrated Business Intelligence Platform Built For The Enterprise 、 The Platform For Intelligent E-Business、The Scalable Business. The main purpose of this service is to generate PDF outputs from the information contained inside a dossier or report. In MicroStrategy Integrity Manager 10. 0. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Add or remove nodes in a cluster, and set the default cluster membership. x. This privilege is part of OLAP. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. The VLDB property, Attribute to Join When Key From Neither Side can be Supported by the Other Side becomes obsolete once you upgrade your data engine version to 2021. grouping attributes MicroStrategy Cloud Creating attributes on dossiers Filtering reports, metrics, and attribute groups Filtering dossiers Improving performance with intelligent cubes Preparing complex data for enhanced storytelling Visualizing, filtering, and linking your data Designing documents Building enterprise mobile applications Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. MicroStrategy 9. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. Click the “Add history list subscription” link near the bottom of the screen to open the. Published: Jun 29, 2018;Data Population for Intelligent Cubes. This Knowledge base article describes how when creating an Intelligence cubes using functions that pass through the database return "There is no data for this result. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. Introduction to visual insight microstrategy visual. Intelligent cubes are generated automatically when a new report is run against the data warehouse. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Results 1 - 20 of 100 What are the feature flag options and what do they accomplish in MicroStrategy Web 10. Main Features. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. For more information on the Intelligent Cube Maximum. To that end, we’ve designed a program of continuous training and certification for every role in your Intelligent Enterprise. • Reports can consist of documents with customized HTML format. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. Select data population for Intelligent Cubes. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. " If you try to edit these MicroStrategy Connector cubes, you may be asked to log into the Library server. This technical document covers a known issue affecting MicroStrategy Secure Analytics Enterprise 10. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. Chapter 7: Improving Performance with Intelligent Cubes Chapter 8: Preparing Complex Data for Enhanced Storytelling Chapter 9: Creating Workflows for Efficient. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. KB442630: CSI optimization for improving the in-memory query execution for many. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. KB46934: Reports created from a MicroStrategy Data Import Intelligent cube are hidden in MicroStrategy Web. KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. Solution:If you have a Distribution Services license, you can subscribe multiple users to an individual report or document through MicroStrategy Web (see To Create a Subscription in MicroStrategy Web). KB314273: Response regarding replacement of interactive PDF and MHT files . The Platform Analytics project comes with three Intelligence Cubes that support nine Dossiers that can be run right after installation to check if everything is functioning properly. Edit Intelligent Cubes from the new editor in Workstation at any time. 1 and 10. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. Due to data privacy considerations, MicroStrategy doesAs the new default monitoring tool for the MicroStrategy platform, Platform Analytics has a slightly different attribute structure to Enterprise Manager. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. Administering MicroStrategy: Managing the Intelligence Platform User privileges and data access Monitoring and tracking the analytics system Administering MicroStrategy Mobile. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. Due to the architecture of the MicroStrategy platform, if a customer chooses to utilize caching and intelligence cube capabilities, then application data files that are at-rest are backed up on MicroStrategy-managed Intelligence Servers for a minimum period of five days. 1 and 10. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. The Intelligent Cube refresh settings are recommended if the data in the. The storage for Intelligent Cubes was not setup properly. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. Note that this document does NOT provide a value for all the given settings but provides a list of all possible settings that can help improve the Cube Publication times. In addition to creating reports directly, you can use the Freeform SQL Editor or Query Builder Editor to create an Intelligent Cube. In the Data Source column, select the checkboxes for the tables to update.