This article narrates large cubes appear in ‘LP’ status and some other cubes not shown up in cube monitor in MicroStrategy 2021 is due to loading cube info thread being blocked by loading the large cube instance. In addition to the above, you can follow the Data Import steps via Web using Amazon Redshift and save your result set in-memory. 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). For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. x that handles the execution of queries and management of the database connections. This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. MicroStrategy implements a list of strategies to generate intermediate tables the choice of which can have a significant impact on query performance. Navigate to the Engine Component with CSI Dispatcher. 3. Click Modify to open the Properties dialog box: Security tab. " Cube B's refresh policy is set to "update existing data. MTDI cubes are the self-service in-memory solution. Whether it's a marketing campaign, infrastructure upgrade, or. 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. Indexes are created in memory on the Intelligence server as part of the in-memory cube instance. This attribute should have a lookup table in the SQL data warehouse. Refer to Product Manual for more detailed information. However, after publishing,. For troubleshooting and diagnostics logging routines related to MDX cube sources, see the Troubleshooting section of the System Administration Help. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. while (cubesEnum. 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. 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:. There is general performance degradation introduced by Sub-query. 19. Community & Support Search Discussions Open A Case View My CasesImproving Response Time: Caching. 3. A solution for this issue is available in current releases but need turn on via registry key setting. Big Data. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. More about Feature flags can be found in this article. Members," which identifies the current level within the hierarchy and evaluates the rank over all the. To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. Performance with mixed selections may vary significantly due to the selections of different elements in Warehouse, such as the performance difference between Case 5 and Case 6, Case 7, and Case 8. The MicroStrategy Intelligence Server 9. Hover the schedule need to be modified, and. Session Recovery is a new feature in MicroStrategy 10. Under the VLDB settings for that cube, make sure that to increase the. You could do this by partitioning and compressing data and by using a columnar format for storage. Hit Count - This count tracks how many times the in-memory version of the Intelligent Cube cache is hit. Right mouse click on the cube and choose Schedule. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. In-store and online. x) or OLAP (first generation of in memory cubes, introduced in 9. Expand Intelligent Cubes, and then select General. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Retail is leveling up with omnichannel analytics. Download the attached PDF for an in-depth understanding of Object Migration best practices. This will influence the user experience. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. 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%. For example, if they open a dashboard, document, or report and step away from the desk, their user session can. About the build/query performance tuning of Apache Kylin4. Refer to Product Manual for more detailed information. The MicroStrategy Performance Analysis service delivers:. 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 a report with the year and quarter attributes and the profit metric. Select data population for Intelligent Cubes. Select the Enable report drilling check box. x. The ability to view or edit certain settings is determined by a user's privileges. Cube Advisor opens. Open the Workstation window. Or, navigate to the Data Explorer for the MDX Cube database instance. They are temporary in nature and hold intermediate results. Create an Attribute Form Caching Cube. How MicroStrategy reduces the impact on page cache on a Linux operating system When publishing large Intelligent Cube files, a large amount of memory is required. This report is prompted on time and on the job type you want to analyze, and you can select the. Pros and Cons. Will it affect the performance of already existing MicroStrategy components?Using MicroStrategy, manufacturers can run Big Data analytics on disparate sources to achieve perfect order rates and quality, and to get in-depth consumption patterns. 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. Prior to 10. The Performance Analysis folder has several reports and two folders, each with its own related area of analysis: •. Answer: Go with dossier. After you have created your Intelligent Cube, you can publish. Under the Catalog>Read mode menu change the Catalog. Impact: Performance, security. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. 1, Intelligent Cubes have a new feature to update information without republishing it. The ID of the Job would be useful in order to read the job trace. 4. Starting from Microstrategy 2020, for duplicated filter conditions, the Engine will only calculate the temporary result once and reused for the same filter conditions, so that the performance can be improved. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Disk Once the cube is published, the Intelligence Server where the cube was published will back up the cube files on a disk. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. 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. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. 9% of resumes. MicroStrategy’s latest software release, MicroStrategy 9 Release 2, offers significant performance improvements that make business intelligence faster for BI users. yaml file and update the viewCutoffRangeInDays field to the. This name change is visible in. Unified calculation engine for building and querying; 3. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 0. Starting with MicroStrategy 10. The Options dialog box opens. To plan for these memory requirements, see the System Administration Help. out. For the Time hierarchy, the offset can. 2 release, the driver file is called odbc8. 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 is committed to helping to ensure Virginia remains at the forefront of innovation and a top place to do business in the United States. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Retail is leveling up with omnichannel analytics. When running an integrity test, users might want to get the execution time of the report or document. Create an Attribute Form Caching Cube. With partitioned enabled, the cube size is expected to be slightly larger than a non-partitioned cube. For example, you can build yearly partitions and then process just those two years so that way it's only accessing that data. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. In Developer, from the File menu select New, and then Intelligent Cube. Login to MicroStrategy Web, create a cube with the function of Data Import. For example, you can choose to add or delete data from the Intelligent Cube. x from any unexpected conditions. In additional to some performance impact, this re-publishing workflow will also need the original data source. How To Reduce Intelligent Cube Size By Finding Intelligent Cube Objects Which Are Not In Use. Collect statistics on the tables 5. The default value is 256 megabytes. To plan for these memory requirements, see the System Administration Guide. The Options dialog box opens. MicroStrategy consistently pushes updates to the Chrome Web Store when any issues are resolved. 0. 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. x for PostgreSQL since MicroStrategy 2021 Update 1. This article explains why MicroStrategy 2021 Update 1 requires additional disk space when publishing a cube to improve cube loading times. 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. Use Cube Advisor to create Intelligent Cubes: 1. MicroStrategy supports reporting and analysis with SAP BW, Microsoft Analysis Services, Hyperion Essbase, and IBM Cognos TM1. Click All Objects View. Tips and Tricks to Partition In-Memory Cubes for Faster Performance. The binary generated for this mode is different from the binary generated for PDF. Dashboards executed in Flash mode require Flex Binary for the data and XML generation for the Dashboard definition. x that allows logged out MicroStrategy Web users to log back in and recover the last dashboard, document, or report they viewed before logging out or being logged out. Steps to Modify the View Date Range. Impact: Performance, security. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. 0 and have upgraded to the most recent version of MicroStrategy, it is recommended that you use a different Intelligent Cube normalization technique. For Oracle 12. The impacted index sorting are basically Integer operation, and based on information online, MicroStrategy 2021 Intelligence Server is 25+% slower than MicroStrategy 2020 Intelligence Server. x SQL engine: "Parallel Query Execution" work. Number. With an increasing number of. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. 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. Cube A's refresh policy is set to "add new data. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. Published: Jun 7, 2017 Last updated: Jun 7, 2017In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. 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) or OLAP (first generation of in memory cubes, introduced in 9. The basics of this feature are covered in KB235131. 9 and 10. Matching and Number of Keyword Limitations. Users may find additional information related to managing and using Intelligent Cubes in. The subscriptions (from the performance test package) were then executed on the reports and dossiers built on the performance test cube to generate approximately 100 jobs/transactions every minute. Create an attribute element prompt for the Year attribute. 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. You can optionally remove cells that have a value of zero. KB442293 : In-Memory query optimization to improve performance by. When editing this type of cube, MicroStrategy Web executes the full SQL of that cube before displaying the returned data to show the first rows of the cube in the Editing page. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Set Freeform SQL and MDX objects default security. Step 2. This can be done by enabling the feature flag "Defect fixes that may impact data, SQL, MDX, CSI" in Web. All necessary privileges are included in the Administrator role by default. The Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. Washington D. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. Number of Views 524. Then click "Save". The cube is based on a MDX datasource, specifically SAP BW. Now there are scenarios where these tables will only have partial data and a join needs to be performed between the tables. To improve performance, MicroStrategy provided a way to bulk insert a large amount of data with prepared statement. During project loading or project schema updates, if dynamic sourcing is enabled for at least one of the projects and there are active cube caches available for the projects, the MicroStrategy data engine must process cubes with an active cube cache status for dynamic sourcing functionality to be ready to work. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more cardinality means the attribute with more different elements, for example in the Tutorial project the. Open the PAConsumerConfig. In Developer, log in to a project with a user account with administrative privileges. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. This is helpful if the Intelligent Cube is used in an internationalized environment that supports multiple languages. Intelligent Cube storage on disk mirrors report cache storage. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. A code fix is provided. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. Defining the partition for Super Cubes. Now offering. 3. This article describes the Intelligent Cube Population options available in MicroStrategyReturn on investment (ROI) is a critical metric for any business as it measures the profitability of an investment in relation to its cost. 3. Use mstr_ko. Use the cube as the dataset for the dashboard and then use view filters however you want on the various. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. 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. An Intelligent Cube is an In-Memory data structure which holds. Starting in MicroStrategy 11. hasMoreElements ()) { //Get the intelligent cubes for one project Caches cubesPerProject = cubesEnum. 2. 4. 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. Install MicroStrategy 10. For example, you can choose to add or delete data from the Intelligent Cube. The cube is based on a MDX datasource, specifically SAP BW. 3. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. In MicroStrategy, users can create and manage datamart tables in a different schema, database, or server from the data warehouse. To plan for these memory requirements, see the System Administration Guide. Right-click the Intelligent Cube, and select Edit. Use Aggregate tables 2. A set of data is returned from the. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. KB484145: Improving report and cube performance against the data warehouse by using an attribute form caching cube: Performance: N/A: 2021: DE172805: SQL, CSI: KB484832: Optimize CONCAT expression containing multiple constant Strings to improve performance: Performance: 2021: 2021: DE158548: SQL Although this technique improves document performance, the amount of time required to publish an Intelligent Cube increases as it grows in size. Set Join behavior for all attributes with the option Outer. For example, the objects developed in a development environment can be copied to a UAT environment to test and validate the. MicroStrategy. The cube can answer most daily questions instead of going back toThis article describes best practices to be taken when using a Teradata database in MicroStrategy. The Intelligent Cube Options dialog box opens. 10 where different behavior is seen in between a Live connect and In-Memory cube when filtering on warehouse null values in Dossier. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Stay up to date on inventory needs and avoid. 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. A keyword must be a minimum length of three characters. 2. 2. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. A good caching strategy can significantly improve system performance. Best Practices with MicroStrategy. 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. Purpose of the registry key. 4. , UNION, INTERSECT, EXCEPT). Set Freeform SQL and MDX objects default security. Since the modifications made in the cube are reflected instantly, you don’t. 2. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesFollow the steps below to delete an OLAP cube database instance from MicroStrategy Developer. The following knowledge base article explains the process to modify the diagnostics logging for MicroStrategy components from the command line in Windows and Unix environments. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. None excludes the attribute in the target from the GROUP. Answer: Go with dossier. "Obtaining the Installation Packages. Dec 2017 - Present 6 years. It is similar to concept of standard report hitting the database with intermediate table concept of fetching required amount of data and merging it finally with necessary filters to improve. To do so, you can take advantage of URL API. To make use of bulk insert for Snowflake, user can simply enable “Use Parameterized Queries” when creating DB Role: After bulk insert functionality is enabled, it enables reuse of SQL statements and only set new parameters. You can try to clear the page cache to see if performance improves. 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. Select the Data Partition category. This provides improved performance when querying in-memory cubes. Full control. getCount. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. To increase performance we can also use Intelligent as they have the loaded data and the reports created from these cubes is capable of fetching data much faster. Partitions help in performance improvement of subset report executions; as a trade-off, some extra information is written in the cube, resulting in an increase in the cube size. You can edit project-level cache and Intelligent Cube settings. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. In some business scenarios, it is required to filter data for current month in cube report with view filter in MicroStrategy 9. This value can be adjusted in the PA project settings. Expand Intelligent Cubes, and then select General. Distributed query engine，avoid single-point-of-failure; 2. When a User Group is configured with a System Prompt Security Filter including 'User Login' the MicroStrategy environment will generate and access caches on a User basis even if the User Login does not have an effect on the final result set. In MicroStrategy 10. In MicroStrategy Secure Enterprise 11. QUESTIONUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. This functionality is run in a separate process to isolate MicroStrategy Intelligence Server 9. 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. Place Intelligence Server close to the both the data warehouse and the metadata repository. Go to Schema and open the OLAP Cube Catalog. It illustrates tips and tricks, such as enabling parallel data fetch, enabling the correct number of partitions, enabling partition on the appropriate attribute, and using cubes vs. 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. 1. Metro Area. To use this functionality in. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. 5. ) As long as each node is using the same server definition, the setting of the cache and history list locations in the Intelligence Server configuration only needs to be done once; however, the creation of the shared folders will need to be done on each node. See how to take advantage of the latest Dossier features for improving data analytics speed and BI scale. Derived metrics; Subtotals; Multi-pass queries against Multi-Table Data Import (MTDI) cubes Refer to Technical Document below on how to enable the VLDB: KB44052: How does the feature in the MicroStrategy 9. x7. To make use of bulk insert for Snowflake, user can simply enable “Use Parameterized Queries” when creating DB Role: After bulk insert functionality is enabled, it enables reuse of SQL statements and only set new parameters. From the performance side it is possible to do a SQL comparison between the two executions, however this was chosen against as the performance impact would be too great for the average user. Iterate through the enumeration to get the cubes per project and the corresponding status. This article reviews the following approaches you can take to improve MicroStrategy performance on SAP HANA. By default, the location configured will be a relative path where ". Run multiple dossiers, documents, or reports based on this cube to. An Intelligent Cube publication takes significantly long to complete publication (several hours). 4. Connectivity. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. The MicroStrategy Intelligence Server 9. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. We can try to use different aggregations groups to improve the query performance of some very important Dim or a Dim with high cardinality. Dedicate a machine for the metadata repository. 7. After you find the microstrategy. The limitations mentioned above are currently being investigated by the Technology team. Full control. Determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results faster and publish Intelligent Cubes. Cause: The root cause of the issue is cube template "Blank Emma Cube Report" that is set to hidden. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. 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 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%. The impacted index sorting are basically Integer operation, and based on information online, MicroStrategy 2021 Intelligence Server is 25+% slower than MicroStrategy 2020 Intelligence Server. However, after publishing,. This can improve the performance of. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. It is local to the node and is reset every time the cube is unloaded/loaded. if it’s take less time then you’ll have something to do with MSTR or fine tune DB SQL with the help DBA. Therefore we need 20GB RAM memory to store the cube. To solve this problem, we introduce a new registry key, " Respect. Choose your preferred method to share the logs. Video Tutorials. Go to Schema Menu > SQL Generation Options. Option 1: Develop each report in Microstrategy developer using attribute filters as desired. Right-mouse click this object, and click on Search for Components. 0, dynamic growth algorithm for buffer size is introduced to improve the performance of buffer, and it is enabled by default. Restart the Intelligent Server. NAME: is the name of the intelligent cube, returned as a string. MicroStrategy Optimization: HINTS. Platform Analytics captures telemetry from the MicroStrategy platform in real-time, and then it presents this data to the administrators, developers, and analysts to help them optimize the performance of their MicroStrategy system, offer personalized recommendations to their business users, improve their analytics apps, secure their data, and more. If the data requirements for the report change, or cannot be satisfied by an available Intelligent Cube, the reports automatically access the data. In Asian languages, the minimum length is one character. The cube can answer most daily questions instead of going back toThis article describes best practices to be taken when using a Teradata database in MicroStrategy. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. 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"MicroStrategy Developer: The right-mouse-click menu is as below if the user has all the other permissions expect Read. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. 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. MicroStrategy Optimization: VLDB Settings. To solve this problem, we introduce a new registry key, " Respect. The "User login" prompt in security filters applied to MDX Cubes. It does not tell us anything helpful and we should not use it as a point of reference. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. Tip: Rename objects in the card to be more concise. x and 10. The Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. 1669 views. 0 MicroStrategy introduced the 'Platform Analytics' application, which helps monitor and track object usage across the MicroStrategy platform in real time. There are options for Replace existing data, update existing data or add. Smart. Easily add or change pre- and post- SQL statements. Intelligence Server supports the following types of caches:Disabling TPT is required because enabling "Fetch data slices in parallel from the warehouse" will instruct the MicroStrategy Query Engine to prepare the SQL statements in a way that they can be parallely executed against the Warehouse. You could do this by partitioning and compressing data and by using a columnar format for storage. Right click the database and under “Tasks” choose “Backup”. 9 or an older version. 2 Secure Enterprise Platform, a new VLDB setting "MCE Join To Get Data Combination" has been introduced, that can help improve the document performance. 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. All Intelligent Cube operations are listed below: 1. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. To enable a new performance logging configuration, users should run the command 'echo "p" >. x and newer. Use partition mapping 3. However, there is no significant improvement against Synapse Analytics. println ("For project: " + cubesPerProject. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. in MSTR, go to project config, increase the project memory settings.