This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. * MicroStrategy does have support for dynamic sourcing with MDX sources. Together with the Reports API, this API is often referred to as the JSON Data API. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. The view filter cannot filter out other elements as shown below:Data Modeling. 4. Number of Views 8. Intelligence Server Statistics Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Documentation on the REST API is at developer. 0. Click All Objects View. By default, there is a system hierarchy on the cube. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. First, you open a blank document and select a report to use as the document's dataset. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. 4. Integer ID of the Intelligent Cube report that was published, if any. x If the Administrator wants to create a user that is. The Modeling service must be configured correctly to use this feature. OR, to convert an existing filter into a security filter, click Import. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. 6 and higher. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Web Open the Settings page (right click the extension and select Options). 4. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. mstr file is a zipped file of object definition package and cube files. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. This can be seen in the screenshot below. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 15K. Right-click an Intelligent Cube and select Delete. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. This applies for example to Cubes created via MicroStrategy Web client. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. When using MicroStrategy and Teradata, the best approach is to. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. The Schedule dialog box opens for your dataset, showing the tables in your dataset. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Data Population for Intelligent Cubes. You cannot create a card based on a live-connect MDX/SAP cube. Edit Intelligent Cubes from the new editor in Workstation at any time. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. Create an Intelligent Cube with attributes Year, Month and Region; 4. This. Intelligent Cubes are multidimensional cubes (sets of data) that exist on the MicroStrategy Intelligence Server memory and can be shared among different users. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Cube Limitations. 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. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. This means any report you create will have caching enabled by default. It is especially useful when data. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. Cube and Cache Metric Names. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. In a BI platform, the logical data model is designed and built using current user requirements. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to. 2. The Full Refresh option is the default. In MicroStrategy Integrity Manager 10. To build an Intelligent Cube. x. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. There's a reason we're at the top of the list. However, the cube monitor doesn’t show partition related information. Most likely several, different fact tables are uses for each query. (Does it sound like multisourcing for all the users without admin help?)Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that can be used by the Microstrategy Intelligence Server. The ability to view or edit certain settings is determined by a user's privileges. x - 10. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. x - 10. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. To use an attribute form. All cubes respect the governing setting. Steps To Reproduce 1. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. To enable or disable dynamic sourcing for an Intelligent Cube. When an Intelligent Cube is in this status, any reports based on this cube have. Browse to and select a previously saved Intelligent Cube on which to build your report. If the Intelligent Cube must be re-processed based on a metric. Implicit degradation occurs when the Intelligent cube report level is not compatible with the fact level of any metric being used in the Intelligent Cube (Fact Editor > Tools > Show Fact Entry Level) so a cross join between the fact table and the report level attribute is needed resulting in a fact extension and disabling Dynamic Sourcing for that specific Intelligent. The. A document is used to format data from multiple datasets in a single display of presentation quality. Memory Storage for document or dossier. Loading. This can. 1. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. Integer ID of the project where the Intelligent Cube is stored. This can improve the performance of. x in maintenance mode, it is recommended for users to enable the setting Cluster Synch Check Duplicate Cubes through the Windows registry or through the MSIReg. IS_CUBE_REP_ID. Related Articles. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Open the Workstation window. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. With OLAP Services features, your report designers can create Intelligent Cube reports. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. This import bridge imports MicroStrategy logical tables as Dimensions. location_path: is the folder where the intelligent cube. GUID of the Intelligent Cube instance in memory. Execute the report and view the SQL:MicroStrategy enables users to pull subsets of data, which could be up to hundreds of Gigabytes, from a Big Data source into an in-memory cube, and build reports/dossiers from the 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. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. This is due to the fact that adding prompts to Intelligent Cubes is not supported. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. 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. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. From the Data menu, select Add Dataset. The Intelligent Cube Monitor is displayed. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. Maintaining data access security. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Why is This Happening? MicroStrategy uses different default encoding for Linux (UTF-8) and Windows (Non UTF-8). For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. The Intelligent Cube Options dialog box opens. 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. The Intelligent Cube refresh settings are recommended if the data in the. On the toolbar, choose Data > Configure Intelligent Cube. 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. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version. Share query results in-memory across multiple dossiers and. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. GUID of the Intelligent Cube instance in memory. The default value is 256 megabytes. Intelligent Cube storage on disk mirrors report cache storage. An Intelligent Cube has been created in a project. 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. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes"You can edit project-level cache and Intelligent Cube settings. 3. The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Dynamic Refresh: The Intelligent Cube's filter is. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. log without functional impact. For more details on enabling the setting. Making the move from Developer to Workstation even smoother, users can now create Intelligent Cube Reports in Workstation. Share query results in-memory across multiple dossiers and reports. Edit Intelligent Cubes from the new editor in Workstation at any time. 3. In MicroStrategy 10. When using an Intelligent Cube, you already have an in memory dataset. If the Intelligent Cube must be re-processed based on a metric. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. x - 9. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. 2. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Senior Lead, Application Support. Choose File > New > Intelligent Cube. Intelligent cubes support time zone based reporting. If the indexes are needed again,. IS_PROJ_ID. Comparing OLAP and MTDI cubes. In MicroStrategy Developer, log in to a project source with administrative privileges. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. This import bridge imports MicroStrategy logical tables as Dimensions. MicroStrategy Analytics cubes are easy to create and deploy. The dataset is a set of data that can be displayed on the document. 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. Specify a name and location for the new security filter and click Save. In the left panel, click Cubes. Open the. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. The Intelligent Cube Options dialog box opens. Create a report based on above Cube and add the prompt in view filter. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version. Required Status to Perform Action. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. In MicroStrategy Desktop 9. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. MicroStrategy is the only comprehensive analytics vendor that supports big data analytics with native connectors to HDFS to access petabytes of data in real time. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. A report that runs against the Intelligent Cube. 2. 56K. Defining Memory Limits for Intelligent CubesThis article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Exit all Windows applications before beginning the installation process. 4. Publish the Intelligent Cube by executing it on either of the nodes. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Expand the Object Templates category, select General, and. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. Only one cube file will be generated for each Intelligent cube on disk. Intelligent Cubes. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. x. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 0 MicroStrategy releases. Providing Intelligent Cube data. Enable core dumping. All MicroStrategy security settings are respected when interacting with MicroStrategy. IS_CUBE_REP_ID. ACTION This. Navigate to the Intelligent Cube for which you want to define the incremental refresh. For more details on enabling the setting, refer to Change Data Engine VersionCertify a super cube¶ Use SuperCube. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. 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. x, create a simple Intelligent Cube with attribute Category and metric Revenue. x. Pros and Cons. 3. Save the Report and close. Drag and drop the objects into the report grid from the Report Objects pane. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. An example of this behavior for a relatively small cube is shown in the screen shots below:The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Create Cube1 with the Region attribute and the metric created in step 1. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. This Knowledge base article describes limitations in using security filters and intelligence cubes. Export data frames from RStudio to MicroStrategy in-memory cubes. 0: Balance MicroStrategy Server threadsDescription The . The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. View the report in either Grid View or Grid and Graph View. Job ID for the action on the Intelligent Cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. 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. 1. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. These reports allow data to be returned from the data. . Prerequisites to creating Intelligent Cubes. 4. HyperAndroid Go to the Account tab. Dynamic Sourcing is a new feature of MicroStrategy 9 OLAP Services that automatically checks a report request, and sources data from a MicroStrategy Intelligent Cube wherever possible. A workaround is available in the current document. To Create a Report that Accesses an Intelligent Cube. 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. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. From the Categories list, expand Options, and then select General. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. 0. The data used for this example. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. The requests are granted or denied according to user-configured limits on the amount of. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. You can add data for your Intelligent. 3. If the indexes are needed again, they are reloaded into memory from disk, instead of being regenerated. For example, an Intelligent Cube that contains data for the top 200 stores by. Browse to and select a previously saved Intelligent Cube on which to build your report. NOTE: There is an inherent limit specific to importing Excel files due to using an internal Java component to extract the data from Excel files. An enhancement Request has been reported to the MicroStrategy Technology team. The **_objects folder with a size of 277G. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The . Click Select. - Normalize Intelligent Cube data in the. 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%. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. This table is not populated unless at least one of the Advanced Statistics Collection Options are selected in the Statistics category of the Project Configuration Editor. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Open the. Under VLDB settings > Query Optimizations > Data Population for Intelligent Cubes admins need to test all the following options: - Normalize Intelligent Cube data in the database. MicroStrategy HyperIntelligence is the next step in the future of data analytics. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. Data modeling is the structuring of an organization's data assets into an applicable logical model. 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. Both properties are located in the Query Optimizations folder in the VLDB property editor. The cube is based on a MDX datasource, specifically SAP BW. table_id: is the guid of a table. Select one: To create a new security filter, click New. Created Intelligent Cubes to solve the performance issues. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. x using Command Manager. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. 1. 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. Intelligent. After execution. An Intelligent Cube publication takes significantly long to complete publication (several hours). " The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. x or 10. 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. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. Since Intelligent Cubes function simply as. 4. Open the Workstation window. Create a report based off the cube in Step 1 that includes the description form for Category. Measures the time duration an operation executed against cubes. IS_CUBE_ACT_ID. If desired, user can create a dashboard immediately from the imported data. The Security Filter Editor opens. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Designing and creating documents: An overview. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. In Enterprise Manager 10. x, but not to publish it, the minimum privileges that the Administrator would need to. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. 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. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. x Intelligent Cube status indication and workflow . STEPS TO REPRODUCE: 1) Add external dataset. The New Intelligent Cube dialog box opens. For reports and Intelligent Cubes that do not use MultiSource Option or database gateway support to access multiple data sources, all queries are processed sequentially. Starting from MicroStrategy 9. Intelligent Cubes can be based on MicroStrategy data or imported data. However, if the Intelligent Cube Monitor on the other node is checked, the size of the same Intelligent Cube will be smaller. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. x. This dataset needs to contain all data in the required granularity. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Note: The maximum file size that can be imported is 100 MB. x -10. The Attribute Index An Intelligent Cube is an In-Memory data structure which holds information from a source in a readily accessible format for quick access. 4. 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 must belong to the System Administrators group to use this feature. MicroStrategy logical tables do not necessarily represent physical tables. 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. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. It stores the non-normalized table into the MicroStrategy. 4. From the Data menu, select Configure Intelligent Cube. Use Case 4. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. Cube Advisor opens. To add an existing report or Intelligent Cube as a dataset. Öffnen Sie das Workstation-Fenster. When a machine runs out of virtual memory, processes on the machine are no longer able. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to its memory limit. Within the set. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. The Incremental Refresh Options dialog box opens. This Python 3 / MicroStrategy 10. The Intelligent Cube is opened in the Report Editor. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. Rather than returning data from the data warehouse for a single. 3. Go to the Report -> Data->Intelligent Cube Options->Point grid to. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). The Intelligent Cube must be published before this report can execute. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. Cube Limitations. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Number of Views 1. 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. ACTION: A fix for this issue is included in MicroStrategy 10. Download the files from the MicroStrategy download site. Log on to the machine where you are installing one or more MicroStrategy products. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesSTEPS TO REPRODUCE. You may share the Intelligent Cube as a single copy in memory. 2 – The data is being pushed to MicroStrategy Intelligent. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes" You can edit project-level cache and Intelligent Cube settings. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 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. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. When a machine runs out of virtual memory, processes on the machine are no longer able. Users of Intelligent Cubes in MicroStrategy 9. "The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. After the previous changes, you'll have to save the cube and republish it. This is the same requirement to create or run a static report in Workstation. 5. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Along with. In addition, multiple logical tables can represent the same physical table.