Starting in MicroStrategy 10. getProjectName () + " number of cubes:"+cubesPerProject. With partitioned enabled, the cube size is expected to be slightly larger than a non-partitioned cube. 19. Tips and Tricks to Partition In-Memory Cubes for Faster Performance. As such, you can only enable a certain amount of cards to avoid. Oversee all IT SaaS strategy, create and execute digital transformation roadmap, and identify ways to. In addition to this, you need a plan for tuning the system. An Intelligent Cube publication takes significantly long to complete publication (several hours). A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. 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. In MicroStrategy Secure Enterprise 11. 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. 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. How To Reduce Intelligent Cube Size By Finding Intelligent Cube Objects Which Are Not In Use. Designed with automatic alerts, Insights is powered by machine learning (ML) models to analyze data behind the scenes and surface key trends, outliers, or anomalies. The cube is based on a MDX datasource, specifically SAP BW. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. 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. GUID: is the GUID of the intelligent cube, returned as a string. x). One way to free memory on Intelligence Server, which can improve Intelligence Server performance, is to temporarily unload an Intelligent Cube from memory. The Options dialog box opens. When running an integrity test, users might want to get the execution time of the report or document. In versions prior to MicroStrategy Intelligence Server 9. 4. While OLAP cubes were limited to 2 billion rows, PRIME OLAP cubes can be divided into. Cube Advisor opens. In addition to the above setting, another major reason for a slow project load could be any additional traces or logs that have been turned on for. In addition, some other important tuning recommendations are mentioned: OS Level Optimization. Install MicroStrategy 10. Data loads and refreshes are too long, data freshness can. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. " If a user refreshes cube A with "add new data" as a refresh policy, he can successfully refresh it. The grouping options for levels include: Standard groups by the attribute level of the target. This count is not shared across nodes of the cluster. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. MicroStrategy will monitor the data repository and/or cube memoryOnce the cube is published, these four files are loaded in-memory on the Intelligence Server. 3. 3. MicroStrategy. The data get's fresher, faster, and less resources consuming for everyone. g. You can learn more about Enterprise Manager in the following documentation resources:In MicroStrategy Desktop 9. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. ProjectName: This field represents the name of the project for which the analysis is being performed. All necessary privileges are included in the Administrator role by default. Metro Area. If the data requirements for the report change, or cannot be satisfied by an available Intelligent Cube, the reports automatically access the data. Step 2. “With a nearly 30-year. Dossiers automatically adjust to look great on any screen. Stored calculations for compound metrics. However, subset. 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. If it is not possible to improve data consistency in the database, the Intelligent Cube report may be configured to normalize data in the Intelligence Server. It is especially useful when data source contains huge data amount. Parallel query execution is disabled by default to allow you to first verify that your reports and Intelligent Cubes are executing correctly prior to any parallel. Disk Once the cube is published, the Intelligence Server where the cube was published will back up the cube files on a disk. g. …Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. 4. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. Use mstr_ko. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. All prerequisites for using security filters with MDX Cubes should be completed before. 3% of resumes. Easily add or change pre- and post- SQL statements. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. This helps enhance query performance and improve the ability to perform multidimensional analytics on the cloud. This privilege is part of OLAP Services. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools > Options. Defines whether to attempt to improve performance of reports that use expression-based transformations. Under CUBE TEMPLATE, choose Default Attribute Form Caching. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. We have already. The first step of the cycle is to quantify the performance by measuring the time spent in each of the components that are part of a Document Execution Request, as described in the preceding sections. In Asian languages, the minimum length is one character. Run multiple dossiers, documents, or reports based on this cube to. Rather than returning data from the data warehouse for a single report, you can return sets of data from you data warehouse and save them directly into the Intelligence Server memory. This knowledge base article describes a behavior in MicroStrategy 10. In MicroStrategy versions prior to MicroStrategy 2021 Update 1, the cube cache file that is saved to disk does not include an Attribute Element Index, which is generated during cube publishing to improve cube querying performance. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. Cube Advisor opens. 0. Performance analysis. To get the best performance out of your MicroStrategy/Any system, you must be familiar with the characteristics of your system and how it performs under different conditions. Full control. Loading × Sorry to interrupt Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. To define an incremental refresh report. Use the table below as a guide to determine whether switching to a single Intelligent Cube as dataset can improve the performance in your environment: 3. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. For example, if they open a dashboard, document, or report and step away from the desk, their user session can. In Developer, from the File menu select New, and then Intelligent Cube. Optimize the performance of derived objects: Skip the evaluation of unused derived attributes and derived elements in a document or dossier to improve performance during execution. Create an Attribute Form Caching Cube. 0 release, we have changed the workflow to ensure we can always deliver the correct data to the user. This is particularly useful when there exist many Intelligent Cubes that have to be published but require a high amount of memory in the process so executing them, all at the same time is not feasible. x). You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. In the bottom section, under Destination note the location of. In a cube containing data from the MicroStrategy Tutorial project, the following metric ranks over the lowest level attribute in the Product hierarchy used on the report. Every newly created MTDI cube will inherit settings from this template and automatically be created. The first step of the cycle is to quantify the performance by measuring the time spent in each of the components that are part of a Document Execution Request, as. All necessary privileges are included in the Administrator role by default. Select data population for Intelligent Cubes. Create a second report with the year and quarter attributes and the revenue metric. MicroStrategy Optimization: VLDB Settings. Maintain your competitive edge with a data-driven retail app designed to scale—from individual. A code fix is provided. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. The New Intelligent Cube dialog box opens. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). 4. QUESTIONUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. 0 and 2019, users will notice objects referred to as "Super Cubes". The limitations mentioned above are currently being investigated by the Technology team. In live dossiers connected to certified gateways, as well as reports and cubes executed against a warehouse, all SQL executions containing text input from filters, search conditions, and text prompts are secured through. To update the newly created Super Cube, create a new script starting from repeating steps 3-7. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. This will influence the user experience. In addition to the above setting, another major reason for a slow project load could be any additional traces or logs that have been turned on for. Answer: Go with dossier. Dashboards executed in Flash mode require Flex Binary for the data and XML generation for the Dashboard definition. Click Modify to open the Properties dialog box: Security tab. The ACL you define here is applied as the default ACL for the project and all of the objects within the project, excluding the objects mentioned in the following option. Tips and Tricks to Partition In-Memory Cubes for Faster Performance. 3. A good caching strategy can significantly improve system performance. NAME: is the name of the intelligent cube, returned as a string. This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. KB36020 "New Statistics and Enterprise Manager tables designed to track new Intelligent Cube Operations in MicroStrategy 9. x-11. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Members," which identifies the current level within the hierarchy and evaluates the rank over all the. 2. There is a substantial increase in complex query performance; 4. The Back Up Database windows will open, ensure that Full is selected under Backup type. 2. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. Starting in MicroStrategy 10. Open Confluent Control Center. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an. Open the Workstation window. This will influence the user experience. Choose the Topic to send to MicroStrategy and click Continue. 4. Stay up to date on inventory needs and avoid. Run both reports after enabling the metric levels log. In live dossiers connected to certified gateways, as well as reports and cubes executed against a warehouse, all SQL executions containing text input from filters, search conditions, and text prompts are secured through. Expand Intelligent Cubes, and then select General. Starting from MicroStrategy 9. Visit the data visualization and data dashboard galleries for inspiration. Right click the database and under “Tasks” choose “Backup”. MicroStrategy supports reporting and analysis with SAP BW, Microsoft Analysis Services, Hyperion Essbase, and IBM Cognos TM1. You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice. println ("For project: " + cubesPerProject. Locate the newly imported cube, right-click on it, and choose "Edit. In the Categories list, expand General, and then select Drilling. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Users may find additional information related to managing and using Intelligent Cubes in. 11, a new feature is available for performance optimization when dealing with derived attributes. HyperIntelligence for Web can only search for a total of 500k keywords and alternate keywords at a time. e. In 11. This article discusses Data Engine changes that may impact performance and stability when upgrading to MicroStrategy 2019. Open Windows Services, right-click MicroStrategy Platform Analytics Consumer and select Stop. In just one week, MicroStrategy Professional Services, will conduct a thorough examination of your Business Intelligence implementation, providing you with actionable recommendations on these five key areas to improve overall performance. Output Mode. value can be set to any zone that is recognized by pytz. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Cube A's refresh policy is set to "add new data. x releases, and the new Multi-table Data Import (MTDI) cubes introduced in 10. This may be done in one of two ways: Reenter the MDX Cube Catalog, switch to the cube mapping, and select the cube that was just imported. Dec 2017 - Present 6 years. Course Categories. In-store and online. Logfilename: This field represents the location of the Metric Levels Log file. To troubleshoot performance issues, users must identify these components, then make the appropriate modifications to the environment and/or to the MicroStrategy dashboard to reduce bottlenecking. An Architect creates, publishes, and optimizes a federated data layer as the enterprise’s single version of the truth. Starting from MicroStrategy 10 – you’ll see tge optimized form of Intelligent Cube based reports SQL modified as below with better optimizations. x SQL engine: "Parallel Query Execution" work. The performance improvement varies based on the CPU cores, memory, file size and the Operation. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. In other words, you should partition. The use of text columns for attribute IDs can impair query performance in the database and, in this scenario, opens the door to inconsistent data handling. 0 MicroStrategy introduced the 'Platform Analytics' application, which helps monitor and track object usage across the MicroStrategy platform in real time. This can be done by enabling the feature flag "Defect fixes that may impact data, SQL, MDX, CSI" in Web. Using Confluent. 7, and later versions, non-distributive metrics do not return correct data, because the engine does double aggregation due to the optimization done in DE81833. This article reviews the following approaches you can take to improve MicroStrategy performance on SAP HANA. If the relations are modified in the cube editor, the cube has to be re-published to be used again. An Intelligent Cube is an In-Memory data structure which holds. This can improve the performance of. 3. Required Status to Perform Action. Starting 10. Create a new variable and assign SuperCube with two parameters inside – connection and id. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. Further in order to enhance the performance and quality of the reports produced we can follow the. The Data Partition options are displayed. Pros and Cons. Optimize the performance of derived objects: Skip the evaluation of unused derived attributes and derived elements in a document or dossier to improve performance during execution. In the next screen, select MicroStrategySink connector class and set the connector name, that will show up in the Kafka Connect list of Sinks. Prior to 10. Select the Enable report drilling check box. Administrators can use this analysis area to understand what effect the server and project governing settings and usage patterns have on the system. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. Create a report with the year and quarter attributes and the profit metric. View reports vs Cubes as datasets It gives you exclusive access to MicroStrategy experts on-demand or on-schedule, as well as access to all 56 courses in the MicroStrategy Education Catalog. . Datamart optimization can be used to improve performance in this situation if the database for the datamart. While this can improve performance of these reports, loading too much data onto Intelligence Server memory can have a negative impact on Intelligence Server's ability to process jobs. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. MicroStrategy Optimization: HINTS. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. This can improve the performance of reports, which get executed against an Intelligent Cube, without having to manually find and select the Intelligent Cube that fits the analysis of the report. In the previous example all the extra calculations were pushed to the intelligent cube which will improve the performance for the end users. This name change is visible in. When you enable these traces, be sure to enlarge the size of trace file to >20MB. Cyber Security and SIEM Tools. To identify if your cube is MTDI or OLAP it’s really simple, if the cube was created through the Data Import Web Interface (“Add External Data” section on MicroStrategy Web. 4. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. To plan for these memory requirements, see the System Administration Help. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Kernel -> Processing Unit Trace – trace tasks execution of a Processing Unit. Open the cube for editing. Smart. This article discusses how the Data Import functionality utilizes multiple threads to improve the cube publishing time, when performing a data import against CSV/Text files Best Practices Articles (Performance Tuning Based on IBM Db2) This article describes best practices to be taken when connecting an instance of IBM Db2 in MicroStrategy. The main reasons an Intelligent Cube size would increase after publishing is for the following reasons: Cube Index generation. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Now there are scenarios where these tables will only have partial data and a join needs to be performed between the tables. 0. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Cube index generation will increase cube size. Intelligent Cubes improve performance and user experience by pre-aggregating and pre-calculating the data. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Select the data set and click Prepare Data. A set of data is returned from the. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. To achieve this, cube processing in the MicroStrategy. Login to MicroStrategy Web, create a cube with the function of Data Import. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. Steps to reproduce Log in to an environment in MicroStrategy Workstation using. The following line chart. During installation you have the following options:Governing Intelligent Cube Memory Usage, Loading, and Storage. In MicroStrategy 10. getProjectName () + " number of cubes:"+cubesPerProject. 3. x, create a simple Intelligent Cube with attribute Category and metric Revenue. To Rename an object within the card: Place the object in the HyperIntelligence card. In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. , UNION, INTERSECT, EXCEPT). You could do this by partitioning and compressing data and by using a columnar format for storage. 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. Using the Performance Monitor Counters to measure Intelligent Cube memory usage and publication times: When an Intelligent Cube report is run (published), the. Create a report with the year and quarter attributes and the profit metric. The following is a full list of MicroStrategy Data Engine changes that may be seen when upgrading to MicroStrategy 2019 which affect Data. If you manually enable this setting. get the SQL and execute directly in DB. For the steps to define an incremental refresh report, refer to:Normally, when memory depletion or delayed system performance occurs, page cache can be a checkpoint. The steps to create an intelligent cube are as follows:This article notes how to use the Cube Advisor in a clustered MicroStrategy environmentThere are multiple ways to intervene the database to generate a better SQL execution plan. In-store and online. Note that the behavior is the same when searching for the cube in MicroStrategy Developer via Tools > Search for Objects: CAUSEEnable dynamic sourcing for the project and other aspects of the MicroStrategy system. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Improve Report and Cube Performance Against the Data Warehouse by Using an Attribute Form Caching Cube This feature was introduced in MicroStrategy 2021 Update 5. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Or, navigate to the Data Explorer for the MDX Cube database instance. To learn more about attribute form caching cubes, see KB484994. With Parallel Hierarchy. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). while (cubesEnum. 11 Derived Attributes for “Connect Live” cubes were always evaluated in memory. Select data population for Intelligent Cubes. x. Video Tutorials. Note: number of columns should be the same as in the original file. Add filters for Year and Quarter through the Advanced Filter Editor by clicking on the 3-dot icon on the grid visualization and select Edit Filter. The "User login" prompt in security filters applied to MDX Cubes. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. Kylin 4 is a major architecture upgrade version, both cube building engine and query engine use spark as calculation engine, and cube data is stored in parquet files instead of HBase. By default, MicroStrategy uses ODBC call 3. Community & Support Search Discussions Open A Case View My CasesImproving Response Time: Caching. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. The solution discussed in this article is a python application that leverages the MicroStrategy API suite to provide an external scheduler, i. It can adapt to report level through the use of "CurrentMember. Providing Intelligent Cube data. In the search, when All objects option is ticked, the cube does not appear. For background. 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. 18. Bulk Insert. VLDB properties allow you to customize the SQL that MicroStrategy generates. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. All of the object comparisons take place before the SQL is generated as they are part of the determination in how to correctly generate the needed SQL. x. Starting in MicroStrategy 10 Data Import in Web supported a new scenario where multiple tables could be imported as part of a single Data Import Cube. PublishCube". Cube advisor. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Data can be analyzed as a report, document, or dossier. The example above can be summarized by ensuring that the project loading is optimized by making the max Ram usage of object cache 10 times greater than the estimated schema size. Regression DefectThe MicroStrategy Internal Reference Number for the issue discussed in this technical note is KB442296 and DE91603. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. The. 2 release, the driver file is called odbc8. The default is 1000 Intelligent Cubes. Please refer to Improving Report and Cube Performance to learn more about it. For the Time hierarchy, the offset can. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Strong semantic layer to define all the business rules and tightly coupled. MicroStrategy support connects you to the most helpful & experienced technical experts in the industry. x This technical note provides a detailed explanation on how. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the. if a temporary disruption occurs at the cube schedule time, current data will not be loaded until the next schedule time, causing an increase in cube update latency. Conclusion We discussed various techniques to improve report building, system performance, and user productivity with MicroStrategy in this eBook. Cloud Computing. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 5 compared to ODBC call 2. In just one week, MicroStrategy Professional Services, will conduct a thorough examination of your Business Intelligence implementation, providing you with actionable recommendations on these five key areas to improve overall performance. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. How Does MicroStrategy Improve Cube Performance? Please login or register to vote! Post MicroStrategy K Kate George Posted on 22nd August 2023 | 59 views 0 votes. 4. Select the Data Partition category. To improve performance between Google BigQuery and MicroStrategy, MicroStrategy changed the way in which SQL is generated by MicroStrategy to first filter the Time Transformation table, followed by joins to the Fact and other lookup tables. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). The ability to view or edit certain settings is determined by a user's privileges. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. In the Folder List, right-click the project and choose Project. Regular OLAP Intelligent Cubes allowed the storage of certain subsets of data to remain in memory for faster access and improved performance. You can further improve query performance by reducing the amount of data scanned. See how to take advantage of the latest Dossier features for improving data analytics speed and BI scale. To Define Limits for the Intelligent Cube Indexes. x and newer. The data fetch time is often too high for reports and cubes that are executed against the data warehouse as most of the data transfer time (for example, network bandwidth) is spent in. x for PostgreSQL since MicroStrategy 2021 Update 1. The M8MulPrc/M8MulPrc_32 process is a database connection process spawned from the MicroStrategy Intelligence Server 9. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. PATH: is the folder where the intelligent cube resides, returned as a string. Locate and execute the MicroStrategy Enterprise Manager report to provide additional performance benefit information on each Intelligent Cube recommended by Cube Advisor. Starting in MicroStrategy 11. Published: Jun 7, 2017 Last updated: Jun 7, 2017In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. the workflow manager or enterprise scheduling tool, to trigger the. 0 ODBC calls. 2 Secure Enterprise Platform, a new VLDB setting "MCE Join To Get Data Combination" has been introduced, that can help improve the document performance. This copy of report data is stored in Intelligence Server memory only. Big Data. Ability to add and edit descriptions in derived attributes, derived metrics, derived attributes, and metrics from a Data Import cube. The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. Logs name for PU, Command ID, and execution Status. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. MicroStrategy is committed to helping to ensure Virginia remains at the forefront of innovation and a top place to do business in the United States. Select the release from the left hand side (Platform or Feature) and choose the version from the drop down in the middle and your release from the collapsible sections below. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. API Management and Testing. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesMicroStrategy Platform Analytics is set up for all MicroStrategy 2019 or later versions and maintained to allow for instant access to system performance metrics.