Run the Report and check the SQL View. x. Object Migration Best Practices. Place Intelligence Server close to the both the data warehouse and the metadata repository. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. Expand Intelligent Cubes, and then select General. 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. Recorded at World 2021. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 4. pdf", Dynamic Sourcing -> Best practices for supporting dynamic sourcing -> Dynamic Sourcing for Incrementally refreshed Intelligent Cubes In a MicroStrategy Web dashboard, from the File menu, choose Dashboard Properties. If the Intelligent Cube must be re-processed based on a metric. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. 10. x environment, Cache Hit Count or the Last Hit Time of a. GUID of the Intelligent Cube instance in memory. Click Select. Web XML API log. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Interact with the data in real time (with targeting, filtering, and more). Complete the "sessionState" field (e. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. 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. Number of Intelligent Cube Publishes: Number of Cube Publishes: Counts the number of times a cube was published. with Gateway Agent enabled and disabled. The dossier shows 4 cubes instances while in workstation there are 6 cubes instance for an intelligent cube as shown below: The missing cube instance GUID could be found in Mstr. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. IsCubeRepStats, but not in PA warehouse tables LU_CACHE or fact_latest_cube_cache . The report retrieves data from Cube B now. Save the Report and close. g. Number of Views 2. When we mention performance, we mean the speed by which HyperWeb scans keywords to present data via HyperIntelligence cards. The ability to view or edit certain settings is determined by a user's privileges. The related section is located in. From the Data menu, select Configure Intelligent Cube. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. Query Generation. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. 1K. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. intelligent cube use cases, and cube optimization techniques with MicroStrategy. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. Always consider to collect database statistics as the query execution plan is generated based on that. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 3 - Check the Make Intelligent Cubes. 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. -10. From the results of single cube publish testing which records and compares the time spent for a single cube (4M rows) republish, JDBC driver has better performance than ODBC driver. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. Open the Workstation window. 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. The Intelligent Cube Options dialog box opens. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. , 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. The report and Intelligent Cube must be based on the same source MDX cube. Starting in MicroStrategy 10. Business Intelligence. When thinking about choosing a template, think about the words and descriptions that will be included on the card. File from URL: Unlimited. x. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Expand the Object Templates category, select General, and from the Show templates for the. By default, the location configured will be a relative path where ". Please contact MicroStrategy Technical Support for an update. It will track and log all. 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. The cube population process could be expensive in time and memory if the cube is large. The Intelligent Cube that serves as the source for the example view report is configured to normalize incoming attribute data in the database using the option "Normalize Intelligent Cube data basing on dimensions with NO attribute. 3. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. You will also work on real-world projects to gain hands-on experience. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. This presentation helps users understand MicroStrategy's in-memory architecture. The ID is found with the heading. 38K. 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. In MicroStrategy 10. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. g. KB14009: In a clustered MicroStrategy Intelligence Server 9. Tell a story with your data using the dossier chapter/page format. Configure a Cluster with a Centralized Cache. 0. A typical case is to create a derived metric to perform calculations between columns of metric data. You should periodically reevaluate the system and update it based on actual system performance and use. McLean, Va. x. Number of Views 8. CAUSE: This is working as designed. ACTION:15. x - 10. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. 0 MicroStrategy releases. 3. x - 10. In section General at the bottom of displayed window there is a check box with option "Hidden". How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. Available PA data is stored in the cube that has a default limit set to 20GB or RAM. 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Webinars. 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. An Enhancement Request for implementing this functionality is. 13K KB31566: MicroStrategy 9. 4. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. x Intelligent Cube status indication and workflow This section describes the ways in which you can design and create a MicroStrategy Report Services document. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. However, if the. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. An Intelligent Cube is an In-Memory data structure which. Published: Apr 6, 2017. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 2. 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 Java XML API log will record all the XML communications between Intelligence Server and Web. You can edit project-level cache and Intelligent Cube settings. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. CAUSE: It is designed behavior that History List subscription job cannot be assigned to other than the user who is creating the subscription. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). Creating an Intelligent cube is similar to creating a report. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;This section describes the ways in which you can design and create a MicroStrategy Report Services document. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. Following are the features, which make intelligent cubes useful. IS_CUBE_ACT_ID. 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. 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. Please refer to the following article to check all the. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. There are multiple components and services replying on MicroStrategy Messaging Services. 4. 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. If you are using or plan to use MicroStrategy Intelligent Cubes, and you plan to implement data internationalization, it is recommended that you use a SQL-based DI model. Place intelligence server close to the both the data warehouse and the metadata repository. OLAP vs MTDI and Best Practices. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. STEPS TO REPRODUCE 1. The MicroStrategy certification training course is designed for those who wish to enhance their knowledge and skills in the field of Business Intelligence and Data Warehousing. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 46K. Description. Go to the Intelligent Cube monitor to identify the cube instance ID: under the three-tier project source, Administration > System Monitors > Caches > Intelligent Cubes. rare practice (British Columbia Ministry of Education, 2011, p. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . This feature is best illustrated with an example. To enable or disable dynamic sourcing for an Intelligent Cube. Published: Dec 31, 2018 Intelligent Cubes. mstr file then uploads to another Intelligence Server without the user's specific database connection, the user will need to republish the cube first. Create Intelligent Cube Reports; Explain different types of derived elements; Creating derived elements; Group and Filter derived elements;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. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. Best practices for mapping MDX. Object Migration is the process of migrating or moving objects from one environment to another environment. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Cause This is a known issue with. KB415730. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the. x: Back up metadata before copying any objects. PlatformAnalytics. Transformation metrics, under the following conditions: -A metric with the same formula and transformation exists in the Intelligent Cube. 10 MicroStrategy Design Challenges Design Tips & Best Practices for MicroStrategy BI Architects and Developers. To Create an Intelligent Cube Using Freeform SQL or Query Builder. This article describes the Intelligent Cube Population options available in MicroStrategy. 0. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. Drag and drop the objects into the report grid from the Report Objects pane. * MicroStrategy does have support for dynamic sourcing with MDX sources. To achieve the best performance possible, it's important to delete all unused objects like datasets, visualizations, tabs (for VIs. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. 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. x and later, users should make sure to take into account the following. MicroStrategy tested on an Intelligence Server instance with 32 vCPUs 256 GB of memory, importing 10x UB data (about a 11G CSV file) from URL. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Best practice to split large files in Linux Operating Systems. Before MicroStrategy 10. x - 10. A set of data is returned from the data warehouse and saved directly to the Intelligence Server memory. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. 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. 8 to help improve the performance of Quick Search on MicroStrategy Web. 1180 views | February 10, 2021 29:25. 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. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. Office Intelligence, MicroStrategy Office. In MicroStrategy Developer or Web, log in to a project that contains Intelligent Cube reports. 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‘. 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. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Number of Views 3. Click the MicroStrategy icon at the upper left of any page and select History List. x-10. They were used to improve subsequent query. 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. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 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. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. 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. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. With OLAP Services features, your report designers can create Intelligent Cube reports. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. 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. 18K. KB47254: How to create a subscription to refresh Intelligent Cubes using MicroStrategy Command Manager 9. This data is stored in cubes or other SAP objects. The Editor and Filter panels are stacked together by default. Overview. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. KB32618: How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. Object Manager cannot undo the copying and replacing of objects. Create Cube A and a report based on it. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. Rather than returning data from the data warehouse for a. 0, the only way to create an intelligent cube (also. A cube is imported into MicroStrategy (Development) and reports are built based on this cube. Prior to MicroStrategy 2020 the Maximum % of growth of an intelligent cube due to indexes governing setting was used to limit the growth of Intellgent cubes over time due to the creation of indexes. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. The. 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. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. 4. 2: Active. Number of Views 611 KB46313: In a clustered environment, Intelligent Cube sizes are varied on different nodes of the cluster in the Intelligen…510 Ratings. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. In a MicroStrategy Web dashboard, from the File menu, choose Dashboard Properties. x. Click Databases . iCubes or Intelligent Cubes are objects that provide pre-cached data which can be queried on the reports. 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 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. Accessibility and 508 Compliance. Best practices for supporting dynamic sourcing. If user downloads the . 1 and 10. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. with Gateway Agent enabled and disabled. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The user then updates the cube. MicroStrategy Dossier Design Best Practices for Performance. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. x? Number of Views 5. 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. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. 12K. Integer ID of the Intelligent Cube report that was published, if any. Intelligence Server Statistics . How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. Defining Intelligent Cube refresh settings. Intelligent Cube Using Microstrategy 9. Before MicroStrategy 10. 000007431. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. KB442526. C:Program Files (x86)MicroStrategyWeb ASPxWEB-INFlog. SHOPMAN, powered by MicroStrategy, delivers sensor data, inventory management, and financial data to enable users make data-driven. Browse to and select a previously saved Intelligent Cube on which to build your report. Published: 4월 6, 2017. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. The dataset is a set of data that can be displayed on the document. Choose one of the following options: Full Refresh: This is the default. Version 9. Instead of always executing against the data warehouse. All necessary privileges are included in the Administrator role by default. Number of Views 15. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. Number of Views 15. Starting in MicroStrategy 10. The Schedule dialog box opens for your dataset, showing the tables in your dataset. MicroStrategy Intelligence Server will submit all queries as prepared statements if the following registry key is created on the Intelligence Server machine:To Create an Intelligent Cube Using Freeform SQL or Query Builder. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). First, define one visualization as the source. 4. 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-10. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Select the data set and click Prepare Data. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. This article describes the Intelligent Cube Population options available in MicroStrategy. 4. KB441987: Best Practices. The Data Transfer Rate varies from 27 to 28 Mb/s. MicroStrategy Real-Time Analytics. Edit Intelligent Cubes from the new editor in Workstation at any time. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. Filename. C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\log. x to 11. I possess exceptional proficiency in analysing extensive data sets, deciphering intricate trends, patterns, and customer behaviors, and unveiling invaluable insights that may otherwise remain concealed. DESCRIPTION: Starting MicroStrategy 10. Choose File > New > Intelligent Cube. 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. You can add data for your Intelligent. 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) or OLAP (first generation of in memory cubes, introduced in 9. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Talk to an expert. One of the first steps in formatting HyperIntelligence cards is to choose the best-fit template. Resources Company Bitcoin Lightning Home Published: August 11, 2022 • 619 Views Advanced Properties for Intelligent Cubes MicroStrategy Workstation. Web log. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. Expand the Object Templates category, select General, and. The metadata is a central repository, which stores all the objects used by it. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. STEPS TO REPRODUCE: 1) Add external dataset. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more. Please make sure that this is disabled. Number of Views 1. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Create a Report 'R3' with 'Country' attribute. KB31566: MicroStrategy 9. Hands-On Learning in MicroStrategy. Shipped vs Native. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. For details, please refer to the Technical Note below. The tooltip will show the dataset type listed as a Super Cube. The objects stored in the metadata are reusable. 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. In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. Select data population for Intelligent Cubes. 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. Our vision is to enable Intelligence Everywhere. foundation to build a career in Analytics, proving expertise in using MicroStrategy.