how to improve cube performance in microstrategy. Enterprise Manager provides detailed level tuning data for individual reports, Intelligent Cubes, scheduled operations, and all other parts of the MicroStrategy platform. how to improve cube performance in microstrategy

 
 Enterprise Manager provides detailed level tuning data for individual reports, Intelligent Cubes, scheduled operations, and all other parts of the MicroStrategy platformhow to improve cube performance in microstrategy Starting in MicroStrategy 11

Starting from MicroStrategy 10 – you’ll see tge optimized form of Intelligent Cube based reports SQL modified as below with better optimizations. 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. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools > Options. Impact: Performance, security. In addition to this, you need a plan for tuning the system. It allows companies to evaluate the effectiveness and efficiency of their investments and make informed decisions based on concrete data. 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. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Distributed query engine,avoid single-point-of-failure; 2. Refer to Product Manual for more detailed information. 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. There is a substantial increase in complex query performance; 4. The below test is based on a 4M rows dataset which shows the throughput improvement with ODBC call 3. Starting from MicroStrategy 10 – you’ll see tge optimized form of Intelligent Cube based reports SQL modified as below with better optimizations. 1, Intelligent Cubes have a new feature to update information without republishing it. Cube A's refresh policy is set to "add new data. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. Platform Analytics repository size may be observed increase rapidly with advanced statistics enabled. 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. To. 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. Logs name for PU, Command ID, and execution Status. The Back Up Database windows will open, ensure that Full is selected under Backup type. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Note: number of columns should be the same as in the original file. 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. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. In addition to the above, you can follow the Data Import steps via Web using Amazon Redshift and save your result set in-memory. Bulk Insert. Navigate to the Engine Component with CSI Dispatcher. Click Modify to open the Properties dialog box: Security tab. The basics of this feature are covered in KB235131. See Memory Mapped Files for Intelligent Cubes for more information. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. Filter the contents of a Cube / Report by passing the selected object IDs for the metrics, attributes, and attribute elements to the apply_filters() method. Open the cube for editing. Step 1. This setting is used to combine multiple subqueries into a single subquery using set operators (e. 0. MicroStrategy Optimization: HINTS. Update Cube Data *. To solve this problem, we introduce a new registry key, " Respect. API Management and Testing. Deploy the ojdbc8. To get the list of object IDs of the metrics, attributes, or attribute elements that are available within the Cube / Report MicroStrategy objects, use the following Cube / Report class. Dynamic source hit. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. out. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. 4. You can further improve query performance by reducing the amount of data scanned. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). Indexes are created in memory on the Intelligence server as part of the in-memory cube instance. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. x for PostgreSQL since MicroStrategy 2021 Update 1. To troubleshoot performance issues, users must identify these components, then make the appropriate modifications to the environment and/or to the MicroStrategy dashboard to reduce bottlenecking. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. 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. 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. Use Cube Advisor to create Intelligent Cubes: 1. 3% of resumes. Upgrade to MicroStrategy and upgrade the metadata using the same cube files generated before. In-store and online. 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. Will it affect the performance of already existing MicroStrategy components?Using MicroStrategy, manufacturers can run Big Data analytics on disparate sources to achieve perfect order rates and quality, and to get in-depth consumption patterns. The following knowledge base article explains the process to modify the diagnostics logging for MicroStrategy components from the command line in Windows and Unix environments. Determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results faster and publish Intelligent Cubes. Connect to your database using SQL Server Management Studio and in the left pane select your Metadata database. 2. 9 and 10. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. 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 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. 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. Smart. The API is only used to publish a cube. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. By default, the location configured will be a relative path where ". It is similar to concept of standard report hitting the database with intermediate table concept of fetching required amount of data and merging it finally with necessary filters to improve. 0 if there are multiple join paths between two or more One-to-Many relationship tables in a multi-table data import cube, rather than using the first available table join path, the analytical engine will look for the path with the least number of tables and the smallest table base on the following order/criteria: 1. Now offering. Expand Intelligent Cubes, and then select General. The metric calculates at the level of the target, if possible. Loading × Sorry to interrupt Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. 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. NAME: is the name of the intelligent cube, returned as a string. In web, run the non intelligent cube and select 2008 in the prompt for the year. Community & Support Search Discussions Open A Case View My CasesImproving Response Time: Caching. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. Cube Definition ID: The ID for the Intelligent Cube object. 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. For more details on Intelligent Cube size increase, refer to the following technical note:. Download the attached PDF for an in-depth understanding of Object Migration best practices. Open the Workstation window. An Intelligent Cube publication takes significantly long to complete publication (several hours). You can also configure these settings using Command Manager scripts located at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_Outlines. 3. Go to Schema and open the OLAP Cube Catalog. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. Use partition mapping 3. In MicroStrategy 9. Dec 2017 - Present 6 years. 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. In-store and online. Performance Analysis. 0 and have upgraded to the most recent version of MicroStrategy, it is recommended that you use a different Intelligent Cube normalization technique. sh . Open Confluent Control Center. The telemetry generated from these actions was processed by the Telemetry Store and loaded into the Platform Analytics warehouse. In the next screen, select MicroStrategySink connector class and set the connector name, that will show up in the Kafka Connect list of Sinks. To achieve this, cube processing in the MicroStrategy. 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. This Technical Note describes how the project level governing limit “Maximum RAM usage (MBytes)" for Intelligent Cubes is implemented in a clustered environment. CAUSE: CPU information shows this is not an apple-to-apple comparison. A major advantage of MicroStrategy 10. You can edit project-level cache and Intelligent Cube settings. Cube index generation will increase cube size. x that handles the execution of queries and management of the database connections. With partitioned enabled, the cube size is expected to be slightly larger than a non-partitioned cube. In Project Configurations, reduce the cube index growth limit setting to the minimum value of 50%. This attribute should have a lookup table in the SQL data warehouse. Every newly created MTDI cube will inherit settings from this template and automatically be created. Login to MicroStrategy Web, create a cube with the function of Data Import. Optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. Conclusion We discussed various techniques to improve report building, system performance, and user productivity with MicroStrategy in this eBook. By default, the location configured will be a relative path where ". In Asian languages, the minimum length is one character. get the SQL and execute directly in DB. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. With caching, users can retrieve results from Intelligence Server rather than re-executing queries against a database. To increase performance we can also use Intelligent as they have the loaded data and the reports created from these cubes is capable of fetching data much faster. 3. 3. 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 steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. 11 the derived attributes are now evaluated at the source when all the required columns come from the same table, which covers the. Solutions Resources Company Bitcoin Lightning Home Published: August 11, 2022 • 619 Views Advanced Properties for Intelligent Cubes MicroStrategy Workstation. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. The first step in analyzing. This presentation helps users understand MicroStrategy's in-memory architecture. Expand Intelligent Cubes, and then select General. Choose Rename. The MicroStrategy Intelligence Server 9. 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. x7. This causes the cube cache file. This presentation helps users understand MicroStrategy's in-memory architecture. in MSTR, go to project config, increase the project memory settings. Further in order to enhance the performance and quality of the reports produced we can follow the. 4. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. The MicroStrategy Performance Analysis service delivers:. When running an integrity test, users might want to get the execution time of the report or document. To plan for these memory requirements, see the System Administration Help. Connectivity. The grouping options for levels include: Standard groups by the attribute level of the target. Another common situation with Parameterized Query will be combining multiple inserts of data into the database as a single query. Select the data set and click Prepare Data. 19. This section focuses on the VLDB properties that are set at the metric and report level. The user has view access to cube A and B. Number. Will let you know more about it once I started using it. 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 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. All necessary privileges are included in the Administrator role by default. If the relations are modified in the cube editor, the cube has to be re-published to be used again. This can be achieved via the report level VLDB property > SQL Time. 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. Defines whether to attempt to improve performance of reports that use expression-based transformations. •. Edit Project-Level Cache and Intelligent Cube Settings. To get a sneak-peak of new functionalities. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an. To do so, you can take advantage of URL API. Example Performance Data. All Intelligent Cube operations are listed below: 1. Note that only the naming convention has changed, as the functionality remains the same. x. In MicroStrategy 10. Intelligence Server Statistics Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. 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 improve performance and user experience by pre-aggregating and pre-calculating the data. 2 Secure Enterprise Platform, a new VLDB setting "MCE Join To Get Data Combination" has been introduced, that can help improve the document performance. MicroStrategy Parameterized Query feature for better performance. Purpose of the registry key. A set of data is returned from the. This name change is visible in. x and 10. 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. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. This is done by using an additional database instance to handle the separate location for the datamarts. Using the Performance Monitor Counters to measure Intelligent Cube memory usage and publication times: When an Intelligent Cube report is run (published), the. 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. Select one of the following: Drill anywhere: (the default) All drill paths in the drill map for the dataset report are shown. You can try to clear the page cache to see if performance improves. None excludes the attribute in the target from the GROUP. 2. 4. You can learn more about Enterprise Manager in the following documentation resources:In MicroStrategy Desktop 9. Click View Logs, to display the share icon in the upper-left. 4. For a single cube publish, using 3. 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. In the bottom section, under Destination note the location of. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Retail is leveling up with omnichannel analytics. QUESTIONUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. 2. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. The cube is based on a MDX datasource, specifically SAP BW. After you find the microstrategy. The ID of the Job would be useful in order to read the job trace. An Intelligent Cube publication takes significantly long to complete publication (several hours). Understand your data characters and choose the matched configuration could enhance the performance and accelerate the process to view the latest data. For troubleshooting and diagnostics logging routines related to MDX cube sources, see the Troubleshooting section of the System Administration Help. 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. Step 1: Optimizing HyperIntelligence Datasets. Web Open the Settings page (right click the extension and select Options). This enhancement only applies to Windows, Linux and Mac OS. x - 10. Datamart optimization can be used to improve performance in this situation if the database for the datamart. Analyze the low performance query using DBA knowledge, add. Use Case 4. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. To prevent any data loss, we strongly recommend that you back up your data, configuration files, metadata, plugins, cubes, caches, and image files prior to. Cloud Computing. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. Place Intelligence Server close to the both the data warehouse and the metadata repository. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Login to using your MicroStrategy Resource Center account. As such, you can only enable a certain amount of cards to avoid. MicroStrategy. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Cube with Date Dim and Currency (as mandatory) 3. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. MicroStrategy consistently pushes updates to the Chrome Web Store when any issues are resolved. 4. 4. These changes are to both defect fixes and enhancements for a more stable and robust reporting. 4 to MicroStrategy 2019 Update 2. Kernel -> Processing Unit Trace – trace tasks execution of a Processing Unit. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. To plan for these memory requirements, see the System Administration Guide. 4. x). This attribute should have a lookup table in the SQL data warehouse. Select data population for Intelligent Cubes. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. We can try to use different aggregations groups to improve the query performance of some very important Dim or a Dim with high cardinality. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. Published: Jun 7, 2017 Last updated: Jun 7, 2017In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. 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. getProjectName () + " number of cubes:"+cubesPerProject. Data loads and refreshes are too long, data freshness can. All prerequisites for using security filters with MDX Cubes should be completed before. Currently, there is no automatic way to trigger the events once cube finished incremental refresh or publishing in MicroStrategy 9. You must belong to the System Administrators group to use this feature. Refer to Product Manual for more detailed information. 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. In versions prior to MicroStrategy Intelligence Server 9. For example, if they open a dashboard, document, or report and step away from the desk, their user session can. 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. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesMicroStrategy Platform Analytics is set up for all MicroStrategy 2019 or later versions and maintained to allow for instant access to system performance metrics. 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. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. 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. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent 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. 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. This will influence the user experience. 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. Solve issues with Garbage Collection overhead limits. Run both reports after enabling the metric levels log. Retail is leveling up with omnichannel analytics. When you enable these traces, be sure to enlarge the size of trace file to >20MB. Matching and Number of Keyword Limitations. 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. 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. •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. To update the newly created Super Cube, create a new script starting from repeating steps 3-7. If the configuration settings are correct the following will happen: KMCW connects to MicroStrategy and crates a new cube. The following steps demonstrates how to reproduce the issue in MicroStrategy Tutorial project: Create an intelligent cube with Category, SubCategory, Item, Warranty, Call Center. Cube Instance ID: The ID for the current published version of the Intelligent Cube. It does not tell us anything helpful and we should not use it as a point of reference. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Developers gain tuning insights to improve project performance. For example, you can choose to add or delete data from the Intelligent Cube. We have already. We have already. Improve Report and Cube Performance Against the Data Warehouse by Using an Attribute Form Caching Cube This feature was introduced in MicroStrategy 2021 Update 5. 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. By default, MicroStrategy uses ODBC call 3. This functionality is run in a separate process to isolate MicroStrategy Intelligence Server 9. MDX cubes are also referred to as MDX cube sources. KMCW connects to Kafka brokers and reads topics. SAP Data Warehouse Optimizations. x that allows logged out MicroStrategy Web users to log back in and recover the last dashboard, document, or report they viewed before logging out or being logged out. 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. Execute View Report. Enterprise Manager is the precursor product for Platform Analytics. All necessary privileges are included in the Administrator role by default. 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. 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. Under Refresh type, select one of the following options. In-Memory capabilities provide tremendous acceleration to your Dashboards. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). The path for cube files must be shared as "ClusterCube". The Intelligent Cube Options dialog box opens. For example, you can build yearly partitions and then process just those two years so that way it's only accessing that data. Choose Data > Configure Intelligent Cube. Instead, Command Manager can be used to display the cube status. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 0 ODBC calls. The Intelligent Cube Editor opens. This technical note will describe the steps to specify the partition attribute and the number of partitions in a regular Intelligent Cube and an in-memory Intelligent Cube created via Data Import. MicroStrategy support connects you to the most helpful & experienced technical experts in the industry. 3. 3. You can further improve query performance by reducing the amount of data scanned. It is local to the node and is reset every time the cube is unloaded/loaded. Please refer to Improving Report and Cube Performance to learn more about it. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Cyber Security and SIEM Tools. Edit Intelligent Cubes from the new editor in Workstation at any time. x This technical note provides a detailed explanation on how. Business users move seamlessly between all five styles of BI and even combine multiple styles. ). Intelligent Cube, or on-demand retrieval using live mode. Run multiple dossiers, documents, or reports based on this cube to. Create an Attribute Form Caching Cube. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. Rather than returning data from the data warehouse for a single report, you can return sets of data from you data warehouse and save them directly into the Intelligence Server memory. This report is prompted on time and on the job type you want to analyze, and you can select the. In the Navigation pane, click , next to Datasets. Full control. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. The result of this setting is reflected in the GROUP BY clause of the SQL command. 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. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. 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. The default is 1000 Intelligent Cubes. The ability to view or edit certain settings is determined by a user's privileges. 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. In kylin4, sparder exists as a long-running spark application. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. x. Parallel query execution is disabled by default to allow you to first verify that your reports and Intelligent Cubes are executing correctly prior to any parallel. Click OK.