Download the files from the MicroStrategy download site. The Intelligent Cube opens in the Report Editor. The limitations of Microstrategy are not worth. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Number of Views 523. 2. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. Loading. IS_CUBE_INST_ID. This Python 3 / MicroStrategy 10. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. Select one: To create a new security filter, click New. This Knowledge base article describes limitations in using security filters and intelligence cubes. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. Add External Data. However, if the. * MicroStrategy does have support for dynamic sourcing with MDX sources. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 0 votes. Click View Logs, to display the share icon in the upper-left. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. 0. 3. Check the status of the cubes in Developer. Modify or remove the view filter to attempt to return data for the report. Making the move from Developer to Workstation even smoother, users can now create Intelligent Cube Reports in Workstation. It stores the non-normalized table into the MicroStrategy. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. This means any report you create will have caching enabled by default. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to. For more information on security filters, see the System Administration Guide. Specify a name and location for the new security filter and click Save. To enable. MicroStrategy AI is here. The user then updates the cube. The **_objects folder with a size of 277G. Related Articles. You must belong to the System Administrators group to use this feature. 4. Create a report based off the cube in Step 1 that includes the description form for Category. 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. A solution/code fix for this issue is not available in current releases but is. Check it in the cube monitor and we can see its column Database Connection is not empty. When running MicroStrategy Intelligence Server 9. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. In MicroStrategy 10. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. Strong semantic layer to define all the business rules and tightly coupled. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. x and newer. The New Grid dialog box opens. com. 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. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. 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. Email subscriptions deliver a report or document to one or more email addresses. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. By default, this is set to 32,000. Providing Intelligent Cube data. Easily add or change pre- and post- SQL statements. If the Intelligent Cube must be re-processed based on a metric. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. 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. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. It remains available, but is not enforced if it is less than the default value of 100000. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Run a dossier based on the cube. Create a report based on above Cube and add the prompt in view filter. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. If the Intelligent Cube must be re-processed based on a metric. 3 - Check the Make Intelligent. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. This is set to 32,000 by default. Required Status to Perform Action. GUID of the Intelligent Cube instance in memory. Create an Intelligent Cube with attributes Year, Month and Region; 4. The MicroStrategy Intelligence Server 9. They should have the “A, L, F” status (Active, Loaded, Filed). com The Maximum RAM usage (Mbytes) memory limit can be defined per project. 3. After execution. 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. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. Integer ID of the Intelligent Cube report that was published, if any. This Python 3 / MicroStrategy 10. x releases, and the new Multi-table Data Import (MTDI) cubes. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. 1. Provides the last cube row count. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. 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. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. The Security Filter Editor opens. Upgrade to those versions to take advantage of the fix. Share query results in-memory across multiple dossiers and reports. Republish the same cube, and a new cube instance is generated. . 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. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. microstrategy. Cube Advisor opens. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. Number of Views 1. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. When using an Intelligent Cube, you already have an in memory dataset. Right-click an Intelligent Cube and select Delete. 3. Edit SQL Transactions in Reports. Integer ID of the project where the Intelligent Cube is stored. x. The. Strong semantic layer to define all the business rules and tightly coupled. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Right-click the dataset, and choose Schedule. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. If removing the view filter does not. x - 10. 4. This import bridge imports MicroStrategy logical tables as Dimensions. 1 – Python program gets and processes the data from a Data Source. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. g. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Under Refresh type, select one of the following options. For example, the above Data Import fails even though the actual utilization of the Intelligent Cubes are 5388mb out of 12000mb, and the Data Import Manager from MicroStrategy. The Intelligence Server checks to see if there is an existing cache for the same Report. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). When using MicroStrategy and Teradata, the best approach is to. Overview. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. x - 10. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. This is controlled by the Python script. 3 - Check the Make Intelligent Cubes. MicroStrategy Web: Web Server. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. Modeling is creating information that describes another set of data. 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. The Intelligent Cube Monitor is displayed. Pros and Cons. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. When a remote accesses this cube, the cube is loaded into memory of the. 0. Type of action against the Intelligent Cube: •In MicroStrategy 11. The first column provides the Intelligent Cube name, and the second column provides the full path to the Command Manager script files used to publish the. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. 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. An Intelligent Cube is. If the Intelligent Cube must be re-processed based on a metric. Dossiers automatically adjust to look great on any screen. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. To access the MicroStrategy Installation Wizard. A report that runs against the Intelligent Cube. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. In the New Intelligent Cube dialog box, select the MDX Sources tab. 1. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Complex metrics here refer to metrics which are defined using multiple. Extensively used “Apply Simple” function for creating attributes. Select data population for Intelligent Cubes. Cube Limitations. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. Select the Allow reports to drill outside the Intelligent Cube check box. Number of Views 1. 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. Records statistics related to Intelligent Cube manipulations. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. This import bridge imports MicroStrategy logical tables as Dimensions. This. In the left panel, click Cubes. Exit all Windows applications before beginning the installation process. Forecast Sales. When you run reports in MicroStrategy, they collect the warehouse data. ACTION: A fix for this issue is included in MicroStrategy 10. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. To build an Intelligent Cube. The Modeling service must be configured correctly to use this feature. 4. IS_CUBE_ACT_ID. 2. It involves only fetching a portion of the data that the user wants, instead of storing all data in-memory as a normal Intelligent Cube. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. For the steps to define an incremental refresh report, refer to:Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. 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. mstr file is a zipped file of object definition package and cube files. Transactions. Contact the MicroStrategy Technical Support for an update on this enhancement request. A workaround is available in the current document. To review and create recommended Intelligent Cubes using Cube Advisor. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. x. 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. First, you open a blank document and select a report to use as the document's dataset. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Edit Intelligent Cubes from the new editor in Workstation at any time. Open the Workstation window. To do so, you can take advantage of URL API. When an Intelligent Cube is in this status, any reports based on this cube have. IS_PROJ_ID. In MicroStrategy Desktop 9. Answer: Go with dossier. The Intelligent Cube is opened in the Report Editor. x and 10. 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. Choose your preferred method to share the logs. 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. Required Status to Perform Action. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. This is the same requirement to create or run a static report in Workstation. 2. 3. 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. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Select the Security Filters tab. 5. In MicroStrategy 10. Export data frames from RStudio to MicroStrategy in-memory cubes. Publish the Intelligent Cube by executing it on either of the nodes. Browse to and select a previously saved Intelligent Cube on which to build your report. By profiling the Intelligent Cube publication (as per KB30699 - How to measure the Intelligent Cube performance parameters for time and memory in the MicroStrategy Intelligence Server 9. Select the schedule you had created in step 2 and in the Intelligent Cubes field, select the desired Intelligent Cube as seen below: 6. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. Expand the Object Templates category, select General, and from the Show templates for the. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. 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. For more information on security filters, see the System Administration Guide. The default value is 256 megabytes. The objects in the source cubes will control how the security filter will be applied. How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. 0. certify() to certify / decertify an existing super cube. Memory Storage for document or dossier. For more information on the Intelligent Cube Maximum. 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. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. 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. Navigate to the Intelligent Cube for which you want to define the incremental refresh. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. To define an incremental refresh report. 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 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. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . Create a security filter on the region attribute such as region not in list central. 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. Create a dossier and add subset R from Existing Dataset. IS_CUBE_INST_ID. This can. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. This KB answers a question regarding memory limitations for In-Memory data import for MicroStrategy 10. 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. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active 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%. Users of Intelligent Cubes in MicroStrategy 9. 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. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. Intelligent. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. 2. The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In the Navigation pane, click Monitors. This is the same requirement to create or run a static report in Workstation. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. However, the cube monitor doesn’t show partition related information. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. 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. It will remain available, but the setting will not. Slice and dice features are awesome. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. This Knowledge base article describes limitations in using security filters and intelligence cubes. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. E. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. metrics in the intelligent cube or in the MicroStrategy schema and application objects. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 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. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. Within the set. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Right-click an Intelligent Cube and select Delete. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Choose your preferred method to share the logs. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. IS_CUBE_REP_ID. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. 1 and 10. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. Öffnen Sie das Workstation-Fenster. x. 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 addition, multiple logical tables can represent the same physical table. An enhancement Request has been reported to the MicroStrategy Technology team. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. microstrategy. 0: Balance MicroStrategy Server threadsDescription The . 2. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. A schedule is defined in Python code. 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. Publish the cube. Intelligent Cubes can be based on MicroStrategy data or imported data. 2. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 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. In MicroStrategy 10. This applies for example to Cubes created via MicroStrategy Web client. x. Edit Intelligent Cubes from the new editor in Workstation at any time. Node 1. zip file, with the. 3. 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 pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". There's a reason we're at the top of the list. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. 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. If a new column is added to the data import data source and the cube is republished, there is no effect. 0. Dynamic Sourcing. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. See full list on community. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. Select the data set and click Prepare Data. 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 . The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. In MicroStrategy Developer, log in to a project source with administrative privileges. The Intelligent Cube opens in the Report Editor. The New Grid dialog box opens. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. STEPS TO REPRODUCE 1. Intelligent Cube memory usage for each node in a clustered environment. Save the Report and close. This template includes the following tasks: Creates a new metadata. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. It is especially useful when data. This import bridge imports MicroStrategy logical tables as Dimensions. Using mstrio as a MicroStrategy Intelligence Server administration tool¶For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. x This is a new feature introduced in MicroStrategy version 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. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. 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.