3. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. An Intelligent Cube is a set of data that can be shared as a single in-memory copy, among many different reports created by multiple users. Dynamic source hit. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. The Intelligent Cube Editor uses the new Modeling service infrastructure. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. The Subscribe to Cube /Cache Update dialog box opens. Click All Objects View. Check in Developer that the stopped node is in Maintenance Mode. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. 3. In the Tutorial project create a cube with the Year attribute. In the Navigation pane, click , next to Datasets. You must belong to the System Administrators group to use this feature. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. Run the report in Grid View. The Save Intelligent Cube As dialog box opens. 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. 2. Create a metric that returns a transformation of last year's. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. 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. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Right-click the cube, and select Schedule. Right-click an Intelligent Cube and select Delete. 4. Steps To Reproduce 1. Web modify the list of report objects (use object browser --all objects) Web Professional. Add a grid to the document with the objects 'Region' and. 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. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. In MicroStrategy Developer, log in to a project that contains reports connected to active Intelligent Cubes. Web Analyst. 4 the connection mapping of the u…Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. You must belong to the System Administrators group to use this feature. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. Edit Intelligent Cubes from the new editor in Workstation at any time. Select an MDX cube. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. 2. Enter a name for your new schedule into the. Data Population for Intelligent Cubes. x. The following procedure will make cube data accessible to view reports. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Report Post SQL Statement. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. In Project B, create and run a new Intelligent Cube. Since Web distributes connections between Intelligence Servers. However, the metric must display in the area of subtotal, the total number of customers inserted into the data warehouse, not the sum of. ACTION:In the Navigation pane, click Monitors. Note that the cube has a neutral data language. 4. 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). 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 also select an existing template (see How to Create a Report Based on an Existing Template ). Both properties are located in the Query Optimizations folder in the VLDB property editor. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Delete one of these two cube caches from the cache monitor in Developer. Once you have reviewed the information, select the check boxes for the Intelligent Cubes to create using Cube Advisor, and then click Create Cube Design. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. xThe following scenario describes how to create a distinct count subtotal from base report: 1 Create a report A with only “year” in row and ”category” in column; add customer in report object window only. This will influence the user experience. This is an identified defect in Visual Insight in MicroStrategy Web 10. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The current version of MicroStrategy Tutorial is designed using the MicroStrategy URL API with JSP framework, therefore MicroStrategy ASP is not supported for the redesigned Tutorial project. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. 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. 4. The Intelligent Cube Options dialog box opens. 2. 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. For the example scenario, create a report with Year, Region, and Profit Margin on the report. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. Select a database configured for SAP HANA. A couple of workarounds are available in the current document. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. This will create the Intelligent Cube directories. From the. 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. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The report retrieves data from Cube B now. Make sure the service is properly configured and running before using the Intelligent Cube Editor. MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. And create one Cube based report called “cube report 2”. Create a New Dossier. The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. In the Refresh Policy column, choose. 1 product only with documents using view filter qualifications. 86K KB31566: MicroStrategy 9. Start > All Programs > MicroStrategy Products > Integrity Manager. To subscribe a report or document to a cube refresh. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. Click here to view details about the Intelligent Cube Monitor. Run the Report and check the SQL View. They are. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . Make sure the service is properly configured and running before using the Intelligent Cube Editor. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. Save as an In-Memory dataset. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. Expand Intelligent Cubes, and then select General. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. Deploy the ojdbc8. All necessary privileges are included in the Administrator role by default. 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. Click the “Add history list subscription” link near the bottom of the screen to open the. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. PublishCube". Browse to an Intelligent Cube, select it, and then click OK. Choose File > New > Intelligent Cube. Create a new File Log and name it “CSI” (or any other name). The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. Run a dossier based on the cube. By default, this is set to 32,000. In MicroStrategy 9. In the Object name field, type a descriptive name for the Intelligent Cube. From the Data menu, select Configure Intelligent Cube. It does not tell us anything helpful and we should not use it as a point of reference. 0. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. How to Import Data from a SAP HANA Database Into MicroStrategy Web. 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. Start > All Programs > MicroStrategy Products > Integrity Manager. It retrieves report results from a schema source and stores it in memory. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Disconnect from the project source and restart both Intelligence servers. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. STEPS TO REPRODUCE: 1. From the File menu, select Create Test. Regular Intelligent Cubes created on Developer. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Create a Data Import Live Intelligent Cube. Sharing data. Open the Workstation window. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. In MicroStrategy 10. This is the same requirement to create or run a static report in Workstation. Permanent Table: When the queries for a report or Intelligent Cube are performed in parallel, any intermediate tables are created. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. In MicroStrategy Developer, log in to a project source with administrative privileges. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. This chapter provides information on how to deploy and configure MicroStrategy Web and Web Universal on Windows and Linux platforms with various Web and application servers. Right-click an Intelligent Cube and select Delete. Web Analyst. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. 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 any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. Open the report in Grid View, Design View, or Grid and Graph view. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. In the Grid/Graph, you can use MicroStrategy Web to create a threshold to change the formatting of the revenue amounts when the profit is greater than a specified amount. In MicroStrategy 10. “Intelligent Cube (<Cube Name>) for locale. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. Easily add or change pre- and post- SQL statements. Add a dataset. Use Intelligent Cube Editor. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect. To do so, you can take advantage of URL API. 11. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. 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. 1. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Data access security is maintained. However, importing data from a Google Drive Spreadsheet requires some additional setup. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. Execute reports or documents that reference the object. Right-click the cube, and select Schedule Data Refresh. To Create a Report that Accesses an Intelligent Cube. Navigate to the folder location of the Intelligent Cube. 3. Create an Intelligent cube with Month and Revenue. Navigate to the Intelligent Cube you want to refresh. 3 - Check the Make Intelligent. Navigate to the Intelligent Cube for which you want to define the incremental refresh. For Oracle 12. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Insert one panel stack and add dynamic text with Profit Margin. 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. x releases, and the new Multi-table Data Import (MTDI) cubes. Total Cubes This section displays the total count of cubes by status. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Right mouse click on the cube and choose Schedule 3. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 1. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Create an Intelligent Cube, with Region, Category, Cost and Profit. Select an Environment from the upper-left drop-down. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. The file location in project configuration is . To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 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. Click the “Add history list subscription” link near the bottom of the screen to open the. 4. To publish an Intelligent. Contact the MicroStrategy Technical Support for an update on this enhancement request. 2. Right-click the report and select Edit. Community & Support Search Discussions Open A Case View My CasesThis defect is addressed in MicroStrategy 11. x, when there are multiple fact tables available to perform the fact extension, different fact table are used by the analytical engine for the fact extension in Connect Live and In-Memory Intelligent Cube. Run a Command Manager script to delete the cube cache previously deleted in step 2. 2. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Right-click the dataset, and choose Schedule. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 4. Quickly integrating data into MicroStrategy as part of a proof-of-concept. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. For example, an Intelligent Cube includes Year and Quarter. 1 to see the results as shown. 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. On the Home screen, select My Subscription. The Intelligent Cube Editor uses the new Modeling service infrastructure. Designing and creating documents: An overview. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 4 the connection mapping of the u… Number of Views 1. 4. STEPS TO REPRODUCE: 1) Add external dataset. Web create derived metrics and derived attributes: This privilege allows you to create new calculations based on other. You can also select an existing template on which to build your new report. 4. You can edit project-level cache and Intelligent Cube settings. A set of data is returned from the. Importing MDX cubes is often handled by a MicroStrategy architect. Open the. To Schedule a Cube Refresh. In the New Intelligent Cube dialog box, select the MDX Sources tab. The following diagram depicts the role of the intelligent cube. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. The report opens with all of the objects of the Intelligent. 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. Intelligent Cubes. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. A report accessing the Intelligent Cube includes only Year on the report. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. 86K KB31566: MicroStrategy 9. 3. Update Cube Data *. Check the location of the new cube cache and notice that it is saved in the default location, i. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. Notice the attribute forms in the Report Objects pane. In MicroStrategy 9. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. When an Intelligent Cube is published, the Intelligent. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 1. STEPS TO REPRODUCE. A report that runs against the Intelligent Cube. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. Open the cube report in Design View. Select a schedule from the Schedule drop-down list. Browse to and select a previously saved Intelligent Cube on which to build your report. You can also create Intelligent Cubes by directly querying your data. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. 0. Common Privileges. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below:To update the newly created Super Cube, create a new script starting from repeating steps 3-7. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. Create Cube A and a report based on it. 4. g. 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. Open the. Publish the cube. Create an Intelligent Cube with attribute Region and metrics, Revenue and Revenue Forecast; Create a subset report based on the above Intelligent Cube; Insert a derived metric DM = Revenue Forecast/Revenue as seen below: Execute the report either in MicroStrategy Desktop 9. Open the cube report in Design View. Open the cube report in Design View. The Intelligent Cube Editor uses the new Modeling service infrastructure. By default, there is a system hierarchy on the cube. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Login MicroStrategy Web as M20061, go to Add External Data -> Databases -> Select Tables, pick the following tablesFollow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Refer to the following tech note, KB37431 for a list of Licenses and privileges required for different actions related to Visual Insight in MicroStrategy Web 9. With OLAP Services features, your report designers can create Intelligent Cube reports. Run the Report and check the SQL View. Under Refresh type, select one of the following options. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. x. These VLDB properties control the method by which the report data are normalized. In MicroStrategy Developer, edit the Intelligent Cube where u sers want to enable partitioning. For example, you can choose to add or delete data from the Intelligent Cube. 4 the connection mapping of the u… Number of Views 1. In MicroStrategy 9. Intelligent Cube IC2 contains attributes 'Country' and 'Region' Create a report services document with the above 2 Intelligent Cubes as datasets. You need the Use Intelligent Cube. STEPS TO REPRODUCE. 1. An. x releases, and the new Multi-table Data Import (MTDI) cubes. To view an existing cube, you must have the following minimal privileges: Use analytics. 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. 000007431. Save the cube, and run it to publish. Navigate to the Intelligent Cube you want to refresh. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. 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. Run a dossier based on the cube. The differences between the options. From the cube monitor, we could see the old cube is it. To review and create recommended Intelligent Cubes using Cube Advisor. KB30711: Security filter application to view reports based on Intelligent Cubes. The New Grid dialog box opens. 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:. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. Save the Cube with Connect Live Data Access Mode. 4 the connection mapping of the u… Number of Views 1. Check it in the cube monitor and we can see its column Database Connection is not empty. x. Create Schema Objects. Select other schedule options as required, and click OK. Node 1. Configure a Cluster with a Centralized Cache. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Supports derived metric creation. 2. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. com. 4. Create an Intelligent Cube, with Region, Category, Cost and Profit. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Workaround 2: Create a non-Kerberos authenticated database login. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. x-10. 4. On the Home screen, select My Subscription. By default SuperCube. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. x. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Full Refresh. Publish. Multiple reports can access a single. In MicroStrategy Developer, log in to a project source with administrative privileges. Type a name for the derived element, and click OK. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public Objects\Reports\Sequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a script that also requests the Command Manager console to be open through the command prompt. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Intelligent Cubes. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. In the left pane, click Intelligent Cubes. The. 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. Create Schema Objects. KB30711: Security filter application to view reports based on Intelligent Cubes. Republish the same cube, and a new cube instance is generated. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. In the Refresh Policy column, choose. 2. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 4. 2. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Select the data sources to be refreshed. In your Datasets panel, hover over the name of your dataset. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. Log in to a project connected to an MDX cube source. Modify the list of Report objects (use object browser). 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. Description What's New 2022 Releases 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. Once you have reviewed the information, select the check boxes for the Intelligent Cubes to create using Cube Advisor, and then click Create Cube Design. x. This determines the approach to existing data at refresh. Number of Views 1. In Web, create a new Dossier and click on New Data. 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. Create. In the Object name field, type a descriptive name for the Intelligent Cube. Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. Log into ProjectA in MicroStrategy Web. Cube index generation will increase cube size. This is the same requirement to create or run a static report in Workstation. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Normalize Intelligent Cube data in the. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. The ability to view or edit certain settings is determined by a user's privileges. Save the Intelligent Cube generated. Create a second report with the year and quarter attributes and the revenue metric. Under Cube Update, click Cube Update. Some uses for this data include: •. Choose Databases.