These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 4. mstr) file size (MB) setting. KB5370: What does each cache status mean in MicroStrategy Intelligence Server 9. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. x. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Dedicate a machine for the metadata repository. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. 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. Web XML API log. Because a single Intelligent Cube cannot connect to more than one data warehouse, using a. Publish the Intelligent Cube by executing it on either of the nodes. 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. 4. KB41988: Is it possible to add prompts to Intelligent Cubes in MicroStrategy Developer 9. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. 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. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. x. The default value is 256 megabytes. 1K. Navigate to the Data Refresh category. Dedicate a machine for the metadata repository. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. 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. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. It performs reporting requests through windows, web, and remote interfaces. Create an attribute element prompt for the. the project configuration: ACTION . Required Status to Perform Action. Job ID for the action on the Intelligent Cube. 1319 views | February 11, 2021 45:05. 1To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. This article outlines some best practices for HyperWeb performance optimization in MicroStrategy 2021. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. 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. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. 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. 0. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. Dedicate a machine for the metadata repository. 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". Refer to Product Manual for more detailed information. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. x. 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. x: Ability to encrypt cache files stored to disk. Intelligent Cube design and utilization; how to build cubes, schedule them,. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. This article describes best practices to be taken when using a Teradata database in MicroStrategy. For details, please refer to the Technical Note below. Then, select a page from a different dossier that you want to filter as the target. Number of Views 18. Publisher (s): Packt Publishing. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. Intelligent Cubes Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. Privileges are given on a per-user basis, some of which are also per-Application. All the attribute forms are in bold type and will display in Intelligent cube reports. x. 4. 18K. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Watch on. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. 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. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Best practices for supporting dynamic sourcing. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. Select a database configured for SAP HANA. You can edit project-level cache and Intelligent Cube settings. 3. It must be ensured that the Windows NT account used to run the MicroStrategy Intelligence Server on every node has access to the shared folders. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. Tell a story with your data using the dossier chapter/page format. An Enhancement Request for implementing this functionality is. To learn more about Super Cubes and relevant best practices, refer to the following Community Article:In MicroStrategy 11. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. x - 10. 84K KB441987: Best Practices for increasing performance of publishing large Intelligent CubesAn Intelligent Cube report is created in MicroStrategy 9. To learn more about Super Cubes and relevant best practices, refer to the following Community Article: Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. x product documentation "InMemoryAnalytics. The report retrieves data from Cube B now. Create Cube A and a report based on it. Lastly, you will learn to use Hadoop for MicroStrategy reporting. The Schedule dialog box opens for your dataset, showing the tables in your dataset. view reports. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Expand Intelligent Cubes, and then select General. In MicroStrategy Desktop 9. It depends on the cube. Complete the "sessionState" field (e. x - 10. Afterwards MTDI cubes should appear as visible from default. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 438832. Text and CSV files: Varies depending on the Intelligence Server memory. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. x. 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. Person-centred care is a collaborative approach in which health care professionals’ partner with patients to deliver personalized care with a focus on physical. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. 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. Description: Intelligent Cube design and utilization; how to build cubes. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 11, a new feature is available for performance optimization when dealing with derived attributes. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. 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. Getting Started with MicroStrategy. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more. 1. x Number of Views 8. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. The Intelligent Cube opens in the Report Editor. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. By default, the location configured will be a relative path where ". 0. Conditional metrics. MicroStrategy provides modern analytics on an open, comprehensive enterprise platform used by many of the […] This article describes best practices to be taken when using a Teradata database in MicroStrategy. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions:. Create Intelligent Cube Sharing Intelligent Cubes Enable ROLAP Enable Dynamic Source How to do Incremental Refresh. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn Enterprise Manager 10. 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. Publish the Intelligent Cube by executing it on either of the nodes. x - 10. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. Resources Company Bitcoin Lightning Home Published: August 11, 2022 • 619 Views Advanced Properties for Intelligent Cubes MicroStrategy Workstation. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. KB36667: Best practices for Dynamic Sourcing in MicroStrategy. The steps to create an intelligent cube are as follows: Navigate to the folder where you want to create an intelligent cube; the best practice is to create it under Public Objects | Reports . Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. 929 views · January 17, 2021. Refer to Knowledge Base article below for cube status introduction: KB47799: What is the "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer CAUSE: Same thread maybe shared to load Cube Info and Cube instance while loading Cube Instance with big size may block the process of loading Cube Info waiting in the queue. 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? 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 Busin ess Intelligence Platform To enable or disable dynamic sourcing for an Intelligent Cube. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. In MicroStrategy Command Manager 10. In MicroStrategy 10. 3. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. 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. When an Intelligent Cube is in this status, any reports based on this cube have. In MicroStrategy Desktop 9. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. 4. 0. You should periodically reevaluate the system and. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. 4. Before MicroStrategy 10. SHOPMAN, powered by MicroStrategy, delivers sensor data, inventory management, and financial data to enable users make data-driven. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. 4. x and 10. To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor, select Create Freeform SQL report. This can be encountered when you're dealing with raw data volumes which have not yet been processed through an ETL. 2. 3. Number of Views 3. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. Intelligent Cubes. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. 3. 3. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. Getting Started with MicroStrategy; Modern BI; BI project life cycle; Meet MicroStrategy 10; Deploying MicroStrategy 10; BI tips; Summary; 2. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. Published August 27, 2020 By akrish1982. KB442424: Best Practices for MicroStrategy Messaging Services. g. For background, we will give a brief introduction about each. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. The first step in analyzing. A document is used to format data from multiple datasets in a single display of presentation quality. x: Back up metadata before copying any objects. Module 14: Practices on MicroStrategy Best . Number of Views 8. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. They were used to improve subsequent query. Instead of always executing against the data warehouse. The Intelligent Cube Options dialog box opens. KB33244: Are there any limits imposed on Intelligent Cube size in. Best practices for mapping MDX. Performance also refers to the speed of loading or rendering data via in-built features like scanning,. Derived metrics are easy to create and can be made on-the-fly when you are viewing or creating a report, allowing you to create a metric while focusing on a given report. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Best practices for mapping MDX. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. Once activated, the user loads the cube in memory. Support. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. 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. Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. 10. 4. STEPS TO REPRODUCE: 1) Add external dataset. For example, these reports go from basic execution pointers, quarterly deals by item. The ability to view or edit certain settings is determined by a user's privileges. Community & Support Search Discussions Open A Case View My CasesThere are some Enhancement Requests opened to improve the behavior, which is to make cubes accessible by remote nodes after restarting a single node. 4. Hardware requirements and recommendations. Click All Objects View. How to Import Data from a SAP HANA Database Into MicroStrategy Web. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. Intelligent Cube Using Microstrategy 9. An Intelligent Cube has been created in a project. By the end of the book, you will become proficient in evaluating any BI software in order to choose the best one that meets all business requirements. rare practice (British Columbia Ministry of Education, 2011, p. To achieve the best performance possible, it's important to delete all unused objects like datasets, visualizations, tabs (for VIs. KB441236. Designing and creating documents: An overview. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. 3. Memory Storage for document or dossier. To Create an Intelligent Cube Using Freeform SQL or Query Builder. intelligent cube use cases, and cube optimization techniques with MicroStrategy. 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. x) or OLAP (first generation of in memory cubes, introduced in 9. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. . The status of each Intelligent Cube is listed in the. Connectivity. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. 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. All necessary privileges are included in the Administrator role by default. 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. 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. Query Generation 3. Save the Report and close. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 4: Persisted. Connectivity. 4. 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. x. . In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 2) Choose "Database" and select the 3rd option to "Pick tables". Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Click the MicroStrategy icon at the upper left of any page and select History List. 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. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. 3 - Check the Make Intelligent. It will track and log all. x releases, and the new Multi-table Data Import (MTDI) cubes. Prompts in a report. The target visualizations only display data that also appears in the source. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. x environment, Cache Hit Count or the Last Hit Time of a. 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. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. It happens in MicroStrategy Developer 9. These are meant to restrict the ability to perform certain privileged actions. 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. 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. Create a Report 'R3' with 'Country' attribute. -10. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. The dataset is a set of data that can be displayed on the document. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. These reports allow data to be returned from the. x and 10. Why MicroStrategy Why MicroStrategy; Customer StoriesMaintaining data access security. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. The Training Metric Wizard opens. IS_CUBE_REP_ID. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. x Intelligent Cubes. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. ISBN: 9781785884405. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and cube optimization techniques for MicroStrategy. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. Available PA data is stored in the cube that has a default limit set to 20GB or RAM. From the Data menu, select Configure Intelligent Cube. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. McLean, Va. The Full Refresh option is the default. Version 9. Select data population for Intelligent Cubes. It improves 30% performance in. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. This can be achieved via the report level VLDB property > SQL Time. For detailed information refer to the System Administration Help. If the Intelligent Cube must be re-processed based on a metric. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. * MicroStrategy does have support for dynamic sourcing with MDX sources. Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. 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'. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. This command will list the table information only when the intelligent cube is a super cube. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. 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. 4. Change Journaling is enabled by default since MicroStrategy version 10. SAP HANA Query Execution. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. First, you open a blank document and select a report to use as the document's dataset. In Developer, log in to a project with a user account with administrative privileges. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Create Cube B which contains all objects in the report and publish it . 3. You should periodically reevaluate the system and update it based on actual system performance and use. Click Create and choose Add External Data. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Number of Views 5. x and later, users should make sure to take into account the following. First, define one visualization as the source. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 38K. For an Intelligent Cube to satisfy the data requirements of a report, the Intelligent Cube and report must have matching settings for VLDB properties that can affect the data that. If you use Enterprise Manager, dedicate a machine for the Enterprise Manager. MicroStrategy Platform-intelligence server is an improved testing system for big business questions. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. 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. x. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. PlatformAnalytics. This documentation is intended to provide some guidelines for BI administrators to maintain Messaging Services. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. Intelligent Cube Using Microstrategy 9. 8 to help improve the performance of Quick Search on MicroStrategy Web. Retail Optimize sales across channels. MDX Cube Reporting Guide Version 10. Required Status to Perform Action. Click 'Add External Data' and then 'File From Disk'. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). MicroStrategy is an enterprise business intelligence (BI) application software vendor. In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. MicroStrategy Dossier Design Best Practices for Performance.