To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor, select Create Freeform SQL report. The. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. . MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines Place. Recommended for Platform Administrators, System Administrators, and Intelligence Directors, this session provides a foundational understanding of how Platform Analytics works and the reporting capabilities it offers. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. x - 10. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. Number of Views 1. 7. Part 1. Take a Data Import Cube similar to below. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. 12K. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. The following diagram depicts the role of the intelligent cube. 13K KB31566: MicroStrategy 9. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. x, it is possible for administrators to setup encryption of result caches that are saved to disk. The considerations and steps required to fully support dynamic sourcing are listed below: While many MicroStrategy features can be used with dynamic sourcing, some features may prevent the use of dynamic sourcing between reports and Intelligent Cubes. Document number: 09481030Our product specialists walk you through best practices for successfully setting up and configuring the out-of-the-box tool Platform Analytics tool. Change Journaling is enabled by default since MicroStrategy version 10. x Attributes used in the filter should also be on the Intelligent Cube’s definition. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. Because every company is a data company—no matter which market it competes in. Using. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. Creating an Intelligent cube is similar to creating a report. Version 9. Starting in MicroStrategy 10. 929 views · January 17, 2021. Learn more about it at MicroStrategy. 4. The tooltip will show the dataset type listed as a Super Cube. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. Number of Views 18. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. If you use Enterprise Manager, dedicate a machine for the Enterprise. MicroStrategy recommends the following best practices to keep your system running smoothly and efficiently: Use the project life cycle of development, testing, production to fully test your reports, metrics, and other objects before releasing them to users. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. Existing best practice recommendations for needle and syringe programs are out of date. Currently, project duplication does not involve Intelligent Cube File Directory. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. To Create an Intelligent Cube Using Freeform SQL or Query Builder. application performance and security best practices. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. Definition. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. The Intelligent Cube that serves as the source for the example view report is configured to normalize incoming attribute data in the database using the option "Normalize Intelligent Cube data basing on dimensions with NO attribute. OLAP vs MTDI and Best Practices. Save the dataset as Employee Dataset. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Generate Oracle AWR report or monitor the database to identify the low performance query. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Publish the cube. 2. view reports. By moving the cursor over the microchart, a tooltip is displayed that lists the various reports that could connect to the Intelligent Cube using dynamic sourcing. ” in the Help menu of your software. IS_CUBE_REP_ID. Create Intelligent Cube Sharing Intelligent Cubes Enable ROLAP Enable Dynamic Source How to do Incremental Refresh. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. Best practices: Importing data into MicroStrategy Web; Importing data from a data source; Previewing, modifying, and refining your data before importing; Editing, republishing, and linking imported data; Configuring OAuth parameters for data sources integrated using Data Import; Scheduling updates for an Intelligent Cube created using imported dataThis issue has been classified as a none defect by MicroStrategy. CAUSE: This is working as designed. When we mention performance, we mean the speed by which HyperWeb scans keywords to present data via HyperIntelligence cards. Intelligent Cube design and utilization; how to build cubes, schedule them,. Click All Objects View. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in. 8. Number of Views 15. xIn 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. KB31566: MicroStrategy 9. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Share query results in-memory across multiple dossiers and. Prerequisites to creating Intelligent Cubes. #Microstrategy Best Practices; #Microstrategy custom group; #Microstrategy dashboard; #Microstrategy delimited file; #microstrategy filter;Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. com Format: A MicroStrategy Online Training Video blog. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. MicroStrategy Internal Reference number for this technical note is KB483620 and DE128512. In MicroStrategy 10. x) and view reports based on MicroStrategy 9. You can add data for your Intelligent. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. 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. Transformation metrics, under the following conditions: -A metric with the same formula and transformation exists in the Intelligent Cube. x - 10. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. Click Create and choose Add External Data. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. x. This command can get the correct cube status and table status only when the cube is being refreshed or published in the same session between Command Manager and Intelligence Server as this command's. MDX Cube Reporting Guide Version 10. Result caches: Report and document results that have already been calculated and processed, that are stored on the Intelligence Server machine so they can be retrieved more quickly than re-executing the request against the data warehouse. Likewise, Analysis Services, Oracle Essbase, and TM1 store data. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. KB442526. Dossier shows different data when In-Memory Intelligent Cube dataset is changed to Live mode. Performance also refers to the speed of loading or rendering data via in-built features like scanning,. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Disconnect from the project source and restart both Intelligence servers. 4. The cube population process is the one that retrieves the information from the Warehouse and transfer it to the MicroStrategy Intelligence Server memory in a format which can readily be consumed by different reports requests. 10. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. In MicroStrategy Desktop 9. x-10. A set of data is returned from the. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. KB41988: Is it possible to add prompts to Intelligent Cubes in MicroStrategy Developer 9. In Intelligent Cube editor, the default display attribute forms cannot be modified after choosing "Use the following attribute forms" and adding a new attribute form in "Attribute Display". When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. Either import tables using Warehouse Catalog in MicroStrategy Developer or create Intelligent Cubes directly using MicroStrategy Web Data Import with the 'Databases' option. Author (s): Dmitry Anoshin, Himani Rana, Ning Ma. 929 views · January 17, 2021 These Intelligent Cubes are created in a folder along with shortcuts to all the reports that can connect to the Intelligent Cube using dynamic sourcing. If the Intelligent Cube must be re-processed based on a metric. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. In direct connection deployments, client products (such as MicroStrategy Developer) should also. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. In MicroStrategy 10. 35K. x - 10. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. Best Practices Privileges and Security Access in Workstation MicroStrategy has a rich security model that consists of three major components - privileges, security filters, and permissions. 2. Use MicroStrategy Developer, Office, or Web. x and newer? Number of Views 4. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. x, create a simple Intelligent Cube with attribute Category and metric Revenue. KB485159: Enable support for Security Filter with Top and Bottom Range Attributes in Data Import Intelligent cubes and Fix the security hole in Connect Live Data Import Intelligent cubes MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). In the Data Source column, select the checkboxes for the tables to update. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. SAP HANA Query Execution. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. 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. MicroStrategy’s In-memory technology is engineered to meet the. KB441987: Best Practices for increasing. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. The cube population process could be expensive in time and memory if the cube is large. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Cause This is a known issue with. Then, select a page from a different dossier that you want to filter as the target. Details on MicroStrategy recommendations can be found in this TN. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Expand the Object Templates category, select General, and from the Show templates for the. (Titled: "Cube broken aplysimple") No data is returned the following SQL view is seen: Report: cube broken applysimple Job: 198 Total Number of Passes: 1 Number of Intelligent Cube SQL Passes: 1 Number of Analytical Passes: 0 Intelligent Cubes Accessed:The Incremental Refresh feature allows users to update cube information without having to republish the entire cube. From the Data menu, select Configure Intelligent Cube. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. To create an Intelligent Cube by creating XQuery. This. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. 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. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. OLAP cubes best practices. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Number of Intelligent. A document is used to format data from multiple datasets in a single display of presentation quality. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. These. . The range of analytical functionality of MicroStrategy is supplemented by the features and processing power provided by SQL Data Warehouse. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Once activated, the user loads the cube in memory. The ID is found with the heading. 2. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. On the toolbar, choose Data > Configure Intelligent Cube. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). Publish the Intelligent Cube by executing it on either of the nodes. 0. Published: Dec 31, 2018; Last updated: Jul 25, 2023Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. 4. In the Refresh Policy column, choose one of the following options:The MicroStrategy Intelligence Server will execute all children datasets on the dashboard by either generating SQL and running this against the data warehouse, or by fetching data from a cache. Using Object Manager, the above cube based reports are migrated into Production. ACTION: 1. If you are using or plan to use MicroStrategy Intelligent Cubes, and you plan to implement data internationalization, it is recommended that you use a SQL-based DI model. To identify if your cube is MTDI or OLAP it’s really simple, if the cube was created through the Data Import Web Interface (“Add External Data” section on MicroStrategy Web. KB441236. Description. This data is stored in cubes or other SAP objects. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. Published: May 29, 2019; Last updated: Oct 29, 2019; Related versions: To build an Intelligent Cube. STEPS TO REPRODUCE: 1) Add external dataset. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. You should periodically reevaluate the system and. Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. This article outlines some best practices for HyperWeb performance optimization in MicroStrategy 2021. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 29K. What are the methods to implement Intelligent cube technology in MicroStrategy? Intelligent cubes allow a user to access OLAP service features on reports, a shared set of data can be shared among multiple reports. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. 84K. The Intelligent Cube Options dialog box opens. We’ll summarize how you can use collected data to help you effectively and efficiently manage and maintain peak performance across your MicroStrategy ecosystem, and walk you through tips and. This can be achieved via the report level VLDB property > SQL Time. Our MicroStrategy certification training helps you to learn the basics of MicroStrategy, so you can easily apply what you’ve learned in the real world. Because a single Intelligent Cube cannot connect to more than one data warehouse, using a. VI). x Intelligent Cube status indication and workflow. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. Rather than returning data from the data warehouse for a. Creating an Intelligent cube is similar to creating a report. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. Prompts in a report. This includes "Personalized Intelligent Cube" reports (which have the same structure as OLAP Services reports in MicroStrategy 8. Since this is the first time the cube and cube based objects are being migrated into Production, there is no conflict resolution and all the new objects are copied into. 15K. 38K. From the results of single cube publish testing which records and compares the time spent for a single cube (4M rows) republish, JDBC driver has better performance than ODBC driver. x-10. 4. x, but not to publish it, the minimum privileges that the Administrator would need to. x to 11. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. x a new concept is introduced called Intelligent Cubes. This command will deactivate the Intelligent Cube cache so reports from this Intelligent Cube will not be able to run while it is being re-published. File from URL: Unlimited. Edit Project-Level Cache and Intelligent Cube Settings. x?The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. 4. The maximum file size of dashboard (. MicroStrategy Dossier Design Best Practices for Performance. By default, the template is 3x3. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions:. With OLAP Services features, your report designers can create Intelligent Cube reports. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. 3. Integer ID of the Intelligent Cube report that was published, if any. DESCRIPTION: Starting MicroStrategy 10. This documentation is intended to provide some guidelines for BI administrators to maintain Messaging Services. 4. Choose one of the following options: Full Refresh: This is the default. Object Manager cannot undo the copying and replacing of objects. Number of Views 2. Available PA data is stored in the cube that has a default limit set to 20GB or RAM. 11 it is possible to have split child hierarchy attributes join through a shared fact table rather than through a parent with Data Import Cubes. 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. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. . This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. The path for cube files must be shared as "ClusterCube". mtc is the name of the saved test file. x ODBC calls by default. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. Hands-On Learning in MicroStrategy. Instead of always executing against the data warehouse. 1. By default, the location configured will be a relative path where ". If prompting is not a requirement for this dataset then the best method to improve performance is to directly utilize the Intelligent Cube within the Dossier to reduce both the. Published: Dec 31, 2018; Last updated: Jul 25, 2023 Intelligence Everywhere. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. What to read next? Nothing to see here. Designing and creating documents: An overview. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the. The Data Transfer Rate varies from 27 to 28 Mb/s. All articles. 4: Persisted. Getting Started with MicroStrategy. KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best Practices . Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 5K KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best PracticesMicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Watch on. Will it affect the performance of already existing MicroStrategy components?How to Start and Stop Intelligence Server Services in Microstrategy By Mohan Vamsi PentakotaOverview of MicroStrategy Training in Chennai. Watch on. Education. When you choose to filter data within another dossier, you also have the option to pass the filter conditions in the source dossier to the. This section describes only the most basic guidelines. GUID of the Intelligent Cube instance in memory. Designing and creating documents: An overview. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. Open the Workstation window. MicroStrategy 9. This paper provides an overview of MicroStrategy and Azure SQL Data Warehouse (SQL DW) architectures and best practices for integrating the two technologies to deliver business intelligence at scale. als Berichtsobjekte oder Berichtsfilter einschließen. If you need to delegate administrative responsibilities among several people, create a. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. This presentation helps users understand MicroStrategy's in-memory architecture. A bar in the microchart represents that the report is covered by the Intelligent Cube and no bar means that report is not covered by the Intelligent Cube. Job ID for the action on the Intelligent Cube. Expand Intelligent Cubes, and then select General. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. blogspot. Release date: July 2016. Best practices for mapping MDX. Place intelligence server close to the both the data warehouse and the metadata repository. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Now that that’s settled, let’s jump into some best practices for. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more. 27K. Number of Views 611 KB46313: In a clustered environment, Intelligent Cube sizes are varied on different nodes of the cluster in the Intelligen…510 Ratings. Consider a data import dataset which has been imported into MicroStrategy. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Go to the Intelligent Cube monitor to identify the cube instance ID: under the three-tier project source, Administration > System Monitors > Caches > Intelligent Cubes. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. 0 has a dedicated section to memory used for Intelligent Cubes. 1. Before MicroStrategy 2020, when using multiple tables cube and use fact extension, the Engine can generate multiple temp tables while there is a join path to use only one temporary table, which leads to an extra temporary table and impacts the. Best practices for supporting dynamic sourcing. For best practices on compatibility and interoperability, as it relates to upgrading a MicroStrategy system,. Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. In MicroStrategy Desktop 9. Choose File > New > Intelligent Cube. It illustrates tips and tricks, such as enabling parallel data fetch, enabling the correct number of partitions, enabling partition on the appropriate attribute, and using cubes vs. These Intelligent Cubes are created in a folder along with shortcuts to all the reports that can connect to the Intelligent Cube using dynamic sourcing. How to configure, monitor, and manage Intelligent Cubes. Starting in MicroStrategy 10. rare practice (British Columbia Ministry of Education, 2011, p. IsCubeRepStats, but not in PA warehouse tables LU_CACHE or fact_latest_cube_cache . 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 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. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). This article describes a limitation of partitioning when used with database side normalized Intelligent CubesIn MicroStrategy 9. This value can be adjusted in the PA project settings. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Publisher (s): Packt Publishing. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. Create a Report 'R3' with 'Country' attribute. x-10. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. KB5370: What does each cache status mean in MicroStrategy Intelligence Server 9. A typical case is to create a derived metric to perform calculations between columns of metric data. 4. Please make sure that this is disabled. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load processes. Before MicroStrategy 10. x improves the performance of user reports by executing reports against published Intelligent Cubes, when the SQL generation engine is able to determine that the cube contains all information required for the report. In MicroStrategy Developer or Web, log in to a project that contains Intelligent Cube reports. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes"Best Practices Super Cubes in MicroStrategy 2019. Check the location of the new cube cache and notice that it is saved in the default location, i. A document that uses the Intelligent Cube as a dataset. Number of Views 5. To enable or disable dynamic sourcing for an Intelligent Cube. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9.