There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. It is recommended that the Excel file size should not exceed 1GB. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. First, you open a blank document and select a report to use as the document's dataset. 4. Providing Intelligent Cube data. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. To enable or disable dynamic sourcing for an Intelligent Cube. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. for a script with several commands, one of which being a cube publication command, the. x. 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 . 3. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. To Create a Report that Accesses an Intelligent Cube. - Normalize Intelligent Cube data in the. Browse to the filter you want to convert and click Open. Create a report based off the cube in Step 1 that includes the description form for Category. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. The article discusses a known situation in MicroStrategy 10. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Intelligent Cubes. Publish the Intelligent Cube by executing it on either of the nodes. 0. This applies for example to Cubes created via MicroStrategy Web client. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to. 3 - Check the Make Intelligent. Use Cube Advisor to create Intelligent Cubes: 1. 2. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. x - 10. Use Case 4. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. Documentation on the REST API is at developer. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. IS_CUBE_REP_ID. x, updating an Intelligent Cube returns "Cube Manager: number of c… Number of Views 1. The memory used by Intelligence Server is limited by the machine's virtual memory. Integer ID of the project where the Intelligent Cube is stored. Under Refresh type, select one of the following options. MicroStrategy Intelligence Cube. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. STEPS TO REPRODUCE: 1) Add external dataset. For more details on enabling the setting. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Vn (with metric Mn from source cube Cn). Defining Memory Limits for Intelligent CubesThis article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. x - 9. Enable core dumping. 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. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. 0 MicroStrategy releases. " The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. For example, an Intelligent Cube that contains data for the top 200 stores by Profit must be re-calculated every time it is updated, and thus must use the Full Refresh option. Maintaining data access security. The following table summarizes the test results of some test scenarios against Oracle 19c. Dynamic Sourcing. 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. zip file, with the. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. Article Reference Number:The memory used by Intelligence Server is limited by the machine's virtual memory. If desired, user can create a dashboard immediately from the imported data. It stores the non-normalized table into the MicroStrategy. Browse to the filter you want to convert and click Open. Choose File > New > Intelligent Cube. The Modeling service must be configured correctly to use this feature. 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. When using MicroStrategy and Teradata, the best approach is to. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). "The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. e. Also, verify that the /<path_to_the_location>/core. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. Share query results in-memory across multiple dossiers and. the project configuration: ACTION . Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. When an Intelligent Cube is in this status, any reports based on this cube have. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 5. By default, the report template used is the same as the Intelligent Cube's template. Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). Documentation on the REST API is at developer. The. Following are the features, which make intelligent cubes useful. Before MicroStrategy 10. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Published: 4월 6, 2017. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. From the Data menu, select Configure Intelligent Cube. Solution This issue has been addressed in MicroStrategy 2021. Create an attribute element prompt for the. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. Web Open the Settings page (right click the extension and select Options). Add Year Id and Quarter. Both properties are located in the Query Optimizations folder in the VLDB property editor. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. Instantly analyze any amount of data without in-memory limitations of MicroStrategy intelligent data models. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 1. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. Why MicroStrategy Why MicroStrategy; Customer StoriesHyperIntelligence is a new addition to MicroStrategy Workstation that allows analysts to inject analytics and intelligence directly into every user's experience. However, a lot of the advanced functionality requires the good old metadata, and having everything cubed means you will need a shit ton of RAM very quickly. It involves only fetching a portion of the data that the user wants, instead of storing all data in-memory as a normal Intelligent 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. Strong semantic layer to define all the business rules and tightly coupled. Number of Views 5. Exit all Windows applications before beginning the installation process. . The cube is based on a MDX datasource, specifically SAP BW. Öffnen Sie das Workstation-Fenster. Pros and Cons. Create a security filter on the region attribute such as region not in list central. Using Database Write-back Functionality to Enable Decision-Making. 1, Intelligent Cubes have a new feature to update information without republishing it. A document is used to format data from multiple datasets in a single display of presentation quality. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. Cube Limitations. This is controlled by the Python script. The **_objects folder with a size of 277G. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. Modeling is creating information that describes another set of data. Expand the Object Templates category, select General, and from the. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. Creating an Intelligent cube is similar to creating a report. location_path: is the folder where the intelligent cube. In MicroStrategy Developer, right-click on the project and select Project. Choose Data > Configure Intelligent Cube. Edit SQL Transactions in Reports. Intelligence Server Statistics Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Strong semantic layer to define all the business rules and tightly coupled. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. To enable. 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. Rather than returning data from the data warehouse for a. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. Users of Intelligent Cubes in MicroStrategy 9. IS_CUBE_INST_ID. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. A document that uses the Intelligent Cube as a dataset. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. 5 GB . 0: Balance MicroStrategy Server threadsDescription The . Instead, MicroStrategy allow one to reverse engineer and rename a logical table. If the Intelligent Cube must be re-processed based on a metric. It is especially useful when data. 4. 4. In MicroStrategy Web, open the document in Design Mode or Editable Mode. x If the Administrator wants to create a user that is. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. com. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. If a new column is added to the data import data source and the cube is republished, there is no effect. Data modeling is the structuring of an organization's data assets into an applicable logical model. 3. In MicroStrategy Integrity Manager 10. zip and use 7Zip, or similar tools, to unzip it. This import bridge imports MicroStrategy logical tables as Dimensions. Open the Workstation window. What BO customers are interested in knowing 3A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Import and save data from a file in a folder location. You can add data for your Intelligent. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Create a report based on above Cube and add the prompt in view filter. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Select an Environment from the upper-left drop-down. 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. 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. x. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Under VLDB settings > Query Optimizations > Data Population for Intelligent Cubes admins need to test all the following options: - Normalize Intelligent Cube data in the database. Create a report with the year and quarter attributes and the profit metric. 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. x using Command Manager. To build an Intelligent Cube. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. 4. Publish the cube. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. Run both. Type of action against the Intelligent Cube: •In MicroStrategy 11. xThis article describes the Intelligent Cube Population options available in MicroStrategyPlease also see this article for more details: Data Engine changes in MicroStrategy 2021 release Acronym used: "CSI", which stands for "Cube Subsetting Instruction". The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. UPDATE: the refresh policy is Update existing data. In versions prior to MicroStrategy Intelligence Server 9. Check in Developer that the stopped node is in Maintenance Mode. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. Node 1. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to its memory limit. Can. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. Integer ID of the Intelligent Cube report that was published, if any. Otherwise, it will increase the percentage to 200% if the "Maximum % of growth of intelligent cube due to indexes" governing rule. Create a Data Import Live Intelligent Cube. In other words, the new column will NOT get mapped automatically in the existing Intelligent Cube. MicroStrategy version 9. 4. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Traditional Report Caching in MicroStrategy is done on a matching basis. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Use the drop-down under the filter summary section to switch the server nodes. This can be seen even when the actual total memory consumption of the Intelligent Cubes loaded for this Project is below the configured Governing Setting. Datasets API. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). To Create a Report that Accesses an Intelligent Cube. 4. You can control users' access to data with security filters. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Create a dossier and add subset R from Existing Dataset. The Full Refresh option is the default. MicroStrategy logical tables do not necessarily represent physical tables. Save the Cube with Connect Live Data Access Mode. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesSTEPS TO REPRODUCE. KB442449: Dossier Performance: Connect Live performance considerations. Published: Apr 6, 2017. When using an Intelligent Cube, you already have an in memory dataset. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. x and newer. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. However, the cube monitor doesn’t show partition related information. The ability to view or edit certain settings is determined by a user's privileges. On the left side of the page, click Logs and then Export Logs to save the file. Navigate to the Intelligent Cube for which you want to define the incremental refresh. The data used for this example is. In MicroStrategy 10. Open the Workstation window. It is shared by all processes running on the machine, including the operating system. A solution/code fix for this issue is not available in current releases but is. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. the user still needs the privilege for re-publishing Intelligent Cubes, but just need this restricted for particular cubes), while still allowing this user to perform Visual Insight analysis on the cubes information. 2. A set of data is returned from the. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. 4. Choose your environment, project, and Intelligent Cube as your dataset type. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. Upgrade to those versions to take advantage of the fix. iCubes, however, has some limitations and thereby needs to be used judiciously based on the need. Create a Report 'R3' with 'Country' attribute. 4. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The data load process moves this table's information to the IS_CUBE_REP_STATS table, which has. Drill up, down, and sideways to get a 360-view of. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. KB35600: Users are unable to restore attributes' default display settings through the attribute display option in the data menu for an Intelligent Cube in MicroStrategy Developer 9. 1 or above, to pick up the fix, enable project level setting "Data Engine. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. Only one cube file will be generated for each Intelligent cube on disk. To add an existing report or Intelligent Cube as a dataset. x. 4. 0. For more information on Intelligent Cube sizes, refer to the following MicroStrategy Knowledge Base technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. From the Data menu, select Add Dataset. MicroStrategy HyperIntelligence is the next step in the future of data analytics. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Select data population for Intelligent Cubes. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. x, but not to publish it, the minimum privileges that the Administrator would need to. Data Population for Intelligent Cubes. Expand the Object Templates category, select General, and from the Show templates for the. The objects in the source cubes will control how the security filter will be applied. 2. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. There are some further steps after this, including Analytical Engine step, etc. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. To Create an Intelligent Cube Using Freeform SQL or Query Builder. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. Select one: To create a new security filter, click New. Pros and Cons. Republish the same cube, and a new cube instance is generated. x. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. ACTION:In MicroStrategy Intelligence Server, how does the project configuration setting "Load Intelligent Cubes on startup" work in a clustered environment?To Create an Intelligent Cube Using Freeform SQL or Query Builder. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. By default, MicroStrategy Command Manager handles cube publication synchronously (i. Um Cubes zu erstellen, müssen Sie über die folgenden zusätzlichen Privilegien verfügen: Verwenden Sie den Intelligent Cube Editor, um auf alle Merkmale und Funktionen zum Erstellen von Cubes zuzugreifen. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. This will work as a regular SQL comparison In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:Total number of columns: The number of columns of data that the Intelligent Cube contains. Number of Views 523. This import bridge imports MicroStrategy logical tables as Dimensions. 1. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. All necessary privileges are included in the Administrator role by default. E. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Users cannot trigger or schedule cube republishing. Most likely several, different fact tables are uses for each query. For example, Create a report with an attribute with only one attribute form. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. To view an Intelligent Cube stored in your History List. If the Intelligent Cube must be re-processed based on a metric. For more information on security filters, see the System Administration Guide. MicroStrategy is the only comprehensive analytics vendor that supports big data analytics with native connectors to HDFS to access petabytes of data in real time. When you run reports in MicroStrategy, they collect the warehouse data. The view filter cannot filter out other elements as shown below:Data Modeling. microstrategy. In addition, multiple logical tables can represent the same physical table. To do this, edit the report in developer and go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose the new target cube: Create Cube A and a report based on it. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. From the Data menu, select Configure Intelligent Cube. 3. Starting in MicroStrategy 10. Click Select. Refer to the following MicroStrategy Knowledge Base. The requests are granted or denied according to user-configured limits on the amount of. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. 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. x Dynamic sourcing extends the accessibility of Intelligent Cubes by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements. OR, to convert an existing filter into a security filter, click Import. In addition, multiple logical tables can represent the same physical table. You can create and analyze new reports in real time. Starting from MicroStrategy 9. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version. Extensively used “Apply Simple” function for creating attributes. If the indexes are needed again,. Open the. table_id: is the guid of a table. Publish the cube. The **_objects folder with a size of 277G. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. Slice and dice features are awesome. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. x Intelligent Cube status indication and workflow . x, when there are multiple fact tables available to perform the fact extension, different fact table are used by the analytical engine for the fact extension in Connect Live and In-Memory Intelligent Cube.