For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. Review steps below to improve bulk data load from Redshift to MicroStrategy. The ID of the Job would be useful in order to read the job trace. Select one of the following: Drill anywhere: (the default) All drill paths in the drill map for the dataset report are shown. Run both reports after enabling the metric levels log. In the search, when All objects option is ticked, the cube does not appear. To define an incremental refresh report. x). 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. By default, the location configured will be a relative path where ". Apply the year prompt to to view filter of the intelligent cube report and the report filter regular report. 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. 3% of resumes. Under CUBE TEMPLATE, choose Default Attribute Form Caching. Starting in MicroStrategy 10 Data Import in Web supported a new scenario where multiple tables could be imported as part of a single Data Import Cube. Connect to your database using SQL Server Management Studio and in the left pane select your Metadata database. Note that only the naming convention has changed, as the functionality remains the same. The telemetry generated from these actions was processed by the Telemetry Store and loaded into the Platform Analytics warehouse. With Kyvos’ Smart OLAP™, you can modify the existing cube to add, delete or reorder the entities by eliminating the need to rebuild the cube. 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. Regression DefectThe MicroStrategy Internal Reference Number for the issue discussed in this technical note is KB442296 and DE91603. Data loads and refreshes are too long, data freshness can. In addition to this, you need a plan for tuning the system. MicroStrategy’s latest software release, MicroStrategy 9 Release 2, offers significant performance improvements that make business intelligence faster for BI users. With Redshift Spectrum, you take advantage of a fast, cost-effective engine that minimizes data processed with dynamic partition pruning. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. Use Cube Advisor to create Intelligent Cubes: 1. Maintain your competitive edge with a data-driven retail app designed to scale—from individual. Create a report with the year and quarter attributes and the profit metric. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. They were used to improve subsequent query performance against the Intelligent cube. If the cube and subset report have similar objects, a best practice is to use the cube as the dataset instead of subset report. After the fix, if user examine the Query Detail, CSI should show reused temporary cube. . 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. 9 or an older version. 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. Cube Advisor opens. During installation you have the following options:Governing Intelligent Cube Memory Usage, Loading, and Storage. For a single cube publish, using 3. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. NAME: is the name of the intelligent cube, returned as a string. 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. Logs name for PU, Command ID, and execution Status. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. MicroStrategy Optimization: VLDB Settings. Starting with MicroStrategy 10. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. 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. HyperAndroid Go to the Account tab. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. When a remote accesses this cube, the cube is loaded into memory of the. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. x). Cube advisor. The ID of the Job would be useful in order to read the job trace. With an increasing number of. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. Therefore we need 20GB RAM memory to store the cube. With caching, users can retrieve results from Intelligence Server rather than re-executing queries against a database. To plan for these memory requirements, see the System Administration Guide. 2. 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. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. This increases readability and enhances the appearance of the card. 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. 3. The first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. Using the Performance Monitor Counters to measure Intelligent Cube memory usage and publication times: When an Intelligent Cube report is run (published), the. Click Modify to open the Properties dialog box: Security tab. 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 the previous example all the extra calculations were pushed to the intelligent cube which will improve the performance for the end users. All Intelligent Cube operations are listed below: 1. Providing Intelligent Cube data. You can edit project-level cache and Intelligent Cube settings. Before you create an Intelligent Cube, search through MicroStrategy to see whether a similar Intelligent Cube already exists that can serve the same. Steps to reproduce Log in to an environment in MicroStrategy Workstation using. With the buffer size dynamic growth. For example, you can choose to add or delete data from the Intelligent Cube. In-store and online. The fix works when the. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Right click the database and under “Tasks” choose “Backup”. MicroStrategy PRIME is a new feature added to the MicroStrategy 10 Secure Enterprise Platform. In 11. To update the newly created Super Cube, create a new script starting from repeating steps 3-7. Full in-memory load can even be a hinder to full deployment. How To Reduce Intelligent Cube Size By Finding Intelligent Cube Objects Which Are Not In Use. With Parallel Hierarchy. In order to protect both security and performance the MicroStrategy system will compare all of the Security settings in. The cube is based on a MDX datasource, specifically SAP BW. while (cubesEnum. Number. To plan for these memory requirements, see the System Administration Help. 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:. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. This causes the cube cache file. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Open the Workstation window. Hadoop Gateway transfers data in parallel without the need for ODBC/JDBC driver. The default is 1000 Intelligent Cubes. In MicroStrategy Web, click "Access External Data"; In the "Connect to Your Data" window, click the "Manage Your Datasets" link in left-bottom corner, as shown below: In Data Storage window, right mouse click the cube and choose "Schedule", a sub context menu displays all the existing schedule. The in-database Advanced Analytics gives you the insights you need to improve everything from database performance to your company’s inventory management. 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. x) or OLAP (first generation of in memory cubes, introduced in 9. Expand Intelligent Cubes, and then select General. PATH: is the folder where the intelligent cube resides, returned as a string. This article explains why MicroStrategy 2021 Update 1 requires additional disk space when publishing a cube to improve cube loading times. 2. getProjectName () + " number of cubes:"+cubesPerProject. x) or OLAP (first generation of in memory cubes, introduced in 9. This helps enhance query performance and improve the ability to perform multidimensional analytics on the cloud. 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. Login to MicroStrategy Web, create a cube with the function of Data Import. This is helpful if the Intelligent Cube is used in an internationalized environment that supports multiple languages. Members," which identifies the current level within the hierarchy and evaluates the rank over all the. println ("For project: " + cubesPerProject. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. In addition, some other important tuning recommendations are mentioned: OS Level Optimization. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. A cache is a result set that is stored on a system to improve response time in future requests. x that handles the execution of queries and management of the database connections. With Parallel Hierarchy. (Intelligent Cube configuration is not relevant in MicroStrategy 8. Answer: Go with dossier. We did internal. Change Journaling is enabled by default since MicroStrategy version 10. Strong semantic layer to define all the business rules and tightly coupled. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Cube index generation will increase cube size. Can benefit from spark new features and ecology. We did internal. SAP Data Warehouse Optimizations. This privilege is part of OLAP Services. The API is only used to publish a cube. If the cube and subset report have similar objects, a best practice is to use the cube as the dataset instead of subset report. Option 1: Develop each report in Microstrategy developer using attribute filters as desired. In MicroStrategy Developer, search for the created dashboard. 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. 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. Distributed query engine，avoid single-point-of-failure; 2. Remove all the selected cubes by right clicking on them and selecting the Remove option as shown in the image below: If there are no reports that. In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services. Then go to the key “Query. The MicroStrategy Performance Analysis service delivers:. MicroStrategy implements a list of strategies to generate intermediate tables the choice of which can have a significant impact on query performance. The M8MulPrc/M8MulPrc_32 process is a database connection process spawned from the MicroStrategy Intelligence Server 9. This count is not shared across nodes of the cluster. To get a sneak-peak of new functionalities. Loading × Sorry to interruptIncremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. For background. It accesses and joins data. 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 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. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Hit Count - This count tracks how many times the in-memory version of the Intelligent Cube cache is hit. MicroStrategy Optimization: HINTS. Right-click the Intelligent Cube, and select Edit. In Developer, from the File menu select New, and then Intelligent Cube. 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. 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. nextElement (); System. Impact: Performance, security. Click OK. Choose your preferred method to share the logs. The attached document details the differences between these two types of cubes, and these distinctions are the basis for the performance profile and available functionality for these two types of in-memory cubes, along with best practices for both publishing, modeling and querying these cubes. Tips and Tricks to Partition In-Memory Cubes for Faster Performance. Web Open the Settings page (right click the extension and select Options). 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. 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. For troubleshooting and diagnostics logging routines related to MDX cube sources, see the Troubleshooting section of the System Administration Help. Load an updated CSV file into a DataFrame providing full path. x from any unexpected conditions. Refer to Product Manual for more detailed information. g. Collect statistics on the tables 5. x environments. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. All prerequisites for using security filters with MDX Cubes should be completed before. Historically, business intelligence (BI) teams focused on building dashboards to run on computer systems. This article explains why MicroStrategy 2021 Update 1 requires additional disk space when publishing a cube to improve cube loading times. All necessary privileges are included in the Administrator role by default. This feature is addressed in MicroStrategy 2020 Update 2 and MicroStrategy 2021. 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. Can benefit from spark new features and ecology. Cloud Computing. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. The MicroStrategy Intelligence Server 9. 8. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. Whether it's a marketing campaign, infrastructure upgrade, or. 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. This functionality is run in a separate process to isolate MicroStrategy Intelligence Server 9. The below test is based on a 4M rows dataset which shows the throughput improvement with ODBC call 3. Watch this video to learn more about the Expert. 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. Answer: Go with dossier. 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. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. To improve performance between Google BigQuery and MicroStrategy, MicroStrategy changed the way in which SQL is generated by MicroStrategy to first filter the Time Transformation table, followed by joins to the Fact and other lookup tables. This Technical Note describes how the project level governing limit “Maximum RAM usage (MBytes)" for Intelligent Cubes is implemented in a clustered environment. To use this functionality in. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. However, after publishing,. Right mouse click on the cube and choose Schedule. Set Freeform SQL and MDX objects default security. Derived element with calculation type degrades execution performance in a cube report with large data and many derived metrics in MicroStrategy OLAP Services 9. In addition to the above, you can follow the Data Import steps via Web using Amazon Redshift and save your result set in-memory. It allows companies to evaluate the effectiveness and efficiency of their investments and make informed decisions based on concrete data. There is general performance degradation introduced by Sub-query. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Increasing this setting can increase caching efficiency in cases. 4. Set Data Retrieval Mode to the setting Allow Native API at the. They are temporary in nature and hold intermediate results. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. CAUSE: CPU information shows this is not an apple-to-apple comparison. Sure, currently just exploring the mstrio. If you manually enable this setting. Unified calculation engine for building and querying; 3. 4. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. 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. To improve the cube publish performance for Oracle, we tried using different ArraySize values and found a more suitable range against the use case. 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. 2. 10 where different behavior is seen in between a Live connect and In-Memory cube when filtering on warehouse null values in Dossier. Disk Once the cube is published, the Intelligence Server where the cube was published will back up the cube files on a disk. 2. Required Status to Perform Action. Instead, Command Manager can be used to display the cube status. 0 MicroStrategy project that includes MDX cubes, see the Upgrade Help for information on updating MDX objects to enhance the performance of using these objects in MicroStrategy. 0. getProjectName () + " number of cubes:"+cubesPerProject. 3. If you upgrade a pre-9. Users can also seamlessly drill down from data in an in-memory cube, to detail data in RDBMS and further detail in Amazon Redshift. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. Please refer to Improving Report and Cube Performance to learn more about it. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Add Month and Profit to a grid visualization of the dossier. Run both reports after enabling the metric levels log. Course Categories. In versions prior to MicroStrategy Intelligence Server 9. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. For more details on Intelligent Cube size increase, refer to the following technical note:. Business users move seamlessly between all five styles of BI and even combine multiple styles. • Do not add a fake. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 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. The MicroStrategy Intelligence Server 9. 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. Login to using your MicroStrategy Resource Center account. jar file to i-server machine. Create a second report with the year and quarter attributes and the revenue metric. However, subset. 4. 3. hasMoreElements ()) { //Get the intelligent cubes for one project Caches cubesPerProject = cubesEnum. x This technical note provides a detailed explanation on how. Under the VLDB settings for that cube, make sure that to increase the. 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. Telcos need network capacity planning and optimization by correlating network usage, subscriber density, along with traffic and location data. See Memory Mapped Files for Intelligent Cubes for more information. An Intelligent Cube is an In-Memory data structure which holds. 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. Users in order to see them have to go to the object and un-hide it. In kylin4, sparder exists as a long-running spark application. Cause: The root cause of the issue is cube template "Blank Emma Cube Report" that is set to hidden. sh to produce 1000 test messages as follows: Sorted by: 3. 3. While OLAP cubes were limited to 2 billion rows, PRIME OLAP cubes can be divided into. jar. Stay up to date on inventory needs and avoid. 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). A code fix is provided. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. It does not tell us anything helpful and we should not use it as a point of reference. Download the attached PDF for an in-depth understanding of Object Migration best practices. From the Data menu, select Grid Data Options. 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. Iterate through the enumeration to get the cubes per project and the corresponding status. Cube Advisor opens. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Ability to add and edit descriptions in derived attributes, derived metrics, derived attributes, and metrics from a Data Import cube. Cube with Date Dim and Currency (as mandatory) 3. A major advantage of MicroStrategy 10. Complete the "sessionState" field (e. This can improve the performance of. When running an integrity test, users might want to get the execution time of the report or document. This knowledge base article describes a behavior in MicroStrategy 10. x from any unexpected conditions. For example, you can choose to add or delete data from the Intelligent Cube. 2. instead of storing all data in-memory as a normal Intelligent Cube. The performance improvement varies based on the CPU cores, memory, file size and the Operation. 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. Create an Attribute Form Caching Cube. 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. For the Time hierarchy, the offset can. 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. 4, the Data Import functionality utilizes multiple threads to improve the cube publishing time, when performing a data import against CSV/Text files. Intelligent Cubes improve performance and user experience by pre-aggregating and pre-calculating the data. ) ,. This article describes a behavior within MicroStrategy Workstation, whereby the environment gets disconnected as soon as one tries to create a new Intelligent cube. Open the Workstation window. Full control. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Now offering. 3. Subset report or view report caching can improve dossier performance in almost 70% of all cases. Hover the schedule need to be modified, and. Both types of cubes leverage the new partitioning functionality that allows loading. 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. Easily add or change pre- and post- SQL statements. Use partition mapping 3. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Step 1: Optimizing HyperIntelligence Datasets. x. MicroStrategy Parameterized Query feature for better performance. Use Index on all Key columns ( for conditions from WHERE clause,. Starting with MicroStrategy 10. The MicroStrategy Performance Analysis service delivers: Performance optimization roadmap: A customized. Required Status to Perform Action. 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. Select SINKS and click the + New Sink button. The main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loadedCreating Intelligent Cubes in this way can improve the performance of your Intelligent Cubes and make it easier to create reports that can access and use the available Intelligent Cubes. In Asian languages, the minimum length is one character. There are two main settings involved in cube partitioning configurations: Partition Attribute: The attribute you select to partition should be the one with the most cardinality in the cube. Edit Intelligent Cubes from the new editor in Workstation at any time. 11, a new feature is available for performance optimization when dealing with derived attributes. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. 1. The Intelligent Cube Options dialog box opens. KB221859: PRIME partitioning guidelines for MicroStrategy 10 . Metro Area. If the configuration settings are correct the following will happen: KMCW connects to MicroStrategy and crates a new cube. Prerequisites •From MicroStrategy 11. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. MicroStrategy supports reporting and analysis with SAP BW, Microsoft Analysis Services, Hyperion Essbase, and IBM Cognos TM1. 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. 3. …Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. All prerequisites for using security filters with MDX Cubes should be completed before. 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. Further in order to enhance the performance and quality of the reports produced we can follow the. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Answer: Go with dossier. There are two types of counters to track hit counts in Intelligent Cubes: 1. KB442293 : In-Memory query optimization to improve performance by. Locate and execute the MicroStrategy Enterprise Manager report to provide additional performance benefit information on each Intelligent Cube recommended by Cube Advisor. The Intelligent Cube Editor opens. Open Confluent Control Center. If it is not possible to improve data consistency in the database, the Intelligent Cube report may be configured to normalize data in the Intelligence Server. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. 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. 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. Under the Catalog>Read mode menu change the Catalog. Beginning in MicroStrategy 11. the workflow manager or enterprise scheduling tool, to trigger the. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. The Incremental Refresh Options dialog box opens. x. You must belong to the System Administrators group to use this feature. There are options for Replace existing data, update existing data or add. 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. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This article discusses Data Engine changes that may impact customers data when upgrading to MicroStrategy 2019. The path for cube files must be shared as "ClusterCube". As the Architect of the company, you are responsible for creating a dataset optimized for HyperIntelligence. Or, navigate to the Data Explorer for the MDX Cube database instance. sh . Cube 7: Improve cube response time.