Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. In 11. After the fix, if user examine the Query Detail, CSI should show reused temporary cube. Dossiers automatically adjust to look great on any screen. jar. MDX cubes are also referred to as MDX cube sources. If the data requirements for the report change, or cannot be satisfied by an available Intelligent Cube, the reports automatically access the data. 4. Select the Data Partition category. In addition to the above, you can follow the Data Import steps via Web using Amazon Redshift and save your result set in-memory. The Intelligent Cube Editor opens. It is local to the node and is reset every time the cube is unloaded/loaded. This section focuses on the VLDB properties that are set at the metric and report level. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. Distributed query engine，avoid single-point-of-failure; 2. VLDB settings 4. Prerequisites • KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. The Options dialog box opens. The expected behavior was that once the governing setting was reached, unused indexes were dropped from memory to make room for newer indexes. 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. 11 it is possible to have split child hierarchy attributes join through a shared fact table rather than through a parent with Data Import Cubes. 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. 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:. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. In MicroStrategy Secure Enterprise 11. Grouping determines how the metric aggregates. Choose Data > Configure Intelligent Cube. Unified calculation engine for building and querying; 3. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of. x). Locate the newly imported cube, right-click on it, and choose "Edit. 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 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. Understand your data characters and choose the matched configuration could enhance the performance and accelerate the process to view the latest data. Metro Area. Details on MicroStrategy recommendations can be found in this TN. You can further improve query performance by reducing the amount of data scanned. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Rather than returning data from the data warehouse for a single. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. Review steps below to improve bulk data load from Redshift to MicroStrategy. 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. This name change is visible in. This change improves the performance for memory intensive use scenario also potentially increases the memory footprint for Intelligence Server. Run both reports after enabling the metric levels log. In the Navigation pane, click , next to Datasets. SUMMARY. Browse resources on demand or contact support directly. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. Click View Logs, to display the share icon in the upper-left. 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. Washington D. Cyber Security and SIEM Tools. Select SINKS and click the + New Sink button. x releases, and the new Multi-table Data Import (MTDI) cubes introduced in 10. An Architect creates, publishes, and optimizes a federated data layer as the enterprise’s single version of the truth. Locate and execute the MicroStrategy Enterprise Manager report to provide additional performance benefit information on each Intelligent Cube recommended by Cube Advisor. This count is not shared across nodes of the cluster. MicroStrategy support connects you to the most helpful & experienced technical experts in the industry. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. In order to protect both security and performance the MicroStrategy system will compare all of the Security settings in. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 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. Apply the year prompt to to view filter of the intelligent cube report and the report filter regular report. Loading × Sorry to interrupt Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. In versions prior to MicroStrategy Intelligence Server 9. MicroStrategy Optimization: HINTS. Video Tutorials. Stored calculations for compound metrics. Note: number of columns should be the same as in the original file. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. The fix works when the. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. The main reasons an Intelligent Cube size would increase after publishing is for the following reasons: Cube Index generation. An Intelligent Cube is an In-Memory data structure which holds. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. 1, Intelligent Cubes have a new feature to update information without republishing it. MicroStrategy implements a list of strategies to generate intermediate tables the choice of which can have a significant impact on query performance. A solution for this issue is available in current releases but need turn on via registry key setting. A keyword must be a minimum length of three characters. On the left side of the page, click Logs and then Export Logs to save the file. 0. The result of this setting is reflected in the GROUP BY clause of the SQL command. This privilege is part of OLAP Services. CAUSE: CPU information shows this is not an apple-to-apple comparison. In Asian languages, the minimum length is one character. Run multiple dossiers, documents, or reports based on this cube to. These changes are to both defect fixes and enhancements for a more stable and robust reporting. x for PostgreSQL since MicroStrategy 2021 Update 1. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. Collect statistics on the tables 5. 11, 10. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. Optimize Build and Query. Determines how MDX cube reports that only include attributes are processed in order to improve performance in certain scenarios. Retail is leveling up with omnichannel analytics. Can benefit from spark new features and ecology. With an increasing number of. The ability to view or edit certain settings is determined by a user's privileges. 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. Refer to Product Manual for more detailed information. Select the database instance to delete. Beginning in MicroStrategy 11. Full in-memory load can even be a hinder to full deployment. Bulk Insert. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". There is an increasing demand, from users across all organizations, for higher BI performance, driven by the rapid growth of data volumes and number of users. Select the data set and click Prepare Data. sh . Click OK. Another common situation with Parameterized Query will be combining multiple inserts of data into the database as a single query. 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. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. This " How to" knowledge base article explains cube advisor. Run both reports after enabling the metric levels log. The path for cube files must be shared as "ClusterCube". The binary generated for this mode is different from the binary generated for PDF. Answer: Go with dossier. 9% of resumes. Problem is: 100% in-memory solutions cannot fit all your requirements. All necessary privileges are included in the Administrator role by default. Solve issues with Garbage Collection overhead limits. Sure, currently just exploring the mstrio. 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. In-Memory capabilities provide tremendous acceleration to your Dashboards. x SQL engine: "Parallel Query Execution" work. When you enable these traces, be sure to enlarge the size of trace file to >20MB. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. To plan for these memory requirements, see the System Administration Guide. By default, the location configured will be a relative path where ". 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. Specific jobs will run (in parallel) on Hadoop and then be transfered back to the intelligence server (in parrallel) via TCP. Or, navigate to the Data Explorer for the MDX Cube database instance. 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. " Cube B's refresh policy is set to "update existing data. MicroStrategy Cube Trigger (MSCT) allows the process which updates the data warehouse, i. Filter the contents of a Cube / Report by passing the selected object IDs for the metrics, attributes, and attribute elements to the apply_filters() method. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. 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. 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. Use a cube with MicroStrategy if you're only concerned with last month’s aggregated data. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 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. Execute View Report. The default value is 256 megabytes. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). x and newer. Cube 7: Improve cube response time. Defines whether to attempt to improve performance of reports that use expression-based transformations. Create a report with the year and quarter attributes and the profit metric. We have already. and access_transactions is heavily indexed because it's critical to the performance of joining and filtering all of the tables that relate through access_transaction (lu_object, lu_account, fact_action_cube_cache, etc. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. This presentation helps users understand MicroStrategy's in-memory architecture. 0 ODBC calls. 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. Use mstr_ko. In MicroStrategy 9. 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. if it’s take less time then you’ll have something to do with MSTR or fine tune DB SQL with the help DBA. To define an incremental refresh report. Click Modify to open the Properties dialog box: Security tab. As the Architect of the company, you are responsible for creating a dataset optimized for HyperIntelligence. This provides improved performance when querying in-memory cubes. Then go to the key “Query. The telemetry generated from these actions was processed by the Telemetry Store and loaded into the Platform Analytics warehouse. If you used this option in 9. Retail is leveling up with omnichannel analytics. Thanks, NitinSubstitute the correct values for the environment for each entry. …Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. In our case we define 3 Aggregations Groups: 1. 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. These enhancements include: Improved Data Compression: New data compression algorithms enable MicroStrategy’s In-memory cubes to store up to three times as much data as before. Open the PAConsumerConfig. 0". For troubleshooting and diagnostics logging routines related to MDX cube sources, see the Troubleshooting section of the System Administration Help. Report runtime performance for reports accessing Intelligent Cubes is optimized because the Intelligent Cube for the report has already been loaded. 3. view reports. Every new MTDI cubes appears as hidden object in Microstaretgy 10. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. The following steps demonstrates how to reproduce the issue in MicroStrategy Tutorial project: Create an intelligent cube with Category, SubCategory, Item, Warranty, Call Center. Maintain your competitive edge with a data-driven retail app designed to scale—from individual. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Telcos using MicroStrategy can run. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. 0 cubes is the ability to partition cubes. CAUSE: CPU information shows this is not an apple-to-apple comparison. The Performance Analysis folder has several reports and two folders, each with its own related area of analysis: •. Use partition mapping 3. Starting from MicroStrategy 10 – you’ll see tge optimized form of Intelligent Cube based reports SQL modified as below with better optimizations. To improve the cube publish performance for Oracle, we tried using different ArraySize values and found a more suitable range against the use case. 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. The in-database Advanced Analytics gives you the insights you need to improve everything from database performance to your company’s inventory management. The iCube creation process is very similar to Reports: Right-click | New Intelligent Cube | Then, add a Template and. MTDI cubes are the self-service in-memory solution. In-store and online. The application is named MicroStrategy Cube. 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. Under CUBE TEMPLATE, choose Default Attribute Form Caching. To locate these settings, right-click the project and select Project Configuration. Place Intelligence Server close to the both the data warehouse and the metadata repository. There is a substantial increase in complex query performance; 4. Intelligence Server Statistics Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. The grouping options for levels include: Standard groups by the attribute level of the target. This value can be adjusted in the PA project settings. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 1. Example Performance Data. Login to MicroStrategy web, create a dossier and use the newly created OLAP01 as a dataset. To check if these cubes can potentially be reduced in size an audit can be performed on the cube objects to see which cube objects are not being used by any of the view reports, documents, or dossiers. Option 2: Have all your 46 million records pulled into a cube. An Intelligent Cube publication takes significantly long to complete publication (several hours). Starting from MicroStrategy 10 – you’ll see tge optimized form of Intelligent Cube based reports SQL modified as below with better optimizations. Traditionally, this type of requirement was hard to achieve as there was not an event that could be triggered right after the execution of an. From the Partition Attribute drop-down, select the partition attribute for the Intelligent Cube. The data get's fresher, faster, and less resources consuming for everyone. 3. For background. This article reviews the following approaches you can take to improve MicroStrategy performance on SAP HANA. The following line chart. Members," which identifies the current level within the hierarchy and evaluates the rank over all the. x. Whether it's a marketing campaign, infrastructure upgrade, or. 0 MicroStrategy introduced the 'Platform Analytics' application, which helps monitor and track object usage across the MicroStrategy platform in real time. Indexes are created in memory on the Intelligence server as part of the in-memory cube instance. 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. Data can be analyzed as a report, document, or dossier. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. Cube A's refresh policy is set to "add new data. 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. This empowers administrators with telemetry capabilities that capture and analyze usage statistics and performance for objects. Cloud Computing. Starting with MicroStrategy 10. Cube index generation will increase cube size. Right-click the Intelligent Cube, and select Edit. MicroStrategy Optimization: VLDB Settings. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. Optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. If you use Enterprise Manager, dedicate a machine for the Enterprise. Use Cube Advisor to create Intelligent Cubes: 1. About the build/query performance tuning of Apache Kylin4. 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. Under the VLDB settings for that cube, make sure that to increase the. Tips and Tricks to Partition In-Memory Cubes for Faster Performance. This would require that you have all your attribute relationships defined correctly. 2. g. The New Intelligent Cube dialog box opens. Create an attribute element prompt for the Year attribute. This causes the cube cache file. 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. 11 the derived attributes are now evaluated at the source when all the required columns come from the same table, which covers the. HyperIntelligence for Web can only search for a total of 500k keywords and alternate keywords at a time. Generate Oracle AWR report or monitor the database to identify the low performance query. Conclusion We discussed various techniques to improve report building, system performance, and user productivity with MicroStrategy in this eBook. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. Create a report with the year and quarter attributes and the profit metric. Deploy the ojdbc8. You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice. ) 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. Starting in MicroStrategy 10. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. Add Month and Profit to a grid visualization of the dossier. Based on performance concerns, the Intelligence Server will also save other remote cluster node's cube lookup indexes in-memory. 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. 4. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. This can be done by enabling the feature flag "Defect fixes that may impact data, SQL, MDX, CSI" in Web. NOTE: For additional information on how to configure a clustered Cache and Inbox sharing, refer to the MicroStrategy technical note: KB441125: How to configure Cache, Cube, Inbox, and Session Recovery file sharing for a MicroStrategy Intelligence Server clusterMicrostrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. 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. The most obvious workflows where you can expect to see performance improvements: Project loading during MicroStrategy Intelligence server startupIntelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Every newly created MTDI cube will inherit settings from this template and automatically be created. API Management and Testing. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. We did internal. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. 2. this is the memory MSTR uses for worker set. 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. , UNION, INTERSECT, EXCEPT). Create the metric levels log file used to track the use of dynamic sourcing. in MSTR, go to project config, increase the project memory settings. Use Case 4. 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. 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. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. It accesses and joins data. In the previous example all the extra calculations were pushed to the intelligent cube which will improve the performance for the end users. Can benefit from spark new features and ecology. To achieve this, cube processing in the MicroStrategy. Set Join behavior for all attributes with the option Outer. MicroStrategy's support for parameterized queries can improve performance in scenarios that require the insertion of information into a database. nextElement (); System. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. Navigate to the Engine Component with CSI Dispatcher. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. Restart the Intelligent Server. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Dec 2017 - Present 6 years. Complete the "sessionState" field (e. 2. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. x and newer. How to troubleshoot and improve Cube Publication times in MicroStrategy Secure Enterprise. MicroStrategy PRIME is a new feature added to the MicroStrategy 10 Secure Enterprise Platform. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. x. To learn more about attribute form caching cubes, see KB484994. 0 release, we have changed the workflow to ensure we can always deliver the correct data to the user. When a derived attribute is built off of data from a single live data import cube, then the calculation of the derived attribute will be pushed down into the query against the data source rather than being done in the. In additional to some performance impact, this re-publishing workflow will also need the original data source. After you find the microstrategy. 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. When there is requirement to fetch non-ID attribute forms, the attribute form caching cube is used instead of database. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. It allows companies to evaluate the effectiveness and efficiency of their investments and make informed decisions based on concrete data. x7. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. g. The second most common hard skill for a microstrategy developer is bi appearing on 5. 1, Intelligent Cubes have a new feature to update information without republishing it. 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. 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. You can also configure these settings using Command Manager scripts located at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_Outlines. Open Windows Services, right-click MicroStrategy Platform Analytics Consumer and select Stop. We have found that educated users are more likely to use the product on a daily basis. 4. Create an Attribute Form Caching Cube. In the search, when All objects option is ticked, the cube does not appear. In MicroStrategy 10. Share query results in-memory across multiple dossiers and. Business Intelligence and Analytics. See Memory Mapped Files for Intelligent Cubes for more information. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. Pros and Cons. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. This Technical Note describes how the project level governing limit “Maximum RAM usage (MBytes)" for Intelligent Cubes is implemented in a clustered environment. Connect to your database using SQL Server Management Studio and in the left pane select your Metadata database. Determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results faster and publish Intelligent Cubes. 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.