This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. The below are examples for a few of the common metadata database platforms. Answer: Go with dossier. Now there are scenarios where these tables will only have partial data and a join needs to be performed between the tables. Beginning in MicroStrategy 11. VLDB settings 4. Loading × Sorry to interruptIncremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. 19. 1. 3. Login to using your MicroStrategy Resource Center account. Determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results faster and publish Intelligent Cubes. Oversee all IT SaaS strategy, create and execute digital transformation roadmap, and identify ways to. 3% of resumes. 0. x) or OLAP (first generation of in memory cubes, introduced in 9. "Normalize Intelligent Cube/Report data in Intelligence Server" may improve performance, at the cost of additional memory use in the database connection process. 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. (Intelligent Cube configuration is not relevant in MicroStrategy 8. 4. 3. 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. With Redshift Spectrum, you take advantage of a fast, cost-effective engine that minimizes data processed with dynamic partition pruning. Cube Definition ID: The ID for the Intelligent Cube object. Cause: The root cause of the issue is cube template "Blank Emma Cube Report" that is set to hidden. All necessary privileges are included in the Administrator role by default. 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. 4. To get a sneak-peak of new functionalities. This article explains why MicroStrategy 2021 Update 1 requires additional disk space when publishing a cube to improve cube loading times. The database requires create table and drop table privileges for this. Hit Count - This count tracks how many times the in-memory version of the Intelligent Cube cache is hit. Locate the newly imported cube, right-click on it, and choose "Edit. The MicroStrategy Performance Analysis service delivers:. This article reviews the following approaches you can take to improve MicroStrategy performance on SAP HANA. In the Platform Analytics directory, located at C:Program Files (x86)MicroStrategyPlatform Analytics, open the conf folder. . There is a substantial increase in complex query performance; 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. Before you create an Intelligent Cube, search through MicroStrategy to see whether a similar Intelligent Cube already exists that can serve the same. 9 or an older version. g. Use partition mapping 3. You can optionally remove cells that have a value of zero. view reports. Or, navigate to the Data Explorer for the MDX Cube database instance. We have already. Iterate through the enumeration to get the cubes per project and the corresponding status. Option 1: Develop each report in Microstrategy developer using attribute filters as desired. Steps to reproduce. MicroStrategy's support for parameterized queries can improve performance in scenarios that require the insertion of information into a database. MicroStrategy Optimization: HINTS. PATH: is the folder where the intelligent cube resides, returned as a string. it should be large enough to process it quickly. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. 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. Specific jobs will run (in parallel) on Hadoop and then be transfered back to the intelligence server (in parrallel) via TCP. Publish the Intelligent Cube by executing it on either of the nodes. The ID of the Job would be useful in order to read the job trace. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services. Logfilename: This field represents the location of the Metric Levels Log file. x and newer. 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. 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. Learn how to increase the JVM Heap size for Microsoft Internet information services to allow for better performance. 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. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. From the Partition Attribute drop-down, select the partition attribute for the Intelligent Cube. Further in order to enhance the performance and quality of the reports produced we can follow the fundamental paths. Open the Workstation window. An Intelligent Cube is an In-Memory data structure which holds. 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. 7. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. 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. Can benefit from spark new features and ecology. HyperAndroid Go to the Account tab. Locate and execute the MicroStrategy Enterprise Manager report to provide additional performance benefit information on each Intelligent Cube recommended by Cube Advisor. Select data population for Intelligent Cubes. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Best Practices with MicroStrategy. 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. 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). This change improves the performance for memory intensive use scenario also potentially increases the memory footprint for Intelligence Server. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. Use the cube as the dataset for the dashboard and then use view filters however you want on the various. In-store and online. 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. By default, the location configured will be a relative path where ". 11, a new feature is available for performance optimization when dealing with derived attributes. 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. Now offering. Right-click the Intelligent Cube, and select Edit. Distributed query engine,avoid single-point-of-failure; 2. In order to protect both security and performance the MicroStrategy system will compare all of the Security settings in. . 2. Share query results in-memory across multiple dossiers and. Community & Support Search Discussions Open A Case View My CasesImproving Response Time: Caching. There is a substantial increase in complex query performance; 4. Open Windows Services, right-click MicroStrategy Platform Analytics Consumer and select Stop. Timezones can be discovered by running the following command: python3 -c "import pytz; print (pytz. Metro Area. Enterprise Manager provides detailed level tuning data for individual reports, Intelligent Cubes, scheduled operations, and all other parts of the MicroStrategy platform. SAP Data Warehouse Optimizations. 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. Further in order to enhance the performance and quality of the reports produced we can follow the. A good caching strategy can significantly improve system performance. Starting in MicroStrategy 11. Choose Rename. 3. Connectivity. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. 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. Browse resources on demand or contact support directly. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. Refer to Product Manual for more detailed information. HyperIntelligence for Web can only search for a total of 500k keywords and alternate keywords at a time. 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. Providing Intelligent Cube data. The following steps demonstrates how to reproduce the issue in MicroStrategy Tutorial project: Create an intelligent cube with Category, SubCategory, Item, Warranty, Call Center. x. The ability to view or edit certain settings is determined by a user's privileges. x. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. Go to Kafka Connect. 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. Kernel -> Processing Unit Trace – trace tasks execution of a Processing Unit. Choose your preferred method to share the logs. The MicroStrategy Intelligence Server 9. 1. With an increasing number of. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. Edit Project-Level Cache and Intelligent Cube Settings. Run both reports after enabling the metric levels log. Helps optimize custom group banding when using the Count Banding method. Understand your data characters and choose the matched configuration could enhance the performance and accelerate the process to view the latest data. 1669 views. Under CUBE TEMPLATE, choose Default Attribute Form Caching. Purpose of the registry key. This article explains why MicroStrategy 2021 Update 1 requires additional disk space when publishing a cube to improve cube loading times. 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. However, there is no significant improvement against Synapse Analytics. In the Navigation pane, click , next to Datasets. Example Performance Data. CAUSE: CPU information shows this is not an apple-to-apple comparison. This article narrates large cubes appear in ‘LP’ status and some other cubes not shown up in cube monitor in MicroStrategy 2021 is due to loading cube info thread being blocked by loading the large cube instance. “With a nearly 30-year. 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. Use Cube Advisor to create Intelligent Cubes: 1. Optimize Aggregation : Generates optimized views based on collected. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. VLDB properties can also be used in order to optimize report. In MicroStrategy 10. 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. 2. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. The cube is based on a MDX datasource, specifically SAP BW. This may be done in one of two ways: Reenter the MDX Cube Catalog, switch to the cube mapping, and select the cube that was just imported. In Developer, log in to a project with a user account with administrative privileges. Because Direct Data. •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. 4 to MicroStrategy 2019 Update 2. 2. 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. 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. Details on MicroStrategy recommendations can be found in this TN. The telemetry generated from these actions was processed by the Telemetry Store and loaded into the Platform Analytics warehouse. 2. They are temporary in nature and hold intermediate results. Regular OLAP Intelligent Cubes allowed the storage of certain subsets of data to remain in memory for faster access and improved performance. 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. This presentation helps users understand MicroStrategy's in-memory architecture. For example, you can choose to add or delete data from the Intelligent Cube. Logs name for PU, Command ID, and execution Status. Number of Views 524. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more cardinality means the attribute with more different elements, for example in the Tutorial project the. Since the modifications made in the cube are reflected instantly, you don’t. We can try to use different aggregations groups to improve the query performance of some very important Dim or a Dim with high cardinality. Smart. This is particularly useful when there exist many Intelligent Cubes that have to be published but require a high amount of memory in the process so executing them, all at the same time is not feasible. 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. Use Aggregate tables 2. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. 4. println ("For project: " + cubesPerProject. 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. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. By default, MicroStrategy uses ODBC call 3. 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. The. It is especially useful when data source contains huge data amount. MicroStrategy is constantly iterating, importing, and creating new features to ensure our customers are having the best experience. e. CI/CD Devops. sh to produce 1000 test messages as follows: Sorted by: 3. 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. In Developer, log in to the project source for your project. CAUSE: CPU information shows this is not an apple-to-apple comparison. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. Data loads and refreshes are too long, data freshness can. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. 6. It is local to the node and is reset every time the cube is unloaded/loaded. You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice. For example, you can choose to add or delete data from the Intelligent Cube. 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. Strong semantic layer to define all the business rules and tightly coupled. x and newer. Based on performance concerns, the Intelligence Server will also save other remote cluster node's cube lookup indexes in-memory. x and 10. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. 11, 10. While OLAP cubes were limited to 2 billion rows, PRIME OLAP cubes can be divided into. 0. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. Step 1. x - 10. To define an incremental refresh report. However, users. Select the environment and project where you want to. The metric calculates at the level of the target, if possible. The data get's fresher, faster, and less resources consuming for everyone. 2. , UNION, INTERSECT, EXCEPT). Every newly created MTDI cube will inherit settings from this template and automatically be created. B) Example of an optimal, unified card. To check if these cubes can potentially be reduced in size an audit can be performed on the cube objects to see which cube objects are not being used by any of the view reports, documents, or dossiers. x that handles the execution of queries and management of the database connections. 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. MicroStrategy PRIME is a new feature added to the MicroStrategy 10 Secure Enterprise Platform. 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. Developers gain tuning insights to improve project performance. x environments. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Expand Intelligent Cubes, and then select General. While this can improve performance of these reports, loading too much data onto Intelligence Server memory can have a negative impact on Intelligence Server's ability to process jobs. Members," which identifies the current level within the hierarchy and evaluates the rank over all the. 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. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. The MicroStrategy Intelligence Server 9. Business Intelligence and Analytics. Open Confluent Control Center. Connect to your database using SQL Server Management Studio and in the left pane select your Metadata database. For example, if they open a dashboard, document, or report and step away from the desk, their user session can. •. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. This knowledge base article describes a behavior in MicroStrategy 10. 2. Purpose of the registry key. The default is 1000 Intelligent Cubes. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Right-click the project and select Project Configuration. 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. 4. Note that only the naming convention has changed, as the functionality remains the same. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. Defines whether to attempt to improve performance of reports that use expression-based transformations. You can learn more about Enterprise Manager in the following documentation resources:In MicroStrategy Desktop 9. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Click View Logs, to display the share icon in the upper-left. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. Fewer slices improve a cube’s performance. 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. Step 1: Optimizing HyperIntelligence Datasets. This attribute should have a lookup table in the SQL data warehouse. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. To solve this problem, we introduce a new registry key, " Respect. The MicroStrategy Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Full control. • Do not add a fake. 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. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. From the kafka_mstr_cubewriter, run KMCW with the command: bin/kafka_mstr_cubewriter. Create an Attribute Form Caching Cube. . Step 2. 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. …Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. 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. x and newer. 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. Rather than returning data from the data warehouse for a single. 2. So the build/query performance tuning is very different from Kylin 3 tuning. The Hadoop Gateway specifically optimizes the performance of cube publication by reducing the data fetch and transfer time. Published: Jun 7, 2017 Last updated: Jun 7, 2017 In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. If the configuration settings are correct the following will happen: KMCW connects to MicroStrategy and crates a new cube. 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. Answer: Go with dossier. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. 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. In 11. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. Kernel -> Processing Unit Trace – trace tasks execution of a Processing Unit. MDX cubes are also referred to as MDX cube sources. You can try to clear the page cache to see if performance improves. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. The following line chart. Hadoop Gateway transfers data in parallel without the need for ODBC/JDBC driver. Available PA data is stored in the cube that has a default limit set to 20GB or RAM. These changes are to both defect fixes and enhancements for a more stable and robust reporting. In-store and online. 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. An Intelligent Cube publication takes significantly long to complete publication (several hours). Prerequisites •From MicroStrategy 11. Login to MicroStrategy Web, create a cube with the function of Data Import. The M8MulPrc/M8MulPrc_32 process is a database connection process spawned from the MicroStrategy Intelligence Server 9. Create a second report with the year and quarter attributes and the revenue metric. 4. The MicroStrategy Intelligence Server 9. Regression DefectThe MicroStrategy Internal Reference Number for the issue discussed in this technical note is KB442296 and DE91603. Choose Data > Configure Intelligent Cube. The cube is based on a MDX datasource, specifically SAP BW. With Parallel Hierarchy. Summary. 3. Expand Intelligent Cubes, and then select General. In the next screen, select MicroStrategySink connector class and set the connector name, that will show up in the Kafka Connect list of Sinks. 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. Steps to Modify the View Date Range. This provides improved performance when querying in-memory cubes. An Architect creates, publishes, and optimizes a federated data layer as the enterprise’s single version of the truth. all_timezones)"With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. nextElement (); System. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. 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 Rename an object within the card: Place the object in the HyperIntelligence card. 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. Please refer to Improving Report and Cube Performance to learn more about it. instead of storing all data in-memory as a normal Intelligent Cube. Intelligent Cubes improve performance and user experience by pre-aggregating and pre-calculating the data. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. This will influence the user experience. Intelligent Cube, or on-demand retrieval using live mode. When a remote accesses this cube, the cube is loaded into memory of the. However, after publishing,. 3. 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 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. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 2. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. If the relations are modified in the cube editor, the cube has to be re-published to be used again. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Create a new variable and assign SuperCube with two parameters inside – connection and id. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. 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. Select the Enable report drilling check box. Open the cube for editing. In MicroStrategy 9. Select the database instance to delete. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. MicroStrategy Parameterized Query feature for better performance. g. Use a cube with MicroStrategy if you're only concerned with last month’s aggregated data. To build an Intelligent Cube. KMCW connects to Kafka brokers and reads topics. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Required Status to Perform Action. Pros and Cons. It accesses and joins data. To Define Limits for the Intelligent Cube Indexes. Users in order to see them have to go to the object and un-hide it. Derived metrics; Subtotals; Multi-pass queries against Multi-Table Data Import (MTDI) cubes Refer to Technical Document below on how to enable the VLDB: KB44052: How does the feature in the MicroStrategy 9. For Oracle 12. x-11. In the bottom section, under Destination note the location of. When a derived attribute is built off of data from a single live data import cube, then the calculation of the derived attribute will be pushed down into the query against the data source rather than being done in the. out. Slice and dice features are awesome. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. All necessary privileges are included in the Administrator role by default. Starting in MicroStrategy ONE Update 10 you can improve the performance of project loading and schema updates. This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Review steps below to improve bulk data load from Redshift to MicroStrategy. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 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. x from any unexpected conditions. Starting 10. Every customer can take advantage of the lookup caching cube to improve report and cube performance by up to 30% against the data warehouse. All Intelligent Cube operations are listed below: 1. Cube advisor. Restart the Intelligent Server. Problem is: 100% in-memory solutions cannot fit all your requirements.