The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. 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. Number of Views 2. Create a subset. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. Stand out in a crowd. Dynamic Sourcing. 2. This returns results much faster than querying the data warehouse. Multi-pass SQL . This command can get the correct cube status and table status only when the cube is being refreshed or published in the same session between Command Manager and Intelligence Server as this command's. The MicroStrategy Intelligence Server 9. I assume both these "cubes" organize data in a way that is easy and fast to use for dimensional queries, but I don't think you can import directly an Oracle cube into. 12 = MicroStrategy 2020 platform behavior 13 = MicroStrategy 2021 platform behavior Steps to reproduce. The Intelligent Cube Options dialog box opens. •Develop a future state pilot that demonstrates the enterprise-ready value of the MicroStrategy Intelligence Platform and. 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. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . When a change is made in one place, all related reports are automatically updated. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. Following are the methods by which we can reflect it in 3 tier. If the Intelligent Cube must be re-processed based on a metric. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. With OLAP Services features, your report designers can create Intelligent Cube reports. View the report in either Grid View or Grid and Graph View. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. Metrics and attributes are created once and used across different types of reports. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue, which is based on the fact Revenue. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. Right-click an Intelligent Cube and select Delete. Disconnect from the project source and restart both Intelligence servers. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. 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. 4. 19. Select the Intelligent Cubes tab. Measures the time duration an operation executed against cubes. The status of each Intelligent Cube is listed in the. In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . MicroStrategy OLAP Services uses the concept of Intelligent Cube, an in-memory version of a report that can be manipulated by the Analytical Engine. Publishing Intelligent Cubes. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. In Developer, log in to a project with a user account with administrative privileges. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. The procedure below provides the steps to manually publish an Intelligent Cube. 0 MicroStrategy releases. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. Creating reports based on Intelligent Cubes can also greatly speed up the processing time for reports. Intelligent Cubes are automatically built once and stored in MicroStrategy’s unified metadata on the centralized server, where they can be shared across the enterprise. 5 GB, the Data Transfer from Datasource(s) time is 77. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. . 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. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. Advanced Properties for Intelligent Cubes MicroStrategy Workstation provides workflows for both modeling and management. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. Normalize Intelligent Cube data in the Database. Many users may request the same report but with different ranges of filter conditions. x. x. In the Data Source column, select the checkboxes for the tables to update. OLAP systems use pre-computed summaries and aggregations, called cubes, to. However, Intelligent cube publishing performance may be affected with the agent enabled. Intelligent Cubes. 9 and above. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Intelligent Cube Technology is used by MicroStrategy. Most likely several, different fact tables are uses for each query. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. Choose File > New > Report. Performed basic stability testing of Intelligence server and updated projects. The first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. arrow_forward Explore the use of computational systems in the field of artificial intelligence and machine learning, emphasizing the role of GPUs and TPUs. 39. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. 1, Data Import allows users to maintain intelligent cubes from external Excel files. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Recorded at World 2021. It will remain available, but the setting will not. 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. 3. For more information on the Intelligent Cube Maximum. The Intelligent Cube opens in the Report Editor. 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. When you run reports in MicroStrategy, they collect the warehouse data. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. It must be ensured that the Windows NT account used to run the MicroStrategy Intelligence Server on every node has access to the shared folders. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. Micro Strategy also supports mobile BI. Instead of always executing against the data warehouse. 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. With the intuitive card editor and flexible data layouts, it’s astonishingly simple. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 2. On the toolbar, choose Data > Configure Intelligent Cube. Source: MicroRooster. The New Intelligent Cube dialog box opens. 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). Jul 17, 2023. Select the Allow reports to drill outside the Intelligent Cube check box. To build an Intelligent Cube. Save the Intelligent Cube. Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 89 reviews while MicroStrategy is ranked 8th in BI (Business Intelligence) Tools with 12 reviews. However, you cannot create a card based on a live-connect MDX/SAP cube. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Traditional Report Caching in MicroStrategy is done on a matching basis. 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. In MicroStrategy Web 9. The ability to view or edit certain settings is determined by a user's privileges. MicroStrategy 9. Click here to view details about the Intelligent Cube Monitor. MicroStrategy version 9. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. This article describes the Intelligent Cube Population options available in MicroStrategy MicroStrategy provides ETL, data warehousing and data mining for data analysis. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. To do so, you can take advantage of URL API. 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. MicroStrategy needs to define which one they will use. 2. Users don’t have to mention the cube to which they want to connect. 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. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Published: Jun 1, 2017. You can also create Intelligent Cubes by directly querying your data. Sharing data. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Once an Intelligent cube is created and then published. Great app and makes a solid impression on C-suite executives. x-10. 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. 2987. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Project Configuration: Intelligence Cubes -> General 2. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. Build a cube of customer data that’s relevant to all employees and publish it. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. . Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Run a dossier based on the cube. To Create a Report that Accesses an Intelligent Cube. Mention the features that are not supported by intelligent cube? Ans: Features that are not supported by intelligent cubes are: Prompt. All necessary privileges are included in the Administrator role by default. 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. Share query results in-memory across multiple dossiers and. MicroStrategy Analytics cubes are easy to create and deploy. Select the data set and click Prepare Data. To enable or disable dynamic sourcing for an Intelligent Cube. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. 2. Advantages of OLAP Tools. MicroStrategy 9. What are the advantages of cubes in MicroStrategy? Ans: The advantages of cubes are: Supports derived metric creations; Fast. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties dialog. Reporting on an Intelligent Cube provides quick access to data, as the data has been pre-aggregated. Click the “Add history list subscription” link near the bottom of the screen to open the. When a remote accesses this cube, the cube is loaded into memory of the. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. This is set to 32,000 by default. Right-click an Intelligent Cube and select Delete. Comparing OLAP and MTDI cubes. x releases, and the new Multi-table Data Import (MTDI) cubes. In the left pane, click Intelligent Cubes. This file stores cache matching. 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. 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. Platform Analytics is the new monitoring tool in MicroStrategy 11. Together with the Reports API, this API is often referred to as the JSON Data API. KB440822. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. Then it generates a report. Drag and drop the objects into the report grid from the Report Objects pane. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. In the Object name field, type a descriptive name for the Intelligent Cube. Multiple reports can access a single. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. Slice and dice features are awesome. A MicroStrategy Business Intelligence Developer can earn US$117,000/year – Indeed. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Definition. Users don’t have to mention the cube to which they want to connect. 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). Mapbox partners with community mapping. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. It's not intended to be a representation of the Oracle cubes. Add objects such as attributes, metrics, and so on for the Intelligent Cube, the same. The Full Refresh option is the default. Subsequently the requests made by other users can. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. The fact that the Intelligent Cube resides on the. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. The Intelligent Cube opens in the Report Editor. Traditionally, this type of requirement was hard to achieve as there was not an event that could be triggered right after the execution of an. 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. Select a schedule from the Schedule drop-down list. An Intelligent Cube is a set of data that can be shared as a single in-memory. In Developer, from the File menu select New, and then Intelligent Cube. You can also supply a MicroStrategy. Maintaining data access security. MicroStrategy recommends to change it to unlimited so your core file is not truncated. x -10. 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. The following diagram depicts the role of the intelligent cube. Intelligent cubes are generated automatically when a new report is run against the data warehouse. x to 8. /ClusterCube. 4 types: matching caches, history caches, matching-history caches, and xml caches. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. To change the status of an Intelligent Cube, right-click that Intelligent Cube and select the desired action from the list. 1. Microsoft BI is rated 8. 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. Number of Views 1. Click Select. e. com Format: A MicroStrategy Online Training Video blog. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. 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. xCreate Intelligent Cube Reports. MicroStrategy Intelligence Server. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. Query Generation. 0 Intelligent and Web servers for development, test and production environments. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. The Intelligent Cube is opened in the Report Editor. Benefits of Intelligent Cubes include: Greater Efficiency - Intelligent Cubes are automatically generated and shared among all users whenever a. However, if the. Easily add or change pre- and post- SQL statements. Intelligent cubes are generated automatically when a new report is run against the data warehouse. Cube Advisor opens. Then the warehouse will have to repeat similar calculations for each report. 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. Defining Intelligent Cube refresh settings. Drag and drop the objects into the report grid from the Report Objects pane. 1 release. 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. Create an Intelligent Cube with attributes Year, Month and Region; 4. Sharing data. Recommends and creates Intelligent Cubes that could provide data to reports using dynamic sourcing. Create the MIN (CurrentDateTime ()) metric. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn MicroStrategy OLAP Services, Transformation metrics used in standard reports can resolve against Intelligent Cubes only when the same Transformation metric exists in the Intelligent Cube. Check it in the cube monitor and we can see its column Database Connection is not empty. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. idx file is cleaned up. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. The objects in the source cubes will control how the security filter will be applied. ACTION: This issue has been fixed in MicroStrategy 10. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. The New Intelligent Cube dialog box opens. Create a report based off the cube in Step 1 that includes the description form for Category. Visit the data visualization and data dashboard galleries for inspiration. The Intelligent Cube Options dialog box opens. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. Browse to an Intelligent Cube, select it, and then click OK. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. x environments. However, there are some differences in security filter resolution for reports that connect to Intelligent Cubes as compared to reports that directly access the. A MicroStrategy prompted document has two dataset reports that are each based on a different Intelligent Cube. The template level metric condition on Aggregate From Base derived metrics have been corrected, so it is no longer is ignored during Data Blending. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. Do you have reports that currently access. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. Telcos need network capacity planning and optimization by correlating network usage, subscriber density, along with traffic and location data. The default value is 256 megabytes. Con: The copy of report data in Intelligence Server memory only applies to a single report. In Developer, log into a project. 49. Watch on Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. 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. 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. Mention the features that are not supported by intelligent cube? Ans: Features that are not supported by intelligent cubes are: Prompt. It helps us analyze and modify reports much faster since the data is from in-memory data cubes rather than the data warehouse. 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. By default, the report template used is the same as the Intelligent Cube's template. 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. MicroStrategy Intelligence Server may run as a daemon process (service). To enable or disable dynamic sourcing for an Intelligent Cube. 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. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. 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. Telcos using MicroStrategy can run. Deploying the MicroStrategy software platform is the first step towards an enterprise scale business intelligence system. Answer: Go with dossier. To schedule the publication of Intelligent Cubes. 0. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. This report is prompted on time. Its 64-bit architecture supports in-memory analytics with "Intelligent Cubes" (or OLAP reports cached in memory as data sets). Open the Workstation window. No data is returned for the report. A set of data is returned from the. Modify or remove the view filter to attempt to return data for the report. Although the directory filed shows the same location as the source project, cubes are saved to a. Click OK. 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%. The Intelligent Cube Monitor is displayed. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. A significant decline in micro-business intelligence strategy is also pricing. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. 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. The Intelligent Cube Options dialog box opens. 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. More about Feature flags can be found in this article. 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. Browse to and select a previously saved Intelligent Cube on which to build your report. Number of Views 1. These restrictions are applied automatically when creating prompts. Before MicroStrategy 10. This article narrates large cubes appear in ‘LP’ status and some other cubes not shown up in cube monitor in MicroStrategy 2021 is due to loading cube info thread being blocked by loading the large cube instance. Subsequently the requests made by other users can. This dataset needs to contain all data in the required granularity. Use the Cube Advisor to create Intelligent Cubes that will allow as many reports as possible to use dynamic sourcing. If the Intelligent Cube must be re-processed based on a metric. MicroStrategy is an enterprise business intelligence application. The New Grid dialog box opens. 5. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. This copy of report data is stored in Intelligence Server memory only. 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. We will examine which of the two offers the best in each round and determine the overall winner at the end based on those results. MicroStrategy takes advantage of key Mapbox features that enable dossier authors to create beautiful and performant visualizations. 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 Dynamic Sourcing feature in MicroStrategy OLAP Services 9. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. Publish the cube. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Published: 4월 6, 2017. This can be done by selecting Run Report in the toolbar. The Report Editor opens. MicroStrategy 2021 Update 9 introduces the ability to create Intelligent cube reports based on an Intelligent cube. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. OLAP Cube Advantages . • Created Intelligent Cubes and performed sharing to reduce the database load and decreasing the report execution time by using the cube services. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. To ensure your project has it enabled, check: 1. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Overview. If you are upgrading to MicroStrategy 11.