Note that the cube has a neutral data language. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. /ClusterCube. 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). Create a Report 'R3' with 'Country' attribute. As shown in the screenshot above, only one cube cache can be loaded in RAM. Then click "Save". Click OK to save the Intelligent Cube and return to the Report Editor. The Modeling service must be configured correctly to use this feature. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. Note: number of columns should be the same as in the original file. Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. ACTION:In the Navigation pane, click Monitors. You can use an Intelligent Cube as a dataset, allowing you to use one Intelligent Cube for many different documents, while reducing access to the data warehouse. 3. To subscribe a report or document to a cube refresh. 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. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. The. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. CAUSE: Starting in MicroStrategy 9. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. Total Cubes This section displays the total count of cubes by status. 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. See Importing MDX cubes in the MDX Cube Reporting Help for more information. Use Intelligent Cube Editor. delete one relation as the following Then click "Save" to go back to the cube editor, click the "Update Dataset" button in the bottom right corner. Create a report based on the Intelligent Cube. You can also select an existing template on which to build your new report. Click OK. 4. In a clustered MicroStrategy Intelligence Server Universal compounded by two nodes Node A and Node B, a cube test cube is published on Node A and its status can be seen in Administration >> System Monitors >> Caches >> Intelligent Cubes:To view an Intelligent Cube stored in your History List. Data Population for Intelligent Cubes. When an Intelligent Cube is published, the Intelligent. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 3. x and create a new Dashboard. For more details on enabling the setting, refer to Change Data Engine Version. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. To publish your cube, see the In-Memory Analytics Help. Watch on. Log in to the project in which you want to create a report. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. Report Post SQL Statement. 0 and earlier releases, Outer Join setting for Metrics does not work when there are more than 1 visualizations containing same attributes, metrics, filters but different metric outer join settings when using Live Intelligent Cube as dataset. This is the same requirement to create or run a static report in Workstation. ACTION: Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled MicroStrategy release. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Integer ID of the project where the Intelligent Cube is stored. Select the refresh policy. The Select Intelligent Cube dialog box opens. Integrity Manager can test the SQL of Intelligent Cubes even if they. In MicroStrategy 9. Prerequisites for using Cube Advisor. Log in to a project connected to an MDX cube source. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user. g. By default, there is a system hierarchy on the cube. Visualizations in the dossier that use data from the cube display. x. The Modeling service must be configured correctly to use this feature. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT * Web publish Intelligent Cube: publish an Intelligent Cube to Intelligence Server: WEBEXECUTECUBEREPORT * Web save derived elements: save stand-alone derived elements, separate from the report: WEBSAVEDERIVEDMETRICS In MicroStrategy Web, log in to a project. 1 to see the results as shown. Select the data set and click Prepare Data. Click Intelligent Cube Report. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. This Python 3 / MicroStrategy 10. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. We can create a report and point the report to a cube or right click. Add Project objects from the All Objects panel. Intelligent Cubes. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 4. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Deploy the ojdbc8. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. The Report Editor opens. jar file to i-server machine. 2. This permission is checked at design time, and when executing reports against an Intelligent Cube. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. 8. Create an Intelligent cube with Month and Revenue. 4. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. This permission is checked at design time, and when executing reports against an Intelligent Cube. When an Intelligent Cube is in this status, any reports based on this cube have. To create an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report. 0. Add the report as the dataset for the Dashboard by. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. Select data population for Intelligent Cubes. Right-click the Intelligent Cube, and select Define Incremental Refresh. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. x - 10. Open the cube report in Design View. Create a Report 'R3' with 'Country' attribute. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. Select a database configured for SAP HANA. Open MicroStrategy Developer. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. A document is used to format data from multiple datasets in a single display of presentation quality. Use Intelligent Cube Editor. Browse to an Intelligent Cube, select it, and then click OK. A solution/code fix for this issue is not available in current releases but is being reviewed for a future MicroStrategy. 86K KB42486: Users are unable to align the report name / title when exporting a report to an Excel file in MicroStrategy Web 9…This article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Check the status of the cubes in Developer. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. IS_PROJ_ID. For: "Import data from file or database before using in a Visual Insight analysis", which makes the source an Intelligent Cube, a Web Professional license is required. x. An. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 2. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. Open the Workstation window. ACTION: Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled MicroStrategy release. The Incremental Refresh Options dialog box opens. Use the Objects section to search for the desired metrics and attributes. To Create an MDX Cube Report. Common Privileges. Browse to and select a. Use Intelligent Cube Editor. 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%. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. How to build and manage Intelligent Cubes. x releases, and the new Multi-table Data Import (MTDI) cubes. 4 the connection mapping of the user account which published the cube are created and database connections are listed in the Intelligent Cube Monitor in Developer. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. Intelligent cubes & Level Metrics. Create Intelligent Cubes. To view an existing cube, you must have the following minimal privileges: Use analytics. 38K. For background. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. ICUBE_STATUS: shows the status of the intelligent cube, returned as a string value. The month ID for 2004 Jan is like 200401. 1. 4. In MicroStrategy Web, edit the Cube where users want to enable partitioning. HyperIntelligence for Web. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. Look for existing Intelligent Cubes: Before you create an Intelligent Cube, search through MicroStrategy to see whether a similar Intelligent Cube already exists that can serve the same purpose as the Intelligent Cube that you. 4 using an Excel file and the Connection mapping database connections of the user account which published the cube are listed when checking the Intelligent Cube monitor in Developer. Login MicroStrategy Developer 10. Select Build a Query and click Next. Select Intelligent Cubes > General > Intelligent Cube File directory. 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. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. 2. CAUSE: This is working as designed. Navigate to the Engine Component with CSI Dispatcher. All articles. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Publish the cube. Section 5: Load Intelligent Cube files into the Intelligence Server. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. To review and create recommended Intelligent Cubes using Cube Advisor. 4. Currently, project duplication does not involve Intelligent Cube File Directory. Common Privileges. There is another reason that the intelligent cube is imported from a local file in the web server machine, and the Web server and the Intelligence Server do not need to be on the same machine. MicroStrategy Developer 9. create(auto_publish=False). For intelligent cube imported from local file via Data Import, we do not support creating subscriptions as the path may change. Right mouse click the Intelligent Cube Q, select Schedule Delivery To>History List as shown below: 3. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Common Privileges. To Create an Intelligent Cube Using Freeform SQL or Query Builder Using MicroStrategy Developer, log in to a project connected to an MDX cube source. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (article describes how to provide Intelligent Cube cache files to MicroStrategy for troubleshooting cases. Allow reports to drill outside the Intelligent Cube Select this option to enable drilling outside the Intelligent Cube to access the full set of data available in the data. 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"" Web Reporter" and "Report Services document" are required to run Intelligent Cube document. On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. They should have the “A, L, F” status (Active, Loaded, Filed). Select the environment and project where you want to save your. details. Run report off cube. Cube Advisor opens. Create a new dossier: Create a new metric M01=Case: Create a new metric. From the System Manager home page, you can access the template workflows in the Templates section. PUBLISH INTELLIGENT CUBE "Year Revenue Cube" IN FOLDER "profilesAdministratorMy Reports" FOR PROJECT "MicroStrategy Tutorial"; TRIGGER EVENT "Run Reports";Create an Intelligent cube with Month and Revenue. Node 2. Steps to Reproduce. 2. Browse to and select a previously saved Intelligent Cube on which to build your report. Modify the list of Report objects (use object browser). Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Choose Databases. In the New Intelligent Cube dialog box, select the MDX Sources tab. There is no need to further create a dashboard. Load an updated CSV file into a DataFrame providing full path. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. In MicroStrategy 9. Publish the cube. For example, an Intelligent Cube includes Year and Quarter. Save the Report and close. Rather than returning data from the data warehouse for a. From the Data menu, select Add Dataset. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. How to configure, monitor, and manage Intelligent Cubes. Choose File > New > Report. com Format: A MicroStrategy Online. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Click Intelligent Cube Report. All necessary privileges are included in the Administrator role by default. 1 or MicroStrategy Web 9. To schedule updates for the Intelligent Cube. x - 10. While the report cache is disabled at the report level and there is no cache or Intelligent Cube exist for the dataset to hit, "In Memory" appears under the dataset name listed in Visual Insight editor with MicroStrategy Web 10. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. Right-click your selection and select Group. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. To choose from the full list of template workflows, click the. You must browse to the MDX cube to use to build the Intelligent Cube. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. From the File menu, select Create Test. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. 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). This Python 3 / MicroStrategy 10. Export to MicroStrategy File. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 86K KB31566: MicroStrategy 9. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. You cannot create or edit a card based on an unpublished cube. In MicroStrategy Web 9. Click here to view details about the Intelligent Cube Monitor. For example, you can choose to add or delete data from the Intelligent Cube. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. Click Databases . In MicroStrategy Desktop 9. Web modify the list of report objects (use object browser --all objects) Web Professional. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. The group is created as a derived element and displayed on the report. Upload Dashboard. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. x, create a simple Intelligent Cube with attribute Category and metric Revenue. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. x-10. 3. The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. Create a second report with the year and quarter attributes and the revenue metric. Check in Developer that the stopped node is in Maintenance Mode. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. To Create a Report from Scratch. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. From the Data menu, select Configure Intelligent Cube. 2. The ability to view or edit certain settings is determined by a user's privileges. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. 1… Number of Views 9. To set refresh filters, or alternate data sources, select Show Advanced Options. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Delete one of these two cube caches from the cache monitor in Developer. Create an attribute element prompt of Month, and use above filter in "Use a filter to reduce the number of elements", as below picture shown: 3. Republish the. Under Cube Update, click Cube Update. Web object search—this enables the user to see the “User Manager” button on the Intelligence Server Administration page. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". 3 - Check the Make Intelligent. Con: The copy of report data in Intelligence Server memory only applies to a single report. Select an Environment from the upper-left drop-down. 3. 7. Execute reports or documents that reference the object. In the grid display of the report, right-click the attribute for which you want to create or modify derived elements, and click Derived Elements . Node 1. Expand Intelligent Cubes, and then select General. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports and documents. Description. However, in MicroStrategy Web 10, this 'Link' property is no longer available for Intelligence cubes2. To Schedule a Cube Refresh. Sharing data. Normalize Intelligent Cube data in the Database 4. IS_CUBE_REP_ID. Save the Intelligent Cube. Upload Dashboard. For steps to use an existing template to. All necessary privileges are included in the Administrator role by default. Complete the "sessionState" field (e. And create one Cube based report called “cube report 2”. Log into the three-tier project source and choose the project that was analyzed in stage 2. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Run both reports after enabling the metric levels log. Create an Intelligent Cube, with Region, Category, Cost and Profit. A possible cause of this issue is that the folder that stores the Intelligent Cube files on the node where the Intelligent Cube is published is not shared with the name 'ClusterCube' on the MicroStrategy Intelligence Server machine(s). Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. STEPS TO REPRODUCE: 1. 4. 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. The Intelligent Cube opens in the Report Editor. In MicroStrategy Web browse to the Cube location and click on the cube . Run a dossier based on the cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Click Create on any page, point to New Report, and select Blank Report. It is especially useful when data. The Browse for Folder dialog box opens. Run a Command Manager script to delete the cube cache previously deleted in step 2. Create an intelligent cube with Call Center, Quarter and the derived metric 3. Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. x. g. This will create the Intelligent Cube directories. For more information on importing MDX cubes into MicroStrategy, see Importing MDX cubes. Login as MSTR, create an intelligent cube with attribute ‘Year’ and metric ‘Average Revenue’, and publish it as ‘Cube_Tutorial’. Click the “Add history list subscription” link near the bottom of the screen to open the. Create. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. From the File menu, select Create Test. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. 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. A couple of workarounds are available in the current document. 1. After the Intelligent Cube has finished republishing, the Cube. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. The month ID for 2004 Jan is like 200401. Create a report based on above Cube and add the prompt in view filter. Run the report, notice that the filter does not work, all. x. In MicroStrategy Web 9. Republish the Intelligent Cube or re-create a report cache, which will be shared with MicroStrategy Technical Support; Send the requested data to MicroStrategy Technical Support; Revert the metric definition back to the original one, or remove the randomized metric from the report (Intelligent Cube configuration is not relevant in MicroStrategy 8. Full Refresh. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. To define an incremental refresh report. This can affect performance of your Intelligence Server as well as the ability to publish the. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Save the Intelligent Cube generated. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. ) As long as each node is using the same server definition, the setting of the cache and history list locations in the Intelligence Server configuration only needs to be done once; however, the creation of the shared folders will need to be done on each node. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. This is set to 32,000 by default. Export to MicroStrategy File. 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. By default, this is set to 32,000. After refreshing an Intelligent Cube that had columns added to it, the newly created attributes do not show up in the document's Dataset Objects pane in MicroStrategy Web 9. 2. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. 4 the connection mapping of the u… Number of Views 1. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. 4. To Schedule a Cube Refresh. Import MicroStrategy File. 3. 000007431. If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. Create a new File Log and name it “CSI” (or any other name). Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. . More than one cube can be used in a single dashboard. STEPS TO REPRODUCE. Publish. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. Loading. Open the. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. They should have the “A, L, F” status (Active, Loaded, Filed). Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. To view an existing cube, you must have the following minimal privileges: Use analytics. Create an MDX Cube ReportThe option to point a grid to an Intelligent Cube appears disabled, while other options such as "Convert Grid to Intelligent Cube" appear available.