x. x, but not to publish it, the minimum privileges that the Administrator would need to. A dataset is a set of data that can be displayed on a document. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. An Intelligent Cube is an In-Memory data structure which. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version shown in “About MicroStrategy. After completing your certification, you’ll receive a digital badge that highlights your accomplishment, which you can post on social media. 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. The. CAUSE: This is working as designed. 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. 4. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. ACTION:15. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. A report that runs against the Intelligent Cube. Object Migration Best Practices. PlatformAnalytics. A document is used to format data from multiple datasets in a single display of presentation quality. Number of Views 15. 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. However unlike MicroStrategy it cannot join data between different cubes into the a single visualization. 0. The target visualizations only display data that also appears in the source. They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. The MicroStrategy Cloud Environment (MCE or MicroStrategy Cloud) is a platform-as-a-service (PaaS) offering that MicroStrategy manages on its customers’ behalf as a unique Amazon Web Services (AWS) or Microsoft Azure implementation. The range of analytical functionality of MicroStrategy is supplemented by the features and processing power provided by SQL Data Warehouse. Microstrategy Dossiers With the release of MicroStrategy 10. 4. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. 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. Number of Views 2. Number of Views 8. 88K. The following diagram depicts the role of the intelligent cube. The first step in analyzing. Prerequisites to creating Intelligent Cubes. Tell a story with your data using the dossier chapter/page format. To enable or disable dynamic sourcing for an Intelligent Cube. 18K. x Attributes used in the filter should also be on the Intelligent Cube’s definition. Updating Intelligent Cubes without re-processing: Incremental Refresh. Number of Views 15. 4. 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. The ODBC connection uses 3. Refer to Product Manual for more detailed information. with Gateway Agent enabled and disabled. IS_CUBE_REP_ID. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. For details, please refer to the Technical Note below. 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. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. ISBN: 9781785884405. x and 10. Supported data structure and distribution on Gateway. Select a database configured for SAP HANA. x: Ability to encrypt cache files stored to disk. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy environment. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. 1180 views | February 10, 2021 29:25. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. x and newer? Number of Views 4. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. Our MicroStrategy Admin certification training course lets you master MicroStrategy administration. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Number of Views 3. IS_CUBE_REP_ID. x and later, users should make sure to take into account the following. 84K KB441987: Best Practices for increasing performance of publishing large Intelligent CubesAn Intelligent Cube report is created in MicroStrategy 9. To stay current with the best available scientific evidence and ensure that people have. IsCubeRepStats, but not in PA warehouse tables LU_CACHE or fact_latest_cube_cache . Right mouse click on the cube, and “Search for dependent subscriptions” as shown below; it shows two subscriptions have been created based on the Intelligent Cube. The Full Refresh option is the default. x. Description. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Number of Views 15. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. First, you open a blank document and select a report to use as the document's dataset. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. The Training Metric Wizard opens. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. Web log. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Using. 1K. Intelligent Cubes can function in a similar fashion to result caches: they. Designing and creating documents: An overview. Description Starting in MicroStrategy 2021 Update 1, you can connect to the on-premise database from the MicroStrategy cloud via Gateway Agent. This value can be adjusted in the PA project settings. When an Intelligent Cube is in this status, any reports based on this cube have. For best practices on compatibility and interoperability, as it relates to upgrading a MicroStrategy system,. 1 To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. The status of each Intelligent Cube is listed in the. 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. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. It happens in MicroStrategy Developer 9. 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. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. Afterwards the cube will start executing. Published: How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. For example, if the Intelligent Cube contains data for 2008, 2009 and 2010, and the filter or report returns data for 2009, all the data for 2009 is deleted from the cube. 8: Monitoring information dirty. 3. In MicroStrategy 10. g. McLean, Va. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. 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. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines Place. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Once activated, the user loads the cube in memory. x: Back up metadata before copying any objects. 3. 11, a new feature is available for performance optimization when dealing with derived attributes. The GUID is part of the project's Intelligent Cube directory path. Published: Apr 6, 2017. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Counts the number of jobs from reports not based on Intelligent Cubes but selected by the engine to go against an Intelligent Cube because the objects on the report matched what is on the Intelligent Cube. You should periodically reevaluate the system and. Start Learning with us ACTE MicroStrategy. Click OK. This practice is a good option if Intelligent Cubes are supported for a project, but some of the Intelligent Cubes are rarely used in the project. Connectivity. 1319 views | February 11, 2021 45:05. MDX, CSI" in Web. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. In MicroStrategy, users can trace MicroStrategy Intelligent Cube activity via the Cube Server Trace which can be enabled through MicroStrategy Diagnositcs Configuration as seen below: The following section displays excerpt from the Cube Server trace when different actions are performed on the MicroStrategy Intelligent Cube. Click 'Add External Data' and then 'File From Disk'. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. OLAP cubes best practices. Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence ServerThis article describes features that are not supported when using Dynamic Sourcing. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. If you use Enterprise Manager, dedicate a machine for the Enterprise Manager. Because every company is a data company—no matter which market it competes in. Intelligent Cubes erstellen. 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. Create an attribute element prompt for the. In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. To do so, you can take advantage of URL API. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. In a MicroStrategy Web dashboard, from the File menu, choose Dashboard Properties. Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. Cause This is a known issue with. KB439693: Best practices for MicroStrategy 10. KB442424: Best Practices for MicroStrategy Messaging Services. Memory Storage for document or dossier. Shipped vs Native. x) or OLAP (first generation of in memory cubes, introduced in 9. Publish the cube. Save the Report and close. Click the MicroStrategy icon at the upper left of any page and select History List. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the Object. 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. 0, the only way to create an intelligent cube (also. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. x ODBC calls by default. 46K. You will also work on real-world projects to gain hands-on experience. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. Refer to the following sections for a list of features that can and cannot be used with. Job ID for the action on the Intelligent Cube. 35K. Select Intelligent Cubes > General > Intelligent Cube File directory. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. 4. Take a Data Import Cube similar to below. While some duplicate columns in a MicroStrategy schema are necessary or benign, a user may experience issues that require the assistance of Technical Support in. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. Version 10. The Intelligent Cube Options dialog box opens. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. Rather than returning data from the data warehouse for a single. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. 0. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. It is capable to deal with the high formatted reports and. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. 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. x MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. Best Practices for MicroStrategy Messaging Services. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. You can edit project-level cache and Intelligent Cube settings. A typical case is to create a derived metric to perform calculations between columns of metric data. These reports allow data to be returned from the. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Hands-On Learning in MicroStrategy. 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. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. The Java XML API log will record all the XML communications between Intelligence Server and Web. blogspot. The second part discusses the common challenges and better practices on using Snowflake as a warehouse in MicroStrategy, and the third part discusses making it available to business users and self-service users. The report and Intelligent Cube must be based on the same source MDX cube. Rather than returning data from the warehouse, if it is placed in the memory (pre-cached), so the. xMicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. An Intelligent Cube has been created in a project. You should periodically reevaluate the system and update it based on actual system performance and use. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformHello<br><br>Please allow me to elucidate how my data analyst skills can significantly contribute to your organisation's business growth. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. 3. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. File from URL: Unlimited. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Go to the "All Objects View" option in the top left corner. Either import tables using Warehouse Catalog in MicroStrategy Developer or create Intelligent Cubes directly using MicroStrategy Web Data Import with the 'Databases' option. Using attributes defined in this way can save space as compared to attributes that use character strings for their ID forms. 4. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. x. 4. In MicroStrategy 10. Expand Intelligent Cubes, and then select General. Creating an Intelligent cube is similar to creating a report. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 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. This technical note outlines how to set. Overview. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. The Intelligent Cube Options dialog box opens. Set the path for the cube cache file directory to . Afterwards MTDI cubes should appear as visible from default. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . This. 3. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Starting in MicroStrategy 10. This is the most popular MicroStrategy Interview Question asked in an interview. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. This article describes best practices to be taken when using a Teradata database in MicroStrategy. -10. Starting in MicroStrategy 10. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Generate Oracle AWR report or monitor the database to identify the low performance query. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. KB14009: In a clustered MicroStrategy Intelligence Server 9. In MicroStrategy Desktop 9. This can be done in one node of the cluster because the information is stored in the metadata then used. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Publish the Intelligent Cube by executing it on either of the nodes. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Place Intelligence Server close to the both the data warehouse and the metadata repository. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. Instead of always executing against the data warehouse. Published: Apr 6, 2017. This is from all MicroStrategy Business Intelligence clients platform. Best Practice for interview Preparation Techniques in MicroStrategy. 0. The cube population process could be expensive in time and memory if the cube is large. Indexes are created in memory on the Intelligence server as part of the in-memory cube instance. This command will list the table information only when the intelligent cube is a super cube. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". x to 11. Create Intelligent Cube Sharing Intelligent Cubes Enable ROLAP Enable Dynamic Source How to do Incremental Refresh. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Click Close, then "Finish" on the "prepare data" view and save the cube. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions:. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more cardinality means the attribute with more different elements, for example in the Tutorial project the. To create an Intelligent Cube by creating XQuery. 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. The maximum file size of dashboard (. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. To build an Intelligent Cube. 1. 3. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). 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. rare practice (British Columbia Ministry of Education, 2011, p. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. The Intelligence Server will then join all the dataset results into one master table, called the virtual dataset or master dataset, to store in memory. x) and view reports based on MicroStrategy 9. This article describes the Intelligent Cube Population options available in MicroStrategy. In MicroStrategy Command Manager 10. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. 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. 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. MicroStrategy’s In-memory technology is engineered to meet the. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 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. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. 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. 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. The Full Refresh option is the default. Number of Views 18. They were used to improve subsequent query. The related section is located in. The dataset is a set of data that can be displayed on the document. For example, the objects developed in a development environment can be copied to a UAT environment to. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. 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. 000007431. MicroStrategy Platform-intelligence server is an improved testing system for big business questions. Likewise, Analysis Services, Oracle Essbase, and TM1 store data. This article outlines some best practices for HyperWeb performance optimization in MicroStrategy 2021. 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. Document Number: 09481030. We, at Intellipaat, provide the best online classes to help you learn its architecture, database connections, cubes, clustering, and security models. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. Disable catalog cache via Developer. 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. Place intelligence server close to the both the data warehouse and the metadata repository. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. MicroStrategy - Architecture. KB37579: Dynamic Sourcing is not used when an Intelligent Cube includes a metric defined as Sum (fact A / fact B) in MicroStrategy 9. KB31566: MicroStrategy 9. The Schedule dialog box opens for your dataset, showing the tables in your dataset. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. 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. 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. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. 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. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. Please make sure that this is disabled. It improves 30% performance in. Title: Mastering Business Intelligence with MicroStrategy. The main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loaded. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. Save the dataset as Employee Dataset. The tooltip will show the dataset type listed as a Super Cube. Right-click the project and select Project Configuration. Compound attributes and joint element lists. The ability to view or edit certain settings is determined by a user's privileges. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. These are meant to restrict the ability to perform certain privileged actions. Reports using Dynamic Sourcing do not hit the Intelligent Cube when using the NullToZero function in MicroStrategy 9. 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. x releases, and the new Multi-table Data Import (MTDI) cubes. 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. Edit Project-Level Cache and Intelligent Cube Settings. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,.