The range of analytical functionality of MicroStrategy is supplemented by the features and processing power provided by SQL Data Warehouse. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. MCE features a fully optimized version of the MicroStrategy Intelligence Platform built specifically forThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions:. 4. x Attributes used in the filter should also be on the Intelligent Cube’s definition. KB32618: How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. The Editor and Filter panels are stacked together by default. IS_CUBE_ACT_ID. Number of Views 18. In MicroStrategy, users can trace MicroStrategy Intelligent Cube activity via the Cube Server Trace which can be enabled through MicroStrategy Diagnositcs Configuration as seen below: The following section displays excerpt from the Cube Server trace when different actions are performed on the MicroStrategy Intelligent Cube. Easily add or change pre- and post- SQL statements. 3. The Intelligent Cube that serves as the source for the example view report is configured to normalize incoming attribute data in the database using the option "Normalize Intelligent Cube data basing on dimensions with NO attribute. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. After the Intelligent Cube has finished republishing, the Cube. How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. For example, derived metrics can be used to subtract the data of one. Job ID for the action on the Intelligent Cube. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. Report runtime performance for reports accessing Intelligent Cubes can be negatively affected as the Intelligent Cube must first be loaded into Intelligence Server. 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. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. MicroStrategy Internal Reference Number for this technical note. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Microstrategy Dossiers With the release of MicroStrategy 10. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). IS_CUBE_INST_ID. Navigate to the Data Refresh category. Existing best practice recommendations for needle and syringe programs are out of date. KB47254: How to create a subscription to refresh Intelligent Cubes using MicroStrategy Command Manager 9. Recorded at World 2021. 1K. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. Start Learning with us ACTE MicroStrategy. 98K. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. Description. Description. The user then updates the cube. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. First, you open a blank document and select a report to use as the document's dataset. x improves the performance of user reports by executing reports against published Intelligent Cubes, when the SQL generation engine is able to determine that the cube contains all information required for the report. A set of data is returned from the. You will also work on real-world projects to gain hands-on experience. Learn more about it at MicroStrategy. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. com Format: A MicroStrategy Online Training Video blog. 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. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Number of Views 15. 4. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. 12K. Dossier shows different data when In-Memory Intelligent Cube dataset is changed to Live mode. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. with Gateway Agent enabled and disabled. 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. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. x - 10. Recommended for Platform Administrators, System Administrators, and Intelligence Directors, this session provides a foundational understanding of how Platform Analytics works and the reporting capabilities it offers. x, but not to publish it, the minimum privileges that the Administrator would need to. Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. x: Back up metadata before copying any objects. Source: MicroRooster. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. The considerations and steps required to fully support dynamic sourcing are listed below: While many MicroStrategy features can be used with dynamic sourcing, some features may prevent the use of dynamic sourcing between reports and Intelligent Cubes. Run the Report and check the SQL View. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\log. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformHello<br><br>Please allow me to elucidate how my data analyst skills can significantly contribute to your organisation's business growth. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. To stay current with the best available scientific evidence and ensure that people have. The steps to create an intelligent cube are as follows: Navigate to the folder where you want to create an intelligent cube; the best practice is to create it under Public Objects | Reports . Select data population for Intelligent Cubes. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best Practices . Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. x and 10. view reports. Place Intelligence Server close to the both the data warehouse and the metadata repository. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. This technical note outlines how to set. x?This is a guest blog post co-written by Amit Nayak at Microstrategy. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. The Data Transfer Rate varies from 27 to 28 Mb/s. 27K. x and 10. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. For details, please refer to the Technical Note below. x. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). It performs reporting requests through windows, web, and remote interfaces. 2. This article covers best practices for the following topics: 1. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. 0, the only way to create an intelligent cube (also. The second part discusses the common challenges and better practices on using Snowflake as a warehouse in MicroStrategy, and the third part discusses making it available to business users and self-service users. From the Data menu, select Configure Intelligent Cube. Publish the Intelligent Cube by executing it on either of the nodes. The report retrieves data from Cube B now. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. x-10. In the Navigation pane, click , next to Datasets. Drag and drop the objects into the report grid from the Report Objects pane. Following are the features, which make intelligent cubes useful. 4. Connectivity. For detailed information refer to the System Administration Help. If you use Enterprise Manager, dedicate a machine for the Enterprise Manager. Currently, project duplication does not involve Intelligent Cube File Directory. Select Build a Query and click Next. For best practices on compatibility and interoperability, as it relates to upgrading a MicroStrategy system,. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. MicroStrategy - Architecture. 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. Best practices for mapping MDX. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. KB37579: Dynamic Sourcing is not used when an Intelligent Cube includes a metric defined as Sum (fact A / fact B) in MicroStrategy 9. Once activated, the user loads the cube in memory. The path for cache files must be shared as "ClusterCaches". The ODBC connection uses 3. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Hands-On Learning in MicroStrategy. x. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Select Intelligent Cubes > General > Intelligent Cube File directory. If the Intelligent Cube must be re-processed based on a metric. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. System Sizing Guidelines The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. For more information on security filters, see the System Administration Guide. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines Place. IS_PROJ_ID. The dataset is a set of data that can be displayed on the document. Click Finish. e. Take a Data Import Cube similar to below. Dynamic Sourcing. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. Therefore we need 20GB RAM memory to store the cube. E. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. 4: Persisted. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. pdf", Dynamic Sourcing -> Best practices for supporting dynamic sourcing -> Dynamic Sourcing for Incrementally refreshed Intelligent Cubes In a MicroStrategy Web dashboard, from the File menu, choose Dashboard Properties. 4. 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. This. with Gateway Agent enabled and disabled. Instead of always executing against the data warehouse. The. Release date: July 2016. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Published: Dec 31, 2018 Intelligent Cubes. How to Import Data from a SAP HANA Database Into MicroStrategy Web. In section General at the bottom of displayed window there is a check box with option "Hidden". In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. Setting Up an Analytics Semantic Layer and Public Objects. VI). Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. IS_CUBE_REP_ID. To do so, you can take advantage of URL API. MicroStrategy’s In-memory technology is engineered to meet the. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. 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. Before MicroStrategy 10. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. Starting in MicroStrategy 10. A report that runs against the Intelligent Cube. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. Likewise, Analysis Services, Oracle Essbase, and TM1 store data. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. 4. IsCubeRepStats, but not in PA warehouse tables LU_CACHE or fact_latest_cube_cache . The Full Refresh option is the default. 4. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. The MicroStrategy certification training course is designed for those who wish to enhance their knowledge and skills in the field of Business Intelligence and Data Warehousing. In MicroStrategy 10. We, at Intellipaat, provide the best online classes to help you learn its architecture, database connections, cubes, clustering, and security models. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. 0 has a dedicated section to memory used for Intelligent Cubes. Disconnect from the project source and restart both Intelligence servers. Description. There are multiple ways to intervene the database to generate a better SQL execution plan. By default, the template is 3x3. You can edit project-level cache and Intelligent Cube settings. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Integer ID of the project where the Intelligent Cube is stored. Object Migration Best Practices. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. Afterwards MTDI cubes should appear as visible from default. Edit Project-Level Cache and Intelligent Cube Settings. The columns ID1 and ID2 correspond to attributes and M1 corresponds to a metric. To enable or disable dynamic sourcing for an Intelligent Cube. To enable or disable dynamic sourcing for an Intelligent Cube. x to 11. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). Use this option under the following conditions: If the data in the Intelligent Cube is outdated. 4, the below command does not work for Data Import cube: LIST [ALL] PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "<intelligent_cube_name>" [FOLDER "<folder_name>"]) FOR PROJECT "<project_name>" However using cube GUID will return correct result: CAUSE: This is a. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. Start a Pilot Solutions Powerful analytics for any industry. 4. The main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loaded. table_name: is the name of a table. Check the location of the new cube cache and notice that it is saved in the default location, i. To enable. The report and Intelligent Cube must be based on the same source MDX cube. KB33244: Are there any limits imposed on Intelligent Cube size in. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. ACTION: 1. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes"Best Practices Super Cubes in MicroStrategy 2019. Designing and creating documents: An overview. x product documentation "InMemoryAnalytics. Defining the partition for Super Cubes. First, you open a blank document and select a report to use as the document's dataset. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. x MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. 1. All articles. x environment, Cache Hit Count or the Last Hit Time of a. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. If user downloads the . Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Such instances can be a problem, as they may impact the accuracy of your data analysis. Number of Views 18. Document number: 09481030Our product specialists walk you through best practices for successfully setting up and configuring the out-of-the-box tool Platform Analytics tool. Resources Company Bitcoin Lightning Home Published: August 11, 2022 • 619 Views Advanced Properties for Intelligent Cubes MicroStrategy Workstation. 0. After completing your certification, you’ll receive a digital badge that highlights your accomplishment, which you can post on social media. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The Training Metric Wizard opens. It depends on the cube. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. This documentation is intended to provide some guidelines for BI administrators to maintain Messaging Services. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. Rather than returning data from the data warehouse for a single. Intelligent Cubes Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. Intelligent Cubes. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Click the Cube Mapping tab. Shipped vs Native. McLean, Va. Do you have reports that currently access. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. I possess exceptional proficiency in analysing extensive data sets, deciphering intricate trends, patterns, and customer behaviors, and unveiling invaluable insights that may otherwise remain concealed. What to read next? Nothing to see here. 3. 1. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). KB415730. Before MicroStrategy 10. These Intelligent Cubes are created in a folder along with shortcuts to all the reports that can connect to the Intelligent Cube using dynamic sourcing. It remains available, but is not enforced if it is less than the default value of 100000. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. Version 9. MDX, CSI" in Web. 4. Integer ID of the project where the Intelligent Cube is stored. The attached document details the differences between OLAP and MTDI cubes, including the basis for the performance profile of each and the available. Counts the number of jobs from reports not based on Intelligent Cubes but selected by the engine to go against an Intelligent Cube because the objects on the report matched what is on the Intelligent Cube. 46K. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)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. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. How to configure, monitor, and manage Intelligent Cubes. Dedicate a machine for the metadata repository. x Intelligent Cube status indication and workflow This section describes the ways in which you can design and create a MicroStrategy Report Services document. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. Place Intelligence Server close to the both the data warehouse and the metadata repository. It happens in MicroStrategy Developer 9. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Right mouse click on the cube, and “Search for dependent subscriptions” as shown below; it shows two subscriptions have been created based on the Intelligent Cube. Using Object Manager, the above cube based reports are migrated into Production. x releases. 11, a new feature is available for performance optimization when dealing with derived attributes. x Intelligent Cube status indication and workflow. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Best Practice for interview Preparation Techniques in MicroStrategy. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. In direct connection deployments, client products (such as MicroStrategy Developer) should also. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. Click Close, then "Finish" on the "prepare data" view and save the cube. In MicroStrategy 10. 4. This article describes the Intelligent Cube Population options available in MicroStrategy. MicroStrategy recommends the following best practices to keep your system running smoothly and efficiently: Use the project life cycle of development, testing, production to fully test your reports, metrics, and other objects before releasing them to users. Refer to Product Manual for more detailed information. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. 31K. Open the Workstation window. Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. KB485674: Create Super Cube from Excel file and update it with a script in. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube. 1. A dataset is a set of data that can be displayed on a document. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the. The cube population process is the one that retrieves the information from the Warehouse and transfer it to the MicroStrategy Intelligence Server memory in a format which can readily be consumed by different reports requests. There are multiple components and services replying on MicroStrategy Messaging Services. MicroStrategy has a metadata-driven architecture. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. From the results of single cube publish testing which records and compares the time spent for a single cube (4M rows) republish, JDBC driver has better performance than ODBC driver. These are meant to restrict the ability to perform certain privileged actions. Job ID for the action on the Intelligent Cube. IS_CUBE_REP_ID. By default, the location configured will be a relative path where ". They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. Number of Intelligent. g. Please contact MicroStrategy Technical Support for an update. Navigate to the folder location of the Intelligent Cube. Edit Intelligent Cubes from the new editor in Workstation at any time. Using attributes defined in this way can save space as compared to attributes that use character strings for their ID forms. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. application performance and security best practices. For example, the objects developed in a development environment can be copied to a UAT environment to. Object Migration is the process of migrating or moving objects from one environment to another environment. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. Change Journaling is enabled by default since MicroStrategy version 10. However unlike MicroStrategy it cannot join data between different cubes into the a single visualization. A list of data sources available in this project appear. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. Define MicroStrategy Best practices for development, testing. It lets you various. MDX Cube Reporting Guide Version 10. The report and Intelligent Cube must be based on the same source MDX cube. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. Click All Objects View.