View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 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. Under the Catalog>Read mode menu change the Catalog. Can benefit from spark new features and ecology. 0, dynamic growth algorithm for buffer size is introduced to improve the performance of buffer, and it is enabled by default. You must belong to the System Administrators group to use this feature. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. With an increasing number of. This presentation helps users understand MicroStrategy's in-memory architecture. 9 or an older version. 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. With caching, users can retrieve results from Intelligence Server rather than re-executing queries against a database. The database requires create table and drop table privileges for this. When you enable these traces, be sure to enlarge the size of trace file to >20MB. Developers gain tuning insights to improve project performance. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. g. About the build/query performance tuning of Apache Kylin4. This knowledge base article describes a behavior in MicroStrategy 10. A code fix is provided. It accesses and joins data. Both enabling and disabling logs are covered. Specific jobs will run (in parallel) on Hadoop and then be transfered back to the intelligence server (in parrallel) via TCP. However, subset. 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. 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. getCount. In the search, when All objects option is ticked, the cube does not appear. One way to free memory on Intelligence Server, which can improve Intelligence Server performance, is to temporarily unload an Intelligent Cube from memory. MicroStrategy Optimization: HINTS. Sure, currently just exploring the mstrio. Stay up to date on inventory needs and avoid. If you use Enterprise Manager, dedicate a machine for the Enterprise. Dossiers automatically adjust to look great on any screen. For the other types of output, MicroStrategy Office and MicroStrategy Web in DHTML mode, the Intelligence Server generates XML. Bulk Insert. 4. Login to MicroStrategy Web, create a cube with the function of Data Import. 7, and later versions, non-distributive metrics do not return correct data, because the engine does double aggregation due to the optimization done in DE81833. This section focuses on the VLDB properties that are set at the metric and report level. Open the PAConsumerConfig. MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. This empowers administrators with telemetry capabilities that capture and analyze usage statistics and performance for objects. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Distributed query engine，avoid single-point-of-failure; 2. out. Plus, our specialists will share tips and tricks to help you avoid common pitfalls and troubleshoot issues that can impact performance. Hit Count - This count tracks how many times the in-memory version of the Intelligent Cube cache is hit. Select data population for Intelligent Cubes. To get a sneak-peak of new functionalities. Metro Area. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. The below test is based on a 4M rows dataset which shows the throughput improvement with ODBC call 3. 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 files Best 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. Cube Info Cache creation. VLDB Properties. 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. 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. The third most common microstrategy developer skill is templates on 5. 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. Full control. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Using the Performance Monitor Counters to measure Intelligent Cube memory usage and publication times: When an Intelligent Cube report is run (published), the. x ODBC calls have approximately 30% performance improvement than using 2. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Steps to reproduce. In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services. An Intelligent Cube is an In-Memory data structure which holds. The Options dialog box opens. x that handles the execution of queries and management of the database connections. Can benefit from spark new features and ecology. This article describes a behavior within MicroStrategy Workstation, whereby the environment gets disconnected as soon as one tries to create a new Intelligent cube. Published: Jun 7, 2017 Last updated: Jun 7, 2017 In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. 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. An Intelligent Cube publication takes significantly long to complete publication (several hours). The limitations mentioned above are currently being investigated by the Technology team. This attribute should have a lookup table in the SQL data warehouse. This provides improved performance when querying in-memory cubes. Oversee all IT SaaS strategy, create and execute digital transformation roadmap, and identify ways to. Update Cube Data *. Fewer slices improve a cube’s performance. Connectivity. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. 9 and 10. The in-database Advanced Analytics gives you the insights you need to improve everything from database performance to your company’s inventory management. 4. SAP Data Warehouse Optimizations. Before MicroStrategy 10. 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. 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. Logfilename: This field represents the location of the Metric Levels Log file. Data can be analyzed as a report, document, or dossier. x and newer. MicroStrategy. The path for cube files must be shared as "ClusterCube". Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. 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. 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. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. Cube index generation will increase cube size. Distributed query engine，avoid single-point-of-failure; 2. Cyber Security and SIEM Tools. Easily add or change pre- and post- SQL statements. We did internal. So the build/query performance tuning is very different from Kylin 3 tuning. Refer to Product Manual for more detailed information. 10 where different behavior is seen in between a Live connect and In-Memory cube when filtering on warehouse null values in Dossier. Dec 2017 - Present 6 years. 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. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. In the previous example all the extra calculations were pushed to the intelligent cube which will improve the performance for the end users. The ability to view or edit certain settings is determined by a user's privileges. Rather than returning data from the data warehouse for a single. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 1. 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. SUMMARY. 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. For example, you can build yearly partitions and then process just those two years so that way it's only accessing that data. To plan for these memory requirements, see the System Administration Guide. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. Go to Schema Menu > SQL Generation Options. . In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. PATH: is the folder where the intelligent cube resides, returned as a string. println ("For project: " + cubesPerProject. With Parallel Hierarchy. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). MicroStrategy is constantly iterating, importing, and creating new features to ensure our customers are having the best experience. You must belong to the System Administrators group to use this feature. Slice and dice features are awesome. x releases, and the new Multi-table Data Import (MTDI) cubes introduced in 10. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Data Language: The language used for the Intelligent Cube. 0. x - 10. Open the cube for editing. Right mouse click on the cube and choose Schedule. To solve this problem, we introduce a new registry key, " Respect. Retail is leveling up with omnichannel analytics. Proactive. Retail is leveling up with omnichannel analytics. •. Cube Definition ID: The ID for the Intelligent Cube object. 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. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Video Tutorials. In addition to this, you need a plan for tuning the system. Starting from MicroStrategy 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Data loads and refreshes are too long, data freshness can. The Data Partition options are displayed. The data get's fresher, faster, and less resources consuming for everyone. Ability to add and edit descriptions in derived attributes, derived metrics, derived attributes, and metrics from a Data Import cube. Set Freeform SQL and MDX objects default security. x. In versions prior to MicroStrategy Intelligence Server 9. In kylin4, sparder exists as a long-running spark application. 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. 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. Click on 'Catalog Options' to open the Warehouse Catalog Options. Create a new File Log and name it “CSI” (or any other name). Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. Prerequisite. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. How To Reduce Intelligent Cube Size By Finding Intelligent Cube Objects Which Are Not In Use. Select the Data Partition category. MTDI cubes are the self-service in-memory solution. Users can also seamlessly drill down from data in an in-memory cube, to detail data in RDBMS and further detail in Amazon Redshift. 2 release, the driver file is called odbc8. 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. 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. Another common situation with Parameterized Query will be combining multiple inserts of data into the database as a single query. Dedicate a machine for the metadata repository. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. getProjectName () + " number of cubes:"+cubesPerProject. sh . Best Practices with MicroStrategy. x and 10. Cube Instance ID: The ID for the current published version of the Intelligent Cube. Helps optimize custom group banding when using the Count Banding method. out. If the relations are modified in the cube editor, the cube has to be re-published to be used again. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The New Intelligent Cube dialog box opens. CAUSE: CPU information shows this is not an apple-to-apple comparison. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. The following diagram depicts the role of the intelligent cube. This article discusses Data Engine changes that may impact customers data when upgrading to MicroStrategy 2019. This change improves the performance for memory intensive use scenario also potentially increases the memory footprint for Intelligence Server. 1, Intelligent Cubes have a new feature to update information without republishing it. If the cube and subset report have similar objects, a best practice is to use the cube as the dataset instead of subset report. Use Cube Advisor to create Intelligent Cubes: 1. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. 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. Stored calculations for compound metrics. In MicroStrategy Developer, search for the created dashboard. The MicroStrategy Performance Analysis service delivers:. The telemetry generated from these actions was processed by the Telemetry Store and loaded into the Platform Analytics warehouse. This technical note will discuss the workflow of a Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to. This will influence the user experience. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. Use Cube Advisor to create Intelligent Cubes: 1. Once the object is used in the card, right-click the object. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. 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. Business Intelligence. For troubleshooting and diagnostics logging routines related to MDX cube sources, see the Troubleshooting section of the System Administration Help. Expand the Object Templates category, select General, and from the Show templates for the. 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. In our case we define 3 Aggregations Groups: 1. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. The binary generated for this mode is different from the binary generated for PDF. There is an increasing demand, from users across all organizations, for higher BI performance, driven by the rapid growth of data volumes and number of users. Apply the year prompt to to view filter of the intelligent cube report and the report filter regular report. 11, 10. . Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In addition, some other important tuning recommendations are mentioned: OS Level Optimization. Kylin 4 is a major architecture upgrade version, both cube building engine and query engine use spark as calculation engine, and cube data is stored in parquet files instead of HBase. An Intelligent Cube publication takes significantly long to complete publication (several hours). Big Data. Providing Intelligent Cube data. x. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. This setting is used to combine multiple subqueries into a single subquery using set operators (e. You can further improve query performance by reducing the amount of data scanned. In-Memory capabilities provide tremendous acceleration to your Dashboards. 4. If the cube and subset report have similar objects, a best practice is to use the cube as the dataset instead of subset report. Strong semantic layer to define all the business rules and tightly coupled. Click OK. 3. the workflow manager or enterprise scheduling tool, to trigger the. To Define Limits for the Intelligent Cube Indexes. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. Note that only the naming convention has changed, as the functionality remains the same. " If a user refreshes cube A with "add new data" as a refresh policy, he can successfully refresh it. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. To use this functionality in. 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. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. In other words, you should partition the the attribute with the highest quantity of unique elements. During installation you have the following options:Governing Intelligent Cube Memory Usage, Loading, and Storage. This article describes the Intelligent Cube Population options available in MicroStrategyReturn on investment (ROI) is a critical metric for any business as it measures the profitability of an investment in relation to its cost. 5 compared to ODBC call 2. while (cubesEnum. Use Count (Attribute@ID) to calculate total element number (uses count distinct if necessary) For Tandem databases, the default is Use ODBC Cursor. However, there is no significant improvement against Synapse Analytics. Published: Jun 7, 2017 Last updated: Jun 7, 2017In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. In MicroStrategy 10. Users may find additional information related to managing and using Intelligent Cubes in. 7. If you upgrade a pre-9. Click All Objects View. Steps to reproduce Log in to an environment in MicroStrategy Workstation using. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. Right-click the Intelligent Cube, and select Edit. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. 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. 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. 11 the derived attributes are now evaluated at the source when all the required columns come from the same table, which covers the. MicroStrategy is committed to helping to ensure Virginia remains at the forefront of innovation and a top place to do business in the United States. They were used to improve subsequent query performance against the Intelligent cube. Use Cube Advisor tool to leverage the use of dynamic sourcing feature; Yes! This tool, even if «archaic» and not update is still useful! Dynamic sourcing can improve performance by enabling reports to automatically hit an available cube if it contains all the required information. This Technical Note describes how the project level governing limit “Maximum RAM usage (MBytes)" for Intelligent Cubes is implemented in a clustered environment. (In MicroStrategy Intelligence Server Universal environments in UNIX/Linux, this may require the memory contract manager setting "Memory reserved for other processes" to be increased. 2. In the Platform Analytics directory, located at C:Program Files (x86)MicroStrategyPlatform Analytics, open the conf folder. 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 Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. The MicroStrategy Performance Analysis service delivers: Performance optimization roadmap: A customized. 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. The cube is based on a MDX datasource, specifically SAP BW. Problem is: 100% in-memory solutions cannot fit all your requirements. MicroStrategy Parameterized Query feature for better performance. 9% of resumes. MicroStrategy Parameterized Query feature for better performance. Increasing this setting can increase caching efficiency in cases. 3. Impact: Performance, security. 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 article explains why MicroStrategy 2021 Update 1 requires additional disk space when publishing a cube to improve cube loading times. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. With Parallel Hierarchy. 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. The following steps demonstrates how to reproduce the issue in MicroStrategy Tutorial project: Create an intelligent cube with Category, SubCategory, Item, Warranty, Call Center. get the SQL and execute directly in DB. 0. In MicroStrategy 10. Number of Views 524. Use Case 4. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. Starting with MicroStrategy 10. In MicroStrategy versions prior to MicroStrategy 2021 Update 1, the cube cache file that is saved to disk does not include an Attribute Element Index, which is generated during cube publishing to improve cube querying performance. Defining the partition for Super Cubes. 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. Select the environment and project where you want to. x-11. Select one of the following: Drill anywhere: (the default) All drill paths in the drill map for the dataset report are shown. 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. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. Required Status to Perform Action. …Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. x from any unexpected conditions. 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. Instead, in prior versions, the Attribute Element Index is only kept in memory. 0 release, we have changed the workflow to ensure we can always deliver the correct data to the user. KB442293 : In-Memory query optimization to improve performance by. You can learn more about Enterprise Manager in the following documentation resources:In MicroStrategy Desktop 9. 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. 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. MicroStrategy supports reporting and analysis with SAP BW, Microsoft Analysis Services, Hyperion Essbase, and IBM Cognos TM1. 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. Connect to your database using SQL Server Management Studio and in the left pane select your Metadata database. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. If the data requirements for the report change, or cannot be satisfied by an available Intelligent Cube, the reports automatically access the data. x. The "User login" prompt in security filters applied to MDX Cubes. Matching and Number of Keyword Limitations. In Developer, from the File menu select New, and then Intelligent Cube. 2. Beginning in MicroStrategy 11. The first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. 4. Watch this video to learn more about the Expert. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesFollow the steps below to delete an OLAP cube database instance from MicroStrategy Developer. To improve the cube publish performance for Oracle, we tried using different ArraySize values and found a more suitable range against the use case. Both types of cubes leverage the new partitioning functionality that allows loading. 8 to help improve the performance of Quick Search on MicroStrategy Web. MicroStrategy Web: MicroStrategy Developer: Published: Jun 14, 2017Hi @Peter Ott(Inactive) (Microstrategy, Inc. 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. Conclusion We discussed various techniques to improve report building, system performance, and user productivity with MicroStrategy in this eBook. The first step in analyzing. Optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. See Memory Mapped Files for Intelligent Cubes for more information. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Determines how MDX cube reports that only include attributes are processed in order to improve performance in certain scenarios. if it’s take less time then you’ll have something to do with MSTR or fine tune DB SQL with the help DBA. 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. How to troubleshoot and improve Cube Publication times in MicroStrategy Secure Enterprise. Intelligent Cube, or on-demand retrieval using live mode. KMCW connects to Kafka brokers and reads topics. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. Tips and Tricks to Partition In-Memory Cubes for Faster Performance. MicroStrategy has been integrated with SQL Server for over 20 years. 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.