Complete the "sessionState" field (e. Starting in MicroStrategy 10. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Strong semantic layer to define all the business rules and tightly coupled. Kernel -> Processing Unit Trace – trace tasks execution of a Processing Unit. In versions prior to MicroStrategy Intelligence Server 9. By profiling the Intelligent Cube publication (as per KB30699 - How to measure the Intelligent Cube performance parameters for time and memory in the MicroStrategy Intelligence Server 9. if it’s take less time then you’ll have something to do with MSTR or fine tune DB SQL with the help DBA. 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. Some of the important points discussed can be summarized as: Metadata modeling is a complex task, so set aside sufficient time for this activity. 0 if there are multiple join paths between two or more One-to-Many relationship tables in a multi-table data import cube, rather than using the first available table join path, the analytical engine will look for the path with the least number of tables and the smallest table base on the following order/criteria: 1. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. While performing multiple queries in parallel can improve the performance of query execution in MicroStrategy, it will not provide the best performance or results in all scenarios. For background. 9 and 10. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. 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. Collect statistics on the tables 5. •MicroStrategy enables users to pull subsets of data, which could be up to hundreds of Gigabytes, from a Big Data source into an in-memory cube, and build reports/dossiers from the cube. 3. 2. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. A solution for this issue is available in current releases but need turn on via registry key setting. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". In-store and online. If you used this option in 9. The MicroStrategy Intelligence Server 9. Note: number of columns should be the same as in the original file. 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. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). 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. 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. 18. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. In order to obtain those values, users must select at least one performance cycle in the Processing options window as shown in the following image: Once the test is completed, the user will get the minimum, maximum and average time of. Create the metric levels log file used to track the use of dynamic sourcing. Dedicate a machine for the metadata repository. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. Impact: Performance, security. Right click the database and under “Tasks” choose “Backup”. Use partition mapping 3. MicroStrategy implements a list of strategies to generate intermediate tables the choice of which can have a significant impact on query performance. Click View Logs, to display the share icon in the upper-left. 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. 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. This enhancement only applies to Windows, Linux and Mac OS. 2. x. 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. Publish the Intelligent Cube by executing it on either of the nodes. Cube index generation will increase cube size. When you enable these traces, be sure to enlarge the size of trace file to >20MB. To do so, you can take advantage of URL API. Starting from MicroStrategy 10 – you’ll see tge optimized form of Intelligent Cube based reports SQL modified as below with better optimizations. MicroStrategy's support for parameterized queries can improve performance in scenarios that require the insertion of information into a database. 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. 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. Intelligent Cube, or on-demand retrieval using live mode. 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. Click Modify to open the Properties dialog box: Security tab. The Performance Analysis folder has several reports and two folders, each with its own related area of analysis: •. 3% of resumes. hasMoreElements ()) { //Get the intelligent cubes for one project Caches cubesPerProject = cubesEnum. 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. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Users may find additional information related to managing and using Intelligent Cubes in. If the configuration settings are correct the following will happen: KMCW connects to MicroStrategy and crates a new cube. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). In addition to this, you need a plan for tuning the system. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. API Management and Testing. Answer: Go with dossier. g. Before you create an Intelligent Cube, search through MicroStrategy to see whether a similar Intelligent Cube already exists that can serve the same. This functionality is run in a separate process to isolate MicroStrategy Intelligence Server 9. Watch this video to learn more about the Expert. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. Historically, business intelligence (BI) teams focused on building dashboards to run on computer systems. With an increasing number of. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Distributed query engine，avoid single-point-of-failure; 2. Before MicroStrategy 10. This helps enhance query performance and improve the ability to perform multidimensional analytics on the cloud. Use Case 4. "Obtaining the Installation Packages. Specific jobs will run (in parallel) on Hadoop and then be transfered back to the intelligence server (in parrallel) via TCP. MicroStrategy. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. The "User login" prompt in security filters applied to MDX Cubes. Cube advisor. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Or, navigate to the Data Explorer for the MDX Cube database instance. MicroStrategy consistently pushes updates to the Chrome Web Store when any issues are resolved. 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. 0. This increases readability and enhances the appearance of the card. println ("For project: " + cubesPerProject. MicroStrategy’s latest software release, MicroStrategy 9 Release 2, offers significant performance improvements that make business intelligence faster for BI users. Regular OLAP Intelligent Cubes allowed the storage of certain subsets of data to remain in memory for faster access and improved performance. CAUSE: CPU information shows this is not an apple-to-apple comparison. 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. IUsers of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. The following diagram depicts the role of the intelligent cube. 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. Under Refresh type, select one of the following options. Visit the data visualization and data dashboard galleries for inspiration. This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. Share query results in-memory across multiple dossiers and. You can optionally remove cells that have a value of zero. Distributed query engine，avoid single-point-of-failure; 2. Select the Enable report drilling check box. 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. However, there is no significant improvement against Synapse Analytics. For a single cube publish, using 3. Loading × Sorry to interruptIncremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. , UNION, INTERSECT, EXCEPT). Locate and execute the MicroStrategy Enterprise Manager report to provide additional performance benefit information on each Intelligent Cube recommended by Cube Advisor. x for PostgreSQL since MicroStrategy 2021 Update 1. 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. ) 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. Increasing this setting can increase caching efficiency in cases. This privilege is part of OLAP Services. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. Therefore we need 20GB RAM memory to store the cube. This name change is visible in. Understand your data characters and choose the matched configuration could enhance the performance and accelerate the process to view the latest data. 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. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. In MicroStrategy Secure Enterprise 11. We have found that educated users are more likely to use the product on a daily basis. 2. Cube A's refresh policy is set to "add new data. In some business scenarios, it is required to filter data for current month in cube report with view filter in MicroStrategy 9. Cyber Security and SIEM Tools. The second most common hard skill for a microstrategy developer is bi appearing on 5. “Normal cube” 2. This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. 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. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. You can also configure these settings using Command Manager scripts located at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_Outlines. Solution. Refer to Product Manual for more detailed information. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. e. The main reasons an Intelligent Cube size would increase after publishing is for the following reasons: Cube Index generation. 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. 3. The below test is based on a 4M rows dataset which shows the throughput improvement with ODBC call 3. x ODBC calls have approximately 30% performance improvement than using 2. Click OK. 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. Once the object is used in the card, right-click the object. During installation you have the following options:Governing Intelligent Cube Memory Usage, Loading, and Storage. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). 5 compared to ODBC call 2. See Memory Mapped Files for Intelligent Cubes for more information. x and newer. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. 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. Starting with MicroStrategy 10. Select the Data Partition category. MicroStrategy is constantly iterating, importing, and creating new features to ensure our customers are having the best experience. Use Cube Advisor tool to leverage the use of dynamic sourcing feature; Yes! This tool, even if «archaic» and not update is still useful! Dynamic sourcing can improve performance by enabling reports to automatically hit an available cube if it contains all the required information. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. 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. x - 10. Providing Intelligent Cube data. If a project is pointing to a large warehouse database, it is important to keep in mind that table structures can be updated without the warehouse catalog loaded. The MicroStrategy Performance Analysis service delivers:. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Create a report with the year and quarter attributes and the profit metric. Smart. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Users can also seamlessly drill down from data in an in-memory cube, to detail data in RDBMS and further detail in Amazon Redshift. This article discusses Data Engine changes that may impact customers data when upgrading to MicroStrategy 2019. In MicroStrategy 10. The default value is 256 megabytes. Iterate through the enumeration to get the cubes per project and the corresponding status. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 1669 views. Run both reports after enabling the metric levels log. Go to Schema and open the OLAP Cube Catalog. In our case we define 3 Aggregations Groups: 1. 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. In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services. The grouping options for levels include: Standard groups by the attribute level of the target. MicroStrategy support connects you to the most helpful & experienced technical experts in the industry. Restart the Intelligent Server. 3. Will let you know more about it once I started using it. g. The ID of the Job would be useful in order to read the job trace. 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. Subset report or view report caching can improve dossier performance in almost 70% of all cases. To solve this problem, we introduce a new registry key, " Respect. If the data requirements for the report change, or cannot be satisfied by an available Intelligent Cube, the reports automatically access the data. 4. Step 1. 0 and have upgraded to the most recent version of MicroStrategy, it is recommended that you use a different Intelligent Cube normalization technique. MicroStrategy PRIME is a new feature added to the MicroStrategy 10 Secure Enterprise Platform. Create a new variable and assign SuperCube with two parameters inside – connection and id. Telcos need network capacity planning and optimization by correlating network usage, subscriber density, along with traffic and location data. You could do this by partitioning and compressing data and by using a columnar format for storage. MicroStrategy supports reporting and analysis with SAP BW, Microsoft Analysis Services, Hyperion Essbase, and IBM Cognos TM1. 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. In Project Configurations, reduce the cube index growth limit setting to the minimum value of 50%. 11, a new feature is available for performance optimization when dealing with derived attributes. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Answer: Go with dossier. The New Intelligent Cube dialog box opens. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. x and newer. This " How to" knowledge base article explains cube advisor. Run multiple dossiers, documents, or reports based on this cube to. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. How to troubleshoot and improve Cube Publication times in MicroStrategy Secure Enterprise. In order to protect both security and performance the MicroStrategy system will compare all of the Security settings in. You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. Login to MicroStrategy web, create a dossier and use the newly created OLAP01 as a dataset. “With a nearly 30-year. 4. The Incremental Refresh Options dialog box opens. The fix works when the. With Parallel Hierarchy. By profiling the Intelligent Cube publication (as per KB30699 - How to measure the Intelligent Cube performance parameters for time and memory in the MicroStrategy Intelligence Server 9. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Set Join behavior for all attributes with the option Outer. VLDB settings 4. x). Load an updated CSV file into a DataFrame providing full path. HyperIntelligence for Web can only search for a total of 500k keywords and alternate keywords at a time. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. To build an Intelligent Cube. in MSTR, go to project config, increase the project memory settings. In the Categories list, expand General, and then select Drilling. How To Reduce Intelligent Cube Size By Finding Intelligent Cube Objects Which Are Not In Use. x and newer. Run both reports after enabling the metric levels log. MicroStrategy enables users to pull subsets of data, which could be up to hundreds of Gigabytes, from a Big Data source into an in-memory cube, and build reports/dossiers from the cube. All necessary privileges are included in the Administrator role by default. VLDB properties can also be used in order to optimize report. Easily add or change pre- and post- SQL statements. This knowledge base article describes a behavior in MicroStrategy 10. x. The default is 1000 Intelligent Cubes. Enterprise Manager is the precursor product for Platform Analytics. 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. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. In other words, you should partition. 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. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. There are two types of counters to track hit counts in Intelligent Cubes: 1. Dec 2017 - Present 6 years. In Developer, log in to the project source for your project. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. 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. MDX cubes are also referred to as MDX cube sources. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Stay up to date on inventory needs and avoid. 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. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. 9 or an older version. 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. 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. Select data population for 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. Hit Count - This count tracks how many times the in-memory version of the Intelligent Cube cache is hit. Expand the Object Templates category, select General, and from the Show templates for the. Thanks, NitinSubstitute the correct values for the environment for each entry. You can learn more about Enterprise Manager in the following documentation resources:In MicroStrategy Desktop 9. Loading × Sorry to interrupt Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Required Status to Perform Action. 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. Big Data. . They were used to improve subsequent query performance against the Intelligent cube. Now there are scenarios where these tables will only have partial data and a join needs to be performed between the tables. This feature is addressed in MicroStrategy 2020 Update 2 and MicroStrategy 2021. If the cube and subset report have similar objects, a best practice is to use the cube as the dataset instead of subset report. Timezones can be discovered by running the following command: python3 -c "import pytz; print (pytz. The path for cache files must be shared as "ClusterCaches". Hover the schedule need to be modified, and. 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. 1, Intelligent Cubes have a new feature to update information without republishing it. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. Open the cube for editing. Add Month and Profit to a grid visualization of the dossier. An Architect creates, publishes, and optimizes a federated data layer as the enterprise’s single version of the truth. MicroStrategy Cube Trigger (MSCT) allows the process which updates the data warehouse, i. CAUSE: CPU information shows this is not an apple-to-apple comparison. 4. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. If you manually enable this setting. The Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. it should be large enough to process it quickly. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. out. Since the Quick Search indices make use of the Change Journaling data, they can easily update their existing indexes based on this data instead of having to do a full table scan. Sure, currently just exploring the mstrio. Connect to your database using SQL Server Management Studio and in the left pane select your Metadata database. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. 7. Dossiers automatically adjust to look great on any screen. Please refer to Improving Report and Cube Performance to learn more about it. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 8. Last updated: Apr 12, 2019 Related versions: 0 Log in to vote Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. SAP Data Warehouse Optimizations. Right-click the project and select Project Configuration. 4. Users in order to see them have to go to the object and un-hide it. You can try to clear the page cache to see if performance improves. I Want to Know how the MicroStrategy improve cube performance? I Want to Know how the MicroStrategy improve cube performance? Open Menu. The renewed lease reflects MicroStrategy’s dedication to supporting the local economy and hiring more STEM talent from the community and the region’s universities. In addition to the above, you can follow the Data Import steps via Web using Amazon Redshift and save your result set in-memory. ProjectName: This field represents the name of the project for which the analysis is being performed. The "User login" prompt in security filters applied to MDX Cubes. out. 4. Can benefit from spark new features and ecology. KB442293 : In-Memory query optimization to improve performance by. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. The following line chart. Steps to Modify the View Date Range. Using Confluent. 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. Restart the Intelligent Server. Connectivity. HyperAndroid Go to the Account tab. 9% of resumes. Bulk Insert. Based on performance concerns, the Intelligence Server will also save other remote cluster node's cube lookup indexes in-memory. 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. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. 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. Instead, Command Manager can be used to display the cube status. 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. 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. They are created, populated, and dropped by MicroStrategy. The metric calculates at the level of the target, if possible. Open Windows Services, right-click MicroStrategy Platform Analytics Consumer and select Stop. The Intelligent Cube Options dialog box opens. Object Migration is the process of migrating or moving objects from one environment to another environment. 0.