There's a reason we're at the top of the list. 3. 1. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Choose your environment, project, and Intelligent Cube as your dataset type. The Modeling service must be configured correctly to use this feature. The New Grid dialog box opens. Related Articles. There's a reason we're at the top of the list. Required Status to Perform Action. 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. x Intelligent Cube status indication and workflow . These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. x. 4. Strong semantic layer to define all the business rules and tightly coupled. When using an Intelligent Cube, you already have an in memory dataset. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. When a machine runs out of virtual memory, processes on the machine are no longer able. x. IS_PROJ_ID. Also, verify that the /<path_to_the_location>/core. Seamlessly create Intelligence Cube Reports. 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. Create Schema Objects. 5. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to its memory limit. 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. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. 0 MicroStrategy releases. 2. Under Refresh type, select one of the following options. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. However, the cube monitor doesn’t show partition related information. Required Status to Perform Action. Run both. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. When using MicroStrategy and Teradata, the best approach is to. To Create a Report that Accesses an Intelligent Cube. Click the MicroStrategy icon at the upper left of any page and select History List. Loading. 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. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. 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. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. For more details on enabling the setting. Type of action against the Intelligent Cube: •In MicroStrategy 11. This KB answers a question regarding memory limitations for In-Memory data import for MicroStrategy 10. In MicroStrategy Developer, right-click on the project and select Project. This can. - Normalize Intelligent Cube data in the. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. x using Command Manager. The Intelligent Cube refresh settings are recommended if the data in the. 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%. Choose File > New > Intelligent Cube. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Feb 2020 - May 2022 2 years 4 months. Use Case 4. 1. Using Database Write-back Functionality to Enable Decision-Making. Open the. 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. Choose Data > Configure Intelligent Cube. 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. They should have the “A, L, F” status (Active, Loaded, Filed). You cannot create a card based on a live-connect MDX/SAP cube. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. 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. Add External Data. GUID of the Intelligent Cube instance in memory. ADD: the refresh policy is Add new data. "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'. Log on to the machine where you are installing one or more MicroStrategy products. 4. Create a security filter on the region attribute such as region not in list central. x. To build an Intelligent Cube. 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 MicroStrategy Web, open the document in Design Mode or Editable Mode. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Create Schema Objects. Number of Views 1. Documents . Dynamic Sourcing. x to 11. 3. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Choose File > New > Intelligent Cube. x - 10. When an Intelligent Cube is in this status, any reports based on this cube have. Choose your preferred method to share the logs. Answer: Go with dossier. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. 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. To Create an Intelligent Cube Using Freeform SQL or Query Builder. 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. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Run the Report and check the SQL View. 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. Use Cube Advisor to create Intelligent Cubes: 1. This article describes how to trace Intelligent Cube activity. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. 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 defect is addressed in MicroStrategy 11. 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. 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. IS_CUBE_ACT_ID. 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 restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. 1. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. x - 10. 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. IS_CUBE_INST_ID. To enable or disable dynamic sourcing for an Intelligent Cube. Starting with MicroStrategy Intelligence Server 9. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. 3. In MicroStrategy 10. Integer ID of the project where the Intelligent Cube is stored. This data is to apply the calculations. 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. In MicroStrategy Developer, log in to a project source with administrative privileges. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. The MicroStrategy Tutorial project uses aggregate tables by default. Choose one of the following options: Full Refresh: This is the default. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. 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. The Security Filter Editor opens. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. You must belong to the System Administrators group to use this feature. 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. IS_CUBE_REP_ID. In MicroStrategy 9. 0. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. The interface has changed a bit. Comparing OLAP and MTDI cubes. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. 88K. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. When a machine runs out of virtual memory, processes on the machine are no longer able. 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. . You can use. Extensively used “Apply Simple” function for creating attributes. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. 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. The Intelligent Cube Options dialog box opens. Create Cube2 with the Region attribute and the metric created in step 1. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. STG_IS_CUBE_REP_STATS. The cube leverages both memory and a file on the disk, so data is quickly reloaded into memory when required. microstrategy. Intelligent Cubes. 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. In MicroStrategy 10. Web Open the Settings page (right click the extension and select Options). 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. It is especially useful when data. However, OLAP Services provides MOLAP and ROLAP analysis on the same report, which offers many distinct benefits, summarized below: Using OLAP Services, you can get fast response times for reports that use data directly from in-memory Intelligent Cubes, instead of from the data warehouse. This is a known issue with Data Import functionality in version 10. 3. The article discusses a known situation in MicroStrategy 10. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. These VLDB properties control the method by which the report data are normalized. cube; oracle12c; cubes; microstrategy; Jorgechu. Select the Security Filters tab. This property can only be enabled through Workstation. 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 Analytics Enterprise Web 10 onewards, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI) which has been renamed as Super Cubes in MSTR 2019. mstr suffix. It stores the non-normalized table into the MicroStrategy. x, but not to publish it, the minimum privileges that the Administrator would need to. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. 3. Export data frames from RStudio to MicroStrategy in-memory cubes. A workaround is available in the current document. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. x? To answer this question, the "Query Engine finish time" is marked when the warehouse query step for generating the Intelligent Cube finishes. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The Intelligent Cube Options dialog box opens. In MicroStrategy Desktop 9. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. Download the files from the MicroStrategy download site. An enhancement Request has been reported to the MicroStrategy Technology team. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. 3. IS_CUBE_INST_ID. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. The following diagram depicts the role of the intelligent cube. 2. Cube Limitations. The Intelligent Cube is opened in the Report Editor. MicroStrategy 9 ships a new utility called MicroStrategy Cube Advisor to assist in the use of the Dynamic Sourcing functionality in MicroStrategy OLAP Services 9. x and newer. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. Create a report with the year and quarter attributes and the profit metric. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). Note: The maximum file size that can be imported is 100 MB. 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. For example, an Intelligent Cube that contains data for the top 200 stores by. 4. 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. 2. This import bridge imports MicroStrategy logical tables as Dimensions. Using any other database should not have any implications, given that TPT is only applicable to Teradata. This Knowledge base article describes limitations in using security filters and intelligence cubes. The **_objects folder with a size of 277G. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. x. Browse to and select a previously saved Intelligent Cube on which to build your report. 15K. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. 5. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Create a Report 'R3' with 'Country' attribute. 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. IS_PROJ_ID. E. All cubes respect the governing setting. To review and create recommended Intelligent Cubes using Cube Advisor. Cube Limitations. The dataset is a set of data that can be displayed on the document. Consolidate multiple MicroStrategy cubes into a single Kyvos data model without limitations on the data size or the number of dimensions that the model can hold. By default, the report template used is the same as the Intelligent Cube's template. 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. mstr file is actually a . A document that uses the Intelligent Cube as a dataset. This dataset needs to contain all data in the required granularity. , 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. (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. Number of Views 8. Choose your preferred method to share the logs. The Intelligence Server checks to see if there is an existing cache for the same Report. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. To customize your filename, please refer to the man page of core(5). MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. This import bridge imports MicroStrategy logical tables as Dimensions. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. With OLAP Services features, your report designers can create Intelligent Cube reports. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 4. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. The data load process moves this table's information to the IS_CUBE_REP_STATS table, which has. Right-click an Intelligent Cube and select Delete. x releases, and the new Multi-table Data Import (MTDI) cubes. Starting in MicroStrategy 10. Designing and creating documents: An overview. Expand Intelligent Cubes, and then select General. location_path: is the folder where the intelligent cube. From the Data menu, select Configure Intelligent Cube. The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. The ability to view or edit certain settings is determined by a user's privileges. 4. x. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. 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. Most likely several, different fact tables are uses for each query. Memory Storage for document or dossier. To use an attribute form. log without functional impact. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. 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. 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. Select an Environment from the upper-left drop-down. For more information on the Intelligent Cube Maximum. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. The view filter cannot filter out other elements as shown below:Data Modeling. 4. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. 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. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. Navigate to and run the Intelligent Cube report. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. conf and add the following lines. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. Intelligence Server Statistics . In addition, multiple logical tables can represent the same physical table. 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. By default, MicroStrategy Command Manager handles cube publication synchronously (i. Create an attribute element prompt for the. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. A report instance is the version of the report results that Intelligence Server holds in memory for cache and working set results. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. 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 a new column is added to the data import data source and the cube is republished, there is no effect. From the Categories list, expand Options, and then select General. 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. 9 and 10. Create Cube B which contains all objects in the report and publish it . KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. Right-click an Intelligent Cube and select Delete. Users with different security filters can use the same Intelligent Cube data. SYMPTOMS: After duplication of a project in Developer that has a user-defined Intelligent Cube cache location, Intelligent Cubes created within the new project are not saved to the location specified in Intelligent Cube File Directory in Project Configuration. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. MicroStrategy Tutorial is used in this example. 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. 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. 0 votes. For example, an Intelligent Cube that contains data for the top 200 stores by Profit must be re-calculated every time it is updated, and thus must use the Full Refresh option. IS_CUBE_REP_ID. This difference is roughly equal to the size of the Intelligent Cube footprint in-memory versus the size of the compressed disk cache. In Developer, from the File menu select New, and then Intelligent Cube. 86K KB31566: MicroStrategy 9. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. If the Intelligent Cube must be re-processed based on a metric. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. 3. Published: Jun 29, 2018;KB321029: In MicroStrategy 10. To enable. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Before MicroStrategy 10. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. 1 and 10. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. 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. 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. For a detailed explanation of the Cube Status values, see KB31566: MicroStrategy 9. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Import and save data from a file in a folder location. Intelligent Cubes can be based on MicroStrategy data or imported data. Create a Data Import Live Intelligent Cube. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. 6 and higher. 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. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. These VLDB properties control the method by which the report data are normalized. By profiling the Intelligent Cube publication (as per KB30699 - How to measure the Intelligent Cube performance parameters for time and memory in the MicroStrategy Intelligence Server 9.