For instance, let’s say you have an Intelligent Cube with 2 million rows and 10 attributes and 5 Expand Intelligent Cubes, and then select General. com. UPDATE: the refresh policy is Update existing data. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. 4. 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. IS_PROJ_ID. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Solution This issue has been addressed in MicroStrategy 2021. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. You must belong to the System Administrators group to use this feature. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. 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. x to 11. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Job ID for the action on the Intelligent Cube. This can improve the performance of. 2. Number of Views 1. 4. 2. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. STEPS TO REPRODUCE: 1) Add external dataset. - Normalize Intelligent Cube data in the. Forecast Sales. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. 3. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. Limited mobile capabilities compared to the latest BI tools like MicroStrategy. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. To build an Intelligent Cube. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. While this can improve performance of these reports. Starting in MicroStrategy 10. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. Starting with MicroStrategy Intelligence Server 9. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Use Cube Advisor to create Intelligent Cubes: 1. SYMPTOM Users may notice that duplicate cube instances are created after an intelligent cube that had a neutral locale is updated with a multilingual. Dynamic Sourcing. This is a known issue with Data Import functionality in version 10. Providing Intelligent Cube data. BUILD Because the in-memory ROLAP Cubes operate below the User Security and Prompting layers, they are able to serve a very wide variety of requests and. Create a New Dossier. For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. x - 10. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. The requests are granted or denied according to user-configured limits on the amount of. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. Click Select. the project configuration: ACTION . This data is to apply the calculations. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. Select data population for Intelligent Cubes. Share query results in-memory across multiple dossiers and. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. This is the most popular MicroStrategy Interview Question asked in an interview. The Intelligent Cube Options dialog box opens. This is due to the fact that adding prompts to Intelligent Cubes is not supported. When a machine runs out of virtual memory, processes on the machine are no longer able. 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 . Published: Apr 6, 2017. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. When you first click on "Add External Data" and a list of connectivity options come up, there is now a small icon at the top left, that allows you to filter the connections for those that support Live Connect. Check the status of the cubes in Developer. Note: The maximum file size that can be imported is 100 MB. Locate and run the Setup. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. 5 GB . When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. Within the set. From the Data menu, select Add Dataset. In MicroStrategy 10. 3. If removing the view filter does not. In the Navigation pane, click , next to Objects. To enable or disable dynamic sourcing for an Intelligent Cube. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. Memory Storage for document or dossier. e. A document is used to format data from multiple datasets in a single display of presentation quality. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. You must belong to the System Administrators group to use this feature. 1. Total Cubes This section displays the total count of cubes by status. Edit Intelligent Cubes from the new editor in Workstation at any time. x. If the Intelligent Cube must be re-processed based on a metric. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 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. KB35600: Users are unable to restore attributes' default display settings through the attribute display option in the data menu for an Intelligent Cube in MicroStrategy Developer 9. MicroStrategy Professional Services for high performance. It is also more difficult or impossible for someone reporting on Intelligent Cube data to unintentionally cause re-execution against the data warehouse, preventing extra load on the data warehouse. Cube Limitations. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. When running MicroStrategy Intelligence Server 9. 4. 1, Intelligent Cubes have a new feature to update information without republishing it. Click All Objects View. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. For more information on security filters, see the System Administration Guide. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Refer to the following MicroStrategy Knowledge Base. Run the Report and check the SQL View. Select the Security Filters tab. Intelligent cubes support time zone based reporting. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Job ID for the action on the Intelligent Cube. Traditional Report Caching in MicroStrategy is done on a matching basis. Measures the time duration an operation executed against cubes. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Data Population for Intelligent Cubes. However, the cube monitor doesn’t show partition related information. Create a report with Year on the rows and Revenue on the columns. See full list on community. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. 1 Hotfix 6, it is not possible to use the Attribute Name macro in the filename of a bursted document when the document uses an Intelligent Cube create via Data Import as a dataset as the Intelligent Cube's attributes are not in the actual project schema. Navigate to the folder location of the Intelligent Cube. You can use. Intelligent Cube storage on disk mirrors report cache storage. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. This import bridge imports MicroStrategy logical tables as Dimensions. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. Right-click an Intelligent Cube and select Delete. To change these behaviors, see: Publishing Intelligent Cubes Without Loading Them into Intelligence Server Memory Loading Intelligent Cubes when Intelligence Server Starts If. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. This is the same requirement to create or run a static report in Workstation. It is also more difficult or impossible for someone reporting on Intelligent Cube. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Pros and Cons. 2. When a machine runs out of virtual memory, processes on the machine are no longer able. Republish the same cube, and a new cube instance is generated. Select an Environment from the upper-left drop-down. In Enterprise Manager 10. The dataset is a set of data that can be displayed on the document. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. The following table summarizes the test results of some test scenarios against Oracle 19c. 5. My complaint is that a lot of the new stuff just works in the "import data into an intelligent cube" model and not the good old metadata. This means you can manually change the suffix to . This enterprise analytics tool works seamlessly across web-based content, mobile devices, and Microsoft Outlook to bring answers to people through relevant, context-based analytics. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. III. 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. 4. For example, an Intelligent Cube that contains data for the top 200 stores by. IS_CUBE_ACT_ID. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 0. To Create a Report that Accesses an Intelligent Cube. However, a lot of the advanced functionality requires the good old metadata, and having everything cubed means you will need a shit ton of RAM very quickly. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. The MicroStrategy Tutorial project uses aggregate tables by default. With in-memory ROLAP, some selected portions of the global virtual cube are populated with actual data as ROLAP Cubes (Intelligent Cube); as you see presented here in the drawing. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. x - 10. Expand the Object Templates category, select General, and from the. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. This KB answers a question regarding memory limitations for In-Memory data import for MicroStrategy 10. Create Cube2 with the Region attribute and the metric created in step 1. Published: Apr 6, 2017. Published: 4월 6, 2017. The memory used by Intelligence Server is limited by the machine's virtual memory. 3. Exit all Windows applications before beginning the installation process. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. x. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms for caching. 4. 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. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Creating an Intelligent cube is similar to creating a report. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. 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. Like cache update subscriptions, Intelligent Cube. Slice and dice features are awesome. The related section is located in. Create Cube1 with the Region attribute and the metric created in step 1. Integer ID of the project where the Intelligent Cube is stored. zip file, with the. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. There's a reason we're at the top of the list. MicroStrategy 9 ships a new utility called MicroStrategy Cube Advisor to assist in the use of the Dynamic Sourcing functionality in MicroStrategy OLAP Services 9. 0. Import and save data from a file in a folder location. To do so, you can take advantage of URL API. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. The cube is based on a MDX datasource, specifically SAP BW. The Intelligent Cube must not be re-processed based on a metric. 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. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. MicroStrategy 10 will report the following. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. The New Grid dialog box opens. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. 1 – Python program gets and processes the data from a Data Source. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. 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. g. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). 3 - Check the Make Intelligent. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. In addition, multiple logical tables can represent the same physical table. Drag and drop the objects into the report grid from the Report Objects pane. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. By default, MicroStrategy Command Manager handles cube publication synchronously (i. These VLDB properties control the method by which the report data are normalized. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 2. Create Cube B which contains all objects in the report and publish it . Drag and drop the objects into the report grid from the Report Objects pane. In the New Intelligent Cube dialog box, select the MDX Sources tab. x. 10 or earlier, outer join to Lookup table in a dashboard/dossier report based on Intelligent Cube with joint element list filter will not work, and incorrect CSI will be generated when both attributes used in the filter are present in visualization. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. This property can only be enabled through Workstation. The Modeling service must be configured correctly to use this feature. Documents . This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. You can create and analyze new reports in real time. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. x or 10. If the data in the Intelligent Cube is outdated. An Intelligent Cube publication takes significantly long to complete publication (several hours). 0 MicroStrategy releases. Intelligent Cubes can be based on MicroStrategy data or imported data. The data used for this example is. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The default value is 256 megabytes. 2. . 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. ACTION: A fix for this issue is included in MicroStrategy 10. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 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). 3. MicroStrategy AI is here. The limitations of Microstrategy are not worth. You can control users' access to data with security filters. This import bridge imports MicroStrategy logical tables as Dimensions. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. In addition, multiple logical tables can represent the same physical table. Overview. This applies for example to Cubes created via MicroStrategy Web client. All necessary privileges are included in the Administrator role by default. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. 4. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Number of Views 1. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The Select Dataset dialog box opens. Select the Security Filters tab. Why MicroStrategy Why MicroStrategy; Customer StoriesHyperIntelligence is a new addition to MicroStrategy Workstation that allows analysts to inject analytics and intelligence directly into every user's experience. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. Create an intelligent cube report with Year and three derived metrics and enable "Aggregate from base" as shown below: Insert view filter "Year in list (2009)". Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Consolidate multiple MicroStrategy cubes into a single Kyvos data model without limitations on the data size or the number of dimensions that the model can hold. MicroStrategy Analytics cubes are easy to create and deploy. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. Upgrade to those versions to take advantage of the fix. This difference is roughly equal to the size of the Intelligent Cube footprint in-memory versus the size of the compressed disk cache. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Select one: To create a new security filter, click New. The display of data is handled by the reports that access the Intelligent Cube. For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. Navigate to the Data Refresh category. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Create Schema Objects. When using an Intelligent Cube, you already have an in memory dataset. Cube and Cache Metric Names. x. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. Required Status to Perform Action. Click the MicroStrategy icon at the upper left of any page and select History List. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Create Schema Objects. 4. Based on the previous explanation, you should only create derived attributes or metrics whenever. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. By default, there is a system hierarchy on the cube. Create Schema Objects. To use an attribute form. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. 3 - Check the Make Intelligent Cubes. In addition, multiple logical tables can represent the same physical table. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. STG_IS_CUBE_REP_STATS. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. For more information on security filters, see the System Administration Guide. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. You can add data for your Intelligent. x, updating an Intelligent Cube returns "Cube Manager: number of c… Number of Views 1. 0 has a dedicated section to memory used for Intelligent Cubes. Integer ID of the Intelligent Cube report that was published, if any. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. A schedule is defined in Python code. An Intelligent Cube is. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. KB442630: CSI optimization for improving the in-memory query execution for many. Intelligent Cube file directory: Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. Report: The results of a report are used to populate the Intelligent Cube. By default, the report template used is the same as the Intelligent Cube's template. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. All MicroStrategy security settings are respected when interacting with MicroStrategy. However, OLAP Services provides MOLAP and ROLAP analysis on the same report, which offers many distinct benefits, summarized below: Using OLAP Services, you can get fast response times for reports that use data directly from in-memory Intelligent Cubes, instead of from the data warehouse. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. The status of each Intelligent Cube is listed in the. The Cubes are modeled with a built-for-purpose modeling thus requiring additional schema work instead of directly leveraging the already-built schema model MicroStrategy Cube Advisor recommends and automatically creates an optimal set of in-memory cubes based on usage patterns for different users accessing the BI system. ACTION:In MicroStrategy Intelligence Server, how does the project configuration setting "Load Intelligent Cubes on startup" work in a clustered environment?To Create an Intelligent Cube Using Freeform SQL or Query Builder. Prerequisites to creating Intelligent Cubes. . In MicroStrategy 10. 1 or above, to pick up the fix, enable project level setting "Data Engine. IS_CUBE_REP_ID. 4. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Check in Developer that the stopped node is in Maintenance Mode. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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. Browse to the filter you want to convert and click Open. Right-click an Intelligent Cube and select Delete. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Run a dossier based on the cube. 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. E. In MicroStrategy 9. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. This. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. Why is This Happening? MicroStrategy uses different default encoding for Linux (UTF-8) and Windows (Non UTF-8). In MicroStrategy 10. 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. Users of Intelligent Cubes in MicroStrategy 9. Open the. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . 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‘. com. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. It is shared by all processes running on the machine, including the operating system. Providing Intelligent Cube data. STEPS TO REPRODUCE 1. Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available.