Installed, upgraded and managed MicroStrategy 7. Choose File > New > Report. If you do not use connection mapping, leave this check box cleared. 4. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Comparing OLAP and MTDI cubes. 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). In MicroStrategy 9. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Intelligent Cubes. Hyper intelligence is a. When an Intelligent Cube is published, the Intelligent. Multiple reports can access a single. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. The Intelligent Cube opens in the Report Editor. " maps to the Intelligence Server working directory (when using default locations, this will be C:\Program Files (x86)\MicroStrategy\Intelligence Server). This can be seen in the screenshot below. 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. Con: The copy of report data in Intelligence Server memory only applies to a single report. In versions prior to MicroStrategy Intelligence Server 9. Select Intelligent Cubes > General > Intelligent Cube File directory. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. This is particularly useful when there exist many Intelligent Cubes that have to be published but require a high amount of memory in the process so executing them, all at the same time is not feasible. This can be done by selecting Run Report in the toolbar. Create a report based on above Cube and add the prompt in view filter. 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. Expand Intelligent Cubes, and then select General. 3. The MicroStrategy Web architecture has the following highlights:. KB442264 : In-Memory query against Intelligent Cube incorrectly does a cross join instead of joining through available tables using which the attributes could be joined. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. KB32540: Intelligent Cube Population methods in MicroStrategy. In the left pane, click Intelligent Cubes. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. Your SQL Server analysis is accessible to the MicroStrategy platform as a Report, Datamart, Intelligent Cube, or on-demand retrieval using live mode. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. idx file is cleaned up. Slice and dice features are awesome. Prerequisites to creating Intelligent Cubes. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. With MicroStrategy optimal handling, calculations can still be distributed with the project’s primary database instance. 4. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Create a Report 'R3' with 'Country' attribute. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. In Developer, log in to a project with a user account with administrative privileges. This can. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. KB255633. Before MicroStrategy 10. From the Data menu, select Configure Intelligent Cube. STEPS TO REPRODUCE: 1. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Datasets API. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. 19. With the intuitive card editor and flexible data layouts, it’s astonishingly simple. A solution for this issue is available in current releases but need turn on via registry key setting. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. Answer: Go with dossier. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. 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. MicroStrategy Analytics cubes are easy to create and deploy. ACTION:The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Complex metrics here refer to metrics which are defined using multiple. For more information on the Intelligent Cube Maximum. Select other schedule options as required, and click OK. QUESTIONIn order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. For Capacity Planning Team (User/Session Concurrency) Provides information by day, hour, and connection source of numbers of users and sessions. In Developer, from the File menu select New, and then Intelligent Cube. The Intelligent Cube Options dialog box opens. 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. MicroStrategy vs. Create a subset. For information about general rules that apply when security filters are applied on view reports based on Intelligent Cubes, refer to the. the scheduler that manages the data lake updates, the ability to initiate an on-demand cube refresh immediately after the data lake update is complete. 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%. Create the metric levels log file used to track the use of dynamic sourcing. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). Some of the obvious benefits of this tool are its excellent data analytics capabilities, extreme scalability, and superior results. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 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. 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. e. 6 plus years in Data warehousing, Business Intelligence systems, OLAP environments and tools. However, storing too much Intelligent Cube data in. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. 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. Before 10. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Right-click a project and select Project Configuration. Create a report on this intelligent cube with the month attribute and the count of day metric. These segments, called partitions, are processed simultaneously, distributed across the processor cores of your Intelligence Server. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. •Develop a future state pilot that demonstrates the enterprise-ready value of the MicroStrategy Intelligence Platform and. MicroStrategy OLAP Services is an extension to MicroStrategy Intelligence Server that allows MicroStrategy Web and Desktop users to manipulate Intelligent Cubes™. Intelligence Server Statistics . The Save Intelligent Cube As dialog box opens. In the left panel, click Cubes. You can edit project-level cache and Intelligent Cube settings. Cube and Cache Metric Names. Storing Intelligent Cubes can greatly improve performance by allowing reports to execute against an in memory copy of data. Run a dossier based on the cube. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access 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. Intelligent Cubes. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Following are the features, which make intelligent cubes useful. 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. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. MicroStrategy recommends to change it to unlimited so your core file is not truncated. Published: Jun 1, 2017. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. The Intelligent Cube Options dialog box opens. PATH: The path to the Intelligent Cube, returned as a string. Enable users to interact with personalized chat for further product discovery. 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. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. Multi-pass SQL is required to answer analytical questions that cannot be. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue, which is based on the fact Revenue. Number of Views 1. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. This report is prompted on time. HIDDEN: Whether or not the Intelligent Cube is hidden, returned as a boolean value. For information on locating and using this Enterprise Manager report, see Enterprise Manager report for Cube Advisor . 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. Microstrategy is actually based on the single meta-data repository. This can improve the performance of reports, which get executed against an Intelligent Cube, without having to manually find and select the Intelligent. Creates the Intelligent Cubes you decide should be created. Jul 17, 2023. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. It takes you from setting up and configuring MicroStrategy to security and administration. 4: Persisted. A MicroStrategy Business Intelligence Developer can earn US$117,000/year – Indeed. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. The following diagram depicts the role of the intelligent cube. Select a schedule from the Schedule drop-down list. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. com Format: A MicroStrategy Online Training Video blog. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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. MicroStrategy reference numbers for this technical note are KB442285 and DE101600. Both the Intelligent Cubes have a common attribute between them and each of the cubes have their own filter on that attribute. The Intelligent Cube Monitor is shown in the image below. This article describes features that are not supported when using Dynamic Sourcing. The Intelligent Cube Options dialog box opens. The first part discusses the behavior of both the MicroStrategy semantic SQL Query engine layer and the Snowflake temporary and transient table. MicroStrategy allows you to load large datasets into your Intelligence Server's memory as Intelligent Cubes, and divide the Intelligent Cubes into multiple segments. The MicroStrategy platform supports components across both Windows and Linux operating systems to support your. The total number of Intelligent Cubes for a project that are stored in Intelligence Server memory is compared to the limit you define. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. However, users. Right-click an application and choose Properties. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. 3. Create an Intelligent cube named Q1 with attribute ‘Brand’, ‘Item’ and ‘Warranty’; publish it. Updating Intelligent Cubes without re-processing: Incremental Refresh. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. In MicroStrategy Developer, browse to an Intelligent Cube. 19. 4. Click All Objects View. Publish the Intelligent Cube by executing it on either of the nodes. Select the Data Partition category. This defect is addressed in MicroStrategy 11. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Modify or remove the view filter to attempt to return data for the report. 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. An example of this behavior for a relatively small cube is shown in the screen shots below:Right-click the report and select Edit. The Visualization SDK has the following benefits. Strong semantic layer to define all the business rules and tightly coupled. Expand Intelligent Cubes, and then select General. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. The Intelligent Cube Monitor is displayed. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. 1. Click the MicroStrategy icon at the upper left of any page and select History List. INTRODUCTION: In MicroStrategy 9. In MicroStrategy Web 9. 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. CAUSE: This is a known issue in MicroStrategy 10. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. The book starts by detailing. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . 3. In either case, the Intelligence Server is responsible for determining the lists of distinct attribute elements, and this operation is always case sensitive. details. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Easily add or change pre- and post- SQL statements. An Intelligent Cube has been created in a project. An Intelligent Cube is a. 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. Follow these steps to enable Dynamic Sourcing for the project: 1. 1,000Indicates a user published an intelligence cube from any tool (Web, Developer, etc). 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. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. In MicroStrategy Developer, log in to a project source using administrative privileges. In the Data Source column, select the checkboxes for the tables to update. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. 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. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. The Intelligent Cube opens in the Report Editor. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. Import and filter data from a OlapCube, SuperCube or Report into a Pandas DataFrame (see code. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. 4. MicroStrategy is an enterprise business intelligence application. Create an attribute element prompt for the. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Choose File > New > Intelligent Cube. 8: Monitoring information dirty. 12 = MicroStrategy 2020 platform behavior 13 = MicroStrategy 2021 platform behavior Steps to reproduce. The Report Editor opens. Source: MicroRooster. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. With OLAP Services features, your report designers can create Intelligent Cube reports. 2. Users don’t have to mention the cube to which they want to connect. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Choose Data > Configure Intelligent Cube. However, if the. Alternatively, you can enable caching on selected reports. 3. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. What are the advantages of cubes in MicroStrategy? Ans: The advantages of cubes are: Supports derived metric creations;. 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. In MicroStrategy Integrity Manager 10. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Drawbacks of Microstrategy Business Intelligence. All necessary privileges are included in the Administrator role by default. Provides the last cube row count. Deploying the MicroStrategy software platform is the first step towards an enterprise scale business intelligence system. 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. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. Share query results in-memory across multiple dossiers and reports. Publishing Intelligent Cubes. KB485159: Enable support for Security Filter with Top and Bottom Range Attributes in Data Import Intelligent cubes and Fix the security hole in Connect Live Data Import Intelligent cubes MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). KB440835: In MicroStrategy 10. To view the details of an Intelligent Cube, double-click that Intelligent Cube. MicroStrategy 9. - Full of advanced features like data storage in MicroStrategy cubes for faster reporting times, advanced grouping and filtering, ability to write your own SQL in the backend, ability to customize using SDK interface - MicroStrategy Mobile is game changer. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. 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. Creates the Intelligent Cubes you decide should be created. The MicroStrategy Intelligence Server 9. 0 MicroStrategy releases. Disconnect from the project source and restart both Intelligence servers. Select Empty Intelligent Cube and click OK. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. x a new concept is introduced called Intelligent Cubes. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Professional Summary. Required Status to Perform Action. 4. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. 1 or above, to pick up the fix, enable project level setting "Data Engine. 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'. Although the company’s platform was traditionally deployed on premises, customers increasingly wanted to create. Platform Analytics is the new monitoring tool in MicroStrategy 11. Users of Intelligent Cubes in MicroStrategy 9. The procedure below provides the steps to manually publish an Intelligent Cube. Because the filters are applied to the master data in the Intelligent. You can create and analyze new reports in real time. Select the Allow reports to drill outside the Intelligent Cube check box. x. Although the directory filed shows the same location as the source project, cubes are saved to a. Schedule administrative tasks and reports to run during off-peak hours, so that they do not adversely affect system performance. x releases. 0 has a dedicated section to memory used for Intelligent Cubes. An Intelligent Cube is a set of data that can be shared as a single in-memory. 3. If removing the view filter does not. MicroStrategy administrators can automatically ensure that business users always have the most current information by configuring the Intelligent Cube data to expire or. Use Case 4. 1 release. The default value is 256 megabytes. The Report Editor opens. Description: Intelligent Cube design and utilization; how to build cubes. This data is to apply the calculations. To enable or disable dynamic sourcing for an Intelligent Cube. This enables the development of datasets via data importing, instead of creating and modifying each new dataset from scratch. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. 4. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. To enable or disable dynamic sourcing for an Intelligent Cube. Subsequently the requests made by other users can. Creating reports based on Intelligent Cubes can also greatly speed up the processing time for reports. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. 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. 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. The Full Refresh option is the default. Edit Intelligent Cubes from the new editor in Workstation at any time. The MicroStrategy platform uses a single common metadata for consistency and streamlined maintenance. Add objects such as attributes, metrics, and so on for the Intelligent Cube, the same. 6, when users created a Dashboard or a Document using a Connect-Live Cube, using Metric Qualification with an output level that is lower than the template level and created at least 2 layers of nested aggregation on top of the cube metrics, the iServer crashes. When you run reports in MicroStrategy, they collect the warehouse data. 0 Intelligent and Web servers for development, test and production environments. The Intelligent Cube Options dialog box opens. 0. To enable. Number of Views 1. 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. 0. 0. 2. Along with. This. Multi-pass SQL . Vn (with metric Mn from source cube Cn). By default, the report template used is the same as the Intelligent Cube's template. Many other OLAP providers support MDX, including Microstrategy’s Intelligence Server, Hyperion’s Essbase Server, and SAS’s Enterprise. 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. MicroStrategy continues to be dedicated to improving the installation and upgrade experience of customers. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. For a list of objects and features that cannot be included in the definition of Intelligent cubes, see Supporting various features using Intelligent cubes. 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. 2. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. Defining the partition for Super Cubes. To publish an Intelligent Cube, see. View the report in either Grid View or Grid and Graph View. 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. You can perform all of your reporting and data analysis requirements within an Intelligent cube without executing against the data warehouse. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. In MicroStrategy Web 9. To schedule an Intelligent Cube to be updated. The New Grid dialog box opens. 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. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. To Create a Report that Accesses an Intelligent Cube. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. This article also provides a workaround to avoid this behavior. The Intelligent Cube Options dialog box opens. 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. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. By storing your data in your Intelligence. The first column provides the Intelligent Cube name, and the second column provides the full path to the Command Manager script files used to publish the. Ans: A report cache is a result set from an executed report that is stored on MicroStrategy Intelligence Server. Intelligent cubes are generated automatically when a new report is run against the data warehouse. On the toolbar, choose Data > Configure Intelligent Cube. Project Configuration: Intelligence Cubes -> General 2. 4. Metrics and attributes are created once and used across different types of reports. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Plus, it connects business apps while integrating data. The fact that the Intelligent Cube resides on the. The Intelligent Cube Options dialog box opens. x and newer. It turns data into reports for making and executing key organization decisions.