View the report in either Grid View or Grid and Graph View. In the Data Source column, select the checkboxes for the tables to update. In MicroStrategy Intelligence Server 9. 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. Our MicroStrategy Admin certification training course lets you master MicroStrategy administration. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. KB485159: Enable support for Security Filter with Top and Bottom Range Attributes in Data Import Intelligent cubes and Fix the security hole in Connect Live Data Import Intelligent cubes MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Transformation metrics, under the following conditions: -A metric with the same formula and transformation exists in the Intelligent Cube. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. x. It is capable to deal with the high formatted reports and. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. It will track and log all. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. In section General at the bottom of displayed window there is a check box with option "Hidden". Excel file: 800M. The tooltip will show the dataset type listed as a Super Cube. 3. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. From the Edit menu, select Training Metric Wizard. Compound attributes and joint element lists. Tell a story with your data using the dossier chapter/page format. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Click All Objects View. x - 10. 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. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. If you use Enterprise Manager, dedicate a machine for the Enterprise. Publisher (s): Packt Publishing. Best practice to split large files in Linux Operating Systems. Version 9. The columns ID1 and ID2 correspond to attributes and M1 corresponds to a metric. Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. 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. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. foundation to build a career in Analytics, proving expertise in using MicroStrategy. Starting in MicroStrategy 10. Best practices for supporting dynamic sourcing. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Number of Intelligent Cube Publishes: Number of Cube Publishes: Counts the number of times a cube was published. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). . x product documentation "InMemoryAnalytics. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. Share query results in-memory across multiple dossiers and. This. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. The New Intelligent Cube dialog box opens. x. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. IS_CUBE_REP_ID. 8 to help improve the performance of Quick Search on MicroStrategy Web. How to configure, monitor, and manage Intelligent Cubes. x. 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. Rather than returning data from the data warehouse for a single. Object Migration Best Practices. x Attributes used in the filter should also be on the Intelligent Cube’s definition. This is from all MicroStrategy Business Intelligence clients platform. Source: MicroRooster. 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. 929 views · January 17, 2021. Object Manager cannot undo the copying and replacing of objects. 2) Choose "Database" and select the 3rd option to "Pick tables". This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesIn MicroStrategy 9. 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. Required Status to Perform Action. 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. If you need to delegate administrative responsibilities among several people, create a. In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . 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. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. The Intelligent Cube opens in the Report Editor. This technical note outlines how to set. Using. Required Status to Perform Action. x?Business Analyzer, MicroStrategy World, Application Development and Sophisticated Analysis, Best In Business Intelligence, Centralized Application Management, Information Like Water, Intelligence Through Every Phone, Intelligence To Every Decision Maker, Intelligent E-Business, Personalized. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. Watch on. x. It lets you various. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. III. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. When we mention performance, we mean the speed by which HyperWeb scans keywords to present data via HyperIntelligence cards. In the grid display of the report, hold down the CTRL key and select multiple attribute elements within the same attribute. Choose File > New > Intelligent Cube. Indexes are created in memory on the Intelligence server as part of the in-memory cube instance. Place Intelligence Server close to the both the data warehouse and the metadata repository. The path for cube files must be shared as "ClusterCube". x. The test is for a single cube (4M rows) republish executed on the MicroStrategy 2021 Update 2 release with platform as 32 CPU, 244 GB memory Amazon Linux machine. KB37579: Dynamic Sourcing is not used when an Intelligent Cube includes a metric defined as Sum (fact A / fact B) in MicroStrategy 9. Best practices for supporting dynamic sourcing. Intelligent Cubes erstellen. The Full Refresh option is the default. This article also provides a workaround to avoid this behavior. Select the data set and click Prepare Data. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. KB442525. Consider a data import dataset which has been imported into MicroStrategy. 0. 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. IS_PROJ_ID. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. 5. 29K. Expand Intelligent Cubes, and then select General. Intelligent Cubes can function in a similar fashion to result caches: they. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. blogspot. This article describes the Intelligent Cube Population options available in MicroStrategy. In MicroStrategy Developer or Web, log in to a project that contains Intelligent Cube reports. SAP HANA Query Execution. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. Use MicroStrategy Developer, Office, or Web. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. In this case, the dataset is a MicroStrategy Intelligent Cube. Resources Company Bitcoin Lightning Home Published: August 11, 2022 • 619 Views Advanced Properties for Intelligent Cubes MicroStrategy Workstation. 0. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. You must belong to the System Administrators group to use this feature. The SQL-based DI model is described in Providing Data Internationalization. The Schedule dialog box opens for your dataset, showing the tables in your dataset. For more information on security filters, see the System Administration Guide. Download the attached PDF for an in-depth understanding of Object Migration best practices. Number of Views 18. 13K. Web XML API log. The Intelligent Cube opens in the Report Editor. Forecast Sales. 8: Monitoring information dirty. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. If user downloads the . This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. 7. Best practices: Importing data into MicroStrategy Web; Importing data from a data source; Previewing, modifying, and refining your data before importing; Editing, republishing, and linking imported data; Configuring OAuth parameters for data sources integrated using Data Import; Scheduling updates for an Intelligent Cube created using imported dataThis issue has been classified as a none defect by MicroStrategy. If you use Enterprise Manager (EM), dedicate a machine for. To enable or disable dynamic sourcing for an Intelligent Cube. 1. The following diagram depicts the role of the intelligent cube. Dynamic Sourcing. After completing your certification, you’ll receive a digital badge that highlights your accomplishment, which you can post on social media. rare practice (British Columbia Ministry of Education, 2011, p. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Job ID for the action on the Intelligent Cube. Defining Intelligent Cube refresh settings. 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. 2. x, create a simple Intelligent Cube with attribute Category and metric Revenue. You should periodically reevaluate the system and update it based on actual system performance and use. This presentation helps users understand MicroStrategy's in-memory architecture. You can edit project-level cache and Intelligent Cube settings. 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. KB441987: Best Practices. Dedicate a machine for the metadata repository. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. The path for cache files must be shared as "ClusterCaches". To enable. Best Practice for interview Preparation Techniques in MicroStrategy. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. The Intelligent Cube Options dialog box opens. KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. x?Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. Create a Report 'R3' with 'Country' attribute. With OLAP Services features, your report designers can create Intelligent Cube reports. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. Description: Intelligent Cube design and utilization; how to build cubes. Watch on. Filename. MDX Cube Reporting Guide Version 10. 4. the project configuration: ACTION . Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. E. 0 MicroStrategy releases. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. 16: Intelligent Cube dirty. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. 1 or later, with the following characteristics:. In MicroStrategy Developer, from the File menu, point to New, and then select 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. 4. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. For details, please refer to the Technical Note below. The solution is to republish the cube after upgrading instead of reusing old cube caches. By default, the template is 3x3. g. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. Rather than returning data from the data warehouse for a. Number of Views 8. Recorded at World 2021. It serves as the starting point for new developers to get This article describes the best practices for using dynamic sourcing in MicroStrategy. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. x: Back up metadata before copying any objects. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 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. Please refer to the following article to check all the. x. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Set the path for the cube cache file directory to . 84K KB441987: Best Practices for increasing performance of publishing large Intelligent CubesAn Intelligent Cube report is created in MicroStrategy 9. iCubes or Intelligent Cubes are objects that provide pre-cached data which can be queried on the reports. x - 10. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. 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. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. From the Data menu, select Configure Intelligent Cube. The main open-source visualization tool, Kibana, that is used to connect to ElasticSearch is fairly limited in its visualization capabilities. IS_PROJ_ID. Before MicroStrategy 10. Published: Apr 6, 2017. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. MicroStrategy’s new Gateway connector can enable analysts to derive new. 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. This includes "Personalized Intelligent Cube" reports (which have the same structure as OLAP Services reports in MicroStrategy 8. 0. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. All necessary privileges are included in the Administrator role by default. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. This command can get the correct cube status and table status only when the cube is being refreshed or published in the same session between Command Manager and Intelligence Server as this command's. Creating an Intelligent cube is similar to creating a report. Run report off cube. Start a Pilot Solutions Powerful analytics for any industry. IS_CUBE_ACT_ID. x-10. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. KB41988: Is it possible to add prompts to Intelligent Cubes in MicroStrategy Developer 9. x and 10. ACTION: 1. Number of Views 5. 4. x) or OLAP (first generation of in memory cubes, introduced in 9. Learn more about it at MicroStrategy. Starting in MicroStrategy 10. Object Migration is the process of migrating or moving objects from one environment to another environment. MicroStrategy Dossier Design Best Practices for Performance. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. x, but not to publish it, the minimum privileges that the Administrator would need to. x and newer? Number of Views 4. 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. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 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. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Published: Dec 31, 2018 Intelligent Cubes. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. 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 shownDrilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. Publish the Intelligent Cube by executing it on either of the nodes. 1. In your Datasets panel, hover over the name of your dataset. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Generate Oracle AWR report or monitor the database to identify the low performance query. x-10. Job ID for the action on the Intelligent Cube. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Number of Views 15. 31K. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. What to read next? Nothing to see here. x, create a simple Intelligent Cube with attribute Category and metric Revenue. This article covers best practices for the following topics: 1. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. In your Datasets panel, hover over the name of your dataset. This can. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Create Intelligent Cube Reports; Explain different types of derived elements; Creating derived elements; Group and Filter derived elements;This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. 3. Best practices for mapping MDX. x. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy environment. The New Grid dialog box opens. KB485674: Create Super Cube from Excel file and update it with a script in. 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. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. Published: Dec 31, 2018; Last updated: Jul 25, 2023 Intelligence Everywhere. 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. x) and view reports based on MicroStrategy 9. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more cardinality means the attribute with more different elements, for example in the Tutorial project the. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 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. All articles. Module 14: Practices on MicroStrategy Best . Supported data structure and distribution on Gateway. Afterwards the cube will start executing. Shipped vs Native. 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. To stay current with the best available scientific evidence and ensure that people have. 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. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. OLAP cubes best practices. A list of data sources available in this project appear. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. PlatformAnalytics. Please make sure that this is disabled. Create Intelligent Cube Sharing Intelligent Cubes Enable ROLAP Enable Dynamic Source How to do Incremental Refresh. Do you have reports that currently access. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. Details on MicroStrategy recommendations can be found in this TN. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. 0, the only way to create an intelligent cube (also. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. application performance and security best practices. VI). The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. 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. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. This data is stored in cubes or other SAP objects. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. x-10. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. Replace the first “/” by “” in the Intelligent Cube file directory option. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. intelligent cube use cases, and cube optimization techniques with MicroStrategy. 2. Intelligent Cubes. IS_CUBE_REP_ID. 4. Published August 27, 2020 By akrish1982. IS_CUBE_INST_ID. Intelligence Server Statistics . How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. -10. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. Best Practice for interview Preparation Techniques in MicroStrategy. Try to include only information that would be imperative at-a-glance. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Browse to and select a previously saved Intelligent Cube on which to build your report. The ODBC connection uses 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. Relationships with Multi-Table Data Import. The Data Transfer Rate varies from 27 to 28 Mb/s. MicroStrategy version 9. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the. 10 MicroStrategy Design Challenges Design Tips & Best Practices for MicroStrategy BI Architects and Developers. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more. 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. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports.