Exceptions: When the Report contains the following features which are not supported in Intelligent Cubes, it’s exempt from this feature: Custom Groups ; Consolidations; Derived Element; Cause: This is a known issue in MicroStrategy. To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. Intelligent cubes support time zone based reporting. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. KB485226: Intelligent Cube size increases irrespective of the "Maximum % growth of Intelligent cube to 50%" governing setting. You can update and modify the document in Design View. When an Intelligent Cube is in this status, any reports based on this cube have. Case A: Security Filter attribute is related to attributes placed on the grid. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. INTELLIGENT_CUBE_MAX_RAM: The maximum size in memory of all Intelligent. Select other schedule options as required, and click OK. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. 9 The MicroStrategy REST API has been unified and expanded to include the following REST API families: Authentication API; Browsing API; Cubes API; Datasets API; Datasource Management API; Dossiers and Documents API; Emails API; Library API;. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks. Both products' features range. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Créer des cubes Intelligent Cube par connexion à la base de données: Cochez cette case pour définir vos cubes intelligents à utiliser et prendre en charge le. In MicroStrategy Developer, log in to a project source using administrative privileges. When the subscription has been configured, click. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. Privilege. Same datasets available for MicroStrategy and TableauCan also be leverage in other analytic applications like SAS and RNo 2 billion row limit. The cube population process could be expensive in time and memory if the cube is large. Save the Report and close. Number of Views 1. x CAUSE: The user is missing the "Administer Subscriptions" privilege under "Administration" in. This VLDB property has the following options: Disable parallel query execution (default): All queries for MicroStrategy reports and Intelligent Cubes are processed sequentially. Depending on location set at the project level, one or none of the Intelligence server nodes will be able. Use the table below as a guide to determine whether switching to a single Intelligent Cube as dataset can improve the performance in your environment: 3. The New Grid dialog box opens. This property can only be enabled through Workstation. Defining the partition for Super Cubes. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. The Intelligent Cube opens in the Report Editor. " If you try to edit these MicroStrategy Connector cubes, you may be. Beginning in MicroStrategy 10. The fact that the. This option is enabled by default. Sharing data. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. The partition attribute is the attribute that is used to divide. The Intelligent Cube Options dialog box opens. In the New Intelligent Cube dialog box, select the MDX Sources tab. 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. View the report in either Grid View or Grid and Graph View. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. All articles. About this book. The default value is 256 megabytes. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. 1 and 10. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. Easily add or change pre- and post- SQL statements. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. Because the filters are applied to the master data in the Intelligent. Select the Data Partition category. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Choose File > New > Intelligent Cube. 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. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Import and filter data from a OlapCube, SuperCube or Report into a Pandas DataFrame (see code. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. Select an Environment from the upper-left drop-down. This defect is addressed in MicroStrategy 11. 1 and 10. Published: Nov 19, 2018; Last updated: Nov 18, 2022;MicroStrategy version 9. 4. To effectively create a HyperIntelligence dataset, your data must have attributes with either one-to-one relationships or many-to-one relationships. 0. You can also define when Intelligent Cubes. Subsequently the requests made by other users can. Main Features. Calculations changed for non-distributive metrics against Intelligence Cube after upgrading from 10. In MicroStrategy Developer, log in to a project source with administrative privileges. Interested in learning more about Platform Analytics or new MicroStrategy features? Visit the Learning Center on Community! Or feel free to visit our Documentation pages for product information. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. In MicroStrategy Developer, browse to an Intelligent Cube. (MDX) for interactively accessing cube databases from SAP, Microsoft AnalysisThis setting also defines when Intelligent Cubes are saved to secondary storage, as described in Storing Intelligent Cubes in Secondary Storage. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 2015-06-04 MicroStrategy Product Manuals 2015-02-01 MicroStrategy Product Manuals The OLAP Services Guide covers information on MicroStrategy OLAP. 0. To enable. The default value is 256 megabytes. The MSTR file download actions is also tracked, along with the export telemetry for documents, dossiers, and reports objects. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Right-click the dataset, and choose Schedule. and background information on Intelligent Cubes is in the MicroStrategy In-memory Analytics Help. The Intelligent Cube Monitor is shown in the image below. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. x and newer. • Reports can consist of documents with customized HTML format. , in search results, to enrich docs, and more. Expand Intelligent Cubes, and then select General. To view embedded fonts in Web, the fonts must be installed on the Intelligence Server machine. Users don’t have to mention the cube to which they want to connect. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. Watch on. MicroStrategy Library. Intelligent Cubes are part of the OLAP Services add-on to Intelligence Server. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. Main features of mstrio-py allows to access MicroStrategy data: Connect to your MicroStrategy environment using Connection class (see code_snippets) Note: to log into Library and use mstrio-py user needs to have UseLibrary privilege. 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. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. 2. Select other schedule options as required, and click OK. x product documentation "InMemoryAnalytics. Each user that connects to the MicroStrategy Intelligence server and/or project has a unique. . MicroStrategy Web allows you to merge two or more Intelligent Cubes. CSI after fix:What is a cube in Microstrategy? Intelligent Cubes: A shared Intelligent Cube (called 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. Published: May 15, 2018;This document provides settings that can be adjusted to help decrease Intelligent Cube publication times in MicroStrategy Secure Enterprise 10. The Intelligent Cube must be published before this report can execute. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. Managing Intelligent Cubes. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. Browse to the folder location to store Intelligent Cubes, and then click OK. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Right mouse click on the cube and choose Schedule 3. 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. x. An Intelligent Cube is an In-Memory data structure which. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. 1 and 10. With Oracle 11g, the integration with Oracle OLAP Cubes is transparent to MicroStrategy, because now cubes can be defined as Materialized Views (MV) and Oracle will rewrite SQL queries to these MV. For more details on enabling the setting, refer to Change Data Engine Version. In the Data Source column, select the checkboxes for the tables to update. To build an Intelligent Cube. The following diagram depicts the role of the intelligent cube. LIST ALL INTELLIGENT CUBES IN FOLDER "Intelligent Cubes" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. 39. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . The Intelligent Cube opens in the Report Editor. A dataset is a MicroStrategy report that is used on a document and all of the report's elements–attributes, custom groups, consolidations, and metrics. In MicroStrategy 10. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. 2. KB19654: How to obtain the Report Execution. This article explains how a cube and its cache become synchronized in a clustered environment. In the Data Source column, select the checkboxes for the tables to update. ACTION: A fix for this issue is included in MicroStrategy 10. The dataset is a set of data that can be displayed on the document. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. • Optimizi ng performance with Intelligent Cubes • Determining the order of calculation • Sharing reports using export, print, or by subscribing to report deliveries 1. From the Data menu, select Configure Intelligent Cube. 0. Browse to the folder location to store Intelligent Cubes, and then click OK. The Intelligent Cube Options dialog box opens. For detailed information about Intelligent Cubes. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. In the left panel, click Cubes. The blog series consists of four blog posts: Unlocking Data Value #1: SAP BTP Data and Analytics overview: Learn about our objectives, SAP products, and real. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. File subscriptions save the report or document as an Excel or PDF file to a disk location on the network. Publishing Intelligent Cubes. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Open the cube report in Design View. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. School NIT Rourkela; Course Title DATA ANALYSIS 102; Uploaded By DeanElectronHummingbird14. In MicroStrategy 2020, the password can be found in the Default_Accounts. Analyzing SQL and For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. x. 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. Create Incremental Refresh Reports directly in Workstation to define how the data is updated on Intelligent Cubes, all with an improved user experience. 2. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. KB440822. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. The status of each Intelligent Cube is listed in the. MicroStrategy 9. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. 0: PDF export comparison. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 4. Created narrowcast services to email /send to a directory either report service documents in PDF or excel files. Dedicate a machine for the metadata repository. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". Choose File > New > Report. From the Partition Attribute drop-down, select the partition attribute for the Intelligent Cube. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Intelligent Cube data can also be stored in secondary storage, such as a hard disk, on the machine hosting Intelligence Server. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is executed in. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. For information about non-aggregatable metrics, refer to the following MicroStrategy Knowledge Base document: KB16070: How to define nonaggregatable metrics in MicroStrategy DesktopWhen exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This knowledge base article assumes that the user has a month attribute whose format is YYYYMM as shown below and s/he wants to delete more than 12 months’. 4. From the Data menu, select Configure Intelligent Cube. x. x releases, and the new Multi-table Data Import (MTDI) cubes. pdf", Dynamic Sourcing -> Best practices for supporting dynamic sourcing -> Dynamic Sourcing for Incrementally refreshed Intelligent Cubes On the toolbar, choose Data > Configure Intelligent Cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. STEPS TO REPRODUCE: 1. It accesses and joins data. KB314273: Response regarding replacement of interactive PDF and MHT files . The maximum value is 9,999,999 and the minimum value is 0. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Visit the data visualization and data dashboard galleries for inspiration. 5 GB, the Data Transfer from Datasource(s) time is 77. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. 3. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. 0 MicroStrategy releases. In the Navigation pane, click Applications. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. Although this technique improves document performance, the amount of time required to publish an Intelligent Cube increases as it grows in size. For information on maintaining data access security with connection mapping to Intelligent Cubes, see the System Administration. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. In the left panel, click Cubes. x. The Intelligent Cube opens in the Report Editor. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. Due to data privacy considerations, MicroStrategy doesAs the new default monitoring tool for the MicroStrategy platform, Platform Analytics has a slightly different attribute structure to Enterprise Manager. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Choose Data > Configure Intelligent Cube. To test the new batch file, the user can execute the batch file by entering its file location in the command line as shown below. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 1) Right click the intelligent cube and select Properties -> Security . This article also provides a workaround to avoid this behavior. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. This will reduce the memory usage from 150GB to 100GB. For example, an Intelligent Cube includes Year and Quarter. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Refer to the tech note below for more information: KB32502 - Support for transformation metrics for Dynamic Sourcing in MicroStrategy OLAP ServicesWhen an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Afterwards the cube will start executing. Navigate to the Data Refresh category. 40. When trying to publish an Intelligent Cube via MicroStrategy Developer 9. You can also apply this security when users create reports that connect to an Intelligent Cube. Open the Workstation window. Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. x? Users may note that it is possible to limit the number of rows of data returned when publishing Intelligent Cubes, via the 'Final Result Rows' for 'Intelligent Cubes' located in the Project Configuration Editor. 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). Login to MicroStrategy Web, create a cube with the function of Data Import 2. Publish the specified Intelligent Cube to the Intelligence Server, so that it can be used by reports. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. 1 and 10. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. The Report Editor opens. Along with storing Intelligent Cubes in. If the objects (metrics/attributes) on an Intelligent Cube have restricted access (via ACLs), such cubes will be implicitly treated as live-connection cubes and hence won't be eligible for use with delivery as an MSTR fileThe Intelligent Cube Editor offers control over advanced properties. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. To schedule an Intelligent Cube to be updated. Multiple reports can access a single. To do so, you can take advantage of URL API. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. This property can only be enabled through Workstation. In MicroStrategy Web, you can. In the left pane, click All Settings. The Full Refresh option is the default. Loading. Find Cube Task . However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. "The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. The Subscription Editor opens. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. Build. 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. Turn on/off the Parallel Execution on project level or report level: Query Optimization > Parallel Query Execution. 88K KB41697: "The Intelligent Cube must be published before this report can be executed. In a clustered environment, each node in a cluster must share its result caches and intelligent cubes with the other nodes, so all clustered machines have the latest cache information. The cube population process is the one that retrieves the information from the Warehouse and transfer it to the MicroStrategy Intelligence Server memory in a format which can readily be consumed by different reports requests. 0 has a dedicated section to memory used for Intelligent Cubes. MicroStrategy reference numbers for this technical note are KB442285 and DE101600. MicroStrategy will continue to investigate and post updates as soon as they are. x, with the Intelligence Server running on Linux, the. Creating an Intelligent cube is similar to creating a report. 18K. To enable. txt file. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. This template includes the following tasks: Creates a new metadata. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The Intelligence Server generates a query based on the requested information and the received definition. Information to use MicroStrategy OLAP Services features, including Intelligent Cubes, derived metrics, derived elements, dynamic aggregation, view filters, and dynamic sourcing. Intelligent Cube design and utilization; how to build cubes, schedule them,. 4. 0. Until then, efectively delivering the last. However, you cannot create a card based on a live-connect MDX/SAP cube. MicroStrategy The ability to view or edit certain settings is determined by a user's privileges. • Meta data that is very scalable and can reach beyond 1TB. This returns results much faster than querying the data warehouse. There is a distributed database for the MicroStrategy metadata and. Right-click an Intelligent Cube and select Delete. 1 release. KB255633. The Intelligent Cube Options dialog box opens. 1 and 10. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. The MicroStrategy Intelligence Server 9. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. You can edit project-level cache and Intelligent Cube settings. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. Users don’t have to mention the cube to which they want to connect. 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). idx file is cleaned up. In the left pane, click Intelligent Cubes. Intelligent cubes are generated automatically when a new report is run against the data warehouse. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Since an Intelligent Cube is structured similarly to a Relational Database the method of retrieving data from the Intelligent Cube, Cube Subsetting Instructions, is very similar to. table_name: is the name of a table. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. In MicroStrategy Web 9. It uses Business Scenarios to provide examples of each concept. 3. You can view the following information in the Intelligent Cube Monitor: Cube Report Name: The name of the Intelligent Cube. For example, the attributes Year and Region and the metrics Cost and Revenue are included in the Intelligent Cube shown in the image above. To view an Intelligent Cube stored in your History List. Overview. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Administer Caches. Share query results in-memory across multiple dossiers and reports. Explain an Intelligent Cube? Instead of returning data from the data warehouse for a single report ,we can return sets of data from our data warehouse and save them directly to Microstrategy. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Con: The copy of report data in Intelligence Server memory only applies to a single report. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. To Create a Report that Accesses an Intelligent Cube. Watch on. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. In MicroStrategy Developer, browse to an Intelligent Cube. The Full Refresh option is the default. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Publish the cube. the project configuration: ACTION . 4. From the Edit menu, select Training Metric Wizard. Using Database Write-back Functionality to Enable Decision-Making. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports.