The. x and later, users should make sure to take into account the following guidelinesIt describes how MicroStrategy Intelligence Server converts MDX cube source data and objects into MicroStrategy using MultiDimensional Expressions (MDX). In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. Memory Storage for document or dossier. Dossier shows different data when In-Memory Intelligent Cube dataset is changed to Live mode. The report and Intelligent Cube must be based on the same source MDX cube. x 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. Release date: July 2016. Click Finish. Easily add or change pre- and post- SQL statements. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. 3. The Intelligence Server will then join all the dataset results into one master table, called the virtual dataset or master dataset, to store in memory. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 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. To do so, you can take advantage of URL API. The Intelligent Cube opens in the Report Editor. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and cube optimization techniques for MicroStrategy. Dedicate a machine for the metadata repository. 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. How to configure, monitor, and manage Intelligent Cubes. 5K KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best PracticesMicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\log. Learn more about it at MicroStrategy. x installation and deployment. 1 or later, with the following characteristics:. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. x. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. MicroStrategy version 9. 1 and 10. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. x. In section General at the bottom of displayed window there is a check box with option "Hidden". Now that that’s settled, let’s jump into some best practices for. Afterwards MTDI cubes should appear as visible from default. Click Close, then "Finish" on the "prepare data" view and save the cube. 1. IS_CUBE_INST_ID. III. It will track and log all. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. To enable. OLAP vs MTDI and Best Practices. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in. Part 1. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. GUID of the Intelligent Cube instance in memory. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesIn MicroStrategy 9. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Defining Intelligent Cube refresh settings. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. A bar in the microchart represents that the report is covered by the Intelligent Cube and no bar means that report is not covered by the Intelligent Cube. Share query results in-memory across multiple dossiers and. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). Dynamic Sourcing. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. Description. An Intelligent Cube is an In-Memory data structure which. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. These. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. 0. For example, derived metrics can be used to subtract the data of one. 3 - Check the Make Intelligent. Solution Gallery. KB33244: Are there any limits imposed on Intelligent Cube size in. 29K. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. Privileges are given on a per-user basis, some of which are also per-Application. KB439693: Best practices for MicroStrategy 10. rare practice (British Columbia Ministry of Education, 2011, p. A set of data is returned from the. IS_CUBE_REP_ID. Published: Dec 31, 2018; Last updated: Jul 25, 2023Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. Notice surprising patterns with visualizations. What are the methods to implement Intelligent cube technology in MicroStrategy? Intelligent cubes allow a user to access OLAP service features on reports, a shared set of data can be shared among multiple reports. Dedicate a machine for the metadata repository. Defining the partition for Super Cubes. Rather than returning data from the data warehouse for a single. 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. 88K. 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. Intelligence Server Statistics . KB441987: Best Practices for increasing performance of publishing. MicroStrategy 9. MicroStrategy OLAP Services는 분석 엔진으로 조작할 수 있는 보고서의 메모리 내 버전인 Intelligent Cube의 개념을 사용합니다. Since this is the first time the cube and cube based objects are being migrated into Production, there is no conflict resolution and all the new objects are copied into. We’ll summarize how you can use collected data to help you effectively and efficiently manage and maintain peak performance across your MicroStrategy ecosystem, and walk you through tips and. 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. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. This can be done in one node of the cluster because the information is stored in the metadata then used. The metadata is a central repository, which stores all the objects used by it. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Right-click the project and select Project Configuration. More about Feature flags can be found in this article. In MicroStrategy Desktop 9. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. MicroStrategy Platform is an enterprise analytics, data management, and BI software platform for managing big data. x Attributes used in the filter should also be on the Intelligent Cube’s definition. Please make sure that this is disabled. The Java XML API log will record all the XML communications between Intelligence Server and Web. The New Intelligent Cube dialog box opens. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. Prompts in a report. x releases. These reports allow data to be returned from the. 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. From the Data menu, select Configure Intelligent Cube. 0 MicroStrategy releases. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and cube optimization techniques for MicroStrategy. Compound attributes and joint element lists. Dozens of Intelligent Cube caches are invisible in one Intelligence Server among the six nodes cluster in MicroStrategy 2021 GA, is due to Intelligence Server starting up before mount of the cube shared location. Published: How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. With OLAP Services features, your report designers can create Intelligent Cube reports. 3. Hands-On Learning in MicroStrategy. 15K. The path for cube files must be shared as "ClusterCube". View the report in either Grid View or Grid and Graph View. Disable catalog cache via Developer. 3. 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. x? Intelligence Portal, Query Tone, Rapid Application Development, MicroStrategy Intelligent Cubes, The Foundation For Intelligent E-Business, The Integrated Business Intelligence Platform Built For The Enterprise, The Platform For Intelligent E-Business, The Scalable Busin ess Intelligence Platform To enable or disable dynamic sourcing for an Intelligent Cube. To create an Intelligent Cube by creating XQuery. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. Discover MicroStrategy 2021 > It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. -10. IS_CUBE_INST_ID. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Within the set. x Intelligent Cube status indication and workflow. Title: Mastering Business Intelligence with MicroStrategy. You should periodically reevaluate the system and. CREATOR: User who created the Intelligent Cube cache, returned as a string. Select Build a Query and click Next. The objects stored in the metadata are reusable. Accessibility and 508 Compliance. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube. Author (s): Dmitry Anoshin, Himani Rana, Ning Ma. 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). Watch on. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. MicroStrategy tested on an Intelligence Server instance with 32 vCPUs 256 GB of memory, importing 10x UB data (about a 11G CSV file) from URL. While some duplicate columns in a MicroStrategy schema are necessary or benign, a user may experience issues that require the assistance of Technical Support in. PlatformAnalytics. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. Number of Views 5. A document is used to format data from multiple datasets in a single display of presentation quality. This section describes only the most basic guidelines. 4. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. Getting Started with MicroStrategy. To identify if your cube is MTDI or OLAP it’s really simple, if the cube was created through the Data Import Web Interface (“Add External Data” section on MicroStrategy Web. Set the path for the cube cache file directory to . This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. Published: Apr 6, 2017. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. 0, the only way to create an intelligent cube (also. MicroStrategy Internal Reference Number for this technical note. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. x) and view reports based on MicroStrategy 9. 1. ACTION:15. 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. When you choose to filter data within another dossier, you also have the option to pass the filter conditions in the source dossier to the. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. x to 11. Following are the features, which make intelligent cubes useful. 4. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. From the Edit menu, select Training Metric Wizard. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. Hands-On Learning in MicroStrategy. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. The status of each Intelligent Cube is listed in the. Select the data set and click Prepare Data. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. x and 10. x: Back up metadata before copying any objects. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Number of Intelligent. * MicroStrategy does have support for dynamic sourcing with MDX sources. 0. Click All Objects View. 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 . VI). 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. By default, the location configured will be a relative path where ". Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. Shipped vs Native. The Intelligent Cube Options dialog box opens. Starting in MicroStrategy 10. Best practice to split large files in Linux Operating Systems. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. 8 to help improve the performance of Quick Search on MicroStrategy Web. If user downloads the . In MicroStrategy Developer, right-click on the intelligent cube and select Edit. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. Visit the data visualization and data dashboard galleries for inspiration. 4. 4. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and cube optimization techniques for MicroStrategy. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Query Generation 3. Source: MicroRooster. Configure a Cluster with a Centralized Cache. 31K. In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. Select a database configured for SAP HANA. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 3. Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. It serves as the starting point for new developers to getThis article describes the best practices for using dynamic sourcing in MicroStrategy. KB32618: How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. Take a Data Import Cube similar to below. It performs reporting requests through windows, web, and remote interfaces. IS_PROJ_ID. The tooltip will show the dataset type listed as a Super Cube. x?This is a guest blog post co-written by Amit Nayak at Microstrategy. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. MicroStrategy Intelligence Server will submit all queries as prepared statements if the following registry key is created on the Intelligence Server machine:To Create an Intelligent Cube Using Freeform SQL or Query Builder. x. The related section is located in. Integer ID of the project where the Intelligent Cube is stored. Lastly, you will learn to use Hadoop for MicroStrategy reporting. A dataset is a set of data that can be displayed on a document. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". To Create an Intelligent Cube Using Freeform SQL or Query Builder. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;This section describes the ways in which you can design and create a MicroStrategy Report Services document. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. Job ID for the action on the Intelligent Cube. 12K. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. xTo Create a Report that Accesses an Intelligent Cube. 4. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. 3. 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. However, if the. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 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. 4. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. MDX Cube Reporting Guide Version 10. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines Place. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. Create an Intelligent Cube with attributes Year, Month and Region; 4. x. 13K KB31566: MicroStrategy 9. IS_CUBE_REP_ID. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. KB36667: Best practices for Dynamic Sourcing in MicroStrategy. In MicroStrategy Desktop 9. If the Intelligent Cube must be re-processed based on a metric. 8: Monitoring information dirty. There are multiple ways to intervene the database to generate a better SQL execution plan. 27K. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Define MicroStrategy Best practices for development, testing. The first step in analyzing. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. x. x. 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. Publish the cube. Best Practices for MicroStrategy Messaging Services. This command will deactivate the Intelligent Cube cache so reports from this Intelligent Cube will not be able to run while it is being re-published. Number of Views 8. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. Disconnect from the project source and restart both Intelligence servers. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. The Editor and Filter panels are stacked together by default. x Intelligent Cubes. . Afterwards the cube will start executing. Open the Workstation window. Number of Views 15. Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Create Cube B which contains all objects in the report and publish it . The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load processes. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Version 10. This article describes best practices to be taken when using a Teradata database in MicroStrategy. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence Server This article describes features that are not supported when using Dynamic Sourcing. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. Recorded at World 2021. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. PublishCube". In MicroStrategy Intelligence Server 9. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. First, you open a blank document and select a report to use as the document's dataset. The MicroStrategy Cloud Environment (MCE or MicroStrategy Cloud) is a platform-as-a-service (PaaS) offering that MicroStrategy manages on its customers’ behalf as a unique Amazon Web Services (AWS) or Microsoft Azure implementation. Choose File > New > Intelligent Cube. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. The New Grid dialog box opens. x. Intelligent Cubes erstellen. In MicroStrategy 10. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Run the Report and check the SQL View. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. 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. ACTION: 1. WORKAROUND . Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Best Practice for interview Preparation Techniques in MicroStrategy. Ensure your data does not exceed the following maximum file sizes: File from disk: 4G. 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. Description: Intelligent Cube design and utilization; how to build cubes. Currently, project duplication does not involve Intelligent Cube File Directory. The main open-source visualization tool, Kibana, that is used to connect to ElasticSearch is fairly limited in its visualization capabilities. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. You should periodically reevaluate the system and update it based on actual system performance and use. 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" The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. KB321029: In MicroStrategy 10. 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. 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. Therefore we need 20GB RAM memory to store the cube. x?Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. 4: Persisted. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. The Data Transfer Rate varies from 27 to 28 Mb/s. 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. Choose File > New > Intelligent Cube. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. x-10. Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. Check the location of the new cube cache and notice that it is saved in the default location, i. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. Go to the "All Objects View" option in the top left corner. Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. x. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy environment. 4. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. In MicroStrategy 10. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. It will track and log all communications at the “XML API. Document Number: 09481030. Create Cube A and a report based on it. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. Best practices to design or utilize mobile dashboards in offline mode in MicroStrategy Mobile. 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. 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. xIn 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.