For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. By default, this is set to 32,000. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). In MicroStrategy 10. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. This is due to the fact that adding prompts to Intelligent Cubes is not supported. Maintaining data access security. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. When running MicroStrategy Intelligence Server 9. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. A document that uses the Intelligent Cube as a dataset. Number of Views 5. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. To use an attribute form. 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. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. x. KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Create a Data Import Live Intelligent Cube. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. An Intelligent Cube publication takes significantly long to complete publication (several hours). Documentation on the REST API is at developer. x. Create a report on this intelligent cube with the month attribute and the count of day metric. Constant Value: 220 (0x000000dc)When enabling the option to "Fetch data slices in parallel from the warehouse" from the Intelligent Cube Options > Data Partitions menu, TPT is required to be disabled on the database side when using Teradata as a Warehouse. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms for caching. This property can only be enabled through Workstation. The limitations of Microstrategy are not worth. 3. 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. To access the MicroStrategy Installation Wizard. STEPS TO REPRODUCE 1. The Intelligent Cube Options dialog box opens. 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. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. (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. With OLAP Services features, your report designers can create Intelligent Cube reports. These VLDB properties control the method by which the report data are normalized. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. To do so, you can take advantage of URL API. Intelligence Server Statistics . Import and save data from a file in a folder location. x. The Intelligent Cube opens in the Report Editor. Data modeling is the structuring of an organization's data assets into an applicable logical model. . Select the Security Filters tab. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. A set of data is returned from the. You can edit project-level cache and Intelligent Cube settings. 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. In addition, multiple logical tables can represent the same physical table. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. A solution/code fix for this issue is not available in current releases but is. 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. Solution This issue has been addressed in MicroStrategy 2021. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. 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. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. zip and use 7Zip, or similar tools, to unzip it. x using Command Manager. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. x or 10. 4. Click Select. You cannot create a card based on a live-connect MDX/SAP cube. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. All necessary privileges are included in the Administrator role by default. The Full Refresh option is the default. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. In MicroStrategy 10. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Publish the Intelligent Cube by executing it on either of the nodes. Easily add or change pre- and post- SQL statements. MicroStrategy Analytics cubes are easy to create and deploy. 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‘. The . MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. This can be seen even when the actual total memory consumption of the Intelligent Cubes loaded for this Project is below the configured Governing Setting. 0: Balance MicroStrategy Server threadsDescription The . The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. A schedule is defined in Python code. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. This Knowledge base article describes limitations in using security filters and intelligence cubes. 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. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. x. Along with. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. In the Data Source column, select the checkboxes for the tables to update. The. Required Status to Perform Action. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Records statistics related to Intelligent Cube manipulations. 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. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Intelligent Cube storage on disk mirrors report cache storage. 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. 4. Like cache update subscriptions, Intelligent Cube. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. 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. Create a report with the year and quarter attributes and the profit metric. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. This Knowledge base article describes limitations in using security filters and intelligence cubes. Job ID for the action on the Intelligent Cube. Intelligent cubes support time zone based reporting. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. MicroStrategy Analytics cubes are easy to create and deploy. Choose one of the following options: Full Refresh: This is the default. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. 0 votes. MicroStrategy logical tables do not necessarily represent physical tables. Intelligent. Once activated, the user loads the cube in memory. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. UPDATE: the refresh policy is Update existing data. Locate and run the Setup. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. An Intelligent Cube is a. By default, MicroStrategy Command Manager handles cube publication synchronously (i. This issue has been classified as a defect by MicroStrategy. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. Number of Views 1. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. 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. 5. 3. Publish the cube. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Cube Advisor opens. reg file on UNIX/Linux operating systems. conf and add the following lines. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. 4. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". Its name stands for MicroStrategy Parallel Relational In-Memory Engine. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. 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 . 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Open the. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. 4. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. See full list on community. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Enable core dumping. com. In the left panel, click Cubes. x. 4. 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. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. Defining the partition for Super Cubes. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. There are some further steps after this, including Analytical Engine step, etc. Note: The maximum file size that can be imported is 100 MB. Steps To Reproduce 1. To Create an Intelligent Cube Using Freeform SQL or Query Builder. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The following table summarizes the test results of some test scenarios against Oracle 19c. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesSTEPS TO REPRODUCE. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. In the Navigation pane, click , next to Objects. Right-click the dataset, and choose Schedule. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. To add an existing report or Intelligent Cube as a dataset. It is also more difficult or impossible for someone reporting on Intelligent Cube. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. However, if the Intelligent Cube Monitor on the other node is checked, the size of the same Intelligent Cube will be smaller. If desired, user can create a dashboard immediately from the imported data. 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. GUID of the Intelligent Cube instance in memory. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. Use Case 4. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. 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. Right-click an Intelligent Cube and select Delete. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. First, you open a blank document and select a report to use as the document's dataset. Use the drop-down under the filter summary section to switch the server nodes. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Prerequisites to creating Intelligent Cubes. Providing Intelligent Cube data. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. The. The **_objects folder with a size of 277G. 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. The ability to view or edit certain settings is determined by a user's privileges. For example, Create a report with an attribute with only one attribute form. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 4. microstrategy. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Data Population for Intelligent Cubes. Under Refresh type, select one of the following options. Integer ID of the project where the Intelligent Cube is stored. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Contact the MicroStrategy Technical Support for an update on this enhancement request. Click the MicroStrategy icon at the upper left of any page and select History List. You can create and analyze new reports in real time. Cube and Cache Metric Names. Öffnen Sie das Workstation-Fenster. Save the Cube with Connect Live Data Access Mode. By default, the report template used is the same as the Intelligent Cube's template. In MicroStrategy Web, open the document in Design Mode or Editable Mode. , 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. Mclean, Virginia. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . 4. Click here to view details about the Intelligent Cube Monitor. KB442449: Dossier Performance: Connect Live performance considerations. Instantly analyze any amount of data without in-memory limitations of MicroStrategy intelligent data models. 2. Choose your preferred method to share the logs. To Create a Report that Accesses an Intelligent Cube. For example, an Intelligent Cube includes the. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. This article notes how support for transformation metrics in Dynamic Sourcing works. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. It will remain available, but the setting will not. The Select Dataset dialog box opens. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. File subscriptions save the report or document as an Excel or. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. Type of action against the Intelligent Cube: • Enable partitioning in OLAP cubes To enable cube partitioning in OLAP cubes, follow the steps in the olap_partition video. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). 4. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Most likely several, different fact tables are uses for each query. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The Full Refresh option is the default. The Intelligence Server checks to see if there is an existing cache for the same Report. Publish the Intelligent Cube by executing it on either of the nodes. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. IS_CUBE_INST_ID. You can add data for your Intelligent. For more information on security filters, see the System Administration Guide. Strong semantic layer to define all the business rules and tightly coupled. Created Intelligent Cubes to solve the performance issues. STG_IS_CUBE_REP_STATS. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. You cannot create a card based on a live-connect MDX/SAP cube. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. IS_CUBE_INST_ID. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. x Intelligent Cube status indication and workflow . The Maximum RAM usage (Mbytes) memory limit can be defined per project. x Dynamic sourcing extends the accessibility of Intelligent Cubes by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements. 4. Click View Logs, to display the share icon in the upper-left. To review and create recommended Intelligent Cubes using Cube Advisor. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Node 1. KB222608: In a clustered environment in MicroStrategy 9. Number of Views 1. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. In a BI platform, the logical data model is designed and built using current user requirements. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. If the Intelligent Cube must be re-processed based on a metric. Also, verify that the /<path_to_the_location>/core. Typically, a cube is setup to be published at regular intervals and is saved in the server's main memory, eliminating the time-consuming need to query the Big. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. The requests are granted or denied according to user-configured limits on the amount of. Strong semantic layer to define all the business rules and tightly coupled. You must belong to the System Administrators group to use this feature. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 8. In MicroStrategy Developer, right-click on the project and select Project. Run sudo vi /etc/sysctl. This is the same requirement to create or run a static report in Workstation. Why is This Happening? MicroStrategy uses different default encoding for Linux (UTF-8) and Windows (Non UTF-8). Create a dossier and add subset R from Existing Dataset. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. The objects in the source cubes will control how the security filter will be applied. the user still needs the privilege for re-publishing Intelligent Cubes, but just need this restricted for particular cubes), while still allowing this user to perform Visual Insight analysis on the cubes information. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. Documentation on the REST API is at developer. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. In versions prior to MicroStrategy Intelligence Server 9. Article Reference Number:The memory used by Intelligence Server is limited by the machine's virtual memory. It is shared by all processes running on the machine, including the operating system. 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. 3. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. GUID of the Intelligent Cube instance in memory. If removing the view filter does not. 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. 2, it is possible to load an Intelligent Cube into memory on all the nodes of the cluster, after the Intelligent Cube finishes publication on one node. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. Publish the cube. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. This template includes the following tasks: Creates a new metadata. 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. 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. Although the directory filed shows the same location as the source project, cubes are saved to a. The cube leverages both memory and a file on the disk, so data is quickly reloaded into memory when required. By default, there is a system hierarchy on the cube. 4. Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. Integer ID of the project where the Intelligent Cube is stored. The Intelligent Cube is opened in the Report Editor. When using an Intelligent Cube, you already have an in memory dataset. 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 ). If the Intelligent Cube must be re-processed based on a metric. Most likely several, different fact tables are uses for each query. 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. 11. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions: A metric with the same formula and transformation exists in the Intelligent Cube. 88K. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. MicroStrategy logical tables do not necessarily represent physical tables. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 4 the connection mapping of the u… Number of Views 1. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. For more information on the Intelligent Cube Maximum. 0. Check in Developer that the stopped node is in Maintenance Mode. 5 GB, the Data Transfer from Datasource(s) time is 77. For a detailed explanation of the Cube Status values, see KB31566: MicroStrategy 9. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version.