KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. What are advantages of cubes? It perform fast It Schedule the Cube It is used for Drilling It helps in Data Sharing. Introduction to MicroStrategy BI Architecture . 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. Refresh. xUse the same attribute in filter in Intelligent Cube and incremental refresh filter. As of MicroStrategy Secure Enterprise 10. Replace a slice of data in an Intelligent cube using a single incremental cube refresh step. 6 and higher. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. The Intelligent Cube opens in the Report Editor. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. For more details on enabling the setting. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. Reporting on Intelligent Cubes also allows you to use all of the OLAP Services features, including derived elements, which allow you to group attribute elements in a report on. Edit Intelligent Cubes from the new editor in Workstation at any time. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. In the New Intelligent Cube dialog box, select the MDX Sources tab. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. mstr file is too large. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. 0. When the subscription has been configured, click. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. 3. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. 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. The ability to view or edit certain settings is determined by a user's privileges. The dataset is a set of data that can be displayed on the document. LIST PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "<intelligent_cube_name>" | GUID <instance_guid>) FOR PROJECT "<project_name>"; An enhancement request has been raised to have the ability to use “cube as trigger”. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. 1 and 10. Create a Report 'R3' with 'Country' attribute. 56K. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. In MicroStrategy Developer, log in to a project source with administrative privileges. Server Logout. This is the most popular MicroStrategy Interview Question asked in an interview. 6, the MicroStrategy PDF Exporter (also known as New Export Engine or NEE) service has been added to support exporting from Visual Insight / Dossier to PDF format. 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. 11. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. From the Edit menu, select Training Metric Wizard. x and newer. You can also apply this security when users create reports that connect to an Intelligent Cube. In the Data Source column, select the checkboxes for the tables to update. An Intelligent Cube is an In-Memory data structure which. However, importing data from a Google Drive Spreadsheet requires some additional setup. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. x. Set Intelligent Cubes to Publish and Trigger initial Object Migration. The fact that the. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. x and newer. Create a report based off the cube in Step 1 that includes the description form for Category. 4. 40. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. Currently, project duplication does not involve Intelligent Cube File Directory. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. The Intelligent Cube Options dialog box opens. Creating Intelligent Cubes is as easy as creating reports. 4. 5. View the report in either Grid View or Grid and Graph View. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. Choose File > New > Intelligent Cube. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. Click OK. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Solution:If you have a Distribution Services license, you can subscribe multiple users to an individual report or document through MicroStrategy Web (see To Create a Subscription in MicroStrategy Web). x, with the Intelligence Server running on Linux, the. Use MicroStrategy Developer, Office, or Web. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. To plan for. Publish the cube. A user logged in to a MicroStrategy Intelligence Server. The Subscription Editor opens. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. The Parallel Query Execution is an advanced property which determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results faster and publish Intelligent cubes. 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. You must belong to the System Administrators group to use this feature. x releases, and the new Multi-table Data Import (MTDI) cubes. The maximum cube size is set by the "Maximum cube size allowed for download" field (in MicroStrategy Developer, in the Project Configuration dialog box, choose Intelligence Cubes > General) Users with security filters subscribing to a Visual Insight dossier built on a cubeUpdate the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. In MicroStrategy Developer, log in to a project source using administrative privileges. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Click OK. 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. All necessary privileges are included in the Administrator role by default. However, Intelligent cube publishing performance may be affected with the agent enabled. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. 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. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. PUBLISH INTELLIGENT CUBE ("name" IN FOLDER "folder_name" | GUID "guid") [ASYNCHRONOUS] FOR PROJECT "project_name"; where: "name" is the name of the Intelligent Cube to be published, of. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports. The ability to view or edit certain settings is determined by a user's privileges. For more information on cube partitioning, download this PDF. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Multiple reports can access a single. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The Intelligent Cube Options dialog box opens. This is because with this feature enabled, the element block ID will be saved to the new cube cache. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. 41. Administer Caches. 4. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. Right-click the Intelligent Cube, and select Edit. 11 on Unix/Linux Number of Views 2. STEPS TO REPRODUCE: 1. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. The VLDB property, Attribute to Join When Key From Neither Side can be Supported by the Other Side becomes obsolete once you upgrade your data engine version to 2021. Users with different security filters can use the same Intelligent Cube data. KB314273: Response regarding replacement of interactive PDF and MHT files . MicroStrategy Intelligence Server . Intelligent Cubes. The Platform Analytics project comes with three Intelligence Cubes that support nine Dossiers that can be run right after installation to check if everything is functioning properly. Subsequently the requests made by other users can. An Enhancement Request for implementing this functionality is. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. xA report that runs against the Intelligent Cube. 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. This enables the development of datasets via data importing, instead of creating and modifying each new dataset from scratch. In addition to creating reports. 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’. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. KB485673: When "Create Intelligent Cubes by database connection" is enabled, the cube published with the latest data can't… Number of Views 157 KB484562: Intelligence Cubes are not published via subscriptions to both nodes of cluster in MicroStrategy 2019 and later. View reports vs Cubes as datasetsTo unpublish an Intelligent Cube. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Before MicroStrategy 10. Narrowcast Server, MicroStrategy Intelligence Server 8i, Oracle 10g/9i, Informatica Designer 8. Creating Intelligent Cubes based on. Pages 272 Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e. 8 and up? KB439821 | Knowledge Article | 2670. Intelligent Cube design and utilization; how to build cubes, schedule them,. 1 and 10. Chapter 8: Improving performance with intelligent cubes Chapter 9: Preparing complex data for enhanced storytelling Chapter 10: Creating workflows for efficient storytelling. 4. Publish the cube. In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . 0 has a dedicated section to memory used for Intelligent Cubes. Number of Views 1. What are advantages of cubes? It perform fast It Schedule the Cube It is used for Drilling It helps in Data Sharing. Open the Workstation window. School NIT Rourkela; Course Title DATA ANALYSIS 102; Uploaded By DeanElectronHummingbird14. 3. In the Navigation pane, click Monitors. AboutMicroStrategyOLAPServices 6 OLAPServicesfeatures 7 ThebenefitsofusingOLAPServices 11 PrivilegesrequiredforDeveloperandWebusers 12 Reporttypes. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data. 88K KB41697: "The Intelligent Cube must be published before this report can be executed. Publish, unpublish, delete, and update Intelligent Cubes. Number of Views 8. What is HyperIntelligence? In 2019, MicroStrategy invented a new solution for a conventional problem in the analytics industry. 3. Right-click the report and select Edit. 3 - Check the Make Intelligent. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesKB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Right mouse click on the cube and choose Schedule 3. 2. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. 4. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. • Reports can consist of documents with customized HTML format. Definition. 0: Balance MicroStrategy Server threadsReporting on an Intelligent Cube provides quick access to data, as the data has been pre-aggregated. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Nature: By nature, both Tableau and MicroStrategy tools are Business Intelligence software designed for visualizing data. x -10. Information to use MicroStrategy OLAP Services features, including Intelligent Cubes, derived metrics, derived elements, dynamic aggregation, view filters, and dynamic sourcing. Published: Jun 1, 2017. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. 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. 23: Find Intelligent Cube. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. While still exposed, the settings will not take effect if. 3. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. 4. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. The ability to view or edit certain settings is determined by a user's privileges. 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. Intelligent Cubes. 1 and 10. This property can only be enabled through Workstation. In MicroStrategy 2020, the password can be found in the Default_Accounts. Select a schedule from the Schedule drop-down list. Export to PDF, web sort, document design. To Create a Report that Accesses an Intelligent Cube. CONTENTS 1. the project configuration: ACTION . In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 4. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Choose one of the following options: Full Refresh: This is the default. x a new concept is introduced called Intelligent Cubes. x CAUSE: The user is missing the "Administer Subscriptions" privilege under "Administration" in. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. Administer Cubes. This image shows a cube with three dimensions (though really, the number of dimensions that can be contained within a cube are limitless): products, customers (by country) and posting date (year). Consider the following example based on the MicroStrategy Tutorial project. 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. 11+, derived attributes are evaluated at the source when all the required columns come from the same table- which is the case for most users. To enable or disable dynamic sourcing for an Intelligent Cube. 4. The following table summarizes the test results of some test scenarios against Oracle 19c. The Intelligent Cube Monitor is displayed. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. To do so, you can take advantage of URL API. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. In the left panel, click Cubes. Administer cluster. MicroStrategy online help and PDF manuals (available both online and in printed format) use standards to help you identify certain types of content. 1 and 10. 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. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. For more information on the Intelligent Cube Maximum. INTELLIGENT_CUBE_MAX_RAM: The maximum size in memory of all Intelligent. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. Learning Resources. Intelligent Cubes. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. x product documentation "InMemoryAnalytics. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. 4, MSTR file is an available export format for individual Visual Insight dashboards from MicroStrategy Web and MicroStrategy Desktop. Total Cubes This section displays the total count of cubes by status. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. The view filter cannot filter out other elements as shown below:The cube associated with the . Users don’t have to mention the cube to which they want to connect. •. MicroStrategy Library. KB442630: CSI optimization for improving the in-memory query execution for many. MicroStrategy OLAP Services is an extension to MicroStrategy Intelligence Server that allows MicroStrategy Web and Desktop users to manipulate Intelligent Cubes™. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. 4. For instance, let’s say you have an Intelligent Cube with 2 million rows and 10 attributes and 5KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The storage for Intelligent Cubes was not setup properly. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Cube-as-Dataset: Security filter will be applied to the dossier/document execution. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. idx file is cleaned up. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. 4. g. 0. The Schedule dialog box opens for your dataset, showing the tables in your dataset. x a new concept is introduced called Intelligent Cubes. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. Measures the time duration an operation executed against cubes. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Browse to the folder location to store Intelligent Cubes, and then click OK. This technical document covers a known issue affecting MicroStrategy Secure Analytics Enterprise 10. You can also define when Intelligent Cubes. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. An Intelligent Cube is. Publish the specified Intelligent Cube to the Intelligence Server, so that it can be used by reports. To enable. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. 2. It uses Business Scenarios to provide examples of each concept. 0. 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. An Intelligent Cube has been created in a project. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. ¶. Publishing Intelligent Cubes. In MicroStrategy 10. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. However, the images in the report display properly when the report is executed in. This can improve the performance of. Integrity Manager can test the SQL of Intelligent Cubes even if they have not been published, but cannot test Intelligent Cube reports based on an unpublished Intelligent Cube. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. In this case, the dataset is a MicroStrategy Intelligent Cube. 0. The display of data is handled by the reports that access the Intelligent Cube. e. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The Intelligence Server brings the live-connect intelligent cube definition from the metadata and analyzes the information requested from that definition. Check the location of the new cube cache and notice that it is saved in the default location, i. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. x This is a new feature introduced in MicroStrategy version 9. Disabling parallel query execution by default allows you to first verify that your reports and Intelligent Cubes are executing correctly prior to any parallel query. Number of Views 391. Published: May 15, 2018;This document provides settings that can be adjusted to help decrease Intelligent Cube publication times in MicroStrategy Secure Enterprise 10. CAUSE: This is working as designed. 2. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Choose Data > Configure Intelligent Cube. Navigate to the folder location of the Intelligent Cube. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Number of. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 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. Intelligent Cubes provide the fast response time and analytic calculations that are often associated with MOLAP cubes. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 4. To view embedded fonts in Web, the fonts must be installed on the Intelligence Server machine. Starting in MicroStrategy 10. Go to the "All Objects View" option in the top left corner. Publish Intelligent Cube statement. Reproduce Steps Definingderivedelementfunctionalityandformatting 156 Interactionwithotherreportingfeatures 169 6. 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. PATH: The path to the Intelligent Cube, returned as a string. To enable or disable dynamic sourcing for an Intelligent Cube. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Browse to the folder location to store Intelligent Cubes, and then click OK. This file stores cache matching. You can view the following information in the Intelligent Cube Monitor: Cube Report Name: The name of the Intelligent Cube. 1, Data Import allows users to maintain intelligent cubes from external Excel files. This article also provides a workaround to avoid this behavior. 4. However, Intelligent cube publishing performance may be affected with the agent enabled. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. 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. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X". 6. 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‘. 4,. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. 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;. Place intelligence server close to the both the data warehouse and the metadata repository. 1 and 10. 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. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. The Intelligent Cube Options dialog box opens. 1 and 10. The default value is 256 megabytes. 2 billion row limit for Intelligent Cubes (240GB cube)Linear scalabilityReduce dependency Sub 5 second response time. MicroStrategy will monitor the data repository and/or cube memory requirement of the Enterprise Manager and/or Platform Analytics. MicroStrategy Web allows you to merge two or more Intelligent Cubes. KB485226: Intelligent Cube size increases irrespective of the "Maximum % growth of Intelligent cube to 50%" governing setting. Select an Environment from the upper-left drop-down. This command can get the correct cube status and table status only when the cube is being refreshed or published in the same session between Command Manager and Intelligence Server as this command's. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. A document is used to format data from multiple datasets in a single display of presentation quality. Administer database connections. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. 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. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. , in search results, to enrich docs, and more. Drag and drop the objects into the report grid from the Report Objects pane. Subsequently the requests made by other users can. In HTML View and PDF View, a dashboard is displayed as a static document. 1,000Drilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. Intelligent Cube storage on disk mirrors report cache storage. 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. 0. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data.