Since Intelligent Cubes function simply as. This is due to the fact that adding prompts to Intelligent Cubes is not supported. Since an Intelligent Cube is structured similarly to a Relational Database the method of retrieving data from the Intelligent Cube, Cube Subsetting Instructions, is very similar to. Related Articles. This import bridge imports MicroStrategy logical tables as Dimensions. To build an Intelligent Cube. The data load process moves this table's information to the IS_CUBE_REP_STATS table, which has. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Index: P = Processing A = Active L = Loaded D = Dirty F = Filed M = Monitoring Information Dirty When a user executes an Intelligent Cube, the initial status is P. 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. Memory Storage for document or dossier. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. Note: The maximum file size that can be imported is 100 MB. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. 0. You must belong to the System Administrators group to use this feature. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. The data used for this example. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. 2. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. Slice and dice features are awesome. In the Drilling area, clear the Use default settings check box. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. The status of each Intelligent Cube is listed in the. Although the directory filed shows the same location as the source project, cubes are saved to a. It will remain available, but the setting will not be enforced if set below the default value of 100000. MicroStrategy Professional Services for high performance. Save the Cube with Connect Live Data Access Mode. Create Schema Objects. the user still needs the privilege for re-publishing Intelligent Cubes, but just need this restricted for particular cubes), while still allowing this user to perform Visual Insight analysis on the cubes information. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. 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. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. 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. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. The Security Filter Editor opens. 5 GB. Introduction. MicroStrategy logical tables do not necessarily represent physical tables. 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. Upgrade to those versions to take advantage of the fix. To view an Intelligent Cube stored in your History List. When a machine runs out of virtual memory, processes on the machine are no longer able. Slice and dice features are awesome. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Run sudo vi /etc/sysctl. Before MicroStrategy 10. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. Documents . Published: Apr 6, 2017. x. x. The interface has changed a bit. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. MicroStrategy logical tables do not necessarily represent physical tables. For more details on enabling the setting. A user logs out of a MicroStrategy Project by scheduler. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available. 3. MicroStrategy 10 will report the following. 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. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. Dynamic Refresh: The Intelligent Cube's filter is. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The New Grid dialog box opens. Navigate to and run the Intelligent Cube report. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. This difference is roughly equal to the size of the Intelligent Cube footprint in-memory versus the size of the compressed disk cache. In a MicroStrategy Intelligence Server clustered environment, it is observed that dynamic sourcing does work against Intelligent Cubes available on a remote node, after updating the schema. To enable or disable dynamic sourcing for an Intelligent Cube. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Choose File > New > Intelligent Cube. 3. A workaround is available in the current document. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Click View Logs, to display the share icon in the upper-left. 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. MicroStrategy AI is here. Provides the last cube row count. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Because the filters are applied to the master data in the Intelligent. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. In addition, multiple logical tables can represent the same physical table. This Knowledge base article describes limitations in using security filters and intelligence cubes. The **_objects folder with a size of 277G. IS_CUBE_ACT_ID. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Share query results in-memory across multiple dossiers and. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. In MicroStrategy Desktop 9. 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. 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. 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%. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. This Python 3 / MicroStrategy 10. View the report in either Grid View or Grid and Graph View. Add External Data. To do so, you can take advantage of URL API. Export data frames from RStudio to MicroStrategy in-memory cubes. Easily add or change pre- and post- SQL statements. For example, an Intelligent Cube includes the. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. Share query results in-memory across multiple dossiers and reports. The requests are granted or denied according to user-configured limits on the amount of. These reports allow data to be returned from the data. Integer ID of the project where the Intelligent Cube is stored. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. Navigate to the folder location of the Intelligent Cube. In the New Intelligent Cube dialog box, select the MDX Sources tab. 1. The Maximum RAM usage (Mbytes) memory limit can be defined per project. Starting with MicroStrategy Intelligence Server 9. x releases, and the new Multi-table Data Import (MTDI) cubes. reg file on UNIX/Linux operating systems. Limiting the Maximum Report Size. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. IS_CUBE_INST_ID. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. . @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. x. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. the project configuration: ACTION . This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. Integer ID of the Intelligent Cube report that was published, if any. x - 9. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. 3. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Number of Views 5. 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. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Most likely several, different fact tables are uses for each query. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. 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. This is set to 32,000 by default. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. In the Navigation pane, click Monitors. An Intelligent Cube is a. MicroStrategy tests on at least one of the CPU chipsets within a set of binary-compatible CPU architectures for purposes of certifying and supporting operating systems with MicroStrategy products. 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. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Modify or remove the view filter to attempt to return data for the report. Another way to use caching in MicroStrategy is through Intelligent Cubes. 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%. Published: Jun 29, 2018;KB321029: In MicroStrategy 10. x? To answer this question, the "Query Engine finish time" is marked when the warehouse query step for generating the Intelligent Cube finishes. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. To build an Intelligent Cube. For more information on security filters, see the System Administration Guide. x -10. On the left side of the page, click Logs and then Export Logs to save the file. Create Cube B which contains all objects in the report and publish it . 3. To review and create recommended Intelligent Cubes using Cube Advisor. x. A document is used to format data from multiple datasets in a single display of presentation quality. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Create a report with this Intelligent Cube and execute the report --> one row with 4 element returned. It is also more difficult or impossible for someone reporting on Intelligent Cube. Moreover, you may generate among the various reports of many users. SYMPTOM Users may notice that duplicate cube instances are created after an intelligent cube that had a neutral locale is updated with a multilingual. In MicroStrategy Desktop 9. Cube Cache Hit: Download MSTR File with Cube Cache Hit: Indicates a user exported a dossier object based on cube as an MSTR file and hits the cube cache. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":The peak memory for publishing an Intelligent cube is much larger in Winodws than Linux if the data contains ASCII characters. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. Choose Data > Configure Intelligent Cube. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Extensively used “Apply Simple” function for creating attributes. 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. To define an incremental refresh report. IS_CUBE_REP_ID. 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. Drag and drop the objects into the report grid from the Report Objects pane. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. 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. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. When running MicroStrategy Intelligence Server 9. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. Designing and creating documents: An overview. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. table_id: is the guid of a table. For more information on Intelligent Cube sizes, refer to the following MicroStrategy Knowledge Base technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Create an Intelligent Cube with this attribute and publish. MicroStrategy HyperIntelligence is the next step in the future of data analytics. For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. This can be seen even when the actual total memory consumption of the Intelligent Cubes loaded for this Project is below the configured Governing Setting. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. The considerations and steps required to fully support dynamic sourcing are listed below: While many MicroStrategy features can be used with dynamic sourcing, some features may prevent the use of dynamic sourcing between reports and Intelligent Cubes. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. x environment . The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. III. 86K KB31566: MicroStrategy 9. 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. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. certify() to certify / decertify an existing super cube. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. 4. Defining the partition for Super Cubes. Slice and dice features are awesome. 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. If the Intelligent Cube must be re-processed based on a metric. In reality, an . 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. Transactions. In MicroStrategy 10. Number of Views 1. IS_CUBE_INST_ID. GUID of the Intelligent Cube instance in memory. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the. Pros and Cons. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Intelligence Server Statistics . If you are upgrading to MicroStrategy 11. The user then updates the cube. Both properties are located in the Query Optimizations folder in the VLDB property editor. All MicroStrategy security settings are respected when interacting with MicroStrategy. microstrategy. 3 - Check the Make Intelligent. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. However, the cube monitor doesn’t show partition related information. Check in Developer that the stopped node is in Maintenance Mode. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Overview. Therefore, the Cache Status is stored in the fact_latest_cube_cache and fact_action_cube_cache tables to track the latest, historical, and changing status over the life of the cube cache instance. Typically, a cube is setup to be published at regular intervals and is saved in the server's main memory, eliminating the time-consuming need to query the Big. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. A solution/code fix for this issue is not available in current releases but is. Click the MicroStrategy icon at the upper left of any page and select History List. 2. 5. The default value is 256 megabytes. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 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). MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. The Intelligent Cube Options dialog box opens. Create an attribute element prompt for the. KB442449: Dossier Performance: Connect Live performance considerations. 0 has a dedicated section to memory used for Intelligent Cubes. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. Select one: To create a new security filter, click New. x, updating an Intelligent Cube returns "Cube Manager: number of c… Number of Views 1. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. Create Schema Objects. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. The display of data is handled by the reports that access the Intelligent Cube. 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. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. This allows for more power and control over data for MicroStrategy. 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‘. However, if the. This will reduce the memory usage from 150GB to 100GB. The Modeling service must be configured correctly to use this feature. Open the. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 2. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. 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. 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 ). A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Datasets API. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. An enhancement Request has been reported to the MicroStrategy Technology team. To Create a Report that Accesses an Intelligent Cube. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . 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’. Once an Intelligent cube is created and then published so its data is available, multiple reports can be created to connect to the Intelligent cube. 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. In the Refresh Policy column, choose one of the following options:Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. Then it generates a report. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. 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. microstrategy. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. You can create and analyze new reports in real time. If the Intelligent Cube must be re-processed based on a metric. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). x and newer. When using MicroStrategy and Teradata, the best approach is to. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. 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. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. A valid CPU architecture is provided in parentheses () to clarify the operating system software certified or supported for Intelligence Server. ACTION: A fix for this issue is included in MicroStrategy 10. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). If the data in the Intelligent Cube is outdated. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Create 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)". When using an Intelligent Cube, you already have an in memory dataset. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. You can control users' access to data with security filters. 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. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. You can use Integrity Manager to perform a before and after test to identify which reports actually connect to a suggested Intelligent Cube and also to test data integrity. Moreover, you can return a data. Publish the cube. This Python 3 / MicroStrategy 10. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . MicroStrategy Analytics cubes performance is best in the industry from performance point of view. For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. IS_CUBE_REP_ID. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Specify a name and location for the new security filter and click Save. 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. IS_PROJ_ID. 4. 3. 4. CAUSE. Job ID for the action on the Intelligent Cube. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. x and 10. x to 11. Maintaining data access security. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. If the Intelligent Cube must be re-processed based on a metric. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. 4. The aim of this KB is to have a look at the Live connected intelligent cubes performance considerations as it’s necessary to understand how many steps are involved in the process, of course each step consumes time, hence the more steps the more time will take a dossier to. cube; oracle12c; cubes; microstrategy; Jorgechu. Number of Views 1. In other words, the new column will NOT get mapped automatically in the existing Intelligent Cube. 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. To do this, edit the report in developer and go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose the new target cube: Create Cube A and a report based on it. Pros and Cons. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Alternatively, you can enable caching on selected reports. 3 - Check the Make Intelligent Cubes. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9.