In a BI platform, the logical data model is designed and built using current user requirements. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. Navigate to the folder location of the Intelligent Cube. 17. 4. Um Cubes zu erstellen, müssen Sie über die folgenden zusätzlichen Privilegien verfügen: Verwenden Sie den Intelligent Cube Editor, um auf alle Merkmale und Funktionen zum Erstellen von Cubes zuzugreifen. How to configure, monitor, and manage Intelligent Cubes. However, the cube monitor doesn’t show partition related information. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Browse to and select a previously saved Intelligent Cube on which to build your report. KB442449: Dossier Performance: Connect Live performance considerations. You can add data for your Intelligent. x - 10. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. It stores the non-normalized table into the MicroStrategy. The Intelligent Cube refresh settings are recommended if the data in the. Intelligence Server Statistics . The cube leverages both memory and a file on the disk, so data is quickly reloaded into memory when required. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. e. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. 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. Create the MIN (CurrentDateTime ()) metric. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. 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. HyperAndroid Go to the Account tab. 56K. To customize your filename, please refer to the man page of core(5). Import and save data from a file in a folder location. Number of Views 1. 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. 4. Click Select. To change these behaviors, see: Publishing Intelligent Cubes Without Loading Them into Intelligence Server Memory Loading Intelligent Cubes when Intelligence Server Starts If. Add External Data. 4. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. These VLDB properties control the method by which the report data are normalized. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. After the previous changes, you'll have to save the cube and republish it. To enable. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. x. NOTE: There is an inherent limit specific to importing Excel files due to using an internal Java component to extract the data from Excel files. Users with different security filters can use the same Intelligent Cube data. zip and use 7Zip, or similar tools, to unzip it. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. See full list on community. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. 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. Check the status of the cubes in Developer. This. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. 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. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Starting from MicroStrategy 9. Designing and creating documents: An overview. A workaround is available in the current document. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. Slice and dice features are awesome. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. Open the. 8. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. 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. Recorded at World 2021. The New Grid dialog box opens. For more details on enabling the setting, refer to Change Data Engine VersionCertify a super cube¶ Use SuperCube. An Intelligent Cube is a. The data load process moves this table's information to the IS_CUBE_REP_STATS table, which has. 2 – The data is being pushed to MicroStrategy Intelligent. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Advanced category, select the Balance MicroStrategy Server threads check box. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. A report that runs against the Intelligent Cube. This will work as a regular SQL comparison In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:Total number of columns: The number of columns of data that the Intelligent Cube contains. Select the Security Filters tab. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 4 the connection mapping of the u… Number of Views 1. The Attribute Index An Intelligent Cube is an In-Memory data structure which holds information from a source in a readily accessible format for quick access. 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". Contact the MicroStrategy Technical Support for an update on this enhancement request. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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. When a machine runs out of virtual memory, processes on the machine are no longer able. 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 ). Developed reports for MicroStrategy Web users. The view filter cannot filter out other elements as shown below:Data Modeling. Dynamic Refresh: The Intelligent Cube's filter is. 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. 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. It is especially useful when data. 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, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Use Cube Advisor to create Intelligent Cubes: 1. CAUSE. 3. 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. 0 MicroStrategy releases. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Intelligent Cubes. for a script with several commands, one of which being a cube publication command, the. 2. Required Status to Perform Action. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. It remains available, but is not enforced if it is less than the default value of 100000. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. 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. 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. The requests are granted or denied according to user-configured limits on the amount of. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. All MicroStrategy security settings are respected when interacting with MicroStrategy. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. The default file location for Intelligent Cubes is defined in the Project Configuration as '. This will reduce the memory usage from 150GB to 100GB. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. To Create an Intelligent Cube Using Freeform SQL or Query Builder. HyperAndroid Go to the Account tab. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. In the Refresh Policy column, choose one of the following options:Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. This is the same requirement to create or run a static report in Workstation. If removing the view filter does not. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. However, a lot of the advanced functionality requires the good old metadata, and having everything cubed means you will need a shit ton of RAM very quickly. In MicroStrategy 10. 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. Exit all Windows applications before beginning the installation process. Run sudo vi /etc/sysctl. 2. 79K. The **_objects folder with a size of 277G. 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. The. To access the MicroStrategy Installation Wizard. x - 9. Only one cube file will be generated for each Intelligent cube on disk. mstr file is a zipped file of object definition package and cube files. Mclean, Virginia. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. x. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. Vn (with metric Mn from source cube Cn). 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. MicroStrategy logical tables do not necessarily represent physical tables. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Drill up, down, and sideways to get a 360-view of. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. Integer ID of the Intelligent Cube report that was published, if any. 0. iCubes, however, has some limitations and thereby needs to be used judiciously based on the need. In MicroStrategy 9. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. When running MicroStrategy Intelligence Server 9. 1 or above, to pick up the fix, enable project level setting "Data Engine. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. Both properties are located in the Query Optimizations folder in the VLDB property editor. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. x This is a new feature introduced in MicroStrategy version 9. Run both. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. This dataset needs to contain all data in the required granularity. IS_CUBE_ACT_ID. Most likely several, different fact tables are uses for each query. x, updating an Intelligent Cube returns "Cube Manager: number of c… Number of Views 1. 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. 2. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. 3. This folder needs to be shared as 'ClusterCube'. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. Cube Cache Hit: Download MSTR File with Cube Cache Hit: Indicates a user exported a dossier object based on cube as an MSTR file and hits the cube cache. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Pros and Cons. 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. 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 . 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. 143; asked Oct 2, 2014 at 14:58. x -10. On the left side of the page, click Logs and then Export Logs to save the file. This enterprise analytics tool works seamlessly across web-based content, mobile devices, and Microsoft Outlook to bring answers to people through relevant, context-based analytics. Using any other database should not have any implications, given that TPT is only applicable to Teradata. It is also more difficult or impossible for someone reporting on Intelligent Cube. 5 GB, the Data Transfer from Datasource(s) time is 77. 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. For instance, let’s say you have an Intelligent Cube with 2 million rows and 10 attributes and 5 Expand Intelligent Cubes, and then select General. In addition, multiple logical tables can represent the same physical table. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). 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. Share query results in-memory across multiple dossiers and. cube; oracle12c; cubes; microstrategy; Jorgechu. 11. microstrategy. mstr file is actually a . Right-click an Intelligent Cube and select Delete. The memory used by Intelligence Server is limited by the machine's virtual memory. Steps To Reproduce 1. 4. Choose your environment, project, and Intelligent Cube as your dataset type. To Create a Report that Accesses an Intelligent Cube. Number of Views 1. The Modeling service must be configured correctly to use this feature. com. Republish the same cube, and a new cube instance is generated. This is set to 32,000 by default. The Modeling service must be configured correctly to use this feature. In Developer, from the File menu select New, and then Intelligent Cube. Under VLDB settings > Query Optimizations > Data Population for Intelligent Cubes admins need to test all the following options: - Normalize Intelligent Cube data in the database. Create a second report with the year and quarter attributes and the revenue metric. The Intelligent Cube opens in the Report Editor. In versions prior to MicroStrategy Intelligence Server 9. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . A solution/code fix for this issue is not available in current releases but is. Job ID for the action on the Intelligent Cube. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The Intelligent Cube opens in the Report Editor. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. By default, MicroStrategy Command Manager handles cube publication synchronously (i. Integer ID of the Intelligent Cube report that was published, if any. 2. While this can improve performance of these 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. You can control users' access to data with security filters. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Dossiers automatically adjust to look great on any screen. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. This issue has been classified as a defect by MicroStrategy. Publish the Intelligent Cube by executing it on either of the nodes. 3. If the Intelligent Cube must be re-processed based on a metric. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. 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. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. x, but not to publish it, the minimum privileges that the Administrator would need to. 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. Refer to the following MicroStrategy Knowledge Base. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Within the set. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. 4. The Intelligent Cube Options dialog box opens. 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. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. Extensively used “Apply Simple” function for creating attributes. This is controlled by the Python script. To build an Intelligent Cube. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. Click the “Add history list subscription” link near the bottom of the screen to open the. Create Schema Objects. . 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Select one: To create a new security filter, click New. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. Choose your preferred method to share the logs. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. MicroStrategy is the only comprehensive analytics vendor that supports big data analytics with native connectors to HDFS to access petabytes of data in real time. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. Seamlessly create Intelligence Cube Reports. 0. All necessary privileges are included in the Administrator role by default. IS_CUBE_INST_ID. The following table summarizes the test results of some test scenarios against Oracle 19c. Specify a name and location for the new security filter and click Save. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. For example, Create a report with an attribute with only one attribute form. mstr suffix. Intelligent Cubes. Cube Limitations. . Create a Data Import Live Intelligent Cube. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. 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. This defect is addressed in MicroStrategy 11. Email subscriptions deliver a report or document to one or more email addresses. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Users of Intelligent Cubes in MicroStrategy 9. In addition, multiple logical tables can represent the same physical table. Answer: Go with dossier. Open the Workstation window. Click here to view details about the Intelligent Cube Monitor. Expand the Object Templates category, select General, and from the. Documentation on the REST API is at developer. 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. Create an attribute element prompt for the. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. Data modeling is the structuring of an organization's data assets into an applicable logical model. Modify or remove the view filter to attempt to return data for the report. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Instantly analyze any amount of data without in-memory limitations of MicroStrategy intelligent data models. The. 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. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. 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%. IS_CUBE_REP_ID. Rather than returning data from the data warehouse for a single. 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. Create Schema Objects. View the report in either Grid View or Grid and Graph View. MicroStrategy tests on at least one of the CPU chipsets within a set of binary-compatible CPU architectures for purposes of certifying and supporting operating systems with MicroStrategy products. STEPS TOP REPRODUCE: 1. In the New Intelligent Cube dialog box, select the MDX Sources tab. 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. Index: P = Processing A = Active L = Loaded D = Dirty F = Filed M = Monitoring Information Dirty When a user executes an Intelligent Cube, the initial status is P. Use the drop-down under the filter summary section to switch the server nodes. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesSTEPS TO REPRODUCE. 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. Creating an Intelligent cube is similar to creating a report. In MicroStrategy Desktop 9. MicroStrategy Web: Web Server. Node 1. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Feb 2020 - May 2022 2 years 4 months. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. 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. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. IS_PROJ_ID. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Starting in MicroStrategy 10. Create a report with this Intelligent Cube and execute the report --> one row with 4 element returned. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. reg file on UNIX/Linux operating systems.