Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 0. Starting in MicroStrategy ONE Update 10 you can improve the performance of project loading and schema updates. The Intelligent Cube Options dialog box opens. Expand Intelligent Cubes, and then select General. There is a substantial increase in complex query performance; 4. 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. Select the Data Partition category. 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 configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. However, users. Specific jobs will run (in parallel) on Hadoop and then be transfered back to the intelligence server (in parrallel) via TCP. Stored calculations for compound metrics. To access this VLDB,. instead of storing all data in-memory as a normal Intelligent Cube. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. To improve the cube publish performance for Oracle, we tried using different ArraySize values and found a more suitable range against the use case. View reports vs Cubes as datasets It gives you exclusive access to MicroStrategy experts on-demand or on-schedule, as well as access to all 56 courses in the MicroStrategy Education Catalog. 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. Disk Once the cube is published, the Intelligence Server where the cube was published will back up the cube files on a disk. 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. x and newer. "Obtaining the Installation Packages. e. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. Data loads and refreshes are too long, data freshness can. 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. 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. Data Language: The language used for the Intelligent Cube. In addition to this, you need a plan for tuning the system. This enhancement only applies to Windows, Linux and Mac OS. See how to take advantage of the latest Dossier features for improving data analytics speed and BI scale. io Control Center. This count is not shared across nodes of the cluster. Add Month and Profit to a grid visualization of the dossier. There is general performance degradation introduced by Sub-query. 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. VLDB properties can also be used in order to optimize report. 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. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. 2. 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. If the cube and subset report have similar objects, a best practice is to use the cube as the dataset instead of subset report. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an 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. Download the attached PDF for an in-depth understanding of Object Migration best practices. Click on 'Catalog Options' to open the Warehouse Catalog Options. Set Join behavior for all attributes with the option Outer. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. The main reasons an Intelligent Cube size would increase after publishing is for the following reasons: Cube Index generation. You can learn more about Enterprise Manager in the following documentation resources:In MicroStrategy Desktop 9. Connectivity. x. 3. The third most common microstrategy developer skill is templates on 5. x-11. Dec 2017 - Present 6 years. x This technical note provides a detailed explanation on how. Use the cube as the dataset for the dashboard and then use view filters however you want on the various. From the Data menu, select Grid Data Options. The path for cube files must be shared as "ClusterCube". This provides improved performance when querying in-memory cubes. 3. The. Another common situation with Parameterized Query will be combining multiple inserts of data into the database as a single query. Kernel -> Processing Unit Trace – trace tasks execution of a Processing Unit. Details on MicroStrategy recommendations can be found in this TN. Right-mouse click this object, and click on Search for Components. 9% of resumes. In kylin4, sparder exists as a long-running spark application. It does not tell us anything helpful and we should not use it as a point of reference. This will influence the user experience. 9 or an older version. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. You can further improve query performance by reducing the amount of data scanned. Please refer to Improving Report and Cube Performance to learn more about it. ). 0". Logs name for PU, Command ID, and execution Status. Under the Catalog>Read mode menu change the Catalog. Further in order to enhance the performance and quality of the reports produced we can follow the fundamental paths. 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. 2. Once the object is used in the card, right-click the object. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. x. MicroStrategy consistently pushes updates to the Chrome Web Store when any issues are resolved. Step 1. The Performance Analysis folder has several reports and two folders, each with its own related area of analysis: •. Before MicroStrategy 10. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. yaml file and update the viewCutoffRangeInDays field to the. 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. Complete the "sessionState" field (e. To do so, you can take advantage of URL API. getCount. Optimize the performance of derived objects: Skip the evaluation of unused derived attributes and derived elements in a document or dossier to improve performance during execution. A major advantage of MicroStrategy 10. The path for cache files must be shared as "ClusterCaches". The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Under Refresh type, select one of the following options. Hadoop Gateway transfers data in parallel without the need for ODBC/JDBC driver. Architect Persona. Starting in MicroStrategy 10. Go to Kafka Connect. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Problem is: 100% in-memory solutions cannot fit all your requirements. ProjectName: This field represents the name of the project for which the analysis is being performed. This name change is visible in. Step 2. Data can be analyzed as a report, document, or dossier. Performance with mixed selections may vary significantly due to the selections of different elements in Warehouse, such as the performance difference between Case 5 and Case 6, Case 7, and Case 8. The Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. Historically, business intelligence (BI) teams focused on building dashboards to run on computer systems. MicroStrategy's support for parameterized queries can improve performance in scenarios that require the insertion of information into a database. Answer: Go with dossier. 2 Secure Enterprise Platform, a new VLDB setting "MCE Join To Get Data Combination" has been introduced, that can help improve the document performance. The API is only used to publish a cube. PublishCube". The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. The MicroStrategy Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. From the performance side it is possible to do a SQL comparison between the two executions, however this was chosen against as the performance impact would be too great for the average user. This helps enhance query performance and improve the ability to perform multidimensional analytics on the cloud. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. x). 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. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. An Intelligent Cube is an In-Memory data structure which holds. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. This change improves the performance for memory intensive use scenario also potentially increases the memory footprint for Intelligence Server. The grouping options for levels include: Standard groups by the attribute level of the target. 6. IUsers of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. However, with the rise of mobility, the advent of the mobile workforce, and an increase in the number of employees who prefer using mobile devices for work-related functions, companies can no longer ignore the importance of building mobile. x - 10. 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. 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 scheduler that manages the data lake updates, the ability to initiate an on-demand cube refresh immediately after the data lake update is complete. 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. All prerequisites for using security filters with MDX Cubes should be completed before. After you have created your Intelligent Cube, you can publish. VLDB properties allow you to customize the SQL that MicroStrategy generates. Answer: Go with dossier. 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. Defining the partition for Super Cubes. With caching, users can retrieve results from Intelligence Server rather than re-executing queries against a database. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. After the fix, if user examine the Query Detail, CSI should show reused temporary cube. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). Every new MTDI cubes appears as hidden object in Microstaretgy 10. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. Rather than returning data from the data warehouse for a single. Expand Intelligent Cubes, and then select General. This section focuses on the VLDB properties that are set at the metric and report level. API Management and Testing. Performance analysis. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. 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. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. Slice and dice features are awesome. However, after publishing,. Impact: Performance, security. Use the table below as a guide to determine whether switching to a single Intelligent Cube as dataset can improve the performance in your environment: 3. A cache is a result set that is stored on a system to improve response time in future requests. value can be set to any zone that is recognized by pytz. To enable a new performance logging configuration, users should run the command 'echo "p" >. 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. To check if these cubes can potentially be reduced in size an audit can be performed on the cube objects to see which cube objects are not being used by any of the view reports, documents, or dossiers. The cube is based on a MDX datasource, specifically SAP BW. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. The M8MulPrc/M8MulPrc_32 process is a database connection process spawned from the MicroStrategy Intelligence Server 9. Using Confluent. 2. Partitions help in performance improvement of subset report executions; as a trade-off, some extra information is written in the cube, resulting in an increase in the cube size. Full control. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. getProjectName () + " number of cubes:"+cubesPerProject. In MicroStrategy 10. Now offering. 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. 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. 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. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. Because Direct Data. This setting is used to combine multiple subqueries into a single subquery using set operators (e. Use Case 4. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Expand the Object Templates category, select General, and from the Show templates for the. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. In other words, you should partition. 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. Retail is leveling up with omnichannel analytics. The below test is based on a 4M rows dataset which shows the throughput improvement with ODBC call 3. Connectivity. NOTE: For additional information on how to configure a clustered Cache and Inbox sharing, refer to the MicroStrategy technical note: KB441125: How to configure Cache, Cube, Inbox, and Session Recovery file sharing for a MicroStrategy Intelligence Server clusterMicrostrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. 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. Datamart optimization can be used to improve performance in this situation if the database for the datamart. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. This causes the cube cache file. The first step in analyzing. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. Run both reports after enabling the metric levels log. 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. 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-store and online. If the user account for the data warehouse has permissions to create tables, switch to the option Normalize Intelligent Cube data in the database . To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. 3% of resumes. This attribute should have a lookup table in the SQL data warehouse. Published: Jun 7, 2017 Last updated: Jun 7, 2017 In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Number of Views 524. The result of this setting is reflected in the GROUP BY clause of the SQL command. 11 Derived Attributes for “Connect Live” cubes were always evaluated in memory. This is done by using an additional database instance to handle the separate location for the datamarts. You can further improve query performance by reducing the amount of data scanned. MicroStrategy Parameterized Query feature for better performance. while (cubesEnum. To improve the report execution performance and response time, it's good to run the report with significant wait time and high usage against intelligent cubes. When you enable these traces, be sure to enlarge the size of trace file to >20MB. The fix works when the. nextElement (); System. x that handles the execution of queries and management of the database connections. Select one of the following: Drill anywhere: (the default) All drill paths in the drill map for the dataset report are shown. “With a nearly 30-year. In-store and online. Publish a cube. 1669 views. DESCRIPTION: Starting MicroStrategy 10. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. At the time of the editing, the execution of that SQL may be too slow due to performance problems or because it retrieves too much data, or may actually time out. Click All Objects View. The Data Partition options are displayed. For example, you can choose to add or delete data from the Intelligent Cube. You can also configure these settings using Command Manager scripts located at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_Outlines. x ODBC calls have approximately 30% performance improvement than using 2. 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. In addition, some other important tuning recommendations are mentioned: OS Level Optimization. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. Prerequisites • KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. For the steps to define an incremental refresh report, refer to:Normally, when memory depletion or delayed system performance occurs, page cache can be a checkpoint. Answer: Go with dossier. Locate and execute the MicroStrategy Enterprise Manager report to provide additional performance benefit information on each Intelligent Cube recommended by Cube Advisor. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. 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. Business Intelligence. 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. Optimize the performance of derived objects: Skip the evaluation of unused derived attributes and derived elements in a document or dossier to improve performance during execution. Select the release from the left hand side (Platform or Feature) and choose the version from the drop down in the middle and your release from the collapsible sections below. All prerequisites for using security filters with MDX Cubes should be completed before. Hit Count - This count tracks how many times the in-memory version of the Intelligent Cube cache is hit. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. In some business scenarios, it is required to filter data for current month in cube report with view filter in MicroStrategy 9. CAUSE: CPU information shows this is not an apple-to-apple comparison. All Intelligent Cube operations are listed below: 1. view reports. x SQL engine: "Parallel Query Execution" work. The basics of this feature are covered in KB235131. In MicroStrategy Developer, search for the created dashboard. 0 and have upgraded to the most recent version of MicroStrategy, it is recommended that you use a different Intelligent Cube normalization technique. To update the newly created Super Cube, create a new script starting from repeating steps 3-7. Whether it's a marketing campaign, infrastructure upgrade, or. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. How Does MicroStrategy Improve Cube Performance? Please login or register to vote! Post MicroStrategy K Kate George Posted on 22nd August 2023 | 59 views 0 votes. Every customer can take advantage of the lookup caching cube to improve report and cube performance by up to 30% against the data warehouse. Use Aggregate tables 2. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. Full in-memory load can even be a hinder to full deployment. You can edit project-level cache and Intelligent Cube settings. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 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. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. Watch this video to learn more about the Expert. MicroStrategy's support for parameterized queries can improve performance in scenarios that require the insertion of information into a database. In addition to this, you need a plan for tuning the system. 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. Report runtime performance for reports accessing Intelligent Cubes is optimized because the Intelligent Cube for the report has already been loaded. MicroStrategy is constantly iterating, importing, and creating new features to ensure our customers are having the best experience. An Intelligent Cube publication takes significantly long to complete publication (several hours). x SQL engine: "Parallel Query Execution" work. Example Performance Data. •. 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. Derived element with calculation type degrades execution performance in a cube report with large data and many derived metrics in MicroStrategy OLAP Services 9. 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. MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. out. In versions prior to MicroStrategy Intelligence Server 9. The MicroStrategy Performance Analysis service delivers: Performance optimization roadmap: A customized. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 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. Users may find additional information related to managing and using Intelligent Cubes in. When you enable these traces, be sure to enlarge the size of trace file to >20MB. Logs name for PU, Command ID, and execution Status. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. MicroStrategy Parameterized Query feature for better performance. Distributed query engine，avoid single-point-of-failure; 2. 4. Starting 10. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. Regular OLAP Intelligent Cubes allowed the storage of certain subsets of data to remain in memory for faster access and improved performance. 19. 2 release, the driver file is called odbc8. 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. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. get the SQL and execute directly in DB. Login to MicroStrategy Web, create a cube with the function of Data Import. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). , UNION, INTERSECT, EXCEPT). You could do this by partitioning and compressing data and by using a columnar format for storage. 4 to MicroStrategy 2019 Update 2. 2. Performance Analysis. In MicroStrategy 9. Steps to reproduce Log in to an environment in MicroStrategy Workstation using. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. hasMoreElements ()) { //Get the intelligent cubes for one project Caches cubesPerProject = cubesEnum. If you upgrade a pre-9. 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. C. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. Navigate to the Intelligent Cube for which you want to define the incremental refresh. This article reviews the following approaches you can take to improve MicroStrategy performance on SAP HANA. 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. 0 MicroStrategy introduced the 'Platform Analytics' application, which helps monitor and track object usage across the MicroStrategy platform in real time. 4. Right-click the Intelligent Cube, and select Edit. Level. Now there are scenarios where these tables will only have partial data and a join needs to be performed between the tables. 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. 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. The application is named MicroStrategy Cube. Note: number of columns should be the same as in the original file. Click Modify to open the Properties dialog box: Security tab. The default is 1000 Intelligent Cubes. The "User login" prompt in security filters applied to MDX Cubes. 4. Helps optimize custom group banding when using the Count Banding method. 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. For example, you can build yearly partitions and then process just those two years so that way it's only accessing that data. MicroStrategy supports reporting and analysis with SAP BW, Microsoft Analysis Services, Hyperion Essbase, and IBM Cognos TM1. Open Windows Services, right-click MicroStrategy Platform Analytics Consumer and select Stop. Intelligence Server supports the following types of caches:Disabling TPT is required because enabling "Fetch data slices in parallel from the warehouse" will instruct the MicroStrategy Query Engine to prepare the SQL statements in a way that they can be parallely executed against the Warehouse. This Technical Note describes how the project level governing limit “Maximum RAM usage (MBytes)" for Intelligent Cubes is implemented in a clustered environment. Under CUBE TEMPLATE, choose Default Attribute Form Caching. Select the environment and project where you want to. For example, the objects developed in a development environment can be copied to a UAT environment to test and validate the. For the Time hierarchy, the offset can. All necessary privileges are included in the Administrator role by default.