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. Create an attribute element prompt for the Year attribute. and select the Project-Name. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. 2. Report: The results of a report are used to populate the Intelligent Cube. This determines the approach to existing data at refresh. By default, this is set to 32,000. You must browse to the MDX cube to use to build the Intelligent Cube. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Under Refresh type, select one of the following options. Add Project objects from the All Objects panel. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Select a schedule from the Schedule drop-down list. Designing and creating documents: An overview. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. 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. Navigate to the Intelligent Cube you want to refresh. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Create Intelligent Cubes. 4. 2. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. STEPS TO REPRODUCE. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. Intelligent Cubes. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Con: The copy of report data in Intelligence Server memory only applies to a single report. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. This determines the approach to existing data at refresh. MicroStrategy Developer 9. Login Web with Administrator, Create a VI Dashboard based on this cube. In the Data Source column, select the checkboxes for the tables to update. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Job ID for the action on the 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. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The Browse for Folder dialog box opens. Importing MDX cubes is often handled by a MicroStrategy architect. Login MicroStrategy Developer 10. 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. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. At this point, the Month attribute can be removed from the cube to reduce the publication time and size of the Intelligent Cube within memory. 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. HyperIntelligence for Web was first. 1 product only with documents using view filter qualifications. Type a name for the derived element, and click OK. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Select Intelligent Cubes > General > Intelligent Cube File directory. And create one Cube based report called “cube report 2”. From the. From the cube monitor, we could see the old cube is it. These VLDB properties control the method by which the report data are normalized. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. From the File menu, select Create Test. You can edit project-level cache and Intelligent Cube settings. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. Right-click an Intelligent Cube and select Delete. Web modify the list of report objects (use object browser --all objects) Web Professional. The New Intelligent Cube dialog box opens. Create an Intelligent Cube with attributes Year, Month and Region; 4. 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. 9 and 10. The Modeling service must be configured correctly to use this feature. Defining the partition for Super Cubes. Modify the list of Report objects (use object browser). 38K. You can also select an existing template on which to build your new report. This is because with this feature enabled, the element block ID will be saved to the new cube cache. In the Refresh Policy column, choose. Sharing data. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. 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. A page with report creation options is displayed. 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%. Watch the Product team review how to configure and manage advanced properties of Intelligent Cubes. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. To Create a Report that Accesses an Intelligent Cube. ICUBE_STATUS: shows the status of the intelligent cube, returned as a string value. 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. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. In the Data Source column, select the checkboxes for the tables to update. 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. Click Databases . Create a new File Log and name it “CSI” (or any other name). You need the Use Intelligent Cube. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Con: The copy of report data in Intelligence Server memory only applies to a single report. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. 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. 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. All necessary privileges are included in the Administrator role by default. This " How to" knowledge base article explains cube advisor. 3. Right mouse click on the cube and choose Schedule 3. These privileges are part of OLAP Services. CAUSE: This is working as designed. 1 release. Open the report in Grid View, Design View, or Grid and Graph view. Save the Report and close. Steps to reproduce. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . Using MicroStrategy Developer, log in to a project connected to an MDX cube source. CAUSE: Starting in MicroStrategy 9. com. Select the environment and project where you want to save your. Publish the cube. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Log in to the project in which you want to create a report. x releases, and the new Multi-table Data Import (MTDI) cubes. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. Select the Intelligent Cubes tab. The Intelligent Cube Editor uses the new Modeling service infrastructure. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. Add Year Id and Quarter. The Intelligent Cube opens in the Report Editor. 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. To publish your cube, see the In-Memory Analytics Help. This issue has been classified as a defect by MicroStrategy. 4. The Intelligent Cube opens in the Report Editor. Web publish 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 New, and then select Intelligent Cube. Check the status of the cubes in Developer. 1Currently it is not possible to create a cube refresh subscription in Command Manager. 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. Call this 'Base Report'. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. In MicroStrategy Developer, log in to a project source with administrative privileges. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. This is the same requirement to create or run a static report in Workstation. Data Population for Intelligent Cubes. You can also modify the properties of. In the Refresh Policy column, choose. 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. Export to MicroStrategy File. The month ID for 2004 Jan is like 200401. This copy of report data is stored in Intelligence Server memory only. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. In MicroStrategy Web 9. The Select Intelligent Cube dialog box opens. The Report Editor opens with all of the objects of the Intelligent Cube. KB30711: Security filter application to view reports based on Intelligent Cubes. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. The Intelligent Cube Editor uses the new Modeling service infrastructure. 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. HyperIntelligence for Web. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. Create a cube report based on the cube. Edit Intelligent Cubes from the new editor in Workstation at any time. Right-click the dataset, and choose Schedule. Browse to an Intelligent Cube, select it, and then click OK. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. Easily add or change pre- and post- SQL statements. The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. Right mouse click on the cube and choose Schedule 3. You can use the Import Data feature in MicroStrategy Web to import data from sources such as Microsoft Excel spreadsheets, comma-separated text files, and external databases into your project. Select the data set and click Prepare Data. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Create a Data Import Live Intelligent Cube. To view an existing cube, you must have the following minimal privileges: Use analytics. PublishCube". The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. In the Navigation pane, click Applications. 2. 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. 4. From the System Manager home page, you can access the template workflows in the Templates section. 4 the connection mapping of the u… Number of Views 1. This permission is checked at design time, and when executing reports against an Intelligent Cube. A solution/code fix for this issue is not available in current releases but is being reviewed for a future MicroStrategy. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. In the Name field, type the name of the subscription. 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. 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). Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Right-click the dataset, and choose Schedule. Run a Command Manager script to delete the cube cache previously deleted in step 2. Supports derived metric creation. The dataset is a set of data that can be displayed on the document. Sharing data. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. 1 or MicroStrategy Web 9. IS_CUBE_REP_ID. This Python 3 / MicroStrategy 10. Complete the "sessionState" field (e. 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. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. In the Object name field, type a descriptive name for the Intelligent Cube. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Publish the cube. x checks for 'Execute' access to the managed column object being used in the metric when adding it to the report, which is not required for regular non-mnanaged metrics. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. To Schedule a Cube Refresh. Select data population for Intelligent Cubes. A list of data sources available in this project appear. 2. 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. Publish the Intelligent Cube by executing it on either of the nodes. 4. Reporting on MDX Cubes. Steps to Reproduce. Then click "Save". All articles. Execute. Add a grid with the attribute Customer. Intelligent cubes & Level Metrics. Share query results in-memory across multiple dossiers and. Select Build a Query and click Next. To choose from the full list of template workflows, click the. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Right-click the cube, and select Schedule. Choose File > New > Intelligent Cube. Use the drop-down under the filter summary section to switch the server nodes. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 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. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. 1. 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. Open the. Common Privileges. Create a second report with the year and quarter attributes and the revenue metric. 2. Web Analyst. Create a report based off the cube in Step 1 that includes the description form for Category. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The report opens with all of the objects of the Intelligent. Do not normalize Intelligent Cube data. Some uses for this data include: •. 8. This property can only be enabled through Workstation. The default value is 256 megabytes. Click All Objects View. Follow the steps below using the MicroStrategy Tutorial project: 1. Number of Views 3. You can use a report or Intelligent Cube. From the Data menu, select Add Dataset. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Drill within Intelligent Cube:. 1. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Enter a name for your new schedule into the. An Intelligent Cube is a set of data that can be shared as a single in-memory copy, among many different reports created by multiple users. 4 the connection mapping of the u… Number of Views 1. 6. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. 2. The partition attribute is the attribute that is used to divide. MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. In Developer, log in to a project with a user account with administrative privileges. A set of data is returned from the. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. In your Datasets panel, hover over the name of your dataset. 4. The main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loadedConsider the following example based on the MicroStrategy Tutorial project. Choose File > New > Intelligent Cube. This provides ROLAP-type analysis without having to re-execute against the data warehouse. Create and publish Intelligent cube called “Cube2” on node B. Cube Advisor opens. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. A report that runs against the Intelligent Cube. Intelligent Cubes. 4. 4. This is the same requirement to create or run a static report in Workstation. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. /ClusterCube. You must belong to the System Administrators group to use this feature. In MicroStrategy Developer, log in to a project source with administrative privileges. Run a dossier based on the cube. For more details on enabling the setting. With OLAP Services features, your report designers can create Intelligent Cube reports. 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. An enhancement Request has been reported to the MicroStrategy Technology team. 1. 4. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. Click Intelligent Cube Report. 2. Publish. x. 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. STEPS TO REPRODUCE 1. Published: 4월 6, 2017. 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. Click All Objects View. 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. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 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. 1. Integrity Manager can test the SQL of Intelligent Cubes even if they. The Intelligent Cube Options dialog box opens. 1 to see the results as shown. Load an updated CSV file into a DataFrame providing full path. Edit Intelligent Cubes from the new editor in Workstation at any time. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. It is possible to create an Object Manager package for an Intelligent Cube created through Data Import in Web and then import the package into a different environment in MicroStrategy 10. 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. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. STEPS TO REPRODUCE: 1) Add external dataset. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. 3. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. In MicroStrategy Developer, log in to a project source with administrative privileges. Restoring cube files. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Description. Create an intelligent cube report with Year and three derived metrics and enable "Aggregate from base" as shown below: Insert view filter "Year in list (2009)". In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. The Incremental Refresh Options dialog box opens. 2. 2 release, the driver file is called odbc8. Navigate to the Intelligent Cube for which you want to define the incremental refresh. 0 MicroStrategy releases. Web Analyst. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. Visualizations in the dossier that use data from the cube display. You can use the Import Data feature in MicroStrategy Web to import data from sources such as Microsoft Excel spreadsheets, comma-separated text files, and external databases into your project. 4. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. From the Categories list, expand Options, and then select Data Languages. This is an identified defect in Visual Insight in MicroStrategy Web 10. Common Privileges. x Intelligent Cube status indication and workflow To create an attribute form caching cube. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Open the Workstation window. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. In MicroStrategy 9. Create a dossier and add subset R from Existing Dataset. Visit the data visualization and data dashboard galleries for inspiration. 4. Workaround 2: Create a non-Kerberos authenticated database login. x, users will notice that this is not possible due to the mouse. 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. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. Integer ID of the project where the Intelligent Cube is stored. Save the cube, and run it to publish. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. Use OLAP Services. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Run report off cube. Dynamic source hit. In the Name field, type the name of the subscription. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. It also. Navigate to Administrator -> System monitor -> Cube monitor both nodes, and check all cube are “active, load, file” status. 1. In the left panel, click Cubes. 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. 119 Share Save 45K views 9 years ago MicroStrategy Advanced Topics by MicroRooster Source: MicroRooster. All necessary privileges are included in the Administrator role by default. Browse to and select a previously saved Intelligent Cube on which to build your report. Log in to a project connected to an MDX cube source. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Browse to and select a previously saved Intelligent Cube on which to build your report. Visit the data visualization and data dashboard galleries for inspiration. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. Permanent Table: When the queries for a report or Intelligent Cube are performed in parallel, any intermediate tables are created. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. create(auto_upload=False,. x. Total Cubes This section displays the total count of cubes by status. Importing MDX cubes is often handled by a MicroStrategy architect. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. GUID of the Intelligent Cube instance in memory. The create_cube() function will return the datasetID and tableID, which can be used to update a dataset with new data. Create Schema Objects. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. In MicroStrategy Web, open the document in Design Mode or Editable Mode.