Number of Views 5. The solution is to republish the cube after upgrading instead of reusing old cube caches. 1 To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. Web log. blogspot. x ODBC calls by default. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Object Migration is the process of migrating or moving objects from one environment to another environment. Intelligent Cubes. However unlike MicroStrategy it cannot join data between different cubes into the a single visualization. The columns ID1 and ID2 correspond to attributes and M1 corresponds to a metric. When an Intelligent Cube is published, the Intelligent. x Number of Views 8. More about Feature flags can be found in this article. Hands-On Learning in MicroStrategy. 8 to help improve the performance of Quick Search on MicroStrategy Web. Use MicroStrategy Developer, Office, or Web. Setting Up an Analytics Semantic Layer and Public Objects. MicroStrategy Platform is an enterprise analytics, data management, and BI software platform for managing big data. KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best Practices . DESCRIPTION: Starting MicroStrategy 10. Refer to Product Manual for more detailed information. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. foundation to build a career in Analytics, proving expertise in using MicroStrategy. If you use Enterprise Manager (EM), dedicate a machine for. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. Click the Cube Mapping tab. Disconnect from the project source and restart both Intelligence servers. You should periodically reevaluate the system and update it based on actual system performance and use. 0. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. x, but not to publish it, the minimum privileges that the Administrator would need to. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. The ODBC connection uses 3. The Intelligent Cube Options dialog box opens. , May 6, 2010 -- MicroStrategy® Incorporated (Nasdaq: MSTR), a leading worldwide provider of business intelligence (BI) software, today announced that its In-memory technology delivers significantly higher performance for BI applications, even at the highest scale. From the Data menu, select Configure Intelligent Cube. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. Web XML API log. Module 14: Practices on MicroStrategy Best . MicroStrategy OLAP Services는 분석 엔진으로 조작할 수 있는 보고서의 메모리 내 버전인 Intelligent Cube의 개념을 사용합니다. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 15K. 8. 31K. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. 4. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. In MicroStrategy 10. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. A typical case is to create a derived metric to perform calculations between columns of metric data. These. 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 initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. Expand Intelligent Cubes, and then select General. Create a Report 'R3' with 'Country' attribute. x? Number of Views 5. Following are the features, which make intelligent cubes useful. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence Server This article describes features that are not supported when using Dynamic Sourcing. Conditional metrics. rare practice (British Columbia Ministry of Education, 2011, p. This presentation helps users understand MicroStrategy's in-memory architecture. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. A dataset is a set of data that can be displayed on a document. Publish the Intelligent Cube by executing it on either of the nodes. Number of Views 15. By default, the location configured will be a relative path where ". In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. Compound attributes and joint element lists. Best Practices for MicroStrategy Messaging Services. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. IS_CUBE_REP_ID. Please contact MicroStrategy Technical Support for an update. 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. Integer ID of the Intelligent Cube report that was published, if any. For more information on security filters, see the System Administration Guide. mtc is the name of the saved test file. Number of Views 18. Relationships with Multi-Table Data Import. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. 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. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. The Java XML API log will record all the XML communications between Intelligence Server and Web. Locate the published cube, right-click on it and choose Quick View. Number of Intelligent Cube Publishes: Number of Cube Publishes: Counts the number of times a cube was published. x. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. 5. The Editor and Filter panels are stacked together by default. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. Text and CSV files: Varies depending on the Intelligence Server memory. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". 1319 views | February 11, 2021 45:05. 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. 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. Also Oracle does not support data blending capabilities from the enterprise platform 3 Built-in Best Practices for Visual Exploration: A number of visual exploration best practices embedded within the product. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). Updating Intelligent Cubes without re-processing: Incremental Refresh. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 0. OLAP cubes best practices. x, with the Intelligence Server running on Linux, the image in the. 1 Department Architecture Department Architecture consists of a single server node for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. 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. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. If user downloads the . Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. Number of Views 8. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 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. Supported data structure and distribution on Gateway. MicroStrategy Best Practices Removing Duplicate Rows Sometimes you need to deal with a data source that has duplicated data. MicroStrategy - Architecture. Choose one of the following options: Full Refresh: This is the default. To enable or disable dynamic sourcing for an Intelligent Cube. View the report in either Grid View or Grid and Graph View. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. Relationships with Multi-Table Data Import. Our MicroStrategy Admin certification training course lets you master MicroStrategy administration. After completing your certification, you’ll receive a digital badge that highlights your accomplishment, which you can post on social media. 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. Always consider to collect database statistics as the query execution plan is generated based on that. 3 - Check the Make Intelligent Cubes. The dataset is a set of data that can be displayed on the document. Place Intelligence Server close to the both the data warehouse and the metadata repository. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. 1. 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. 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. Since the Quick Search indices make use of the Change Journaling data, they can easily update their existing indexes based on this data instead of having to do a full table scan. 13K. Filename. Try to include only information that would be imperative at-a-glance. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. Generate Oracle AWR report or monitor the database to identify the low performance query. 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. . als Berichtsobjekte oder Berichtsfilter einschließen. 4. x a new concept is introduced called Intelligent Cubes. MicroStrategy’s In-memory technology is engineered to meet the. x. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 3. The first step in analyzing. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. The New Grid dialog box opens. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. application performance and security best practices. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. 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 "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. MicroStrategy Real-Time Analytics. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Best practices for mapping MDX. x Intelligent Cube status indication and workflow. Query Generation. These reports allow data to be returned from the. Run the Report and check the SQL View. KB442526. If you use Enterprise Manager, dedicate a machine for the Enterprise Manager. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 1. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. The. MicroStrategy Internal Reference number for this technical note is KB483620 and DE128512. Privileges are given on a per-user basis, some of which are also per-Application. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. This command will list the table information only when the intelligent cube is a super cube. You can add data for your Intelligent. STEPS TO REPRODUCE: 1) Add external dataset. 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. File from URL: Unlimited. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. x. Why MicroStrategy Why MicroStrategy; Customer StoriesMaintaining data access security. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesThis technical note documents an issue that occurs when an Intelligent Cube created through Live Connection to an OLAP data source is migrated to another environment, with MicroStrategy Object Manager 10. KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. Click Create and choose Add External Data. If the Intelligent Cube must be re-processed based on a metric. This article describes the Intelligent Cube Population options available in MicroStrategy. We, at Intellipaat, provide the best online classes to help you learn its architecture, database connections, cubes, clustering, and security models. In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. With OLAP Services features, your report designers can create Intelligent Cube reports. 5 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 shownWhen configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. The report and Intelligent Cube must be based on the same source MDX cube. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. 98K. 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. Click All Objects View. The ID is found with the heading. Select Intelligent Cubes > General > Intelligent Cube File directory. 1180 views | February 10, 2021 29:25. x) or OLAP (first generation of in memory cubes, introduced in 9. 2. 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. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. Disable catalog cache via Developer. 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. Using Object Manager, the above cube based reports are migrated into Production. Create a Report 'R3' with 'Country' attribute. -10. Start Learning with us ACTE MicroStrategy. 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. OLAP vs MTDI and Best Practices. Published: Apr 6, 2017. The tooltip will show the dataset type listed as a Super Cube. Dedicate a machine for the metadata repository. Business Intelligence. ACTION This. e. The metadata is a central repository, which stores all the objects used by it. MicroStrategy’s new Gateway connector can enable analysts to derive new. 3. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. Dossier shows different data when In-Memory Intelligent Cube dataset is changed to Live mode. It will track and log all communications at the “XML API. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. This article describes the Intelligent Cube Population options available in MicroStrategy. 4. Click the MicroStrategy icon at the upper left of any page and select History List. Afterwards MTDI cubes should appear as visible from default. From the Data menu, select Configure Intelligent Cube. Then, select a page from a different dossier that you want to filter as the target. Release date: July 2016. KB31566: MicroStrategy 9. Trending Articles. Web log. 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. By default, the template is 3x3. 4. 84K KB441987: Best Practices for increasing performance of publishing large Intelligent CubesAn Intelligent Cube report is created in MicroStrategy 9. x. Refer to Product Manual for more detailed information. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. Intelligent Cubes can function in a similar fashion to result caches: they. The Intelligent Cube opens in the Report Editor. MicroStrategy Platform-intelligence server is an improved testing system for big business questions. Integer ID of the project where the Intelligent Cube is stored. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. CAUSE: This is working as designed. 4. KB441987: Best Practices for increasing. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. Before MicroStrategy 10. Create an attribute element prompt for the. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. 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 MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. x - 10. Microstrategy Dossiers With the release of MicroStrategy 10. SAP BW obtains data from R/3, CRM, SEM, or another SAP data source system. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. 4. The main open-source visualization tool, Kibana, that is used to connect to ElasticSearch is fairly limited in its visualization capabilities. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. 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. It improves 30% performance in. 46K. 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. 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. 4. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. In MicroStrategy Intelligence Server 9. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. Published: May 29, 2019; Last updated: Oct 29, 2019; Related versions: To build an Intelligent Cube. E. Complete the "sessionState" field (e. 3. This can be encountered when you're dealing with raw data volumes which have not yet been processed through an ETL. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. If the Intelligent Cube must be re-processed based on a metric. Published: Jan 29, 2019;. When a derived attribute is built off of data from a single live data import cube, then the calculation of the derived attribute will be pushed down into the query against the data source rather than being done in the. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. 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‘. IS_CUBE_REP_ID. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). Number of Views 8. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. CREATOR: User who created the Intelligent Cube cache, returned as a string. Intelligent Cube refresh options supported for dynamic sourcingMicroStrategy 10. Number of Views 1. In Developer, log in to a project with a user account with administrative privileges. x) and view reports based on MicroStrategy 9. x. It lets you various. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy environment. Indexes are created in memory on the Intelligence server as part of the in-memory cube instance. x - 10. It happens in MicroStrategy Developer 9. 4. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. 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. 2: Active. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. This article describes best practices to be taken when using a Teradata database in MicroStrategy. 18K. Created cube with lastname and any other attribute. To enable. After the Intelligent Cube has finished republishing, the Cube. How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. This technical note outlines how to set. This includes "Personalized Intelligent Cube" reports (which have the same structure as OLAP Services reports in MicroStrategy 8. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. Intelligent cube; Advanced reports; Creating and adding data to the document;To view an Intelligent Cube stored in your History List. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. If you use Enterprise Manager, dedicate a machine for the Enterprise. When thinking about choosing a template, think about the words and descriptions that will be included on the card. 4. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. In MicroStrategy Command Manager 10. Integer ID of the Intelligent Cube report that was published, if any. 0. x: Back up metadata before copying any objects. Open the Workstation window. Because a single Intelligent Cube cannot connect to more than one data warehouse, using a. Rather than returning data from the data warehouse for a single. with Gateway Agent enabled and disabled. Required Status to Perform Action. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. 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. Object Manager cannot undo the copying and replacing of objects. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. For example, these reports go from basic execution pointers, quarterly deals by item. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. 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. The following diagram depicts the role of the intelligent cube. 3. 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. Designing and creating documents: An overview. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. Please refer to the following article to check all the. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. The Java XML API log will record all the XML communications between Intelligence Server and Web. Save the Report and close. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. Best practices for mapping MDX. 3 - Check the Make Intelligent. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. First, you open a blank document and select a report to use as the document's dataset. This can be achieved via the report level VLDB property > SQL Time. Intelligent cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. 2. 8: Monitoring information dirty. Consider joining one of our full courses. 3. Number of Views 15.