However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Create a report based on above Cube and add the prompt in view filter. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Answer: Intelligent Cubes can be created in microstrategy in public objects folder or in a particular user folder. Purpose of the registry key. In MicroStrategy Web 10. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Watch the Product team review how to configure and manage advanced properties of Intelligent Cubes. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 2. “Intelligent Cube (<Cube Name>) for locale. "In MicroStrategy 10. x-10. To do so, you can take advantage of URL API. Select from the following localization options: Use project default data language (Default): Select this option to provide data only in the default language for the project. Integrity Manager can test the SQL of Intelligent Cubes even if they. Some data that may be available to the user by directly querying a data source may not be available in the report that accessed an Intelligent Cube. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. Save the Report and close. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. A user with Use but not Execute permission for an Intelligent Cube can create and execute reports that use that Intelligent Cube, but cannot publish the Intelligent Cube. To choose from the full list of template workflows, click the. In the Object name field, type a descriptive name for the Intelligent Cube. As shown in the screenshot above, only one cube cache can be loaded in RAM. The Intelligent Cube Monitor is displayed. By default, this is set to 32,000. Regular Intelligent Cubes created on Developer. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Both types of subscriptions when targeting intelligent cubes will submit the same SQL statements to the database. Number of Views 2. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. 2. Later the user can poll for the change in the value of the flag. Click OK to save the Intelligent Cube and return to the Report Editor. If the Intelligent Cube must be re-processed based on a metric. 8. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. Open MicroStrategy Web. 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). The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. They should have the “A, L, F” status (Active, Loaded, Filed). All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. Publish the cube. 1. Create an Intelligent cube with Month and Revenue. Navigate to Administrator -> System monitor -> Cube monitor both nodes, and check all cube are “active, load, file” status. A report accessing the Intelligent Cube includes only Year on the report. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. For a MicroStrategy environment configured to use Database level security using MSTR connection mapping, Intelligent Cubes can still be utilized. To learn more about Intelligent Cube Data Partition, please refer to KB237803. Supports derived metric creation. Loading. Under Cube Update, click Cube Update. Run the Report and check the SQL View. 4 the connection mapping of the u… Number of Views 1. Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. 1. For the example scenario, create a report with Year, Region, and Profit Margin on the report. When an Intelligent Cube is published, the Intelligent. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Browse to and select a. Defining the partition for Super Cubes. (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 steps below show you how to create an Intelligent Cube based on an MDX cube. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). This is an identified defect in Visual Insight in MicroStrategy Web 10. Workaround 2: Create a non-Kerberos authenticated database login. 2. The impact is limited to MicroStrategy Developer 9. Right-click the dataset, and choose Schedule. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. Then click "Save". The dataset is a set of data that can be displayed on the document. 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 . 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). You can also select an existing template on which to build your new report. In the Name field, type the name of the subscription. 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. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. GUID: is the GUID of the intelligent cube, returned as a string. Number of Views 1. 3 - Check the Make Intelligent. In the New Intelligent Cube dialog box, select the MDX Sources tab. 2. Right-click an Intelligent Cube and select Delete. Once this privilege is enabled, the Intelligence Server Administration screen looks like the following: With only these three privileges, a user is able to access the User Manager in Web. g. 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. 3. Select the data sources to be refreshed. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Cube index generation will increase cube size. x environments. By default, there is a system hierarchy on the cube. 3. Faster performance than directly querying warehouse. Connection mapping can then be used to map the desired MicroStrategy users to this database login. Login to MicroStrategy Web, create a cube with the function of Data Import 2. This is the same requirement to create or run a static report in Workstation. The Report Editor opens. Con: The copy of report data in Intelligence Server memory only applies to a single report. Business users might not want MicroStrategy to build any M:M Relationship tables while publishing the Intelligent Cube In-Memory due to the following reasons: 1) It distorts the actual relationship between a tuple of 3 or more attributes related to each other through M:M relationship in Project Schema by creating individual tables and joining. This " How to" knowledge base article explains cube advisor. ACTION:In the Navigation pane, click Monitors. In the user interface, specify the partition attribute and the number of partition . x - 10. In MicroStrategy Web, click "Access External Data"; In the "Connect to Your Data" window, click the "Manage Your Datasets" link in left-bottom corner, as shown below: In Data Storage window, right mouse click the cube and choose "Schedule", a sub context menu displays all the existing schedule. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. The "Refresh Cube. jar. A page with report creation options is displayed. Node 2. Follow the steps below using the MicroStrategy Tutorial project: 1. Navigate to the Intelligent Cube for which you want to define the incremental refresh. All necessary privileges are included in the Administrator role by default. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. In MicroStrategy Desktop 9. 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%. 4. 38K. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. Prerequisites. Enter a name for your new schedule into the. Right mouse click on the cube and choose Schedule 3. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. KB30711: Security filter application to view reports based on Intelligent Cubes. You'll need to provide a name for your cube, as well as a name for the table that will contain the data. Publish the cube. Intelligent Cubes. For the example scenario, log in to the MicroStrategy Tutorial project. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Save as an In-Memory dataset. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). Then click "Save". On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL. x - 10. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. This is set to 32,000 by default. The Create Group dialog box opens. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. Select the refresh policy. The group is created as a derived element and displayed on the report. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. Republish the same cube, and a new cube instance is generated. Click Databases . This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. This privilege is part of OLAP Services. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. 1. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. The Intelligent Cube Options dialog box opens. On the Home screen, select My Subscription. 1. Intelligent cube is a pre aggregated set of data stored in intelligent server memory and it will give very quick access to the data without hitting the data warehouse. Click a catalog. 86K KB31566: MicroStrategy 9. This determines the approach to existing data at refresh. Modify the list of Report objects (use object browser). From the File menu, select New, and then select Intelligent Cube. Create Schema Objects. Create a new Intelligent Cube C01 using the "ORDER_FACT" table: Add External Data > Databases > Select Tables. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 2. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Expand Intelligent Cubes, and then select General. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. This permission is checked at design time, and when executing reports against an Intelligent Cube. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. In the left panel, click Cubes. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Designing and creating documents: An overview. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. Login MicroStrategy Web as M20061, go to Add External Data -> Databases -> Select Tables, pick the following tables Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. This article describes the Intelligent Cube Population options available in MicroStrategy. This article describes how to update information in an Intelligent Cube without having to do a full republishUsing Web, create an Intelligent Cube with Add External Data> Databases > Select Tables option and add 1 table Order_Detail using a "Live" connection. At this time, only one table per cube is supported. Do not normalize Intelligent Cube data. Web modify the list of report objects (use object browser --all objects) Web Professional. Notice the attribute forms in the Report Objects pane. 1 and 10. This is a known issue classified as a defect with MicroStrategy Web 9. Prerequisites. STEPS TO REPRODUCE: 1. Save the cube, and run it to publish. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. CubeServerDefinition, and this folder should be shared as 'ClusterCube'. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. Open MicroStrategy Web. To subscribe a report or document to a cube refresh. CAUSE: Starting in MicroStrategy 9. Open Command Manager and type the following commands to. This data is stored as Intelligent Cubes. In MicroStrategy 10. 1 Hotfix 6, it is not possible to use the Attribute Name macro in the filename of a bursted document when the document uses an Intelligent Cube create via Data Import as a dataset as the Intelligent Cube's attributes are not in the actual project schema. 1 release. Community & Support Search Discussions Open A Case View My CasesSince the Intelligent Cube is based off a FFSQL report, the columns in the metrics being used are managed objects. From the Data menu, select Configure Intelligent Cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. . For example, you can choose to add or delete data from the Intelligent Cube. By default SuperCube. 4. jar file to i-server machine. Designing and creating documents: An overview. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. 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. Before MicroStrategy 10. They should have the “A, L, F” status (Active, Loaded, Filed). Drag and drop the objects into the report grid from the Report Objects pane. This is the same requirement to create or run a static report in Workstation. To set refresh filters, or alternate data sources, select Show Advanced Options. 3. Ensure that the email addresses can be displayed properly. The report opens with all of the objects of the Intelligent. MicroStrategy Web is a browser-based client interface that enables IT to satisfy the diverse analytics needs of every enterprise user—consumers, analysts, data scientists, developers, and administrators—without the burden of distributing and maintaining multiple software packages. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. The Intelligent Cube Options dialog box opens. 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‘. Integer ID of the Intelligent Cube report that was published, if any. MicroStrategy Tutorial is used in this example. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. In Project B, create and run a new Intelligent Cube. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. KB30711: Security filter application to view reports based on Intelligent Cubes. Stop the. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. Open the Workstation window. Use OLAP Services. To Create a Report that Accesses an Intelligent Cube. STEPS TO REPRODUCE: 1. Allow reports to drill outside the Intelligent Cube: Select this check box to enable drilling outside the Intelligent Cube to access the full set of data available in the data. Reporting on MDX Cubes. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Web publish Intelligent Cube. The report opens with all of the objects of the Intelligent. Now, templates for existing Intelligent Cubes must be created and placed into the report templates folder in order to allow Intelligent Cube Report Designer to select the Intelligent Cube on which they would like to build a report. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. This can affect performance of your Intelligence Server as well as the ability to publish the. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Select the data sources to be refreshed. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. Cube Advisor opens. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Note: number of columns should be the same as in the original file. Open the Workstation window. Reports/Documents not created from Intelligent Cube but meet dynamic sourcing requirements: Additional "Use OLAP services" and "Use Dynamic Sourcing" are required for a user to hit an Intelligent Cube, besides the privileges. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Create a report with Category, Region and Year attributes, and Revenue metric in the grid, and Year prompt from Step 1 in the report filter. Type a name for the derived element, and click OK. For example, if a user has an Intelligent Cube that contains weekly sales data, the user may want this Intelligent Cube to be updated at the end of every week with the sales data for that week. All articles. Navigate to the Engine Component with CSI Dispatcher. 4. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Add the report as the dataset for the Dashboard by. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Trending Articles. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. Save the Intelligent Cube. Choose File > New > Intelligent Cube. STEPS TO REPRODUCE. In MicroStrategy Web, log in to a project. The Intelligent Cube Options dialog box opens. Click OK to save the Intelligent Cube and return to the Report Editor. Shut down Intelligent Server node A with command . Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. From the File menu, select Create Test. The New Grid dialog box opens. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. The Schedule dialog box opens for your dataset, showing the tables in your dataset. In the Data Source column, select the checkboxes for the tables to update. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. 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 Create on any folder page, point to New Report, and select Intelligent Cube Report. 4. Now, create an hierarchy prompt but before saving , save/overwrite them on top of “Qualification Prompt” that is being used in the Cube – ensure, the hierarchy objects exists within cube. After the Intelligent Cube has finished republishing, the Cube. Importing MDX cubes is often handled by a MicroStrategy architect. Web Analyst. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". To solve this problem, we introduce a new registry key, " Respect. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Log in to the project in which you want to create a report. x a new concept is introduced called Intelligent Cubes. Steps to reproduce. Right-click the cube, and select Schedule Data Refresh. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Web modify the list of report objects (use object browser --all objects) Web Professional. Some uses for this data include: •. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. x releases, and the new Multi-table Data Import (MTDI) cubes. Log into the three-tier project source and choose the project that was analyzed in stage 2. 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. Check in Developer that the stopped node is in Maintenance Mode. Create a New Dossier. You can also reproduce this issue in a Document. 4. 0 MicroStrategy releases. In MicroStrategy OLAP Services, Transformation metrics used in standard reports can resolve against Intelligent Cubes only when the same Transformation metric exists in the Intelligent Cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Run the report, notice that the filter does not work, all. Created cube with lastname and any other attribute. In MicroStrategy 10. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Sharing data. Click the “Add history list subscription” link near the bottom of the screen to open the. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. Click Intelligent Cube Report. 3. The Select Intelligent Cube dialog box opens. IS_CUBE_INST_ID. 1. Add Project objects from the All Objects panel. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. To build an Intelligent Cube In Developer, from the File menu select New, and then Intelligent Cube. Follow the steps below using the MicroStrategy Tutorial project: 1. 2) Choose "Database" and select the 3rd option to "Pick tables". 4. A page with report creation options is displayed. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. In the web cube editor for a data-import cube, pick a table and choose "Define Relationships" from the table drop-down menu to modify the relations, e. At least one MDX cube must be imported into your MicroStrategy project. Hover the schedule need to be modified,. Select the data set and click Prepare Data. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Navigate to the folder location of the Intelligent Cube. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. From the MicroStrategy Web Home page navigate to the Intelligent Cube (Cube A) you want to merge data into. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 1… Number of Views 9. 1 product only with documents using view filter qualifications. STEPS TO REPRODUCE: 1) Add external dataset. Complete the "sessionState" field (e. To view an existing cube, you must have the following minimal privileges: Use analytics. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Normalize Intelligent Cube data in the Database 4. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. By default, the report template used is the same as the Intelligent Cube's template. This is the same requirement to create or run a static report in Workstation. 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. 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. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Create an attribute element prompt for the. The Subscription Editor opens. access the MicroStrategy Web Administrator page and assign Project defaults: WEBADMIN: Privileges marked with * are included only if you have OLAP Services installed as part of the Intelligence Server. STEPS TO REPRODUCE 1. Create a Report 'R3' with 'Country' attribute. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. However, the metric must display in the area of subtotal, the total number of customers inserted into the data warehouse, not the sum of. Report: The results of a report are used to populate the Intelligent Cube. 2 release, the driver file is called odbc8. When triggering the concurrent subscriptions to publish a cube with different database connections, some of them do not publish. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. Select the data sources to be refreshed. Make sure the service is properly configured and running before using the Intelligent Cube Editor. Publish the cube. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. In MicroStrategy Web 9. For Oracle 12. In the Data Source column, select the checkboxes for the tables to update. x as Administrator; create a simple Intelligent Cube called Q, and publish it. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 4. x. Upload Dashboard. How to build and manage Intelligent Cubes. DESC forms are in bold as they are displayed by default in the report, as shown below:In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. For steps, see the Upgrade Guide. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8.