Configure a Cluster with a Centralized Cache. To learn more, read our detailed. Navigate to the Data Refresh category. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. No data is returned for the report. Create a report on this intelligent cube with the month attribute and the count of day metric. ¶. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. 9 and above. Right-click an application and choose Properties. CAUSE: This is a known issue in MicroStrategy 10. 0, while MicroStrategy is rated 8. View the report in either Grid View or Grid and Graph View. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. 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. Easily add or change pre- and post- SQL statements. Two unique methods to implement Intelligent Cube Technology: •Personal Intelligent Cubes. Set the path for the cube cache file directory to . IBM Cognos Conversion Startup Program Key Benefits 14 Convert to MicroStrategy to Enable the Intelligent Enterprise. To publish an Intelligent Cube, see. A MicroStrategy prompted document has two dataset reports that are each based on a different Intelligent 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. ACTION: This issue has been fixed in MicroStrategy 10. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. The default value is 256 megabytes. The Intelligent Cube Options dialog box opens. 3. 2. Strong semantic layer to define all the business rules and tightly coupled. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Configurez les agrégations de mesures, la gestion des valeurs nulles, l’indexation, etc. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Defining the partition for Super Cubes. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. No data is returned for the report. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. In Developer, log in to a project with a user account with administrative privileges. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Create Cube1 with the Region attribute and the metric created in step 1. 1,000Indicates a user published an intelligence cube from any tool (Web, Developer, etc). To unpublish an Intelligent Cube. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. 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. the user still needs the privilege for re-publishing Intelligent Cubes, but just need this restricted for particular cubes), while still allowing this user to perform Visual Insight analysis on the cubes information. Choose one of the following options: Full Refresh: This is the default. 11 it is possible to have split child hierarchy attributes join through a shared fact table rather than through a parent with Data Import Cubes. Select an Environment from the upper-left drop-down. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Choose one of the following options: Full Refresh: This is the default. MicroStrategy supports dimensional models well, but does not require a dimensional model. Once an Intelligent Cube is created for an MDX cube, reports can be created based on 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. You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube. x and newer. 39. Enable users to interact with personalized chat for further product discovery. Other metadata database platforms:KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. Expand Intelligent Cubes, and then select General. The Intelligent Cube Options dialog box opens. Multi-pass SQL is required to answer analytical questions that cannot be. 0 MicroStrategy releases. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. x?. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties dialog. They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. 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. Datasets API. 16: Intelligent Cube dirty. Reports cannot combine data from multiple Intelligent Cubes. An Intelligent Cube is an In-Memory data structure which. MicroStrategy recommends to change it to unlimited so your core file is not truncated. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. KB46934: Reports created from a MicroStrategy Data Import Intelligent cube are hidden in MicroStrategy Web. The Intelligent Cube opens in the Report Editor. 0. Select other schedule options as required, and click OK. Users may note that it is possible to limit the number of rows of data returned when publishing Intelligent Cubes, via the 'Final Result Rows' for 'Intelligent Cubes' located in the Project Configuration Editor under 'Governing Rules / Default / Result sets'. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. BACKGROUND: When configuring a MicroStrategy Intelligence Server cluster, special configuration must be made in order for the Intelligence Server cluster nodes to be able to access report and document caches, intelligent cubes, history list messages, and session recovery files that were created on other nodes of the cluster. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. It is expected that when there is no eligible cube, the Data Engine has to query the warehouse; Only projects that have Dynamic Sourcing enabled will be able to automatically access published Intelligent Cubes in regular reports. These VLDB properties control the method by which the report data are normalized. Right mouse click on the cube and choose Schedule 3. Right-click the dataset, and choose Schedule. The Data Partition options are displayed. 19. Answer: Go with dossier. The total number of Intelligent Cubes for a project that are stored in Intelligence Server memory is compared to the limit you define. Provides information about how many jobs were executed, with numbers of hits for caches and Intelligent Cubes. In the Drilling area, clear the Use default settings check box. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. x environments. In the Data Source column, select the checkboxes for the tables to update. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. Jul 17, 2023. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). number_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among. However, after publishing,. In the Navigation pane, click Applications. x. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. The ability to view or edit certain settings is determined by a user's privileges. 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. Normalize Intelligent Cube data in the Database using. 40. To Create a Report that Accesses an Intelligent Cube. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. To publish an Intelligent Cube, see. Metrics and attributes are created once and used across different types of reports. 4. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Intelligent Cubes as datasets. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. For reports and Intelligent Cubes that do not use MultiSource Option or database gateway support to access multiple data sources, all queries are processed sequentially. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. In MicroStrategy Web 9. The. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. Click OK to save the Intelligent Cube and return to the Report Editor. The fact that the. This article describes features that are not supported when using Dynamic Sourcing. Overview. The Intelligent Cube Options dialog box opens. On the toolbar, choose Data > Configure Intelligent Cube. Select the data set and click Prepare Data. · Update the schema in 2-tier and reload the project from the Project Monitor. 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. Providing Intelligent Cube data. Multiple reports can access a single. 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. Select Intelligent Cubes > General > Intelligent Cube File directory. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. However, you cannot create a card based on a live-connect MDX/SAP cube. To build an Intelligent Cube. Vn (with metric Mn from source cube Cn). The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Visit the data visualization and data dashboard galleries for inspiration. 4 types: matching caches, history caches, matching-history caches, and xml caches. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. Click the MicroStrategy icon at the upper left of any page and select History List. 1. 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. 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. Provides the last cube row count. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. The Dynamic Sourcing feature in MicroStrategy OLAP Services 9. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. Together with the Reports API, this API is often referred to as the JSON Data API. IBM Cognos, Microsoft BI, and MicroStrategy comparison summary. Q: In order to create intelligent cubes, MicroStrategy employs a variety of methods A: Introduction In Micro Strategy, intelligent cubes can be created by selecting either a public folder… Q: Why is responsiveness necessary when it comes to web design?To schedule updates for the Intelligent Cube. In the left panel, click Cubes. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. This includes the following:To review and create recommended Intelligent Cubes using Cube Advisor. What are the new Intelligent Cube Cache commands available in MicroStrategy Command Manager 9. The template level metric condition on Aggregate From Base derived metrics have been corrected, so it is no longer is ignored during Data Blending. Its 64-bit architecture supports in-memory analytics with "Intelligent Cubes" (or OLAP reports cached in memory as data sets). Prerequisites to creating Intelligent Cubes. Published: Nov 19, 2018; Last updated: Nov 18, 2022;The Full Refresh option is the default. What are the features which the Intelligence cube doesn’t support generally? This is basically a trick question and is generally asked from those who have experience in the Microstrategy tool. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. 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’. Disconnect from the project source and restart both Intelligence servers. Choose Data > Configure Intelligent Cube. Instead of always executing against the data warehouse. 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. 18K. Microsoft BI is rated 8. x and 10. Right-click the project and select Project Configuration. ) As long as each node is using the same server definition, the setting of the cache and history list locations in the Intelligence Server configuration only needs to be done once; however, the creation of the shared folders will need to be done on each node. To Create a Report that Accesses an Intelligent Cube. You can also define when Intelligent Cubes. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. In this Microsoft Power BI vs. Source: MicroRooster. SYMPTOMS: After duplication of a project in Developer that has a user-defined Intelligent Cube cache location, Intelligent Cubes created within the new project are not saved to the location specified in Intelligent Cube File Directory in Project Configuration. Navigate to the folder location of the Intelligent Cube. 3. MicroStrategy comparison, we will tackle four aspects of the platforms: user interface, data sources integration, visualizations, and pricing. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. You can also supply a MicroStrategy. In the New Intelligent Cube dialog box, select the MDX Sources tab. Browse to and select a previously saved Intelligent Cube on which to build your report. The partition attribute is the attribute that is used to divide. This file stores cache matching. Check it in the cube monitor and we can see its column Database Connection is not empty. In MicroStrategy Developer, log in to a project source with administrative privileges. However, users. However, importing data from a Google Drive Spreadsheet requires some additional setup. Right-click a project and select Project Configuration. Number of Views 1. 3. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. At this point, the Month attribute can be removed from the cube to reduce the publication time and size of the Intelligent Cube within memory. With the intuitive card editor and flexible data layouts, it’s astonishingly simple. This can be done by selecting Run Report in the toolbar. Choose File > New > Intelligent Cube. Browse to an Intelligent Cube, select it, and then click OK. Create an Intelligent cube named Q1 with attribute ‘Brand’, ‘Item’ and ‘Warranty’; publish it. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. Click OK. Main Features. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. A significant decline in micro-business intelligence strategy is also pricing. MicroStrategy’s 64-bit architecture supports in-memory analytics with “Intelligent Cubes” that are OLAP reports cached in memory as data sets. Intelligent Cubes are part of the OLAP Services features in Intelligence Server. 3. In the left pane, click Intelligent Cubes. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. For Capacity Planning Team (User/Session Concurrency) Provides information by day, hour, and connection source of numbers of users and sessions. For the time being the only suggestion we may offer is to not use both data base functions and intelligence cubes in conjunction. This report is prompted on time. Report: The results of a report are used to populate the Intelligent Cube. Performed system checks like licensing, functionality, managing user privileges of the system. 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. Reporting on an Intelligent Cube provides quick access to data, as the data has been pre-aggregated. MicroStrategy is an enterprise business intelligence application. 28. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Click Select. 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. Do not normalize Intelligent Cube data. What are the benefits of Microstrategy you are familiar with? 1. Before 10. To Create an Intelligent Cube Using Freeform SQL or Query Builder. 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. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. It helps us analyze and modify reports much faster since the data is from in-memory data cubes rather than the data warehouse. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. This template includes the following tasks: Creates a new metadata. 1. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Required Status to Perform Action. Intelligent Cubes. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. 20. Follow these steps to enable Dynamic Sourcing for the project: 1. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. Both tools allow you to plot interactive charts, graphs, and dashboards for comprehensive analysis. Intelligent Cube Technology is used by MicroStrategy. Select the data set and click Prepare Data. Build a cube of customer data that’s relevant to all employees and publish it. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. In MicroStrategy Developer, log in to a project source using administrative privileges. Description: Intelligent Cube design and utilization; how to build cubes. Our MicroStrategy Online Training module will provide you a way to become certified in MicroStrategy Online Training India. OLAP services: Derived metrics and viewed filters cannot be supported. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. Number of Views 2. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Telcos need network capacity planning and optimization by correlating network usage, subscriber density, along with traffic and location data. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. 4. x. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Microstrategy is actually based on the single meta-data repository. Some of the obvious benefits of this tool are its excellent data analytics capabilities, extreme scalability, and superior results. Overview What is MicroStrategy Analytics? MicroStrategy Analytics is an enterprise business analytics and mobility platform. MicroStrategy continues to be dedicated to improving the installation and upgrade experience of customers. The display of data is handled by the reports that access the Intelligent Cube. This is the most popular MicroStrategy Interview Question asked in an interview. Users don’t have to mention the cube to which they want to connect. blogspot. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Alternatively, you can enable caching on selected reports. The Intelligent Cube Options dialog box opens. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. The Subscription Editor opens. 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. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. STEPS TO REPRODUCE 1. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". This article describes a limitation of partitioning when used with database side normalized Intelligent Cubes Expand Intelligent Cubes, and then select General. KB255633. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. The Report Editor opens. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL. Metrics and attributes are created once and used across different types of reports. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. All necessary privileges are included in the Administrator role by default. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. Publish the cube. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Intelligent cubes are generated automatically when a new report is run against the data warehouse. STEPS TO REPRODUCE: 1. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. To view an Intelligent Cube stored in your History List. Users don’t have to mention the cube to which they want to connect. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube. Select other schedule options as required, and click OK. Open the Workstation window. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. Advantages of OLAP Tools. Right-click an Intelligent Cube and select Delete. 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. Multi-pass SQL . These restrictions are applied automatically when creating prompts. Key features include automatic big data. 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. If removing the view filter does not. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 0 has a dedicated section to memory used for Intelligent Cubes. Edit Intelligent Cubes from the new editor in Workstation at any time. This status can appear due to an environment issue such as the network, database connection, or a PC resource usage issue. This will reduce the memory usage from 150GB to 100GB. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Because the filters are applied to the master data in the Intelligent. You can also supply a MicroStrategy Enterprise Manager report to include more information on the performance benefits of each Intelligent Cube as part of your dynamic sourcing strategy. 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. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. Create the MIN (CurrentDateTime ()) metric. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. From the Administration menu, point to Scheduling, and then select Subscription Creation Wizard. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Create a Report 'R3' with 'Country' attribute. In Developer, log into a project. Published: May 15, 2018; Last updated: Nov 15, 2022The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. It takes you from setting up and configuring MicroStrategy to security and administration. The Intelligent Cube Options dialog box opens. Dynamic Sourcing. Create the metric levels log file used to track the use of dynamic sourcing. Create a report based off the cube in Step 1 that includes the description form for Category. Create a report based on above Cube and add the prompt in view filter. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. In the Refresh Policy column, choose. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. 3. Select the Allow reports to drill outside the Intelligent Cube check box. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. Intelligent Cubes. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. MicroStrategy version 9. Publish the Cube, and create the following Dossier:. 17. With OLAP Services features, your report designers can create Intelligent Cube reports. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 46K. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. MicroStrategy Intelligence Server. The Intelligent Cube refresh settings are recommended if the data in the. /ClusterCube. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. An Intelligent Cube is a set of data that can be shared as a single in-memory. This data can be used to create a. Right-click the Intelligent Cube, and select Edit. The first part discusses the behavior of both the MicroStrategy semantic SQL Query engine layer and the Snowflake temporary. Run the Report and check the SQL View. Users don’t have to mention the cube to which they want to connect. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 1 release. However, Intelligent cube publishing performance may be affected with the agent enabled. Do you have reports that currently access. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. Click OK. Number of Views 1. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports.