The ID of the Job would be useful in order to read the job trace. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. 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. Cube Advisor opens. The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Distributed query engine，avoid single-point-of-failure; 2. Users may find additional information related to managing and using Intelligent Cubes in. Always consider to collect database statistics as the query execution plan is generated based on that. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. Dossiers automatically adjust to look great on any screen. Use Aggregate tables 2. 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. When a remote accesses this cube, the cube is loaded into memory of the. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 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. All prerequisites for using security filters with MDX Cubes should be completed before. In MicroStrategy 10. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. After the fix, if user examine the Query Detail, CSI should show reused temporary cube. ). Optimize Aggregation : Generates optimized views based on collected. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. In-store and online. 0 and have upgraded to the most recent version of MicroStrategy, it is recommended that you use a different Intelligent Cube normalization technique. The default is 1000 Intelligent Cubes. 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. Expand Intelligent Cubes, and then select General. The following line chart. In the Platform Analytics directory, located at C:Program Files (x86)MicroStrategyPlatform Analytics, open the conf folder. Cube Advisor checks if existing reports can use dynamic sourcing. To solve this problem, we introduce a new registry key, " Respect. An Architect creates, publishes, and optimizes a federated data layer as the enterprise’s single version of the truth. Apply the year prompt to to view filter of the intelligent cube report and the report filter regular report. Use Cube Advisor to create Intelligent Cubes: 1. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. To locate these settings, right-click the project and select Project Configuration. In-Memory capabilities provide tremendous acceleration to your Dashboards. 6. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesFollow the steps below to delete an OLAP cube database instance from MicroStrategy Developer. 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. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Generate Oracle AWR report or monitor the database to identify the low performance query. With an increasing number of. Cube Info Cache creation. Go to Schema Menu > SQL Generation Options. Before MicroStrategy 10. all_timezones)"With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. this is the memory MSTR uses for worker set. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. 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. In kylin4, sparder exists as a long-running spark application. Understand your data characters and choose the matched configuration could enhance the performance and accelerate the process to view the latest data. This will influence the user experience. 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. In Developer, log in to a project with a user account with administrative privileges. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. The "User login" prompt in security filters applied to MDX Cubes. Browse resources on demand or contact support directly. Subset report or view report caching can improve dossier performance in almost 70% of all cases. Conclusion We discussed various techniques to improve report building, system performance, and user productivity with MicroStrategy in this eBook. The MicroStrategy Intelligence Server 9. Starting 10. 1. 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. MicroStrategy has been integrated with SQL Server for over 20 years. 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. Business Intelligence. Understand your data characters and choose the matched configuration could enhance the performance and accelerate the process to view the latest data. 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. Platform Analytics repository size may be observed increase rapidly with advanced statistics enabled. Click Modify to open the Properties dialog box: Security tab. Stored calculations for compound metrics. This section focuses on the VLDB properties that are set at the metric and report level. Cloud Computing. Prerequisites • KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. MicroStrategy supports reporting and analysis with SAP BW, Microsoft Analysis Services, Hyperion Essbase, and IBM Cognos TM1. This " How to" knowledge base article explains cube advisor. 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. 3. To Define Limits for the Intelligent Cube Indexes. get the SQL and execute directly in DB. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. MicroStrategy will monitor the data repository and/or cube memoryOnce the cube is published, these four files are loaded in-memory on the Intelligence Server. To get a sneak-peak of new functionalities. The M8MulPrc/M8MulPrc_32 process is a database connection process spawned from the MicroStrategy Intelligence Server 9. After you find the microstrategy. This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. In the Navigation pane, click , next to Datasets. Create a second report with the year and quarter attributes and the revenue metric. All Intelligent Cube operations are listed below: 1. 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. In some business scenarios, it is required to filter data for current month in cube report with view filter in MicroStrategy 9. x and newer. Under the Catalog>Read mode menu change the Catalog. Level. x. 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. You could do this by partitioning and compressing data and by using a columnar format for storage. 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. Prerequisites •From MicroStrategy 11. To use this functionality in. Collect statistics on the tables 5. 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. Best Practices with MicroStrategy. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. 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. 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. SUMMARY. x and newer. Timezones can be discovered by running the following command: python3 -c "import pytz; print (pytz. Users may find additional information related to managing and using Intelligent Cubes in. When running an integrity test, users might want to get the execution time of the report or document. x that handles the execution of queries and management of the database connections. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. 9 and 10. Option 2: Have all your 46 million records pulled into a cube. Intelligent Cubes improve performance and user experience by pre-aggregating and pre-calculating the data. ) 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. In order to protect both security and performance the MicroStrategy system will compare all of the Security settings in. (Intelligent Cube configuration is not relevant in MicroStrategy 8. The API is only used to publish a cube. GUID: is the GUID of the intelligent cube, returned as a string. ProjectName: This field represents the name of the project for which the analysis is being performed. out. view reports. Easily add or change pre- and post- SQL statements. For example, you can choose to add or delete data from the Intelligent Cube. Step 2. Loading × Sorry to interrupt Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Select one of the following: Drill anywhere: (the default) All drill paths in the drill map for the dataset report are shown. The Data Partition options are displayed. Can benefit from spark new features and ecology. MicroStrategy Parameterized Query feature for better performance. Choose Data > Configure Intelligent Cube. 9% of resumes. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Under the VLDB settings for that cube, make sure that to increase the. 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. MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. 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. An Intelligent Cube is an In-Memory data structure which holds. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. 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. The Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. 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. The cube is based on a MDX datasource, specifically SAP BW. 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 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. There is general performance degradation introduced by Sub-query. Click View Logs, to display the share icon in the upper-left. Dynamic source hit. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 8 to help improve the performance of Quick Search on MicroStrategy Web. 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. Performance analysis. Best Practices with MicroStrategy. 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. Optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. Starting in MicroStrategy 10. 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. How to increase the Java Heap size. Option 1: Develop each report in Microstrategy developer using attribute filters as desired. This article discusses Data Engine changes that may impact customers data when upgrading to MicroStrategy 2019. Oversee all IT SaaS strategy, create and execute digital transformation roadmap, and identify ways to. 2. Create an Attribute Form Caching Cube. view reports. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. Solutions Resources Company Bitcoin Lightning Home Published: August 11, 2022 • 619 Views Advanced Properties for Intelligent Cubes MicroStrategy Workstation. To achieve this, cube processing in the MicroStrategy. 0, dynamic growth algorithm for buffer size is introduced to improve the performance of buffer, and it is enabled by default. This is helpful if the Intelligent Cube is used in an internationalized environment that supports multiple languages. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the. When you enable these traces, be sure to enlarge the size of trace file to >20MB. 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. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). This privilege is part of OLAP Services. The first step in analyzing. 11 Derived Attributes for “Connect Live” cubes were always evaluated in memory. " Cube B's refresh policy is set to "update existing data. Big Data. x SQL engine: "Parallel Query Execution" work. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Video Tutorials. 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. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more cardinality means the attribute with more different elements, for example in the Tutorial project the. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. Edit Project-Level Cache and Intelligent Cube Settings. Whenever you use a view report instead of the intelligent cube, the MicroStrategy Analytical Engine (MicroStrategy AE) spends more time searching and fetching the report definition and then applies. "Obtaining the Installation Packages. MicroStrategy PRIME goes far beyond by adding a complete extra layer between the data store and the data analytics layers, allowing to process orders of much higher magnitude and. Ability to add and edit descriptions in derived attributes, derived metrics, derived attributes, and metrics from a Data Import cube. Problem is: 100% in-memory solutions cannot fit all your requirements. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. Create a new File Log and name it “CSI” (or any other name). 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. In MicroStrategy, users can create and manage datamart tables in a different schema, database, or server from the data warehouse. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. A major advantage of MicroStrategy 10. Update Cube Data *. Historically, business intelligence (BI) teams focused on building dashboards to run on computer systems. Select data population for Intelligent Cubes. You could do this by partitioning and compressing data and by using a columnar format for storage. This article discusses Data Engine changes that may impact performance and stability when upgrading to MicroStrategy 2019. Cube 7: Improve cube response time. The binary generated for this mode is different from the binary generated for PDF. Install MicroStrategy 10. Business Intelligence and Analytics. println ("For project: " + cubesPerProject. 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. Smart. There are two types of counters to track hit counts in Intelligent Cubes: 1. Starting in MicroStrategy 11. Deploy the ojdbc8. 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. 19. From the Data menu, select Grid Data Options. Locate the newly imported cube, right-click on it, and choose "Edit. g. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . We did internal. One way to free memory on Intelligence Server, which can improve Intelligence Server performance, is to temporarily unload an Intelligent Cube from memory. Normalize Intelligent Cube data in Intelligence Server. Create a new variable and assign SuperCube with two parameters inside – connection and id. Open the cube for editing. This feature is addressed in MicroStrategy 2020 Update 2 and MicroStrategy 2021. Hadoop Gateway transfers data in parallel without the need for ODBC/JDBC driver. 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. How To Reduce Intelligent Cube Size By Finding Intelligent Cube Objects Which Are Not In Use. 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. "Normalize Intelligent Cube/Report data in Intelligence Server" may improve performance, at the cost of additional memory use in the database connection process. Performance Analysis. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Cube advisor. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. By default, the location configured will be a relative path where ". 3. g. 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. This can improve the performance of. Purpose of the registry key. Grouping determines how the metric aggregates. while (cubesEnum. A solution for this issue is available in current releases but need turn on via registry key setting. The data get's fresher, faster, and less resources consuming for everyone. 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. Run multiple dossiers, documents, or reports based on this cube to. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 2. Example Performance Data. In Asian languages, the minimum length is one character. 9 or an older version. 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. Solution. Right click the database and under “Tasks” choose “Backup”. Community & Support Search Discussions Open A Case View My CasesImproving Response Time: Caching. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. Go to Schema and open the OLAP Cube Catalog. Specific jobs will run (in parallel) on Hadoop and then be transfered back to the intelligence server (in parrallel) via TCP. 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. Cube index generation will increase cube size. Use Cube Advisor to create Intelligent Cubes: 1. By default, the location configured will be a relative path where ". MicroStrategy consistently pushes updates to the Chrome Web Store when any issues are resolved. •. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. value can be set to any zone that is recognized by pytz. If the data requirements for the report change, or cannot be satisfied by an available Intelligent Cube, the reports automatically access the data. 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. Optimize Build and Query. For Oracle 12. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. 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. Retail is leveling up with omnichannel analytics. To enable a new performance logging configuration, users should run the command 'echo "p" >. Now offering. To solve this problem, we introduce a new registry key, " Respect. Defines whether to attempt to improve performance of reports that use expression-based transformations. Instead, Command Manager can be used to display the cube status. Unified calculation engine for building and querying; 3. This Knowledge Base article describes the steps to filter data for the current month in a cube report. instead of storing all data in-memory as a normal Intelligent Cube. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. A code fix is provided. Defining the partition for Super Cubes. Note: number of columns should be the same as in the original file. Steps to Modify the View Date Range. HyperAndroid Go to the Account tab. Hover the schedule need to be modified, and. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. You can further improve query performance by reducing the amount of data scanned. Enterprise Manager provides detailed level tuning data for individual reports, Intelligent Cubes, scheduled operations, and all other parts of the MicroStrategy platform. See how to take advantage of the latest Dossier features for improving data analytics speed and BI scale. Cube with Date Dim and Currency (as mandatory) 3. Select the data set and click Prepare Data. 2. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. out. Example Performance Data. QUESTIONUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. Once the object is used in the card, right-click the object. The following is a full list of MicroStrategy Data Engine changes that may be seen when upgrading to MicroStrategy 2019 which affect Data. 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. MicroStrategy Optimization: HINTS. Unified calculation engine for building and querying; 3. 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. 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. Cube with Date Dim and Carteras_Desc (as mandatory)We should ignore the size of the Cube in the Cube Monitor when the Status is "A,F" (Active, Filed). The Intelligent Cube Options dialog box opens. Visit the data visualization and data dashboard galleries for inspiration. This article reviews the following approaches you can take to improve MicroStrategy performance on SAP HANA. Choose your preferred method to share the logs. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. There is a substantial increase in complex query performance; 4. All necessary privileges are included in the Administrator role by default. Step 1. Users in order to see them have to go to the object and un-hide it. 0 cubes is the ability to partition cubes. Set Freeform SQL and MDX objects default security. 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. Data can be analyzed as a report, document, or dossier. x. The below test is based on a 4M rows dataset which shows the throughput improvement with ODBC call 3. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. MicroStrategy is committed to helping to ensure Virginia remains at the forefront of innovation and a top place to do business in the United States. The solution discussed in this article is a python application that leverages the MicroStrategy API suite to provide an external scheduler, i. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. 4. Choose Rename. Set Data Retrieval Mode to the setting Allow Native API at the. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. Click Modify to open the Properties dialog box: Security tab. In the next screen, select MicroStrategySink connector class and set the connector name, that will show up in the Kafka Connect list of Sinks. For background. Business users move seamlessly between all five styles of BI and even combine multiple styles. Watch this video to learn more about the Expert. Cube Instance ID: The ID for the current published version of the Intelligent Cube. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. 4. Locate and execute the MicroStrategy Enterprise Manager report to provide additional performance benefit information on each Intelligent Cube recommended by Cube Advisor. Analyze the low performance query using DBA knowledge, add. 4 to MicroStrategy 2019 Update 2. (In MicroStrategy Intelligence Server Universal environments in UNIX/Linux, this may require the memory contract manager setting "Memory reserved for other processes" to be increased. The fix works when the. This is done by using an additional database instance to handle the separate location for the datamarts. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. The cube is based on a MDX datasource, specifically SAP BW. The second most common hard skill for a microstrategy developer is bi appearing on 5. With Parallel Hierarchy.