An Architect creates, publishes, and optimizes a federated data layer as the enterprise’s single version of the truth. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. The solution discussed in this article is a python application that leverages the MicroStrategy API suite to provide an external scheduler, i. HyperAndroid Go to the Account tab. Create a second report with the year and quarter attributes and the revenue metric. MicroStrategy Analytics cubes are easy to create and deploy. Available PA data is stored in the cube that has a default limit set to 20GB or RAM. By default, MicroStrategy uses ODBC call 3. Open the Workstation window. Watch the presentation where you'll discover our top five hacks to optimize your Dossier designs including best practices for data wrangling, dataset management, and content caching. For more details on Intelligent Cube size increase, refer to the following technical note:. Further in order to enhance the performance and quality of the reports produced we can follow the. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. view reports. With Kyvos’ Smart OLAP™, you can modify the existing cube to add, delete or reorder the entities by eliminating the need to rebuild the cube. VLDB Properties. The test cube report report will be executed with success in both nodes. Use partition mapping 3. Performance analysis. MicroStrategy Optimization: VLDB Settings. 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. 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. This empowers administrators with telemetry capabilities that capture and analyze usage statistics and performance for objects. In Developer, log in to a project with a user account with administrative privileges. e. Indexes are created in memory on the Intelligence server as part of the in-memory cube instance. The path for cache files must be shared as "ClusterCaches". 11, 10. 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. 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. Purpose of the registry key. Set Freeform SQL and MDX objects default security. The use of text columns for attribute IDs can impair query performance in the database and, in this scenario, opens the door to inconsistent data handling. Right-mouse click this object, and click on Search for Components. 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. Best Practices with MicroStrategy. Create an Attribute Form Caching Cube. 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. 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. •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. Published: Jun 7, 2017 Last updated: Jun 7, 2017 In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Summary. Timezones can be discovered by running the following command: python3 -c "import pytz; print (pytz. The. The grouping options for levels include: Standard groups by the attribute level of the target. 0. Details on MicroStrategy recommendations can be found in this TN. Answer: Go with dossier. The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. getCount. We can try to use different aggregations groups to improve the query performance of some very important Dim or a Dim with high cardinality. Users in order to see them have to go to the object and un-hide it. Solution. Browse resources on demand or contact support directly. In-store and online. Number of Views 524. To plan for these memory requirements, see the System Administration Guide. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. VLDB properties can also be used in order to optimize report. x and newer. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Ability to add and edit descriptions in derived attributes, derived metrics, derived attributes, and metrics from a Data Import cube. This can be done by enabling the feature flag "Defect fixes that may impact data, SQL, MDX, CSI" in Web. 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. 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. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. In our case we define 3 Aggregations Groups: 1. 3. Because Direct Data. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. Solve issues with Garbage Collection overhead limits. To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. In MicroStrategy 9. In additional to some performance impact, this re-publishing workflow will also need the original data source. The default value is 256 megabytes. x. An Intelligent Cube publication takes significantly long to complete publication (several hours). Purpose: This is a pre-built plug-in that, when enabled, adds 2 timestamp columns to the Kafka data that will be sent to the MicroStrategy cube. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services. 1. Best Practices with MicroStrategy. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. 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. There is a substantial increase in complex query performance; 4. Right mouse click on the cube and choose Schedule. SUMMARY. hasMoreElements ()) { //Get the intelligent cubes for one project Caches cubesPerProject = cubesEnum. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Under the VLDB settings for that cube, make sure that to increase the. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Prerequisites •From MicroStrategy 11. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. 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 results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Choose Rename. 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 results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. This attribute should have a lookup table in the SQL data warehouse. 2. 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. If the relations are modified in the cube editor, the cube has to be re-published to be used again. Report runtime performance for reports accessing Intelligent Cubes is optimized because the Intelligent Cube for the report has already been loaded. This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. The user has view access to cube A and B. while (cubesEnum. NAME: is the name of the intelligent cube, returned as a string. In the previous example all the extra calculations were pushed to the intelligent cube which will improve the performance for the end users. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. Optimize Build and Query. 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). Can benefit from spark new features and ecology. It can adapt to report level through the use of "CurrentMember. x). Cube index generation will increase cube size. Now offering. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Expand the Object Templates category, select General, and from the Show templates for the. Using Confluent. Example Performance Data. CAUSE: CPU information shows this is not an apple-to-apple comparison. 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. 2 release, the driver file is called odbc8. Note that only the naming convention has changed, as the functionality remains the same. Cube Instance ID: The ID for the current published version of the Intelligent Cube. Iterate through the enumeration to get the cubes per project and the corresponding status. Impact: Performance, security. 2. x. To build an Intelligent Cube. 4. 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. Select the environment and project where you want to. Before MicroStrategy 10. Click Modify to open the Properties dialog box: Security tab. Click OK. The MicroStrategy Performance Analysis service delivers:. However, there is no significant improvement against Synapse Analytics. KB442293 : In-Memory query optimization to improve performance by. In the Platform Analytics directory, located at C:Program Files (x86)MicroStrategyPlatform Analytics, open the conf folder. 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. Stored calculations for compound metrics. Cube index generation will increase cube size. The basics of this feature are covered in KB235131. Oversee all IT SaaS strategy, create and execute digital transformation roadmap, and identify ways to. Select the database instance to delete. 2. It allows companies to evaluate the effectiveness and efficiency of their investments and make informed decisions based on concrete data. x. IUsers of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Open the Workstation window. Starting from MicroStrategy 10 – you’ll see tge optimized form of Intelligent Cube based reports SQL modified as below with better optimizations. Further in order to enhance the performance and quality of the reports produced we can follow the fundamental paths. Apply the year prompt to to view filter of the intelligent cube report and the report filter regular report. Open the cube for editing. From the Data menu, select Grid Data Options. Update Cube Data *. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. Select the data set and click Prepare Data. Example Performance Data. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. In Project Configurations, reduce the cube index growth limit setting to the minimum value of 50%. For background. Pros and Cons. For background. This privilege is part of OLAP Services. Share query results in-memory across multiple dossiers and. To plan for these memory requirements, see the System Administration Guide. Starting from MicroStrategy 9. 5 compared to ODBC call 2. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. This copy of report data is stored in Intelligence Server memory only. A set of data is returned from the. However, subset. Derived element with calculation type degrades execution performance in a cube report with large data and many derived metrics in MicroStrategy OLAP Services 9. To do so, you can take advantage of URL API. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". 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. The cube is based on a MDX datasource, specifically SAP BW. Use a cube with MicroStrategy if you're only concerned with last month’s aggregated data. Some of the important points discussed can be summarized as: Metadata modeling is a complex task, so set aside sufficient time for this activity. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. Required Status to Perform Action. After you have created your Intelligent Cube, you can publish. 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. MicroStrategy is constantly iterating, importing, and creating new features to ensure our customers are having the best experience. 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. 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. 6. You can edit project-level cache and Intelligent Cube settings. x. x from any unexpected conditions. 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. 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. Can benefit from spark new features and ecology. You could do this by partitioning and compressing data and by using a columnar format for storage. 0". 3. More about Feature flags can be found in this article. 5. Strong semantic layer to define all the business rules and tightly coupled. 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. The main reasons an Intelligent Cube size would increase after publishing is for the following reasons: Cube Index generation. It does not tell us anything helpful and we should not use it as a point of reference. You could do this by partitioning and compressing data and by using a columnar format for storage. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. 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. AI and Machine Learning. 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. When a remote accesses this cube, the cube is loaded into memory of the. Restart the Intelligent Server. For troubleshooting and diagnostics logging routines related to MDX cube sources, see the Troubleshooting section of the System Administration Help. These enhancements include: Improved Data Compression: New data compression algorithms enable MicroStrategy’s In-memory cubes to store up to three times as much data as before. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). 4. Retail is leveling up with omnichannel analytics. Answer: Go with dossier. To improve the cube publish performance for Oracle, we tried using different ArraySize values and found a more suitable range against the use case. Use Cube Advisor to create Intelligent Cubes: 1. 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. Hit Count - This count tracks how many times the in-memory version of the Intelligent Cube cache is hit. The ability to view or edit certain settings is determined by a user's privileges. 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. 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. Slice and dice features are awesome. After you find the microstrategy. In some business scenarios, it is required to filter data for current month in cube report with view filter in MicroStrategy 9. x that handles the execution of queries and management of the database connections. These changes are to both defect fixes and enhancements for a more stable and robust reporting. 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. Users may find additional information related to managing and using Intelligent Cubes in. 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 access this VLDB,. The metric calculates at the level of the target, if possible. Create a report with the year and quarter attributes and the profit metric. 0 MicroStrategy introduced the 'Platform Analytics' application, which helps monitor and track object usage across the MicroStrategy platform in real time. At the time of the editing, the execution of that SQL may be too slow due to performance problems or because it retrieves too much data, or may actually time out. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Web Open the Settings page (right click the extension and select Options). 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. 4. MicroStrategy. 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. 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. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. 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. Note that the behavior is the same when searching for the cube in MicroStrategy Developer via Tools > Search for Objects: CAUSEEnable dynamic sourcing for the project and other aspects of the MicroStrategy system. PublishCube". An Intelligent Cube publication takes significantly long to complete publication (several hours). hasMoreElements ()) { //Get the intelligent cubes for one project Caches cubesPerProject = cubesEnum. sh to produce 1000 test messages as follows: Sorted by: 3. The below are examples for a few of the common metadata database platforms. All necessary privileges are included in the Administrator role by default. Steps to reproduce Log in to an environment in MicroStrategy Workstation using. x). You can edit project-level cache and Intelligent Cube settings. 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 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. Increasing this setting can increase caching efficiency in cases. 3. 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. Bulk Insert. 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. In MicroStrategy Web, click "Access External Data"; In the "Connect to Your Data" window, click the "Manage Your Datasets" link in left-bottom corner, as shown below: In Data Storage window, right mouse click the cube and choose "Schedule", a sub context menu displays all the existing schedule. Install MicroStrategy 10. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. The fix works when the. The binary generated for this mode is different from the binary generated for PDF. 3. x - 10. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. To solve this problem, we introduce a new registry key, " Respect. A code fix is provided. In the Folder List, right-click the project and choose Project. The following line chart. Intelligent Cube storage on disk mirrors report cache storage. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. SAP Data Warehouse Optimizations. 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. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. How to increase the Java Heap size. If the cube and subset report have similar objects, a best practice is to use the cube as the dataset instead of subset report. To define an incremental refresh report. x releases, and the new Multi-table Data Import (MTDI) cubes introduced in 10. 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. Users can also seamlessly drill down from data in an in-memory cube, to detail data in RDBMS and further detail in Amazon Redshift. Course Categories. Administrators can use this analysis area to understand what effect the server and project governing settings and usage patterns have on the system. Unified calculation engine for building and querying; 3. Place Intelligence Server close to the both the data warehouse and the metadata repository. Therefore we need 20GB RAM memory to store the cube. Cube Info Cache creation. Locate and execute the MicroStrategy Enterprise Manager report to provide additional performance benefit information on each Intelligent Cube recommended by Cube Advisor. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. The application is named MicroStrategy Cube. The ID of the Job would be useful in order to read the job trace. Use Case 4. This article explains why MicroStrategy 2021 Update 1 requires additional disk space when publishing a cube to improve cube loading times. Telcos using MicroStrategy can run. This is helpful if the Intelligent Cube is used in an internationalized environment that supports multiple languages. out. If you use Enterprise Manager, dedicate a machine for the Enterprise. The Data Partition options are displayed. Note: number of columns should be the same as in the original file. If it is not possible to improve data consistency in the database, the Intelligent Cube report may be configured to normalize data in the Intelligence Server. Select SINKS and click the + New Sink button. 2. Click All Objects View. VLDB properties allow you to customize the SQL that MicroStrategy generates. x) or OLAP (first generation of in memory cubes, introduced in 9. Collect statistics on the tables 5. There is a substantial increase in complex query performance; 4. Use mstr_ko. 4, the Data Import functionality utilizes multiple threads to improve the cube publishing time, when performing a data import against CSV/Text files. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. To improve 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. Disk Once the cube is published, the Intelligence Server where the cube was published will back up the cube files on a disk. 11 it is possible to have split child hierarchy attributes join through a shared fact table rather than through a parent with Data Import Cubes. In other words, you should partition. The Options dialog box opens. To Define Limits for the Intelligent Cube Indexes. Impact: Performance, security. Number. After the fix, if user examine the Query Detail, CSI should show reused temporary cube. Click on 'Catalog Options' to open the Warehouse Catalog Options. Stay up to date on inventory needs and avoid. In versions prior to 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. Loading × Sorry to interruptIncremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Create a new variable and assign SuperCube with two parameters inside – connection and id. Maintain your competitive edge with a data-driven retail app designed to scale—from individual. x and 10. and access_transactions is heavily indexed because it's critical to the performance of joining and filtering all of the tables that relate through access_transaction (lu_object, lu_account, fact_action_cube_cache, etc. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. This presentation helps users understand MicroStrategy's in-memory architecture. 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. Community & Support Search Discussions Open A Case View My CasesImproving Response Time: Caching. This article reviews the following approaches you can take to improve MicroStrategy performance on SAP HANA. The performance improvement varies based on the CPU cores, memory, file size and the Operation. This name change is visible in. Unified calculation engine for building and querying; 3. One way to free memory on Intelligence Server, which can improve Intelligence Server performance, is to temporarily unload an Intelligent Cube from memory. This " How to" knowledge base article explains cube advisor. The Performance Analysis folder has several reports and two folders, each with its own related area of analysis: •. 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 Intelligent Cube for which you want to define the incremental refresh. API Management and Testing. MicroStrategy Parameterized Query feature for better performance. 3% of resumes. Use Index on all Key columns ( for conditions from WHERE clause,. About the build/query performance tuning of Apache Kylin4. 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. It is local to the node and is reset every time the cube is unloaded/loaded. When running an integrity test, users might want to get the execution time of the report or document. 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. Prior to 10. This can be achieved via the report level VLDB property > SQL Time. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. This article discusses Data Engine changes that may impact customers data when upgrading to MicroStrategy 2019. The data get's fresher, faster, and less resources consuming for everyone. Session Recovery is a new feature in MicroStrategy 10. While OLAP cubes were limited to 2 billion rows, PRIME OLAP cubes can be divided into. instead of storing all data in-memory as a normal Intelligent Cube. The MicroStrategy Intelligence Server 9. The first step in analyzing. Complete the "sessionState" field (e. Connectivity. Select the Data Partition category. Cloud Computing.