Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. table_id: is the guid of a table. 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). Create a Data Import Live Intelligent Cube. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesSTEPS TO REPRODUCE. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). The display of data is handled by the reports that access the Intelligent Cube. Browse to the filter you want to convert and click Open. Check it in the cube monitor and we can see its column Database Connection is not empty. 3. Reproduce Steps This level of system resources allows MicroStrategy Intelligence Server to fully use performance-improving technologies such as MicroStrategy OLAP Services, and to support optimal performance for MicroStrategy Report Services documents and dossiers and the other features of the MicroStrategy Product Suite. Together with the Reports API, this API is often referred to as the JSON Data API. A solution/code fix for this issue is not available in current releases but is. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. Edit Intelligent Cubes from the new editor in Workstation at any time. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 3. Data modeling is the structuring of an organization's data assets into an applicable logical model. Create the MIN (CurrentDateTime ()) metric. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. x) • MSI_STATS_PROP (properties table that MicroStrategy Intelligence Server uses to initialize statistics logging) • IS_SESSION_STATS (server session statistics)In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Integer ID of the Intelligent Cube report that was published, if any. For more information on Intelligent Cube sizes, refer to the following MicroStrategy Knowledge Base technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. If the data in the Intelligent Cube is outdated. Advanced category, select the Balance MicroStrategy Server threads check box. If the Intelligent Cube must be re-processed based on a metric. The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. Records statistics related to Intelligent Cube manipulations. Create Schema Objects. microstrategy. 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. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. MicroStrategy Intelligence Cube. Edit Intelligent Cubes from the new editor in Workstation at any time. III. 4. IS_CUBE_INST_ID. Index: P = Processing A = Active L = Loaded D = Dirty F = Filed M = Monitoring Information Dirty When a user executes an Intelligent Cube, the initial status is P. You must belong to the System Administrators group to use this feature. Intelligent Cubes can be based on MicroStrategy data or imported data. This is the same requirement to create or run a static report in Workstation. 4. x. 1. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. Strong semantic layer to define all the business rules and tightly coupled. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Create a New Dossier. x - 10. Click View Logs, to display the share icon in the upper-left. x - 10. Contact the MicroStrategy Technical Support for an update on this enhancement request. When a machine runs out of virtual memory, processes on the machine are no longer able. Total Cubes This section displays the total count of cubes by status. Expand the Object Templates category, select General, and from the. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. This enterprise analytics tool works seamlessly across web-based content, mobile devices, and Microsoft Outlook to bring answers to people through relevant, context-based analytics. 1. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. 0 votes. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. You can control users' access to data with security filters. Intelligent Cube storage on disk mirrors report cache storage. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. Dossier Datasets do not include all the Security Filter attributes, and one of the Datasets are Connect Live Data Import Dataset, it may have security concerns. Drag and drop the objects into the report grid from the Report Objects pane. Starting in MicroStrategy 10. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. 17. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. Create a report with the year and quarter attributes and the profit metric. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. In MicroStrategy Developer, right-click on the project and select Project. Open the. Designing and creating documents: An overview. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. Although the directory filed shows the same location as the source project, cubes are saved to a. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. e. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. This article notes how support for transformation metrics in Dynamic Sourcing works. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. x Intelligent Cube status indication and workflow . Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. Um Cubes zu erstellen, müssen Sie über die folgenden zusätzlichen Privilegien verfügen: Verwenden Sie den Intelligent Cube Editor, um auf alle Merkmale und Funktionen zum Erstellen von Cubes zuzugreifen. ACTION:In MicroStrategy Intelligence Server, how does the project configuration setting "Load Intelligent Cubes on startup" work in a clustered environment?To Create an Intelligent Cube Using Freeform SQL or Query Builder. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. 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. x. Required Status to Perform Action. When using MicroStrategy and Teradata, the best approach is to. Also, verify that the /<path_to_the_location>/core. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. 3. OR, to convert an existing filter into a security filter, click Import. The Modeling service must be configured correctly to use this feature. The Intelligent Cube Options dialog box opens. This import bridge imports MicroStrategy logical tables as Dimensions. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. MicroStrategy logical tables do not necessarily represent physical tables. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. OR, to convert an existing filter into a security filter, click Import. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. You may share the Intelligent Cube as a single copy in memory. 3. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. x to 11. For example, an Intelligent Cube that contains data for the top 200 stores by Profit must be re-calculated every time it is updated, and thus must use the Full Refresh option. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). Slice and dice features are awesome. Intelligent Cube storage on disk mirrors report cache storage. 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. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. x This is a new feature introduced in MicroStrategy version 9. An example of this behavior for a relatively small cube is shown in the screen shots below:The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. certify() to certify / decertify an existing super cube. In MicroStrategy Desktop 9. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. Making the move from Developer to Workstation even smoother, users can now create Intelligent Cube Reports in Workstation. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. x and 10. They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. This data is to apply the calculations. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. Maintaining data access security. You must belong to the System Administrators group to use this feature. For instance, let’s say you have an Intelligent Cube with 2 million rows and 10 attributes and 5 Expand Intelligent Cubes, and then select General. 1 and 10. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. MicroStrategy HyperIntelligence is the next step in the future of data analytics. The New Intelligent Cube dialog box opens. 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. Answer: Go with dossier. You cannot create a card based on a live-connect MDX/SAP cube. Web Open the Settings page (right click the extension and select Options). It is shared by all processes running on the machine, including the operating system. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. This is the same requirement to create or run a static report in Workstation. 5 GB . In addition, multiple logical tables can represent the same physical table. The. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. 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. Drag and drop the objects into the report grid from the Report Objects pane. KB442449: Dossier Performance: Connect Live performance considerations. x. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. This can. Slice and dice features are awesome. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. MicroStrategy logical tables do not necessarily represent physical tables. Email subscriptions deliver a report or document to one or more email addresses. Number of Views 1. To do this, edit the report in developer and go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose the new target cube: Create Cube A and a report based on it. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Create Schema Objects. 4. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. With OLAP Services features, your report designers can create Intelligent Cube reports. In the Drilling area, clear the Use default settings check box. Choose File > New > Intelligent Cube. In MicroStrategy Integrity Manager 10. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. . 4. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. If the Intelligent Cube must be re-processed based on a metric. From the Categories list, expand Options, and then select General. Locate and run the Setup. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. To Create a Report that Accesses an Intelligent Cube. Dynamic Sourcing is a new feature of MicroStrategy 9 OLAP Services that automatically checks a report request, and sources data from a MicroStrategy Intelligent Cube wherever possible. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. 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. IS_PROJ_ID. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). You can control users' access to data with security filters. Senior Lead, Application Support. For a detailed explanation of the Cube Status values, see KB31566: MicroStrategy 9. Node 2. Browse to and select a previously saved Intelligent Cube on which to build your report. Browse to the filter you want to convert and click Open. No data is returned for the report. Overview. the project configuration: ACTION . The Intelligence Server checks to see if there is an existing cache for the same Report. Intelligent Cube file directory Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. The Security Filter Editor opens. 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. Expand the Object Templates category, select General, and. x. 4. IS_CUBE_ACT_ID. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. This Python 3 / MicroStrategy 10. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Moreover, you can return a data. 2. Cube Advisor opens. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. What BO customers are interested in knowing 3A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. These reports allow data to be returned from the data. The memory used by Intelligence Server is limited by the machine's virtual memory. Choose your preferred method to share the logs. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. The Intelligent Cube Options dialog box opens. However, the cube monitor doesn’t show partition related information. x If the Administrator wants to create a user that is. The Intelligent Cube opens in the Report Editor. An Intelligent Cube is a. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. From the Data menu, select Configure Intelligent Cube. On the toolbar, choose Data > Configure Intelligent Cube. 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. IS_CUBE_REP_ID. The change journal logs now process the type, version, and name for databases configured in an environment. Create Cube B which contains all objects in the report and publish it . MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. 2 – The data is being pushed to MicroStrategy Intelligent. Cube Cache Hit: Download MSTR File with Cube Cache Hit: Indicates a user exported a dossier object based on cube as an MSTR file and hits the cube cache. Upgrade to those versions to take advantage of the fix. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Both properties are located in the Query Optimizations folder in the VLDB property editor. The maximum number of Intelligent Cubes that can be loaded onto Intelligence Server for this project. Publish the cube. Report: The results of a report are used to populate the Intelligent Cube. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. Seamlessly create Intelligence Cube Reports. Intelligent Cube file directory: Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. ACTION: A fix for this issue is included in MicroStrategy 10. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Create an attribute element prompt for the. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Number of Views 1. 1 – Python program gets and processes the data from a Data Source. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. 4. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. All MicroStrategy security settings are respected when interacting with MicroStrategy. IS_PROJ_ID. Users cannot trigger or schedule cube republishing. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. From the Data menu, select Configure Intelligent Cube. MicroStrategy is the only comprehensive analytics vendor that supports big data analytics with native connectors to HDFS to access petabytes of data in real time. There's a reason we're at the top of the list. Intelligent Cubes. The MicroStrategy Intelligence Server 9. If desired, user can create a dashboard immediately from the imported data. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Select data population for Intelligent Cubes. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). However, if the Intelligent Cube Monitor on the other node is checked, the size of the same Intelligent Cube will be smaller. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. x releases, and the new Multi-table Data Import (MTDI) cubes. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. " The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. There's a reason we're at the top of the list. MicroStrategy Tutorial is used in this example. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. Pros and Cons. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 11. Data in Intelligent cubes can be either marked as available for time zone conversion when running objects against it or set within a specific time zone. 1, Intelligent Cubes have a new feature to update information without republishing it. For reports and Intelligent Cubes that do not use MultiSource Option or database gateway support to access multiple data sources, all queries are processed sequentially. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Choose your preferred method to share the logs. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. The Maximum RAM usage (Mbytes) memory limit can be defined per project. The first is to enable report caching at the project level. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. GUID of the Intelligent Cube instance in memory. To build an Intelligent Cube. The MicroStrategy Tutorial project uses aggregate tables by default. zip and use 7Zip, or similar tools, to unzip it. Select the data set and click Prepare Data. For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. Check the status of the cubes in Developer. Limited mobile capabilities compared to the latest BI tools like MicroStrategy. In MicroStrategy 10. To add an existing report or Intelligent Cube as a dataset. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. This is controlled by the Python script. The related section is located in. The Incremental Refresh Options dialog box opens. Before MicroStrategy 10. Add Year Id and Quarter. Once activated, the user loads the cube in memory. IS_CUBE_REP_ID. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. Log on to the machine where you are installing one or more MicroStrategy products. You can add data for your Intelligent. Integer ID of the project where the Intelligent Cube is stored. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. Right-click an Intelligent Cube and select Delete. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. A document is used to format data from multiple datasets in a single display of presentation quality. 6 and higher. Easily add or change pre- and post- SQL statements. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 0. Web Open the Settings page (right click the extension and select Options). Click View Logs, to display the share icon in the upper-left. An Intelligent Cube has been created in a project. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Pros and Cons. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. An Intelligent Cube is. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. 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. UPDATE: the refresh policy is Update existing data. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. To build an Intelligent Cube.