In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The Intelligent Cube Monitor is displayed. 6, users now have the option to select MSTR as the Delivery format for email and file subscriptions as shown below: MicroStrategy Intelligence Server. Publish Intelligent Cube statement. Because the filters are applied to the master data in the Intelligent. 4. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. The Intelligent Cube Monitor is shown in the image below. " If you try to edit these MicroStrategy Connector cubes, you may be. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. Build a cube of customer data that’s relevant to all employees and publish it. User Review of MicroStrategy Analytics: 'Microstrategy is used as a reporting solution in my work environment. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. In MicroStrategy Developer, log in to a project source with administrative privileges. Save the Intelligent Cube. Drag and drop the objects into the report grid from the Report Objects pane. To Create an Intelligent Cube Using Freeform SQL or Query Builder. The. While still exposed, the settings will not take effect if. x. This enables the development of datasets via data importing, instead of creating and modifying each new dataset from scratch. Creating an Intelligent cube is similar to creating a report. The fact that the Intelligent Cube resides on the. 0. Sharing data. Total Cubes This section displays the total count of cubes by status. Right-click an Intelligent Cube and select Delete. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Use MicroStrategy Developer, Office, or Web. The Training Metric Wizard opens. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Users don’t have to mention the cube to which they want to connect. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. This data can then be shared as a single in-memory copy, among many different reports created by multiple users. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. In the left pane, click Intelligent Cubes. 0. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions = 12. In a text editor (such as Notepad), enter the command line statement that the task scheduler should execute. . Overview. 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. 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. Every time that a user does something in MicroStrategy, like. Publishing Intelligent Cubes. In Developer, log into a project. 5 GB, the Data Transfer from Datasource(s) time is 77. 81K. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. KB314273: Response regarding replacement of interactive PDF and MHT files . 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 allows for more power and control over data for MicroStrategy. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Nature: By nature, both Tableau and MicroStrategy tools are Business Intelligence software designed for visualizing data. Sharing data. Run the Report and check the SQL View. The ability to view or edit certain settings is determined by a user's privileges. Go to the "All Objects View" option in the top left corner. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". 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. If you use Enterprise Manager (EM),. You can update and modify the document in Design View. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. als Berichtsobjekte oder Berichtsfilter einschließen. Navigate to the Data Refresh category. MicroStrategy Intelligent Cubes Eliminate the Need to Maintain a Proprietary Cube Environment and Redundant Hardware and Databases In order to provide BI functionality, many vendors use proprietary cubes, which require additional hardware storage 7 4%: Breakdown of TCO for IT Infrastructure workloads over a five-year period. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 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. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. Publishing Intelligent Cubes. Select to move project-related objects, administration objects, or merge entire projects together. To Create a Report that Accesses an 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. The **_objects folder with a size of 277G. Vn (with metric Mn from source cube Cn). The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Intelligent Cubes: MicroStrategy’s Intelligent Cubes are pre-aggregated, in-memory data structures that enhance the performance of queries. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. 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. Report Data Manipulation 5. Click OK. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. Easily add or change pre- and post- SQL statements. All necessary privileges are included in the Administrator role by default. Cube and Cache Metric Names. After each unload/reload, and running the Dossiers against the cube, the duplicate Element Block files will be dumped into the same *****_objects folder. KB442453: Dossier loses the font format when exported to PDF file in MicroStrategy 10. Each user that connects to the MicroStrategy Intelligence server and/or project has a unique. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. To enable. This is due to the fact that adding prompts to Intelligent Cubes is not supported. The cube population process could be expensive in time and memory if the cube is large. • OLAP cubes that can be entirely based on memory. x and 10. Narrowcast Server, MicroStrategy Intelligence Server 8i, Oracle 10g/9i, Informatica Designer 8. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. A report accessing the Intelligent Cube includes only Year on the report. 4. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. 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. This VLDB property has the following options: Disable parallel query execution (default): All queries for MicroStrategy reports and Intelligent Cubes are processed sequentially. 6. From the Data menu, select Configure Intelligent Cube. Learning Resources. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. See KB484738 for more information. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. 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. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Number of Views 1. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. Published: May 15, 2018;This document provides settings that can be adjusted to help decrease Intelligent Cube publication times in MicroStrategy Secure Enterprise 10. This defect is addressed in MicroStrategy 11. Save the Report and close. 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. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. 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. Click here to view details about the Intelligent Cube Monitor. It accesses and joins data. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. Login to MicroStrategy Web, create a cube with the function of Data Import 2. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. 4. Save the Report and close. x and newer. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. 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. Add data from existing reports, documents, and Intelligent Cubes. Email subscriptions deliver a report or document to one or more email addresses. MicroStrategy The ability to view or edit certain settings is determined by a user's privileges. Published: Nov 19, 2018; Last updated: Nov 18, 2022;MicroStrategy version 9. Run the Report and check the SQL View. What is MicroStrategy? MicroStrategy is a Business Intelligence software that can be connected with any data including data files, big data, social media data, and so on to create and modify highly detailed reports and dashboards. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Open the Workstation window. Intelligence Server Statistics . 4. To Create an Intelligent Cube Using Freeform SQL or Query Builder. 2. MicroStrategy Web allows you to merge two or more Intelligent Cubes. 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. To schedule the publication of Intelligent Cubes. 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. MicroStrategy Intelligence Server . The Intelligent Cube Options dialog box opens. The Intelligent Cube opens in the Report Editor. Edit Intelligent Cubes from the new editor in Workstation at any time. This article notes how support for transformation metrics in Dynamic Sourcing works. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Refresh. "The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. 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. 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. 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. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. Name the different export. MicroStrategy World 2014: Scaling MicroStrategy at eBay - Download as a PDF. This section contains the following information: Managing Intelligent Cubes: Intelligent Cube Monitor Governing Intelligent Cube Memory Usage, Loading, and Storage The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. 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. In-Memory Intelligent Cube: The request is received by the. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. 0 has a dedicated section to memory used for Intelligent Cubes. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. In MicroStrategy Developer, log in to a project source with administrative privileges. Create a report based off the cube in Step 1 that includes the description form for Category. Expand the Object Templates category, select General, and. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. 0. This will work as a regular SQL comparison. In HTML View and PDF View, a dashboard is displayed as a static document. The Intelligent Cube Monitor is displayed. This privilege is part of OLAP Services. Intelligent Cube design and utilization; how to build cubes, schedule them,. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 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. 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. For example, for a project, result caches on each node that has. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Select the data set and click Prepare Data. Good Understanding of Intelligent cubes and Data mart design. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. 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. In the Data Source column, select the checkboxes for the tables to update. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. 11 on Unix/Linux Number of Views 2. Users with different security filters can use the same Intelligent Cube data. An Intelligent Cube is. Introduction to advanced analytics 3. Introduction to MicroStrategy BI Architecture . Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. If an attempt to load an Intelligent Cube is made that would exceed the limit, an Intelligent Cube is removed from Intelligence Server memory before the new Intelligent Cube is loaded into memory. However, importing data from a Google Drive Spreadsheet requires some additional setup. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. Within the set. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. Drag and drop the objects into the report grid from the Report Objects pane. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The New Grid dialog box opens. When the subscription has been configured, click. This. 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. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 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. Indicates a user exported a view report or a cube-based document or a cube-based dossier to PDF and hits the cube cache. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. /ClusterCube. 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 Intelligent Cube must be published before this report can execute. Configure metric aggregations, null handling, indexing, and more. To enable or disable dynamic sourcing for an Intelligent Cube. This section. 1 and 10. 3. The partition attribute is the attribute that is used to divide. However, you cannot create a card based on a live-connect MDX/SAP cube. Intelligent Cubes can be partitioned,. Publish the cube. By default this is set to 256 megabytes. The cube instance is located from the Intelligent Cube Manager, when a subset report, or a standard report that uses dynamic caching, is executed. The Intelligence Server executes the previous query against the Data Warehouse. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. 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 tools allow you to plot interactive charts, graphs, and dashboards for comprehensive analysis. Description: Intelligent Cube design and utilization; how to build cubes. The MicroStrategy analytics platform is consistently rated as the best in enterprise analytics and is used by many of the world’s most admired. 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. Add or remove nodes in a cluster, and set the default cluster membership. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Enable Document Output Caching in PDF Turn on this option to enable document output caching. 24: Update Intelligent Cube. 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. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. •PDF. Created narrowcast services to email /send to a directory either report service documents in PDF or excel files. Select other schedule options as required, and click OK. ¶. To display PDF bookmarks with the correct font, the language pack must be installed on the viewer's machine. Create the MIN (CurrentDateTime ()) metric. 1 and 10. 4, MSTR file is an available export format for individual Visual Insight dashboards from MicroStrategy Web and MicroStrategy Desktop. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. In the Navigation pane, click Monitors. Two unique methods to implement Intelligent Cube Technology: •Personal Intelligent Cubes: You can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. A document is used to format data from multiple datasets in a single display of presentation quality. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. the project configuration: ACTION . Open the Workstation window. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Use MicroStrategy Developer, Office, or Web. Intelligent cubes are generated automatically when a new report is run against the data warehouse. 4. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. 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. These VLDB properties control the method by which the report data are normalized. Users are unable to see the "Refresh Cube" option (as shown below) while scheduling a delivery on an Intelligent Cube in MicroStrategy 9. This command will list the table information only when the intelligent cube is a super cube. 4. Provides the last cube row count. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions: A metric with the same formula and transformation exists in the Intelligent Cube. 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. Due to the architecture of the MicroStrategy platform, if a customer chooses to utilize caching and intelligence cube capabilities, then application data files that are at-rest are backed up on MicroStrategy-managed Intelligence Servers for a minimum period of five days. Chapter 7: Improving Performance with Intelligent Cubes Chapter 8: Preparing Complex Data for Enhanced Storytelling Chapter 9: Creating Workflows for Efficient. In MicroStrategy Developer, log in to a project source with administrative privileges. STEPS TO REPRODUCE: 1. Build a cube of customer data that’s relevant to all employees and publish it. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. Refer to the following MicroStrategy Knowledge base document for general remarks on security filter application to Intelligent Cubes where not all of the security attributes are found. However, after publishing,. For detailed information about Intelligent Cubes. However, Intelligent cube publishing performance may be affected with the agent enabled. Decision Maker、Intelligent E-Business、Personalized Intelligence Portal、Query Tone、Rapid Application Development、MicroStrategy Intelligent Cubes、The Foundation For Intelligent E-Business 、The Integrated Business Intelligence Platform Built For The Enterprise 、 The Platform For Intelligent E-Business、The Scalable Business. This is the most popular MicroStrategy Interview Question asked in an interview. 1) Right click the intelligent cube and select Properties -> Security . Click All Objects View. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Intelligent Cubes as datasets. For example, the objects developed in a development environment can be copied to a UAT environment to. x. Publish the cube. Defining the partition for Super Cubes. Share query results in-memory across multiple dossiers and reports. Datasets API. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. 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. I have I-cubes with billions of rows stored in memory. MicroStrategyMicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. 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. 0. 4. 1 and 10. Creating Intelligent Cubes based on. Select the Data Partition category. 0. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. From the Partition Attribute drop-down, select the partition attribute for the Intelligent Cube. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 1 and 10. For more information on the Intelligent Cube Maximum. The Intelligent Cube Monitor is displayed. All necessary privileges are included in the Administrator role by default. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. Required Status to Perform Action. To that end, we’ve designed a program of continuous training and certification for every role in your Intelligent Enterprise. Select the data set and click Prepare Data. 4 to MSTR 2019 U2. "Maintaining data access security. x CAUSE: The user is missing the "Administer Subscriptions" privilege under "Administration" in. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Click Select. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. 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. WORKAROUND: Two possible workarounds which may be feasible, depending on the situation are:Select Intelligent Cubes > General > Intelligent Cube File directory. An Intelligent Cube is a. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. Defining the partition for Super Cubes. 4. g. The fact that the. The related section is located in. 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.