A possible cause of this issue is that the folder that stores the Intelligent Cube files on the node where the Intelligent Cube is published is not shared with the name 'ClusterCube' on the MicroStrategy Intelligence Server machine(s). For the example scenario, log in to the MicroStrategy Tutorial project. 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. Choose File > New > Report. Shut down Intelligent Server node A with command . Click a catalog. Click Create on any folder page, point to New Report, and select MDX Cube Report. after executing the Login task), and type the GUID of the. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. IS_CUBE_REP_ID. Start > All Programs > MicroStrategy Products > Integrity Manager. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". 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. Add Project objects from the All Objects panel. Complete the "sessionState" field (e. 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. 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. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. e. Start > All Programs > MicroStrategy Products > Integrity Manager. Since Web distributes connections between Intelligence Servers. 4. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. ACTION:In the Navigation pane, click Monitors. Under Refresh type, select one of the following options. 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. MicroStrategy Tutorial is used in this example. It's basically just a report, and can even start it's life off as a report. Cube A must be selected here to maintain its attribute IDs after the merge. Create a report based on the Intelligent Cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. 2. Select the data set and click Prepare Data. Create an attribute element prompt of Month, and use above filter in "Use a filter to reduce the number of elements", as below picture shown: 3. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. Right mouse click on the cube and choose Schedule 3. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. In the left pane, click Intelligent Cubes. Load an updated CSV file into a DataFrame providing full path. Create Intelligent Cubes. 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. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Republish the Intelligent Cube or re-create a report cache, which will be shared with MicroStrategy Technical Support; Send the requested data to MicroStrategy Technical Support; Revert the metric definition back to the original one, or remove the randomized metric from the report (Intelligent Cube configuration is not relevant in MicroStrategy 8. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. 4. Defining the partition for Super Cubes. MicroStrategy AI is here. Select the data sources to be refreshed. STEPS TO REPRODUCE. com. Click Create on any page, point to New Report, and select Blank Report. Include “Qualification Prompt”. As shown in the screenshot above, only one cube cache can be loaded in RAM. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. STEPS TO REPRODUCE: 1. Right-click the Intelligent Cube, and select Define Incremental Refresh. 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). ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. 4. Go to MicroStrategy Web 10. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. x. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. 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‘. microstrategy. 2. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. 38K. For the Intelligent Cube that you want to refresh, click the subscription icon. Create a Report 'R3' with 'Country' attribute. 3 - Check the Make Intelligent. Easily add or change pre- and post- SQL statements. 4. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. 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. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. Choose Databases. KB30711: Security filter application to view reports based on Intelligent Cubes. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. Web Analyst. 4. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Intelligent Cubes. Node 1. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Create a new File Log and name it “CSI” (or any other name). In the user interface, specify the partition attribute and the number of partition . 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. The "Refresh Cube. Create a document with orderID and itemID attributes on the grid. Reporting on MDX Cubes. 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. The Subscription Editor opens. Open the. Create a Report 'R3' with 'Country' attribute. A report that runs against the Intelligent Cube. In MicroStrategy Web, edit the Cube where users want to enable partitioning. The Modeling service must be configured correctly to use this feature. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. In a clustered MicroStrategy Intelligence Server Universal compounded by two nodes Node A and Node B, a cube test cube is published on Node A and its status can be seen in Administration >> System Monitors >> Caches >> Intelligent Cubes:To view an Intelligent Cube stored in your History List. x. 4. Integer ID of the Intelligent Cube report that was published, if any. Create Schema Objects. This Python 3 / MicroStrategy 10. 6. details. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Check the status of the cubes in Developer. 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. The New Intelligent Cube dialog box opens. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 11. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. Create. 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. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. com Format: A MicroStrategy Online. Cube index generation will increase cube size. You can also select an existing template on which to build your new report. IS_CUBE_ACT_ID. 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. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. From the cube monitor, we could see the. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. Create a report based off the cube in Step 1 that includes the description form for Category. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. To set refresh filters, or alternate data sources, select Show Advanced Options. 2. See Importing MDX cubes in the MDX Cube Reporting Help for more information. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. This privilege is part of OLAP Services. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. In MicroStrategy Web, open the document in Design Mode or Editable Mode. Steps To Reproduce 1. In MicroStrategy Web, log in to a project. 2. Web create derived metrics and derived attributes: This privilege allows you to create new calculations based on other. Faster performance than directly querying warehouse. Right-click the dataset, and choose Schedule. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. Ensure that the email addresses can be displayed properly. STEPS TO REPRODUCE: 1) Add external dataset. 1. And create one Cube based report called “cube report 2”. The dataset is a set of data that can be displayed on the document. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Insert one panel stack and add dynamic text with Profit Margin. Navigate to the Engine Component with CSI Dispatcher. To publish an Intelligent Cube, see. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. Save the Report and close. In MicroStrategy Developer, edit the Intelligent Cube where u sers want to enable partitioning. Create a report based off the cube in Step 1 that includes the description form for Category. Configure a Cluster with a Centralized Cache. e. 4 using an Excel file and the Connection mapping database connections of the user account which published the cube are listed when checking the Intelligent Cube monitor in Developer. Con: The copy of report data in Intelligence Server memory only applies to a single report. 3. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. Create Intelligent Cubes. 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. The New Grid dialog box opens. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 4. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. The display of data is handled by the reports that access the Intelligent Cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Follow the steps below using the MicroStrategy Tutorial project: 1. Unable to create Derived Elements in a Report Services document with a dataset that is not based on an Intelligent Cube in MicroStrategy Developer 9. You can also create Intelligent Cubes by directly querying your data. Right-click an Intelligent Cube and select Delete. In the Tutorial project create a cube with the Year attribute. Modify the list of Report objects (use object browser). If the Intelligent Cube must be re-processed based on a metric. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. Import MicroStrategy File. Contact the MicroStrategy Technical Support for an update on this enhancement request. To view an existing cube, you must have the following minimal privileges: Use analytics. 9 and 10. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. To build an Intelligent Cube In Developer, from the File menu select New, and then Intelligent Cube. They should have the “A, L, F” status (Active, Loaded, Filed). HyperIntelligence for Web was first. x. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. A report accessing the Intelligent Cube includes only Year on the report. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. ICUBE_STATUS: shows the status of the intelligent cube, returned as a string value. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. microstrategy. Browse to an Intelligent Cube, select it, and then click OK. Number of Views 2. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The Select Dataset dialog box opens. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. x: Create a new Intelligent Cube with Attributes Category, Subcategory and Metric Revenue. Open the. Kickstart Your Career Get. From the System Manager home page, you can access the template workflows in the Templates section. Share query results in-memory across multiple dossiers and reports. In MicroStrategy Web 9. Click Select. 4 the connection mapping of the u… Number of Views 1. Select the refresh policy. The report opens with all of the objects of the Intelligent. Add a grid to the document with the objects 'Region' and. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. How to configure, monitor, and manage Intelligent Cubes. To schedule updates for the Intelligent Cube. PUBLISH INTELLIGENT CUBE "Year Revenue Cube" IN FOLDER "profilesAdministratorMy Reports" FOR PROJECT "MicroStrategy Tutorial"; TRIGGER EVENT "Run Reports";Create an Intelligent cube with Month and Revenue. Edit Intelligent Cubes from the new editor in Workstation at any time. Note: number of columns should be the same as in the original file. Data Population for Intelligent Cubes. Web publish Intelligent Cube. Publish the Intelligent Cube by executing it on either of the nodes. The default value is 256 megabytes. 1 release. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. x, sharing of Intelligent Cube data files is configured similarly. Regular Intelligent Cubes created on Developer. Open the. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Create a report services document or Visual Insight Analysis. The following procedure will make cube data accessible to view reports. 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. All necessary privileges are included in the Administrator role by default. Select the data set and click Prepare Data. Navigate to the Intelligent Cube you want to refresh. Right-click the dataset, and choose Schedule. 1. From the Report Selection panel, go to the File menu > Open. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. However, importing data from a Google Drive Spreadsheet requires some additional setup. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . From the Categories list, expand Options, and then select Data Languages. 4. You can also modify the properties of. You need the. This is the same requirement to create or run a static report in Workstation. To Create an Intelligent Cube Using Freeform SQL or Query Builder Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Create an intelligent cube with Call Center, Quarter and the derived metric 3. 2. All articles. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 4 the connection mapping of the u… Number of Views 1. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. In MicroStrategy Developer, log in to a project source with administrative privileges. Check in Developer that the stopped node is in Maintenance Mode. GUID of the Intelligent Cube instance in memory. “Intelligent Cube (<Cube Name>) for locale. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. From the Data menu, select Configure Intelligent Cube. In MicroStrategy 9. When an Intelligent Cube is published, the Intelligent. On the Home screen, select My Subscription. 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. blogspot. The user continues to use the report that accesses the Intelligent Cube. Rather than returning data from the data warehouse for a. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. To Create a Report that Accesses an Intelligent Cube. Complete the "sessionState" field (e. 11. However, importing data from a Google Drive Spreadsheet requires some additional setup. Navigate to the Intelligent Cube for which you want to define the incremental refresh. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. 86K KB31566: MicroStrategy 9. 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. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. 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. Open the cube report in Design View. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. Open Command Manager and type the following commands to. If you want to create an empty SuperCube, use SuperCube. You can also select an existing template on which to build your new report. Defining the partition for Super Cubes. The Schedule dialog box opens for your dataset, showing the tables in your dataset. By default, this is set to 32,000. 4. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. This data is stored as Intelligent Cubes. 4. Integrity Manager can test the SQL of Intelligent Cubes even if they. This Python 3 / MicroStrategy 10. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Save the Intelligent Cube. Common Privileges. 4. Run the Report and check the SQL View. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Click Databases . Node 1. To define an incremental refresh report. At least one MDX cube must be imported into your MicroStrategy project. 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 from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. Click the “Add history list subscription” link near the bottom of the screen to open the. The old cube files don't have this property, so new IDs will be generated every. Multiple reports can access a single. Normalize Intelligent Cube data in the Database 4. The Browse for Folder dialog box opens. The Intelligent Cube Monitor is displayed. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). Log into the three-tier project source and choose the project that was analyzed in stage 2. For background. The impact is limited to MicroStrategy Developer 9. Permanent Table: When the queries for a report or Intelligent Cube are performed in parallel, any intermediate tables are created. 2. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. x. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. In MicroStrategy 9. Steps to Reproduce. Open the cube report in Design View. After updating an intelligent cube through incremental refresh, when running a report based off the cube, the incorrect time (12/29/99 7:00:00 PM) appears as the last update time in MicroStrategy Web 9. 10, when the "Defect fixes may impact Data, SQL, MDX, CSI" is turned to "On" under Web preferences > Project Default, thresholds for derived metric cannot be properly applied if the condition is based on a cube base attribute. 2. x - 9. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. To publish your cube, see the In-Memory Analytics Help. 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. Save the Cube with Connect Live Data Access Mode. /mstrctl -s IntelligenceServer. When an Intelligent Cube is published, the Intelligent. Make sure the service is properly configured and running before using the Intelligent Cube Editor. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. 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. 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)". Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Select a database configured for SAP HANA. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. Modify the list of Report objects (use object browser). Create. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. Prerequisites. Republish the same cube, and a new cube instance is generated. The Report Editor opens with all of the objects of the Intelligent Cube. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 8. Supports derived metric creation. 2. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. You should see these cubes in the Intelligent Cube cache monitor in Developer. Expand Intelligent Cubes, and then select General. With OLAP Services features, your report designers can create Intelligent Cube reports. From the File menu, select New,. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. The Modeling service must be configured correctly to use this feature. Open the report in Grid View, Design View, or Grid and Graph view. HyperIntelligence for Web. 4. 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. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Click OK to save the Intelligent Cube and return to the Report Editor. 4. The Intelligent Cube opens in the Report Editor. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. Data access security is maintained. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. This data is stored as Intelligent Cubes. Select Intelligent Cubes > General > Intelligent Cube File directory. 0. This property can only be enabled through Workstation. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. 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. 3. The Intelligent Cube Editor uses the new Modeling service infrastructure. This can affect performance of your Intelligence Server as well as the ability to publish the. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. 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).