Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Edit Project-Level Cache and Intelligent Cube Settings. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. 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. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. HyperAndroid Go to the Account tab. With OLAP Services features, your report designers can create Intelligent Cube reports. Modify or remove the view filter to attempt to return data for the report. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. If the Intelligent Cube must be re-processed based on a metric. 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 ). 0 MicroStrategy releases. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Data modeling is the structuring of an organization's data assets into an applicable logical model. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. The Intelligent Cube is opened in the Report Editor. 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 . In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The objects in the source cubes will control how the security filter will be applied. 3. . for a script with several commands, one of which being a cube publication command, the. Can. x - 10. 2. HyperAndroid Go to the Account tab. IS_CUBE_INST_ID. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The memory used by Intelligence Server is limited by the machine's virtual memory. 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. 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. Advanced category, select the Balance MicroStrategy Server threads check box. From the Data menu, select Add Dataset. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. 4. 1 release. 0. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. A MicroStrategy Report Services document displays your organization's data in a format. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. MicroStrategy version 9. 11. Create Schema Objects. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. IS_CUBE_REP_ID. 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. Moreover, you may generate among the various reports of many users. Rather than returning data from the data warehouse for a. Click the “Add history list subscription” link near the bottom of the screen to open the. x -10. Created Intelligent Cubes to solve the performance issues. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. You can create and analyze new reports in real time. Choose your preferred method to share the logs. MicroStrategy AI is here. Publish the cube. In MicroStrategy 10. To access the MicroStrategy Installation Wizard. Under Refresh type, select one of the following options. 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. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. The article discusses a known situation in MicroStrategy 10. Web Open the Settings page (right click the extension and select Options). In this case, the dataset is a MicroStrategy Intelligent Cube. This Knowledge base article describes limitations in using security filters and intelligence cubes. What BO customers are interested in knowing 3A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. 79K. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. Dynamic Refresh: The Intelligent Cube's filter is. 2. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Intelligent Cube memory usage for each node in a clustered environment. This template includes the following tasks: Creates a new metadata. The Intelligent Cube opens in the Report Editor. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. MicroStrategy AE, even when the data is coming from an intelligent cube, MicroStrategy still needs to calculate the derived elements and depending on the data size and complexity sometimes these calculations can take minutes. Publish the Intelligent Cube by executing it on either of the nodes. 88K. If you are upgrading to MicroStrategy 11. A report instance is the version of the report results that Intelligence Server holds in memory for cache and working set results. mstr file is actually a . Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. The Full Refresh option is the default. Providing Intelligent Cube data. The Security Filter Editor opens. The first is to enable report caching at the project level. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. The user then updates the cube. 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. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. It is shared by all processes running on the machine, including the operating system. If desired, user can create a dashboard immediately from the imported data. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. the project configuration: ACTION . Report: The results of a report are used to populate the Intelligent Cube. 2) Choose "Database" and select the 3rd option to "Pick tables". Transactions. This import bridge imports MicroStrategy logical tables as Dimensions. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. The. How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. When you run reports in MicroStrategy, they collect the warehouse data. In versions prior to MicroStrategy Intelligence Server 9. By default, MicroStrategy Command Manager handles cube publication synchronously (i. CAUSE. After the previous changes, you'll have to save the cube and republish it. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. IS_CUBE_REP_ID. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. This can improve the performance of. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. To view this field, the Intelligent Cube must be published at least once. Within the set. See full list on community. A document is used to format data from multiple datasets in a single display of presentation quality. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. 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. Create Cube2 with the Region attribute and the metric created in step 1. This difference is roughly equal to the size of the Intelligent Cube footprint in-memory versus the size of the compressed disk cache. Enable core dumping. 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. g. Choose Data > Configure Intelligent Cube. 3. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Note: The maximum file size that can be imported is 100 MB. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. Intelligence Server Statistics . In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. This will reduce the memory usage from 150GB to 100GB. 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. 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. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. Choose one of the following options: Full Refresh: This is the default. STG_IS_CUBE_REP_STATS. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Instantly analyze any amount of data without in-memory limitations of MicroStrategy intelligent data models. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 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. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. Intelligent Cubes. MicroStrategy 10 will report the following. A document that uses the Intelligent Cube as a dataset. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. 1. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. Documents . Download the files from the MicroStrategy download site. Along with. Dossier Datasets do not include all the Security Filter attributes, and one of the Datasets are Connect Live Data Import Dataset, it may have security concerns. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Open the. x. Pros and Cons. On the left side of the page, click Logs and then Export Logs to save the file. The status of each Intelligent Cube is listed in the. com. cube; oracle12c; cubes; microstrategy; Jorgechu. Create an attribute element prompt for the. 3. 3. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Case A: Security Filter attribute is related to attributes placed on the grid. 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. The **_objects folder with a size of 277G. To add an existing report or Intelligent Cube as a dataset. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. 4. 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. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. 0. Limited mobile capabilities compared to the latest BI tools like MicroStrategy. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Type of action against the Intelligent Cube: •In MicroStrategy 11. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. SYMPTOM Users may notice that duplicate cube instances are created after an intelligent cube that had a neutral locale is updated with a multilingual. Intelligent Cube storage on disk mirrors report cache storage. IS_CUBE_ACT_ID. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. This import bridge imports MicroStrategy logical tables as Dimensions. Mclean, Virginia. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. This is the same requirement to create or run a static report in Workstation. Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. In MicroStrategy Developer, right-click on the project and select Project. Extensively used “Apply Simple” function for creating attributes. Reproduce Steps This level of system resources allows MicroStrategy Intelligence Server to fully use performance-improving technologies such as MicroStrategy OLAP Services, and to support optimal performance for MicroStrategy Report Services documents and dossiers and the other features of the MicroStrategy Product Suite. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. The Incremental Refresh Options dialog box opens. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 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. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. x - 10. In the Drilling area, clear the Use default settings check box. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. microstrategy. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Feb 2020 - May 2022 2 years 4 months. In a BI platform, the logical data model is designed and built using current user requirements. xA warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Using Database Write-back Functionality to Enable Decision-Making. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 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. The. Users with different security filters can use the same Intelligent Cube data. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. Check the status of the cubes in Developer. xThis article describes the Intelligent Cube Population options available in MicroStrategyPlease also see this article for more details: Data Engine changes in MicroStrategy 2021 release Acronym used: "CSI", which stands for "Cube Subsetting Instruction". microstrategy. x. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). When a machine runs out of virtual memory, processes on the machine are no longer able. Intelligent Cubes. Then it generates a report. Exit all Windows applications before beginning the installation process. MicroStrategy logical tables do not necessarily represent physical tables. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 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. Intelligent. 3. Documentation on the REST API is at developer. Select an Environment from the upper-left drop-down. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. In MicroStrategy 10. Slice and dice features are awesome. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Alternatively, you can enable caching on selected reports. The New Grid dialog box opens. x and 10. The Full Refresh option is the default. zip file, with the. x. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. Users cannot trigger or schedule cube republishing. Also, verify that the /<path_to_the_location>/core. Check in Developer that the stopped node is in Maintenance Mode. 2. 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‘. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. com The Maximum RAM usage (Mbytes) memory limit can be defined per project. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. BUILD Because the in-memory ROLAP Cubes operate below the User Security and Prompting layers, they are able to serve a very wide variety of requests and. 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. 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). x - 10. 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. 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. 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. Create Schema Objects. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Seamlessly create Intelligence Cube Reports. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The ability to view or edit certain settings is determined by a user's privileges. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 9 and 10. 56K. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. 4. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Browse to the filter you want to convert and click Open. x - 10. 1. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. Open the Workstation window. Otherwise, it will increase the percentage to 200% if the "Maximum % of growth of intelligent cube due to indexes" governing rule. Making the move from Developer to Workstation even smoother, users can now create Intelligent Cube Reports in Workstation. Together with the Reports API, this API is often referred to as the JSON Data API. Use Cube Advisor to create Intelligent Cubes: 1. 2. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. Republish the same cube, and a new cube instance is generated. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 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. x - 9. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. Starting from MicroStrategy 9. 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. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. You can add data for your Intelligent. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Forecast Sales. The Intelligent Cube refresh settings are recommended if the data in the. e. Locate and run the Setup. This is a known issue with Data Import functionality in version 10. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. x) • MSI_STATS_PROP (properties table that MicroStrategy Intelligence Server uses to initialize statistics logging) • IS_SESSION_STATS (server session statistics)In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Email subscriptions deliver a report or document to one or more email addresses. 15K. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. x using Command Manager. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. When a remote accesses this cube, the cube is loaded into memory of the. It will remain available, but the setting will not be enforced if set below the default value of 100000. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. metrics in the intelligent cube or in the MicroStrategy schema and application objects. 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. The Intelligent Cube Options dialog box opens. 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. The Maximum RAM usage (Mbytes) memory limit can be defined per project. This allows for more power and control over data for MicroStrategy. Number of Views 1. 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. Create a report based on above Cube and add the prompt in view filter. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 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. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. 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%. Job ID for the action on the Intelligent Cube. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. How to configure, monitor, and manage Intelligent Cubes. Data in Intelligent cubes can be either marked as available for time zone conversion when running objects against it or set within a specific time zone. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). 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. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 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. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. This is the same requirement to create or run a static report in Workstation. This dataset needs to contain all data in the required granularity. (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 Select Dataset dialog box opens. Create a Data Import Live Intelligent Cube. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. For more information on security filters, see the System Administration Guide. Choose your preferred method to share the logs. In MicroStrategy Developer, right-click on the project and select Project. If the indexes are needed again, they are reloaded into memory from disk, instead of being regenerated. 4. On the toolbar, choose Data > Configure Intelligent Cube. The display of data is handled by the reports that access the Intelligent Cube. com. Create Cube1 with the Region attribute and the metric created in step 1. Web Open the Settings page (right click the extension and select Options). 4.