Overview What is MicroStrategy Analytics? MicroStrategy Analytics is an enterprise business analytics and mobility platform. 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. Select data population for Intelligent Cubes. For example, analyzing the MicroStrategy Tutorial project creates a Cube Advisor results file named MicroStrategy Tutorial. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Speed: Aggregating (Summarizing) the data for performance with processing Cube. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Merging Intelligent Cubes. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. Pros and Cons. Report: The results of a report are used to populate the 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. In the Object name field, type a descriptive name for the Intelligent Cube. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. I assume both these "cubes" organize data in a way that is easy and fast to use for dimensional queries, but I don't think you can import directly an Oracle cube into. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Maintaining data access security. 46K. 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. This defect is addressed in MicroStrategy 11. number_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. Updating Intelligent Cubes without re-processing: Incremental Refresh. 1. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. The Intelligent Cube Monitor is displayed. The application is named MicroStrategy Cube. Recommends and creates Intelligent Cubes that could provide data to reports using dynamic sourcing. 20. The Subscription Editor opens. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)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. In the Refresh Policy column, choose one of the following options:For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. All articles. 50. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 89 reviews while MicroStrategy is ranked 8th in BI (Business Intelligence) Tools with 12 reviews. 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. Learn more about it at MicroStrategy. The total number of Intelligent Cubes for a project that are stored in Intelligence Server memory is compared to the limit you define. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. If the welcome page is shown, review the information and click Next. Then it generates a report. The New Grid dialog box opens. MicroStrategy Analytics cubes are easy to create and deploy. 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. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. The ability to view or edit certain settings is determined by a user's privileges. Browse to the folder location to store Intelligent Cubes, and then click OK. This returns results much faster than querying the data warehouse. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The Intelligent Cube Editor opens. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. This can be done by selecting Run Report in the toolbar. Create the metric levels log file used to track the use of dynamic sourcing. This includes the following: To review and create recommended Intelligent Cubes using Cube Advisor. In MicroStrategy Integrity Manager 10. However, importing data from a Google Drive Spreadsheet requires some additional setup. 2987. number_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. The Visualization SDK has the following benefits. The Intelligent Cube Monitor is displayed. To do so, you can take advantage of URL API. Published: Jun 29, 2018;To Create an Intelligent Cube Using Freeform SQL or Query Builder. It helps us analyze and modify reports much faster since the data is from in-memory data cubes rather than the data warehouse. Prerequisites to creating Intelligent Cubes. In MicroStrategy Developer, log into a project as a user with full administrative privileges. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. 25) Mention what are the business benefits of Microstrategy Narrowcast Server? Ans: The business benefits of Microstrategy Narrowcast Server is that it provides an inexpensive way to send corporate information to. When an Intelligent Cube is published, the Intelligent. 1. 0. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Metrics and attributes are created once and used across different types of reports. Choose File > New > Report. Check the number of CPU cores. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. Navigate to the folder location of the Intelligent Cube. x to 8. An Intelligent Cube is a. Telcos using MicroStrategy can run. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Many other OLAP providers support MDX, including Microstrategy’s Intelligence Server, Hyperion’s Essbase Server, and SAS’s Enterprise. On the toolbar, choose Data > Configure Intelligent Cube. Advanced Properties for Intelligent Cubes MicroStrategy Workstation provides workflows for both modeling and management. With OLAP Services features, your report designers can create Intelligent Cube reports. With the intuitive card editor and flexible data layouts, it’s astonishingly simple. MicroStrategy OLAP Services uses the concept of Intelligent Cube, an in-memory version of a report that can be manipulated by the Analytical Engine. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. The default value is 256 megabytes. The Intelligent Cube opens in the Report Editor. Traditionally, this type of requirement was hard to achieve as there was not an event that could be triggered right after the execution of an. Personalized Intelligence Portal, Query Tone, Rapid Application Development, MicroStrategy Intelligent Cubes, The Foundation For Intelligent E-Business, The Integrated Business In telligence Platform Built For The Enterprise, The Platform. In addition, it was observed that in certain cases the Maximum % growth setting did not constrain the growth of Intelligent cubes and it was possible for the size. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. Expand Intelligent Cubes, and then select General. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. 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. An Intelligent Cube has been created in a project. 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. x and newer. The Intelligence Server checks to see if there is an existing cache for the same Report. 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. Right-click a project and select Project Configuration. 0 Intelligent and Web servers for development, test and production environments. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Con: The copy of report data in Intelligence Server memory only applies to a single report. MicroStrategy 9. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. 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. Select the Allow reports to drill outside the Intelligent Cube check box. INTRODUCTION: In MicroStrategy 9. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Creates the Intelligent Cubes you decide should be created. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. If no data is returned for a report that is connected to an Intelligent Cube, this can be caused by the following scenarios: The view filter for the report is too restrictive (see View Filters ). The Subscription Creation Wizard opens. However, after publishing,. Under VLDB settings > Query Optimizations > Data Population for Intelligent Cubes admins need to test all the following options: - Normalize Intelligent Cube data in the database. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. It allows users to customize data visualizations and build personalized real-time dashboards. MicroStrategy 2 As a Business Intelligence tool with wide range of capabilities, MicroStrategy has powerful features that helps to find answers and insights in business data analysis. 2. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. A solution for this issue is available in current releases but need turn on via registry key setting. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. MicroStrategy administrators can automatically ensure that business users always have the most current information by configuring the Intelligent Cube data to expire or. To build an Intelligent Cube. Recommends Intelligent Cube definitions for Intelligent Cubes that could be connected to by reports using dynamic sourcing. 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. (Intelligent Cube configuration is not relevant in MicroStrategy 8. Select the data set and click Prepare Data. 4: Persisted. . In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. From these results it can be determined that the Month attribute is not being used within any of the view Reports, Documents, Dossiers that reference this Intelligent Cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. In most cases, the automation in the semantic layer provides more considerable resource savings than maintaining multiple custom SQL query Intelligent Cubes in memory that do not relate to each other. txt. To ensure your project has it enabled, check: 1. Strong semantic layer to define all the business rules and tightly coupled. You must belong to the System Administrators group to use this feature. Alternatively, you can enable caching on selected reports. Slice and dice features are awesome. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. Mapbox partners with community mapping. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 8: Monitoring information dirty. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. To publish an Intelligent Cube, see. 1 release. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. It turns data into reports for making and executing key organization decisions. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. 11. Dossiers automatically adjust to look great on any screen. A discussion of pre-MicroStrategy 2020 behavior can be found in the article, KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. When an Intelligent Cube is defined to support a language, data is available for the Intelligent Cube in that language. Companies of all sizes use this platform to assess, visualise, and build dashboards. If removing the view filter does not. This. Share query results in-memory across multiple dossiers and. LIST ALL INTELLIGENT CUBES IN FOLDER "Intelligent Cubes" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. Right-click an Intelligent Cube and select Delete. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. To enable. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Dynamic Sourcing. 1, users could right click an Intelligence cube to create a URL API call that would allow users to automatically create a Visual Insight dashboard using that same cube, as shown below: However, in MicroStrategy Web 10, this 'Link' property is no longer available for Intelligence cubes, as seen below: CAUSE:Starting in MicroStrategy 10. It's not intended to be a representation of the Oracle cubes. Defining the partition for Super Cubes. In the Drilling area, clear the Use default settings check box. Comparing OLAP and MTDI cubes. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. 6 plus years in Data warehousing, Business Intelligence systems, OLAP environments and tools. Run a dossier based on the cube. Cube index generation will increase cube size. This can improve the performance of. x releases, and the new Multi-table Data Import (MTDI) cubes. KB440822. The Intelligent Cube Monitor provides information about published Intelligent Cubes, as well as Intelligent Cube usage statistics. MicroStrategy 9. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Cube Advisor opens. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. The book starts by detailing. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Other metadata database platforms:KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. 4, Command Manager script for listing. "Navigate to the folder location of the Intelligent Cube. Sharing data. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. This data is to apply the calculations. x improves the performance of user reports by executing reports against published Intelligent Cubes, when the SQL generation engine is able to determine that the cube contains all information required for the report. This file stores cache matching. A significant decline in micro-business intelligence strategy is also pricing. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. Instead of always executing against the data warehouse. Vn (with metric Mn from source cube Cn). Cube and Cache Metric Names. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Key features include automatic big data. Republish DI Cube with Multi-refresh Policies. x: Ability to encrypt cache files stored to disk. / -- HyperIntelligenceTM Offering Delivers Groundbreaking Zero-Click Analytics Experience MicroStrategy Incorporated (Nasdaq: MSTR), a leading worldwide provider of enterprise analytics and mobility software, today announced that MicroStrategy 201 9, the industry's first and only enterprise platform for HyperIntelligence,. 3. Watch on Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 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). By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 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. From the Data menu, select Configure Intelligent Cube. The reports accessing Intelligent Cubes can use all of the OLAP Services features for analysis and reporting. The MicroStrategy Web architecture has the following highlights:. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Create a report based off the cube in Step 1 that includes the description form for Category. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Most likely several, different fact tables are uses for each query. MicroStrategy AI is here. However, OLAP Services provides MOLAP and ROLAP analysis on the same report, which offers many distinct benefits, summarized below: Using OLAP Services, you can get fast response times for reports that use data directly from in-memory Intelligent Cubes, instead of from the data warehouse. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. Follow these steps to enable Dynamic Sourcing for the project: 1. The first part discusses the behavior of both the MicroStrategy semantic SQL Query engine layer and the Snowflake temporary and transient table. In most cases, the automation in the semantic layer provides more considerable resource savings than maintaining multiple custom SQL query Intelligent Cubes in memory that do not relate to each other. The fact that the Intelligent Cube resides on the. Recorded at World 2021. Ans: A report cache is a result set from an executed report that is stored on MicroStrategy Intelligence Server. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. This data can be used to create a. 1. The New Intelligent Cube dialog box opens. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. 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. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In Developer, log into a project. 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. KB32540: Intelligent Cube Population methods in MicroStrategy. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. What are the new Intelligent Cube Cache commands available in MicroStrategy Command Manager 9. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Publish the Intelligent Cube by executing it on either of the nodes. Create an attribute element prompt for the. Required Status to Perform Action. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. 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. NAME: The name of the Intelligent Cube, returned as a string. Configurez les agrégations de mesures, la gestion des valeurs nulles, l’indexation, etc. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. From the Data menu, select Configure Intelligent Cube. Right mouse click on the cube and choose Schedule 3. Publish the cube. MicroStrategy OLAP Services is an extension to MicroStrategy Intelligence Server that allows MicroStrategy Web and Desktop users to manipulate Intelligent Cubes™. Starting in MicroStrategy 10. CONTENT: Enable cube. Localizing Intelligent Cubes in multiple languages. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. The Intelligent Cube refresh settings are recommended if the data in the. For information about general rules that apply when security filters are applied on view reports based on Intelligent Cubes, refer to the. 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. OLAP services: Derived metrics and viewed filters cannot be supported. In MicroStrategy Developer, log in to a project source using administrative privileges. Recommends and creates Intelligent Cubes that could provide data to reports using dynamic sourcing. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. Required Status to Perform Action. The user experience is confusing for the users. This report is prompted on time. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. To view an Intelligent Cube stored in your History List. 4. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesIn the Navigation pane, click Monitors. Metrics and attributes are created once and used across different types of reports. Select Empty Intelligent Cube and click OK. x environments. Publishing Intelligent Cubes. The solution has a very non-logical user usage part. Subsequently the requests made by other users can. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. To effectively create a HyperIntelligence dataset, your data must have attributes with either one-to-one relationships or many-to-one relationships. Discover MicroStrategy 2021 >The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Expand the Object Templates category, select General, and. To Create a Report that Accesses an Intelligent Cube. Published: Apr 5, 2017 Last updated: Apr 12, 2019 Related versions: 0 Log in to vote MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. MicroStrategy’s 64-bit architecture supports in-memory analytics with “Intelligent Cubes” that are OLAP reports cached in memory as data sets. x. These reports allow data to be returned from the data. Case A: Security Filter attribute is related to attributes placed on the grid. Sharing data. Users don’t have to mention the cube to which they want to connect. Telcos need network capacity planning and optimization by correlating network usage, subscriber density, along with traffic and location data. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Drawbacks of Microstrategy Business Intelligence. To enable or disable dynamic sourcing for an Intelligent Cube. When an Intelligent Cube is in this status, any reports based on this cube have. The display of data is handled by the reports that access 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. The Intelligent Cube Monitor is displayed. Click here to view details about the Intelligent Cube Monitor. 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. However, storing too much Intelligent Cube data in. You can also create Intelligent Cubes by directly querying your data. The MicroStrategy OLAP Services Guide lists the features that prevent Intelligent Cubes from being available for dynamic sourcing. Intelligent Cube storage on disk mirrors report cache storage. This will work as a regular SQL comparison In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:MicroStrategy provides a powerful analytics and mobility software platform that its customers use to gain actionable intelligence from their data and deliver answers to 100 percent of their workforce through innovative solutions. Stand out in a crowd. The. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. Answer: Go with dossier. Click OK to save the Intelligent Cube and return to the Report Editor. 2. 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 Categories list, expand Options, and then select General. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. Intelligent Cube Technology is used by MicroStrategy. Build a cube of customer data that’s relevant to all employees and publish it. Microsoft BI based on real PeerSpot user reviews. 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. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. The Intelligent Cube Monitor is displayed. Advantages of XSL stylesheets 68 Default stylesheets provided 70KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. Con: The copy of report data in Intelligence Server memory only applies to a single report. 2: Active. 20. x and 10. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. Do you have reports that currently access. Configure a Cluster with a Centralized Cache. OLAP Services store reports as Intelligent Cubes in the physical memory of the Intelligence Server. x a new concept is introduced called Intelligent Cubes.