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. 1, Intelligent Cubes have a new feature to update information without republishing it. 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. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. 3. This provides improved performance when querying in-memory cubes. Choose Data > Configure Intelligent Cube. MicroStrategy Optimization: VLDB Settings. Change Journaling is enabled by default since MicroStrategy version 10. x - 10. 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. MicroStrategy has been integrated with SQL Server for over 20 years. Cube Advisor checks if existing reports can use dynamic sourcing. 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. To achieve this, cube processing in the MicroStrategy. Derived element with calculation type degrades execution performance in a cube report with large data and many derived metrics in MicroStrategy OLAP Services 9. 4. 1. Calculations changed for non-distributive metrics against the Intelligence Cube after upgrading from 10. By default, the location configured will be a relative path where ". 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. The iCube creation process is very similar to Reports: Right-click | New Intelligent Cube | Then, add a Template and. Based on performance concerns, the Intelligence Server will also save other remote cluster node's cube lookup indexes in-memory. Data Language: The language used for the Intelligent Cube. The Performance Analysis folder has several reports and two folders, each with its own related area of analysis: •. 5. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). To improve performance, MicroStrategy provided a way to bulk insert a large amount of data with prepared statement. VLDB properties can also be used in order to optimize report. Use Case 4. 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. Best Practices with MicroStrategy. Under CUBE TEMPLATE, choose Default Attribute Form Caching. DESCRIPTION: Starting MicroStrategy 10. Select the database instance to delete. Logs name for PU, Command ID, and execution Status. Administrators can use this analysis area to understand what effect the server and project governing settings and usage patterns have on the system. x-11. the workflow manager or enterprise scheduling tool, to trigger the. Users may find additional information related to managing and using Intelligent Cubes in. 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. In addition to this, you need a plan for tuning the system. This " How to" knowledge base article explains cube advisor. 4. Grouping determines how the metric aggregates. Easily add or change pre- and post- SQL statements. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. We have found that educated users are more likely to use the product on a daily basis. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. This would require that you have all your attribute relationships defined correctly. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. This article discusses how the Data Import functionality utilizes multiple threads to improve the cube publishing time, when performing a data import against CSV/Text filesBest Practices Articles (Performance Tuning Based on IBM Db2) This article describes best practices to be taken when connecting an instance of IBM Db2 in MicroStrategy. Login to MicroStrategy web, create a dossier and use the newly created OLAP01 as a dataset. Answer: Go with dossier. Dashboards executed in Flash mode require Flex Binary for the data and XML generation for the Dashboard definition. 2. Select the Enable report drilling check box. 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. Easily add or change pre- and post- SQL statements. By default, the location configured will be a relative path where ". 3. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. If the configuration settings are correct the following will happen: KMCW connects to MicroStrategy and crates a new cube. out. This empowers administrators with telemetry capabilities that capture and analyze usage statistics and performance for objects. Kernel -> Processing Unit Trace – trace tasks execution of a Processing Unit. 3. Retail is leveling up with omnichannel analytics. 2. Refer to Product Manual for more detailed information. Summary. Under the VLDB settings for that cube, make sure that to increase the. 9 or an older version. 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. x This technical note provides a detailed explanation on how. The table below summarizes a few key modules that commonly consume the most amount of time during a dashboard execution: Fewer slices improve a cube’s performance. All prerequisites for using security filters with MDX Cubes should be completed before. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The MicroStrategy Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. The Data Partition options are displayed. From the Data menu, select Grid Data Options. The limitations mentioned above are currently being investigated by the Technology team. One way to free memory on Intelligence Server, which can improve Intelligence Server performance, is to temporarily unload an Intelligent Cube from memory. There are a number of optimizations that you can do to help improve cube processing: Build periodic partitions for your cube and process those partitions to a particular time period. Once the object is used in the card, right-click the object. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. The data get's fresher, faster, and less resources consuming for everyone. For example, you can choose to add or delete data from the Intelligent Cube. Intelligent Cubes improve performance and user experience by pre-aggregating and pre-calculating the data. If you use Enterprise Manager, dedicate a machine for the Enterprise. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. 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). This can be done by enabling the feature flag "Defect fixes that may impact data, SQL, MDX, CSI" in Web. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. Iterate through the enumeration to get the cubes per project and the corresponding status. Right click the database and under “Tasks” choose “Backup”. println ("For project: " + cubesPerProject. In MicroStrategy 10. 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. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. Performance analysis. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. The main reasons an Intelligent Cube size would increase after publishing is for the following reasons: Cube Index generation. in MSTR, go to project config, increase the project memory settings. Use mstr_ko. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. 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. In MicroStrategy, users can create and manage datamart tables in a different schema, database, or server from the data warehouse. There is a substantial increase in complex query performance; 4. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Video Tutorials. VLDB properties can also be used in order to optimize report. Starting 10. In addition to the above, you can follow the Data Import steps via Web using Amazon Redshift and save your result set in-memory. 3. In additional to some performance impact, this re-publishing workflow will also need the original data source. So the build/query performance tuning is very different from Kylin 3 tuning. 11 the derived attributes are now evaluated at the source when all the required columns come from the same table, which covers the. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. 0 and have upgraded to the most recent version of MicroStrategy, it is recommended that you use a different Intelligent Cube normalization technique. Apply the year prompt to to view filter of the intelligent cube report and the report filter regular report. e. This copy of report data is stored in Intelligence Server memory only. HyperIntelligence for Web can only search for a total of 500k keywords and alternate keywords at a time. I Want to Know how the MicroStrategy improve cube performance? I Want to Know how the MicroStrategy improve cube performance? Open Menu. Starting with MicroStrategy 10. Cube index generation will increase cube size. Create a report with the year and quarter attributes and the profit metric. Solution. Cube A's refresh policy is set to "add new data. x ODBC calls have approximately 30% performance improvement than using 2. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. Collect statistics on the tables 5. This article describes a behavior within MicroStrategy Workstation, whereby the environment gets disconnected as soon as one tries to create a new Intelligent cube. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Starting in MicroStrategy 10. Edit Project-Level Cache and Intelligent Cube Settings. GUID: is the GUID of the intelligent cube, returned as a string. 4. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. 3. 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. • Do not add a fake. SUMMARY. MicroStrategy is constantly iterating, importing, and creating new features to ensure our customers are having the best experience. 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. This knowledge base article describes a behavior in MicroStrategy 10. In just one week, MicroStrategy Professional Services, will conduct a thorough examination of your Business Intelligence implementation, providing you with actionable recommendations on these five key areas to improve overall performance. 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. 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. 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. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. CI/CD Devops. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. For the steps to define an incremental refresh report, refer to: Subset report or view report caching can improve dossier performance in almost 70% of all cases. Object Migration is the process of migrating or moving objects from one environment to another environment. For example, you can choose to add or delete data from the Intelligent Cube. Option 2: Have all your 46 million records pulled into a cube. MicroStrategy Parameterized Query feature for better performance. 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. Increasing this setting can increase caching efficiency in cases. You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice. Transformations allow you to apply an attribute-element based offset to compare metric data. Select the Data Partition category. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. It is especially useful when data source contains huge data amount. The "User login" prompt in security filters applied to MDX Cubes. 0. 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. x. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Right mouse click on the cube and choose Schedule. Bulk Insert. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. 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. The Intelligent Cube Options dialog box opens. Dossiers automatically adjust to look great on any screen. Both enabling and disabling logs are covered. In order to stay informed about the size of the data or troubleshoot issues with memory or performance, a user may want to check the size of the tables in their environment. Generate Oracle AWR report or monitor the database to identify the low performance query. Place Intelligence Server close to the both the data warehouse and the metadata repository. Cyber Security and SIEM Tools. MicroStrategy. See how to take advantage of the latest Dossier features for improving data analytics speed and BI scale. 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. 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. While OLAP cubes were limited to 2 billion rows, PRIME OLAP cubes can be divided into. 4. In the Folder List, right-click the project and choose Project. Therefore we need 20GB RAM memory to store the cube. Architect Persona. Analyze the low performance query using DBA knowledge, add. Connect to your database using SQL Server Management Studio and in the left pane select your Metadata database. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. 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. 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. Navigate to the Engine Component with CSI Dispatcher. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . When you enable these traces, be sure to enlarge the size of trace file to >20MB. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. The Options dialog box opens. hasMoreElements ()) { //Get the intelligent cubes for one project Caches cubesPerProject = cubesEnum. Community & Support Search Discussions Open A Case View My CasesImproving Response Time: Caching. x and newer. Learn how to increase the JVM Heap size for Microsoft Internet information services to allow for better performance. Developers gain tuning insights to improve project performance. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. With Parallel Hierarchy. Distributed query engine，avoid single-point-of-failure; 2. 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. Select data population for Intelligent Cubes. 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. Add filters for Year and Quarter through the Advanced Filter Editor by clicking on the 3-dot icon on the grid visualization and select Edit Filter. In the Categories list, expand General, and then select Drilling. 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. In kylin4, sparder exists as a long-running spark application. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. If the cube and subset report have similar objects, a best practice is to use the cube as the dataset instead of subset report. This will influence the user experience. 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. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. 0 cubes is the ability to partition cubes. 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. Set Freeform SQL and MDX objects default security. To learn more about attribute form caching cubes, see KB484994. if it’s take less time then you’ll have something to do with MSTR or fine tune DB SQL with the help DBA. KB442293 : In-Memory query optimization to improve performance by. 1, Intelligent Cubes have a new feature to update information without republishing it. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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. You can learn more about Enterprise Manager in the following documentation resources:In MicroStrategy Desktop 9. An Architect creates, publishes, and optimizes a federated data layer as the enterprise’s single version of the truth. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. You must belong to the System Administrators group to use this feature. x, create a simple Intelligent Cube with attribute Category and metric Revenue. During installation you have the following options:Governing Intelligent Cube Memory Usage, Loading, and Storage. Understand your data characters and choose the matched configuration could enhance the performance and accelerate the process to view the latest data. As such, you can only enable a certain amount of cards to avoid. To access this VLDB,. It can adapt to report level through the use of "CurrentMember. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. IUsers of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. sh to produce 1000 test messages as follows: Sorted by: 3. In-store and online. Sure, currently just exploring the mstrio. 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. g. 1. 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 can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Every newly created MTDI cube will inherit settings from this template and automatically be created. Telcos using MicroStrategy can run. 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. In the Navigation pane, click , next to Datasets. The MicroStrategy Performance Analysis service delivers:. Platform Analytics repository size may be observed increase rapidly with advanced statistics enabled. Stay up to date on inventory needs and avoid. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. 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. To solve this problem, we introduce a new registry key, " Respect. This feature is addressed in MicroStrategy 2020 Update 2 and MicroStrategy 2021. Every customer can take advantage of the lookup caching cube to improve report and cube performance by up to 30% against the data warehouse. The Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. Run multiple dossiers, documents, or reports based on this cube to. 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. Hover the schedule need to be modified, and. Plus, our specialists will share tips and tricks to help you avoid common pitfalls and troubleshoot issues that can impact performance. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Set Freeform SQL and MDX objects default security. The ID of the Job would be useful in order to read the job trace. This change improves the performance for memory intensive use scenario also potentially increases the memory footprint for Intelligence Server. Session Recovery is a new feature in MicroStrategy 10. (Intelligent Cube configuration is not relevant in MicroStrategy 8. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. 2. PATH: is the folder where the intelligent cube resides, returned as a string. Under the VLDB settings for that cube, make sure that to increase the. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. In addition to the above setting, another major reason for a slow project load could be any additional traces or logs that have been turned on for. Steps to reproduce. While performing multiple queries in parallel can improve the performance of query execution in MicroStrategy, it will not provide the best performance or results in all scenarios. In the search, when All objects option is ticked, the cube does not appear. view reports. view reports. The first step of the cycle is to quantify the performance by measuring the time spent in each of the components that are part of a Document Execution Request, as described in the preceding sections. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. We have already. getCount. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. 1. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. The M8MulPrc/M8MulPrc_32 process is a database connection process spawned from the MicroStrategy Intelligence Server 9. The performance improvement varies based on the CPU cores, memory, file size and the Operation. 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. 2. As the Architect of the company, you are responsible for creating a dataset optimized for HyperIntelligence. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. 0". The. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. In some business scenarios, it is required to filter data for current month in cube report with view filter in MicroStrategy 9. Timezones can be discovered by running the following command: python3 -c "import pytz; print (pytz. Or, navigate to the Data Explorer for the MDX Cube database instance. while (cubesEnum. To plan for these memory requirements, see the System Administration Help. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. There is a substantial increase in complex query performance; 4. The default is 1000 Intelligent Cubes. Publish the Intelligent Cube by executing it on either of the nodes. With Redshift Spectrum, you take advantage of a fast, cost-effective engine that minimizes data processed with dynamic partition pruning. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Web Open the Settings page (right click the extension and select Options). In MicroStrategy Analytics Enterprise Web 10, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI). In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services. Starting from MicroStrategy 9. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. You can optionally remove cells that have a value of zero. The subscriptions (from the performance test package) were then executed on the reports and dossiers built on the performance test cube to generate approximately 100 jobs/transactions every minute. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Determines how MDX cube reports that only include attributes are processed in order to improve performance in certain scenarios. Loading × Sorry to interruptIncremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. 5 compared to ODBC call 2. Retail is leveling up with omnichannel analytics. The application is named MicroStrategy Cube. 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. The path for cube files must be shared as "ClusterCube". Another common situation with Parameterized Query will be combining multiple inserts of data into the database as a single query. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Publish a cube. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Note: number of columns should be the same as in the original file. In order to protect both security and performance the MicroStrategy system will compare all of the Security settings in. Use Count (Attribute@ID) to calculate total element number (uses count distinct if necessary) For Tandem databases, the default is Use ODBC Cursor. x and newer. If you manually enable this setting. In 11. 3. 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. Please refer to Improving Report and Cube Performance to learn more about it. Under Refresh type, select one of the following options. Visit the data visualization and data dashboard galleries for inspiration. g. x that handles the execution of queries and management of the database connections. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. On the left side of the page, click Logs and then Export Logs to save the file. Connectivity. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. To Define Limits for the Intelligent Cube Indexes. In other words, you should partition the the attribute with the highest quantity of unique elements. 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. 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. 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. This functionality is run in a separate process to isolate MicroStrategy Intelligence Server 9.