x ODBC calls by default. In Intelligent Cube editor, the default display attribute forms cannot be modified after choosing "Use the following attribute forms" and adding a new attribute form in "Attribute Display". The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. Description. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Such instances can be a problem, as they may impact the accuracy of your data analysis. 3. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. Using. SHOPMAN, powered by MicroStrategy, delivers sensor data, inventory management, and financial data to enable users make data-driven. C:Program Files (x86)MicroStrategyWeb ASPxWEB-INFlog. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 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%. KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. Tell a story with your data using the dossier chapter/page format. It must be ensured that the Windows NT account used to run the MicroStrategy Intelligence Server on every node has access to the shared folders. A dataset is a set of data that can be displayed on a document. Dedicate a machine for the metadata repository. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. MicroStrategy Internal Reference number for this technical note is KB483620 and DE128512. A cube is imported into MicroStrategy (Development) and reports are built based on this cube. ” in the Help menu of your software. MicroStrategy Dossier Design Best Practices for Performance. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. This presentation helps users understand MicroStrategy's in-memory architecture. 5 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version shownWhen configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. Starting in MicroStrategy 10. KB415730. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Publish the Intelligent Cube by executing it on either of the nodes. It will track and log all communications at the “XML API. 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. IS_CUBE_REP_ID. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. IS_CUBE_ACT_ID. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. To Create an Intelligent Cube Using Freeform SQL or Query Builder. If you are using or plan to use MicroStrategy Intelligent Cubes, and you plan to implement data internationalization, it is recommended that you use a SQL-based DI model. In your Datasets panel, hover over the name of your dataset. The following diagram depicts the role of the intelligent cube. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. What to read next? Nothing to see here. Publish the cube. 3 - Check the Make Intelligent Cubes. Select Build a Query and click Next. 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). Afterwards MTDI cubes should appear as visible from default. Getting Started with MicroStrategy. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. There is a distributed database for the MicroStrategy metadata and statistics. Web log. In the grid display of the report, hold down the CTRL key and select multiple attribute elements within the same attribute. Updating Intelligent Cubes without re-processing: Incremental Refresh. Relationships with Multi-Table Data Import. Right-click the project and select Project Configuration. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. 13K KB31566: MicroStrategy 9. 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. Number of Views 1. An Intelligent Cube has been created in a project. The following diagram depicts the role of the intelligent cube. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. For example, the objects developed in a development environment can be copied to a UAT environment to. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. KB485674: Create Super Cube from Excel file and update it with a script in. 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. 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. blogspot. Place Intelligence Server close to the both the data warehouse and the metadata repository. 10. Select the data set and click Prepare Data. KB37579: Dynamic Sourcing is not used when an Intelligent Cube includes a metric defined as Sum (fact A / fact B) in MicroStrategy 9. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Configure a Cluster with a Centralized Cache. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Business Intelligence. x. With OLAP Services features, your report designers can create Intelligent Cube reports. MicroStrategy’s In-memory technology is engineered to meet the. 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. To enable or disable dynamic sourcing for an Intelligent Cube. Expand the Object Templates category, select General, and from the Show templates for the. x: Back up metadata before copying any objects. 4. Best practices for mapping MDX. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Before MicroStrategy 2020, when using multiple tables cube and use fact extension, the Engine can generate multiple temp tables while there is a join path to use only one temporary table, which leads to an extra temporary table and impacts the. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Number of Views 15. These. Discover MicroStrategy 2021 > It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. GUID of the Intelligent Cube instance in memory. Hardware requirements and recommendations. x Attributes used in the filter should also be on the Intelligent Cube’s definition. Click OK. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. 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. 4. 4. Go to the "All Objects View" option in the top left corner. Document Number: 09481030. 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. This will create an Intelligent Cube for the data of the Excel file to be accessed. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. Click the Cube Mapping tab. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Transformation metrics, under the following conditions: -A metric with the same formula and transformation exists in the Intelligent Cube. This article describes the Intelligent Cube Population options available in MicroStrategy. Place Intelligence Server close to the both the data warehouse and the metadata repository. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. In MicroStrategy 10. Defining the partition for Super Cubes. 3. 4. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. This data is stored in cubes or other SAP objects. Compound attributes and joint element lists. In MicroStrategy Desktop 9. 0. Connectivity. If you need to delegate administrative responsibilities among several people, create a. ISBN: 9781785884405. MicroStrategy has a metadata-driven architecture. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 4. Discover MicroStrategy 2021 > Events;It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. Change Journaling is enabled by default since MicroStrategy version 10. A list of data sources available in this project appear. Share query results in-memory across multiple dossiers and. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . The solution is to republish the cube after upgrading instead of reusing old cube caches. Edit Project-Level Cache and Intelligent Cube Settings. 929 views · January 17, 2021 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. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. We, at Intellipaat, provide the best online classes to help you learn its architecture, database connections, cubes, clustering, and security models. Our vision is to enable Intelligence Everywhere. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. If you need to delegate administrative responsibilities among several people, create a. Click Close, then "Finish" on the "prepare data" view and save the cube. 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. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 0. 1. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. One of the first steps in formatting HyperIntelligence cards is to choose the best-fit template. The maximum file size of dashboard (. DESCRIPTION: Starting MicroStrategy 10. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. 10 MicroStrategy Design Challenges Design Tips & Best Practices for MicroStrategy BI Architects and Developers. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. 1To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. If the Intelligent Cube must be re-processed based on a metric. This section describes only the most basic guidelines. Create an attribute element prompt for the. g. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. KB442525. Save the Report and close. Save the dataset as Employee Dataset. A typical case is to create a derived metric to perform calculations between columns of metric data. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. 4. x and 10. 1180 views | February 10, 2021 29:25. Number of Views 3. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Open the Workstation window. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Designing and creating documents: An overview. x Intelligent Cube status indication and workflow. It remains available, but is not enforced if it is less than the default value of 100000. The user then updates the cube. The ID is found with the heading. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. 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. 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. Do you have reports that currently access. Published: May 29, 2019; Last updated: Oct 29, 2019; Related versions: To build an Intelligent Cube. x releases, and the new Multi-table Data Import (MTDI) cubes. In MicroStrategy 10. x and 10. This can be achieved via the report level VLDB property > SQL Time. 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. rare practice (British Columbia Ministry of Education, 2011, p. In this case, the dataset is a MicroStrategy Intelligent Cube. x. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. Best practices for mapping MDX. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Webinars. KB36667: Best practices for Dynamic Sourcing in MicroStrategy. Create a Report 'R3' with 'Country' attribute. Number of Views 611 KB46313: In a clustered environment, Intelligent Cube sizes are varied on different nodes of the cluster in the Intelligen…510 Ratings. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Lastly, you will learn to use Hadoop for MicroStrategy reporting. Shipped vs Native. 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. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). ElasticSearch is an open-source search engine based on Lucene that provides multitenant-capable full-text search capabilities. 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. Description: Intelligent Cube design and utilization; how to build cubes. 4. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. Select a database configured for SAP HANA. SAP BW obtains data from R/3, CRM, SEM, or another SAP data source system. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. x. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. x. Solution Gallery. 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. Author (s): Dmitry Anoshin, Himani Rana, Ning Ma. 4. 0. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. The Full Refresh option is the default. 2. 2) Choose "Database" and select the 3rd option to "Pick tables". Type of action against the Intelligent Cube: •What is MicroStrategy? MicroStrategy is a Business Intelligence software that can be connected with any data including data files, big data, social media data, and so on to create and modify highly detailed reports and dashboards. Accessibility and 508 Compliance. Query Optimization 2. Module 14: Practices on MicroStrategy Best . The path for cache files must be shared as "ClusterCaches". 0. 1 or later, with the following characteristics:. 1. To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor, select Create Freeform SQL report. 3. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. (Titled: "Cube broken aplysimple") No data is returned the following SQL view is seen: Report: cube broken applysimple Job: 198 Total Number of Passes: 1 Number of Intelligent Cube SQL Passes: 1 Number of Analytical Passes: 0 Intelligent Cubes Accessed:The Incremental Refresh feature allows users to update cube information without having to republish the entire cube. This can improve the performance of. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. 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. Create Intelligent Cube Reports; Explain different types of derived elements; Creating derived elements; Group and Filter derived elements;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. 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. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. STEPS TO REPRODUCE: 1) Add external dataset. By default, the template is 3x3. x, with the Intelligence Server running on Linux, the image in the. Best Practices for MicroStrategy Messaging Services. Following are the. 38K. 1. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. 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. You should periodically reevaluate the system and. To access the setting, in MicroStrategy Developer right-click on the project and select Project Configuration…Then, In the Project Configuration dialog box, choose Project Definition >. Object Migration is the process of migrating or moving objects from one environment to another environment. 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. . To learn more about Super Cubes and relevant best practices, refer to the following Community Article: Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 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. application performance and security best practices. The objects stored in the metadata are reusable. Intelligent cube; Advanced reports; Creating and adding data to the document;To view an Intelligent Cube stored in your History List. 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. 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. 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. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. xTo Create a Report that Accesses an Intelligent Cube. x and 10. x and later, users should make sure to take into account the following. 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. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Our vision is to enable Intelligence Everywhere. mtc is the name of the saved test file. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. Prompts in a report. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Number of Views 18. Hands-On Learning in MicroStrategy. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Getting Started with MicroStrategy; Modern BI; BI project life cycle; Meet MicroStrategy 10; Deploying MicroStrategy 10; BI tips; Summary; 2. Open the Workstation window. Intelligent Cube design and utilization; how to build cubes, schedule them,. The status of each Intelligent Cube is listed in the. When an Intelligent Cube is published, the Intelligent. Support. Published: Dec 31, 2018; Last updated: Jul 25, 2023 Intelligence Everywhere. 31K. Required Status to Perform Action. 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 - 10. 8: Monitoring information dirty. Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. x - 10. By the end of the book, you will become proficient in evaluating any BI software in order to choose the best one that meets all business requirements. KB442526. 438832. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. More about Feature flags can be found in this article. This can be done in one node of the cluster because the information is stored in the metadata then used. The main open-source visualization tool, Kibana, that is used to connect to ElasticSearch is fairly limited in its visualization capabilities. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. x. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. . Overview. You can control users' access to data with security filters. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. Published: Jan 29, 2019;. A set of data is returned from the. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. 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. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. x Intelligent Cube status indication and workflow. To do so, you can take advantage of URL API. All the attribute forms are in bold type and will display in Intelligent cube reports. Using Object Manager, the above cube based reports are migrated into Production. Run report off cube. 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. A document that uses the Intelligent Cube as a dataset. The Full Refresh option is the default. Definition. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. ACTION: 1. McLean, Va. For an Intelligent Cube to satisfy the data requirements of a report, the Intelligent Cube and report must have matching settings for VLDB properties that can affect the data that. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. Version 10. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. with Gateway Agent enabled and disabled. The New Grid dialog box opens. 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. The data in this cube is as given below. Published August 27, 2020 By akrish1982. 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. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. On the toolbar, choose Data > Configure Intelligent Cube. Replace the first “/” by “” in the Intelligent Cube file directory option. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. 5. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. Choose one of the following options: Full Refresh: This is the default. Cause This is a known issue with. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. 2. 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.