An example of this behavior for a relatively small cube is shown in the screen shots below:Right-click the report and select Edit. MicroStrategy recommends to change it to unlimited so your core file is not truncated. x. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. 4 types: matching caches, history caches, matching-history caches, and xml caches. Add objects such as attributes, metrics, and so on for the Intelligent Cube, the same. In MicroStrategy Tutorial Project, create an In-Memory Intelligent Cube by importing the following Database Tables. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. The prompt in the document is an attribute qualification prompt on the same attribute that is common to. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. The Intelligent Cube refresh settings are recommended if the data in the. 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. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. Slice and dice features are awesome. Traditional Report Caching in MicroStrategy is done on a matching basis. 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. The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. 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. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Strong semantic layer to define all the business rules and tightly coupled. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical. Intelligence Server Statistics . The. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. You can also supply a MicroStrategy. Telcos using MicroStrategy can run. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 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. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. x-10. Its 64-bit architecture supports in-memory analytics with "Intelligent Cubes" (or OLAP reports cached in memory as data sets). Using MicroStrategy OLAP Services, it is possible to apply security filters at the view report level. Expand Intelligent Cubes, and then select General. When an Intelligent Cube. Intelligent Cubes. This report is prompted on time. Some of the obvious benefits of this tool are its excellent data analytics capabilities, extreme scalability, and superior results. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. Multi-pass SQL is required to answer analytical questions that cannot be. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. The. 4. Intelligent Cubes as datasets. 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. The Intelligent Cube Options dialog box opens. 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. Import and filter data from a OlapCube, SuperCube or Report into a Pandas DataFrame (see code. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Since accessing Intelligent Cubes for OLAP analysis does not require runtime processing on the data warehouse and can use schedules to reduce IT management, users have. This data can be used to create a. The VLDB property, Attribute to Join When Key From Neither Side can be Supported by the Other Side becomes obsolete once you upgrade your data engine version to 2021. You can edit project-level cache and Intelligent Cube settings. 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. The Intelligent Cube Options dialog box opens. Published: Jun 29, 2018;To Create an Intelligent Cube Using Freeform SQL or Query Builder. KB47254: How to create a subscription to refresh Intelligent Cubes using MicroStrategy Command Manager 9. Along with. 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. What are the new Intelligent Cube Cache commands available in MicroStrategy Command Manager 9. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. Sharing data. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. 1. This can improve the performance of reports, which get executed against an Intelligent Cube, without having to manually find and select the Intelligent. In MicroStrategy Developer, log into a project as a user with full administrative privileges. Follow these steps to enable Dynamic Sourcing for the project: 1. Click All Objects View. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. The default value is 256 megabytes. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. (Intelligent Cube configuration is not relevant in MicroStrategy 8. 49. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Intelligent Cube storage on disk mirrors report cache storage. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Using Database Write-back Functionality to Enable Decision-Making. MicroStrategy for Tableau allows you to fetch data from reports or cubes that reside in MicroStrategy projects into Tableau Public (also known as Tableau Desktop). The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Edit Intelligent Cubes from the new editor in Workstation at any time. 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. Create Cube1 with the Region attribute and the metric created in step 1. The display of data is handled by the reports that access the Intelligent Cube. 5. Together with the Reports API, this API is often referred to as the JSON Data API. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. If the welcome page is shown, review the information and click Next. Drive revenue growth with memorable app workflows and AI features that really speak to the user. Telcos need network capacity planning and optimization by correlating network usage, subscriber density, along with traffic and location data. In the left panel, click Cubes. Measures the time duration an operation executed against cubes. Required Status to Perform Action. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. Choose Data > Configure Intelligent Cube. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Color thresholds enable users to gain insight into a specific metric at a glance. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. Upgrade to those versions to take advantage of the fix. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. . Drag and drop the objects into the report grid from the Report Objects pane. This template includes the following tasks: Creates a new metadata. You can control users' access to data with security filters. This can be done by enabling the feature flag "Defect fixes that may impact data, SQL, MDX, CSI" in Web. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. The Schedule dialog box opens for your dataset, showing the tables in your dataset. See KB484738 for more information. A MicroStrategy Business Intelligence Developer can earn US$117,000/year – Indeed. Choose one of the following options: Full Refresh: This is the default. 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. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. With OLAP Services features, your report designers can create Intelligent Cube reports. 2987. Key features include automatic big data. 6 plus years in Data warehousing, Business Intelligence systems, OLAP environments and tools. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. In the Data Source column, select the checkboxes for the tables to update. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. idx file is cleaned up. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. Refresh. MicroStrategy Developer, MicroStrategy Web, and MicroStrategy Office users can slice and dice data in reports within the Intelligent Cubes without having to re-execute SQL against the data warehouse. 2. MicroStrategy comparison, we will tackle four aspects of the platforms: user interface, data sources integration, visualizations, and pricing. Enable users to interact with personalized chat for further product discovery. Select the data set and click Prepare Data. The Dynamic Sourcing feature in MicroStrategy OLAP Services 9. However, storing too much Intelligent Cube data in. Visit the data visualization and data dashboard galleries for inspiration. Mention the features that are not supported by intelligent cube? Ans: Features that are not supported by intelligent cubes are: Prompt. Normalize Intelligent Cube data in the Database using. L’éditeur Cube intelligent permet de contrôler les propriétés avancées. Two unique methods to implement Intelligent Cube Technology: •Personal Intelligent Cubes. Create the metric levels log file used to track the use of dynamic sourcing. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Published: 4월 6, 2017. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. 3 - Check the Make Intelligent. You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. CONTENT: Enable cube. 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. Definition. 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. Create an Intelligent cube named Q1 with attribute ‘Brand’, ‘Item’ and ‘Warranty’; publish it. Benefits of Intelligent Cubes include: Greater Efficiency - Intelligent Cubes are automatically generated and shared among all users whenever a. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Check it in the cube monitor and we can see its column Database Connection is not empty. 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. No data is returned for the report. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". MicroStrategy needs to define which one they will use. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. Design and deploy Hyper cards in minutes. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . With an increasing number of cubes being processed and/or increasing cube complexity, more time is needed for cube processing since project loading and schema updates take longer. However, you cannot create a card based on a live-connect MDX/SAP cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Many other OLAP providers support MDX, including Microstrategy’s Intelligence Server, Hyperion’s Essbase Server, and SAS’s Enterprise. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. Creates the Intelligent Cubes you decide should be created. This dataset needs to contain all data in the required granularity. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. In Developer, log in to a project with a user account with administrative privileges. This can be done by selecting Run Report in the toolbar. 28. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube. The solution discussed in this article is a python application that leverages the MicroStrategy API suite to provide an external scheduler, i. Watch on Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. 4. The Report Editor opens. MicroStrategy vs. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. - Normalize Intelligent Cube data in the. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. The New Intelligent Cube dialog box opens. The default value is 256 megabytes. To learn more, read our detailed. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. 0, to pick up the feature, enable project level setting. 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. Publish the Intelligent Cube by executing it on either of the nodes. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. 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%. x a new concept is introduced called Intelligent Cubes. KB32540: Intelligent Cube Population methods in MicroStrategy. Some key benefits include: Mapbox maps use vector tiles instead of image tiles used by many competitors, which enables much smoother and more customizable zooming. MicroStrategy Intelligence Server may run as a daemon process (service). Recorded at World 2021. What is a cube in Microstrategy? Intelligent Cubes: A shared Intelligent Cube (called an Intelligent Cube) is a set of data that can be shared as a single in-memory copy, among many different reports created by multiple users. Modify or remove the view filter to attempt to return data for the report. To learn more about Intelligent Cube Data Partition, please refer to KB237803. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. To plan for. 4: Persisted. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue, which is based on the fact Revenue. An Intelligent Cube has been created in a project. Intelligent Cubes. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. Microsoft BI is rated 8. Microsoft BI based on real PeerSpot user reviews. Users of Intelligent Cubes in MicroStrategy 9. It takes you from setting up and configuring MicroStrategy to security and administration. Then it generates a report. arrow_forward Explore the use of computational systems in the field of artificial intelligence and machine learning, emphasizing the role of GPUs and TPUs. Creates the Intelligent Cubes you decide should be created. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Subsequently the requests made by other users can. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. An Intelligent Cube is an In-Memory data structure which. 4. 6 and higher. This means any report you create will have caching enabled by default. Click Select. Although it seems at first sight that the resolution of intelligence in small business is competitive, you will quickly find that the addition of all required units quickly raises the price to levels close to cognos. In the New Intelligent Cube dialog box, select the MDX Sources tab. In this Microsoft Power BI vs. For example, analyzing the MicroStrategy Tutorial project creates a Cube Advisor results file named MicroStrategy Tutorial. MicroStrategy is an enterprise BI application software. 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. Intelligent Cubes. Name the different. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. Check the number of CPU cores. Choose File > New > Intelligent Cube. 0. This can improve the performance of reports, which get executed against an Intelligent Cube, without having to manually find and select the Intelligent. Verify that sudo ulimit -c returns an unlimited value. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent cube technology: This article describes features that are not supported when using Dynamic Sourcing. 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. The path for cube files must be shared as "ClusterCube". OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. Depending on the implementation this can have many benefits as joining can be more efficient then removing rows through a WHERE clause, and a reduced Tabular Dataset helps the. 19. 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. 0 MicroStrategy releases. 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. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. 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%. Schedule administrative tasks and reports to run during off-peak hours, so that they do not adversely affect system performance. 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. Video Tutorials. - Normalize Intelligent Cube data in the. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Click OK. The Intelligent Cube Monitor is displayed. 4. For Capacity Planning Team (User/Session Concurrency) Provides information by day, hour, and connection source of numbers of users and sessions. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. This status can appear due to an environment issue such as the network, database connection, or a PC resource usage issue. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. 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. The Intelligent Cube Monitor is displayed. · Update the schema in 2-tier and reload the project from the Project Monitor. This option allows users to collaborate and develop an application schema over time by merging smaller,. The Intelligent Cube Monitor is shown in the image below. In Developer, log in to a project with a user account with administrative privileges. The ability to view or edit certain settings is determined by a user's privileges. 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 connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. Overview What is MicroStrategy Analytics? MicroStrategy Analytics is an enterprise business analytics and mobility platform. Click Select. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Navigate to the Data Refresh category. Save the 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%. To schedule the publication of Intelligent Cubes. Number of Views 1. x releases. All necessary privileges are included in the Administrator role by default. Platform Analytics is the new monitoring tool in MicroStrategy 11. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . After a report. 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. Do not normalize Intelligent Cube data. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. The following table summarizes the test results of some test scenarios against Oracle 19c. It will remain available, but the setting will not. The reports accessing Intelligent Cubes can use all of the OLAP Services features for analysis and reporting. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. MicroStrategy reference numbers for this technical note are KB442285 and DE101600. The book starts by detailing. Select a schedule from the Schedule drop-down list. Select Intelligent Cubes > General > Intelligent Cube File directory. Although the company’s platform was traditionally deployed on premises, customers increasingly wanted to create. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. When a change is made in one place, all related reports are automatically updated. The Intelligent Cube opens in the Report Editor. A significant decline in micro-business intelligence strategy is also pricing. Performed basic stability testing of Intelligence server and updated projects. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. 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. By default, the report template used is the same as the Intelligent Cube's template. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. 1. 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 Intelligent Cube Options dialog box opens. Although the directory filed shows the same location as the source project, cubes are saved to a. This defect is addressed in MicroStrategy 11. 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. Both properties are located in the Query Optimizations folder in the VLDB property editor. MicroStrategy supports dimensional models well, but does not require a dimensional model. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. All articles. 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. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. In MicroStrategy Desktop 9. You can perform all of your reporting and data analysis requirements within an Intelligent cube without executing against the data warehouse. Complex metrics here refer to metrics which are defined using multiple. In MicroStrategy Developer, log in to a project source with administrative privileges. To build an Intelligent Cube. Datasets API. When a remote accesses this cube, the cube is loaded into memory of the. The New Grid dialog box opens. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. 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. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. 20. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. 0. Number of Views 1. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. 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. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Unlike personal Intelligent Cubes that are created automatically, you create Intelligent Cubes and publish. ¶. x. Expand Intelligent Cubes, and then select General. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes"For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. Select the Intelligent Cubes tab. 4.