4. MicroStrategy Tutorial is used in this example. 4. 3. Create Cube2 with the Region attribute and the metric created in step 1. Moreover, you may generate among the various reports of many users. You can edit project-level cache and Intelligent Cube settings. 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. Although the directory filed shows the same location as the source project, cubes are saved to a. x. Users cannot trigger or schedule cube republishing. SYMPTOM Users may notice that duplicate cube instances are created after an intelligent cube that had a neutral locale is updated with a multilingual. GUID of the Intelligent Cube instance in memory. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). reg file on UNIX/Linux operating systems. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Edit SQL Transactions in Reports. KB222608: In a clustered environment in MicroStrategy 9. Edit Intelligent Cubes from the new editor in Workstation at any time. STEPS TO REPRODUCE 1. Like cache update subscriptions, Intelligent Cube. Cube Limitations. 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. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. KB442449: Dossier Performance: Connect Live performance considerations. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. 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. If the Intelligent Cube must be re-processed based on a metric. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube. x - 9. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. com The Maximum RAM usage (Mbytes) memory limit can be defined per project. Click View Logs, to display the share icon in the upper-left. 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. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Starting with MicroStrategy Intelligence Server 9. Execute the report and view the SQL:MicroStrategy enables users to pull subsets of data, which could be up to hundreds of Gigabytes, from a Big Data source into an in-memory cube, and build reports/dossiers from the cube. To Create a Report that Accesses an Intelligent Cube. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. 0. Create a report with the year and quarter attributes and the profit metric. 4. The Security Filter Editor opens. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. 3. Dynamic Sourcing. GUID of the Intelligent Cube instance in memory. 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. Email subscriptions deliver a report or document to one or more email addresses. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. conf and add the following lines. x. KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. To customize your filename, please refer to the man page of core(5). In MicroStrategy 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. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. In command manager run the following commands: TRIGGER EVENT "<event_name>";Instead, reports created off of the cube will continue to hit the outdated cube. The Modeling service must be configured correctly to use this feature. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Published: Apr 6, 2017. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. ADD: the refresh policy is Add new data. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. 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%. Within the set. 143; asked Oct 2, 2014 at 14:58. 56K. 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 MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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 following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. This property can only be enabled through Workstation. MicroStrategy 10 will report the following. 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%. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. Intelligent Cubes. OR, to convert an existing filter into a security filter, click Import. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. If the data in the Intelligent Cube is outdated. Consider the following example based on the MicroStrategy Tutorial project. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. The following diagram depicts the role of the intelligent cube. In MicroStrategy Web, open the document in Design Mode or Editable Mode. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. In the left panel, click Cubes. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The . With in-memory ROLAP, some selected portions of the global virtual cube are populated with actual data as ROLAP Cubes (Intelligent Cube); as you see presented here in the drawing. The data used for this example. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. By default, this is set to 32,000. In a BI platform, the logical data model is designed and built using current user requirements. Forecast Sales. Contact the MicroStrategy Technical Support for an update on this enhancement request. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. " The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. Based on the previous explanation, you should only create derived attributes or metrics whenever. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. For more information on security filters, see the System Administration Guide. Slice and dice features are awesome. Traditional Report Caching in MicroStrategy is done on a matching basis. IS_CUBE_REP_ID. x. The Intelligent Cube Options dialog box opens. Known Limitations and Challenges in MicroStrategy 2019 Update 2 HyperIntelligence for Office. The Full Refresh option is the default. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. After the previous changes, you'll have to save the cube and republish it. Creating an Intelligent cube is similar to creating a report. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Web Open the Settings page (right click the extension and select Options). Answer: Go with dossier. 2. The limitations of Microstrategy are not worth. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Job ID for the action on the Intelligent Cube. e. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This can improve the performance of. MicroStrategy version 9. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 2. 2. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. There's a reason we're at the top of the list. Browse to and select a previously saved Intelligent Cube on which to build your 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. To review and create recommended Intelligent Cubes using Cube Advisor. The user then updates the cube. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. In MicroStrategy Developer, log in to a project source with administrative privileges. Once activated, the user loads the cube in memory. Select one: To create a new security filter, click New. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. Publish the cube. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. This is the same requirement to create or run a static report in Workstation. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In the New Intelligent Cube dialog box, select the MDX Sources tab. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. x - 10. In the Navigation pane, click , next to Objects. 86K KB31566: MicroStrategy 9. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. 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. 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. Create a dossier and add subset R from Existing Dataset. Intelligent Cubes are a more aggressive form of caching and allow multiple reports to be stored in the Cube (which is effectively a large cached report stored in memory on the. Expand the Object Templates category, select General, and from the. 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. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. The objects in the source cubes will control how the security filter will be applied. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. Using any other database should not have any implications, given that TPT is only applicable to Teradata. It remains available, but is not enforced if it is less than the default value of 100000. This dataset needs to contain all data in the required granularity. 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. It is shared by all processes running on the machine, including the operating system. x Intelligent Cube status indication and workflow . 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. Otherwise, it will increase the percentage to 200% if the "Maximum % of growth of intelligent cube due to indexes" governing rule. 3. When using an Intelligent Cube, you already have an in memory dataset. 0 has a dedicated section to memory used for Intelligent Cubes. IS_PROJ_ID. 3. Republish the same cube, and a new cube instance is generated. View the report in either Grid View or Grid and Graph View. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. To enable or disable dynamic sourcing for an Intelligent Cube. Navigate to the folder location of the Intelligent Cube. mstr file is actually a . You cannot create a card based on a live-connect MDX/SAP cube. MicroStrategy HyperIntelligence is the next step in the future of data analytics. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server 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. The interface has changed a bit. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). . The Intelligent Cube Options dialog box opens. To build an Intelligent Cube. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. A MicroStrategy Report Services document displays your organization's data in a format. Integer ID of the project where the Intelligent Cube is stored. In the Drilling area, clear the Use default settings check box. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. 2. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. 6 and higher. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. 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. 3. Slice and dice features are awesome. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. Select one: To create a new security filter, click New. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. The Modeling service must be configured correctly to use this feature. Required Status to Perform Action. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 4. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. 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. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. Number of Views 1. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. Under Refresh type, select one of the following options. If the indexes are needed again,. The Schedule dialog box opens for your dataset, showing the tables in your dataset. BACKGROUND: When configuring a MicroStrategy Intelligence Server cluster, special configuration must be made in order for the Intelligence Server cluster nodes to be able to access report and document caches, intelligent cubes, history list messages, and session recovery files that were created on other nodes of the cluster. With OLAP Services features, your report designers can create Intelligent Cube reports. Create an attribute element prompt for the. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. III. Choose your preferred method to share the logs. The Full Refresh option is the default. 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. 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. ACTION This. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Loading. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. Seamlessly create Intelligence Cube Reports. Click the “Add history list subscription” link near the bottom of the screen to open the. 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. Refer to the following MicroStrategy Knowledge Base. This means you can manually change the suffix to . Technically this will result is different queries on the database, due to the fact that each calculation level is different. 2. To view an Intelligent Cube stored in your History List. x and newer. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. If the Intelligent Cube must be re-processed based on a metric. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Required Status to Perform Action. Mclean, Virginia. 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. location_path: is the folder where the intelligent cube. 1. HyperAndroid Go to the Account tab. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Integer ID of the Intelligent Cube report that was published, if any. When using an Intelligent Cube, you already have an in memory dataset. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. Both properties are located in the Query Optimizations folder in the VLDB property editor. The cube is based on a MDX datasource, specifically SAP BW. Choose Data > Configure Intelligent Cube. This can. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Log on to the machine where you are installing one or more MicroStrategy products. IS_CUBE_INST_ID. IS_CUBE_REP_ID. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. UPDATE: the refresh policy is Update existing data. STEPS TOP REPRODUCE: 1. 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. Extensively used “Apply Simple” function for creating attributes. Save the Cube with Connect Live Data Access Mode. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. Both properties are located in the Query Optimizations folder in the VLDB property editor. Create a New Dossier. The. MicroStrategy Web: Web Server. Go to the Report -> Data->Intelligent Cube Options->Point grid to. 88K. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. Browse to and select a previously saved Intelligent Cube on which to build your report. The **_objects folder with a size of 277G. 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. 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. 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. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below:This article describes features that are not supported when using Dynamic Sourcing. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. 3. 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. First, you open a blank document and select a report to use as the document's dataset. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. To enable. 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. Overview. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. For more details on enabling the setting, refer to Change Data Engine VersionCertify a super cube¶ Use SuperCube. 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. 1 release. Publish the cube. 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. IS_CUBE_REP_ID. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. 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. If you are upgrading to MicroStrategy 11. There are some further steps after this, including Analytical Engine step, etc. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. 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. IS_CUBE_INST_ID. For reports and Intelligent Cubes that do not use MultiSource Option or database gateway support to access multiple data sources, all queries are processed sequentially. Since Intelligent Cubes function simply as. If the Intelligent Cube must be re-processed based on a metric. This template includes the following tasks: Creates a new metadata. Required Status to Perform Action. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. IS_CUBE_ACT_ID. Published: 4월 6, 2017. 9 and 10. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Dynamic Refresh: The Intelligent Cube's filter is. Note: The maximum file size that can be imported is 100 MB. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 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 first is to enable report caching at the project level. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. The. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. In addition, multiple logical tables can represent the same physical table. Another way to use caching in MicroStrategy is through Intelligent Cubes. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. IS_PROJ_ID. Right-click the dataset, and choose Schedule. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. x? To answer this question, the "Query Engine finish time" is marked when the warehouse query step for generating the Intelligent Cube finishes. Why MicroStrategy Why MicroStrategy; Customer StoriesHyperIntelligence is a new addition to MicroStrategy Workstation that allows analysts to inject analytics and intelligence directly into every user's experience. All MicroStrategy security settings are respected when interacting with MicroStrategy.