Click OK to save the Intelligent Cube and return to the Report Editor. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. What are the advantages of cubes in MicroStrategy? Ans: The advantages of cubes are: Supports derived metric creations;. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. 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. By using a single Intelligent Cube to support all the security filters for a project, data access security is implemented automatically with minimal burden on Intelligence Server memory. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. In Developer, log into a project. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Published: Apr 5, 2017 Last updated: Apr 12, 2019 Related versions: 0 Log in to vote MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Metrics and attributes are created once and used across different types of reports. Navigate to and run the Intelligent Cube report. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. Sharing data. 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. MicroStrategy Web is composed of a multi-layered architecture that clearly separates functionality from presentation. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. Solution for In a variety of methods, MicroStrategy produces intelligent cubes. Intelligent Cube Technology is used by MicroStrategy. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. KB32540: Intelligent Cube Population methods in MicroStrategy. Although the directory filed shows the same location as the source project, cubes are saved to a. The top reviewer of Microsoft BI writes "User friendly,. If you are upgrading to MicroStrategy 11. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. Platform Analytics is the new monitoring tool in MicroStrategy 11. Intelligent Cubes are part of the OLAP Services features in Intelligence Server. 0, to pick up the feature, enable project level setting. Users with different security filters can use the same Intelligent Cube data. Watch on Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. KB442264 : In-Memory query against Intelligent Cube incorrectly does a cross join instead of joining through available tables using which the attributes could be joined. 2. For example, analyzing the MicroStrategy Tutorial project creates a Cube Advisor results file named MicroStrategy Tutorial. Microstrategy is actually based on the single meta-data repository. Overview. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. Nature: By nature, both Tableau and MicroStrategy tools are Business Intelligence software designed for visualizing data. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. x, create a simple Intelligent Cube with attribute Category and metric Revenue. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. From the Categories list, expand Options, and then select General. Cube Advisor opens. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Our MicroStrategy Online Training module will provide you a way to become certified in MicroStrategy Online Training India. Follow these steps to enable Dynamic Sourcing for the project: 1. Benefits of Intelligent Cubes include: Greater Efficiency - Intelligent Cubes are automatically generated and shared among all users whenever a. Right-click the dataset, and choose Schedule. The Intelligence Server checks to see if there is an existing cache for the same Report. Click Select. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. With the intuitive card editor and flexible data layouts, it’s astonishingly simple. Instead of always executing against the data warehouse. HIDDEN: Whether or not the Intelligent Cube is hidden, returned as a boolean value. The Intelligent Cube opens in the Report Editor. 2021 Update 6 (Août 2022) MicroStrategy Workstation. 0 MicroStrategy releases. KB440835: In MicroStrategy 10. If you are upgrading to MicroStrategy 11. To schedule an Intelligent Cube to be updated. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. The Schedule dialog box opens for your dataset, showing the tables in your dataset. the project configuration: ACTION . 6, when users created a Dashboard or a Document using a Connect-Live Cube, using Metric Qualification with an output level that is lower than the template level and created at least 2 layers of nested aggregation on top of the cube metrics, the iServer crashes. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. A MicroStrategy Business Intelligence Developer can earn US$117,000/year – Indeed. Jul 17, 2023. CAUSE: This is a known issue in MicroStrategy 10. MicroStrategy 2021 Update 9 introduces the ability to create Intelligent cube reports based on an Intelligent cube. 4. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Create Cube2 with the Region attribute and the metric created in step 1. number_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. From the Categories list, expand Options, and then select General. Reporting on Intelligent Cubes also allows you to use all of the OLAP Services features, including derived elements, which allow you to group attribute elements in a report on. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. (Intelligent Cube configuration is not relevant in MicroStrategy 8. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. 3. Reports cannot combine data from multiple Intelligent Cubes. Users don’t have to mention the cube to which they want to connect. Normalize Intelligent Cube data in the Database using. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. OLAP services: Derived metrics and viewed filters cannot be supported. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. In the Data Source column, select the checkboxes for the tables to update. 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 . Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. Consider the following example based on the MicroStrategy Tutorial project. MicroStrategy vs. arrow_forward Explore the use of computational systems in the field of artificial intelligence and machine learning, emphasizing the role of GPUs and TPUs. 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%. 4. blogspot. Modify or remove the view filter to attempt to return data for the report. You can mention the two features which the Intelligent Cube doesn’t support and they are OLAP Service and the second is Prompts. 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. Ans: A report cache is a result set from an executed report that is stored on MicroStrategy Intelligence Server. Most likely several, different fact tables are uses for each query. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). You can also define when Intelligent Cubes. You can create and analyze new reports in real time. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. The Intelligent Cube refresh settings are recommended if the data in the. 2: Active. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Published: 4월 6, 2017. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. MicroStrategy recommends to change it to unlimited so your core file is not truncated. Public folder or a specific user folder can be selected for the creation of intelligent cubes in MicroStrategy. 4. 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%. The Intelligent Cube opens in the Report Editor. To schedule an Intelligent Cube to be updated. An Intelligent Cube has been created in a project. The objects in the source cubes will control how the security filter will be applied. Users of Intelligent Cubes in MicroStrategy 9. In the Refresh Policy column, choose one of the following options:For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. The Visualization SDK has the following benefits. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. . 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. Teradata suggests the use of fully normalized physical schemas (specifically, Third Normal Form or 3NF). Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. 6 plus years in Data warehousing, Business Intelligence systems, OLAP environments and tools. The default value is 256 megabytes. STEPS TO REPRODUCE 1. One of the main advantages of OLAP is that it allows you to perform complex and fast queries on large amounts of data. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. KB485159: Enable support for Security Filter with Top and Bottom Range Attributes in Data Import Intelligent cubes and Fix the security hole in Connect Live Data Import Intelligent cubes MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). During card design, select from different widgets, matrix views, and card header formats to best display data. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)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 MicroStrategy Knowledge base document for general remarks on security filter application to Intelligent Cubes where not all of the security attributes are found. Performed basic stability testing of Intelligence server and updated projects. No data is returned for the report. Select the Intelligent Cubes tab. Ad hoc report. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. The solution has a very non-logical user usage part. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. These VLDB properties control the method by which the report data are normalized. By default, the location configured will be a relative path where ". Installed, upgraded and managed MicroStrategy 7. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. Choose File > New > Intelligent Cube. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Defining Intelligent Cube refresh settings. 19. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Both products' features range. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. Apply the setting above, by logging out from your current session and then logging back in. When these Intelligent Cubes are cached in memory, report manipulations, such as adding derived metrics and derived elements, formatting, and drilling within the Intelligent Cube, take considerably less time. This can improve the performance of. The **_objects folder with a size of 277G. The book starts by detailing. The Report Editor opens. OLAP systems use pre-computed summaries and aggregations, called cubes, to. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. Number of Views 1. 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. The partition attribute is the attribute that is used to divide. These reports allow data to be returned from the data. This defect is addressed in MicroStrategy 11. Choose File > New > Intelligent Cube. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesIn the Navigation pane, click Monitors. Click the MicroStrategy icon at the upper left of any page and select History List. The Intelligent Cube Monitor provides information about published Intelligent Cubes, as well as Intelligent Cube usage statistics. Share query results in-memory across multiple dossiers and reports. Updating Intelligent Cubes without re-processing: Incremental Refresh. 1 release. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. Drawbacks of Microstrategy Business Intelligence. They have to log into the platform. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. If the Intelligent Cube must be re-processed based on a metric. Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. Published: Jun 29, 2018;To Create an Intelligent Cube Using Freeform SQL or Query Builder. 49. To enable or disable dynamic sourcing for an Intelligent Cube. MicroStrategy allows you to load large datasets into your Intelligence Server's memory as Intelligent Cubes, and divide the Intelligent Cubes into multiple segments. Prerequisites to creating Intelligent Cubes. Create a security filter on the region attribute such as region not in list central. 0. Prerequisites to creating Intelligent Cubes. The Intelligent Cube Options dialog box opens. 8 and earlier using 'Live' Intelligent Cubes. Click OK. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Cube Advisor provides the following features for creating and supporting a dynamic sourcing strategy: Analyzes reports to determine if their report definitions can support the use of dynamic sourcing. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. Upgrade to those versions to take advantage of the fix. Localizing Intelligent Cubes in multiple languages. To effectively create a HyperIntelligence dataset, your data must have attributes with either one-to-one relationships or many-to-one relationships. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Right-click an Intelligent Cube and select Delete. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Select Intelligent Cubes > General > Intelligent Cube File directory. The Report Editor opens. The reports accessing Intelligent Cubes can use all of the OLAP Services features for analysis and reporting. From these results it can be determined that the Month attribute is not being used within any of the view Reports, Documents, Dossiers that reference this Intelligent Cube. It will remain available, but the setting will not. xCreate Intelligent Cube Reports. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. The Report Editor opens. Using the Tableau connector since MicroStrategy 2019 Update 2 requires the Use Application Tableau privilege. This means any report you create will have caching enabled by default. Create a subset. x: Ability to encrypt cache files stored to disk. Advantages of OLAP Tools. This template includes the following tasks: Creates a new metadata. This knowledge base article assumes that the user has a month attribute whose format is YYYYMM as shown below and s/he wants to delete more than 12 months’. 4 HF 2 or 10. MicroStrategy is an enterprise business intelligence application. No data is returned for the report. Select other schedule options as required, and click OK. The Intelligent Cube Options dialog box opens. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. Create a report based on above Cube and add the prompt in view filter. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent cube technology: This article describes features that are not supported when using Dynamic Sourcing. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. If your MicroStrategy project supports the localization of information into multiple languages, you can also support this localization to provide Intelligent Cubes in multiple languages. Intelligent Cubes. Then it generates a report. To enable. The Subscription Creation Wizard opens. This is the most popular MicroStrategy Interview Question asked in an interview. Mention the features that are not supported by intelligent cube? Ans: Features that are not supported by intelligent cubes are: Prompt. Depending on the implementation this can have many benefits as joining can be more efficient then removing rows through a WHERE clause, and a reduced Tabular Dataset helps the. To build an Intelligent Cube. What are the benefits of Microstrategy you are familiar with? 1. Exporting Multiple Grids to Microsoft Excel. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. Hyper intelligence is a. • Created Intelligent Cubes and performed sharing to reduce the database load and decreasing the report execution time by using the cube services. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. For a list of objects and features that. Two unique methods to implement Intelligent Cube Technology: •Personal Intelligent Cubes. For a description of all Intelligent Cube statuses, see. MicroStrategy needs to define which one they will use. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. 4. Analyze SQL Server data with multiple tools. 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. Select the Create Intelligent Cubes by database connection check box. This file stores cache matching. Visit the data visualization and data dashboard galleries for inspiration. Case A: Security Filter attribute is related to attributes placed on the grid. Some key benefits include: Mapbox maps use vector tiles instead of image tiles used by many competitors, which enables much smoother and more customizable zooming. Select data population for Intelligent Cubes. However, after publishing,. See KB484738 for more information. Use Case 4. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. In MicroStrategy Developer, log in to a project source with administrative privileges. Navigate to the folder location of the Intelligent Cube. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. The first part discusses the behavior of both the MicroStrategy semantic SQL Query engine layer and the Snowflake temporary and transient table. Right-click the Intelligent Cube, and select Edit. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Intelligent Cube storage on disk mirrors report cache storage. Create the MIN (CurrentDateTime ()) metric. 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. The. MicroStrategy Web allows you to merge two or more Intelligent Cubes. Subsequently the requests made by other users can. MicroStrategy administrators can automatically ensure that business users always have the most current information by configuring the Intelligent Cube data to expire or. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. MicroStrategy Developer, MicroStrategy Web, and MicroStrategy Office users can slice and dice data in reports within the Intelligent Cubes without having to re-execute SQL against the data warehouse. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. An example of this behavior for a relatively small cube is shown in the screen shots below:Right-click the report and select Edit. •Develop a future state pilot that demonstrates the enterprise-ready value of the MicroStrategy Intelligence Platform and. In the Drilling area, clear the Use default settings check box. Intelligent Cubes are automatically built once and stored in MicroStrategy’s unified metadata on the centralized server, where they can be shared across the enterprise. 1. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. You can edit project-level cache and Intelligent Cube settings. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. 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. You can import datasets with up to four million rows and 30+ columns. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Multi-pass SQL is required to answer analytical questions that cannot be. Intelligent cubes are generated automatically when a new report is run against the data warehouse. Schedule administrative tasks and reports to run during off-peak hours, so that they do not adversely affect system performance. 2. To do so, you can take advantage of URL API. In the Object name field, type a descriptive name for the Intelligent Cube. In most cases, the automation in the semantic layer provides more considerable resource savings than maintaining multiple custom SQL query Intelligent Cubes in memory that do not relate to each other. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Number of Views 1. As an extension of MicroStrategy Intelligence Server, OLAP Services uses Intelligent Cube Technology—an in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. The Full Refresh option is the default. 4. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. 46K. KB46934: Reports created from a MicroStrategy Data Import Intelligent cube are hidden in MicroStrategy Web. Provides the last cube row count. This can. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. 3 - Check the Make Intelligent. 50. table_name: is the name of a table. This article narrates large cubes appear in ‘LP’ status and some other cubes not shown up in cube monitor in MicroStrategy 2021 is due to loading cube info thread being blocked by loading the large cube instance. This copy of report data is stored in Intelligence Server memory only. The Intelligent Cube must be published before this report can execute. Create a Report 'R3' with 'Country' attribute. To view an Intelligent Cube stored in your History List. Maintaining data access security. Intelligent Cubes. Choose File > New > Intelligent Cube. When using an Intelligent Cube, you already have an in memory dataset. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. idx file is cleaned up. Traditionally, this type of requirement was hard to achieve as there was not an event that could be triggered right after the execution of an. Replace a slice of data in an Intelligent cube using a single incremental cube refresh step. Build a cube of customer data that’s relevant to all employees and publish it. Pros and Cons. The Intelligent Cube Editor opens. You can also create Intelligent Cubes by directly querying your data. 2. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. If no data is returned for a report that is connected to an Intelligent Cube, this can be caused by the following scenarios: The view filter for the report is too restrictive (see View Filters ). 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. 0. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. The Intelligent Cube is opened in the Report Editor. 20. 0. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. Browse to and select a previously saved Intelligent Cube on which to build your report. Disconnect from the project source and restart both Intelligence servers. 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. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. The application is named MicroStrategy Cube. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes.