KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy environment. MicroStrategy Intelligence Server will submit all queries as prepared statements if the following registry key is created on the Intelligence Server machine:To Create an Intelligent Cube Using Freeform SQL or Query Builder. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. If the Intelligent Cube must be re-processed based on a metric. This knowledge base article assumes that the user has a month attribute whose format is YYYYMM as shown below and s/he wants to delete more than 12 months’. PlatformAnalytics. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. How to configure, monitor, and manage Intelligent Cubes. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. rare practice (British Columbia Ministry of Education, 2011, p. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. exe using the command line. * MicroStrategy does have support for dynamic sourcing with MDX sources. Check the location of the new cube cache and notice that it is saved in the default location, i. Version 10. Getting Started with MicroStrategy; Modern BI; BI project life cycle; Meet MicroStrategy 10; Deploying MicroStrategy 10; BI tips; Summary; 2. 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. 1K. Navigate to the Data Refresh category. I possess exceptional proficiency in analysing extensive data sets, deciphering intricate trends, patterns, and customer behaviors, and unveiling invaluable insights that may otherwise remain concealed. This article describes the Intelligent Cube Population options available in MicroStrategy. A typical case is to create a derived metric to perform calculations between columns of metric data. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. Open the Workstation window. Right-click the project and select Project Configuration. Expand the Object Templates category, select General, and. Change Journaling is enabled by default since MicroStrategy version 10. Published: 4월 6, 2017. x, with the Intelligence Server running on Linux, the image in the. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. MicroStrategy provides modern analytics on an open, comprehensive enterprise platform used by many of the […] This article describes best practices to be taken when using a Teradata database in MicroStrategy. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. Source: MicroRooster. Intelligent cube; Advanced reports; Creating and adding data to the document;To view an Intelligent Cube stored in your History List. Refer to Knowledge Base article below for cube status introduction: KB47799: What is the "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer CAUSE: Same thread maybe shared to load Cube Info and Cube instance while loading Cube Instance with big size may block the process of loading Cube Info waiting in the queue. ACTION This. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. This practice is a good option if Intelligent Cubes are supported for a project, but some of the Intelligent Cubes are rarely used in the project. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. x. The test is for a single cube (4M rows) republish executed on the MicroStrategy 2021 Update 2 release with platform as 32 CPU, 244 GB memory Amazon Linux machine. e. Designing and creating documents: An overview. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence Server This article describes features that are not supported when using Dynamic Sourcing. In the Navigation pane, click , next to Datasets. MicroStrategy tested on an Intelligence Server instance with 32 vCPUs 256 GB of memory, importing 10x UB data (about a 11G CSV file) from URL. 46K. , May 6, 2010 -- MicroStrategy® Incorporated (Nasdaq: MSTR), a leading worldwide provider of business intelligence (BI) software, today announced that its In-memory technology delivers significantly higher performance for BI applications, even at the highest scale. The tooltip will show the dataset type listed as a Super Cube. Click 'Add External Data' and then 'File From Disk'. Published: How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. Ensure your data does not exceed the following maximum file sizes: File from disk: 4G. 05K. To do so, you can take advantage of URL API. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). Also Oracle does not support data blending capabilities from the enterprise platform 3 Built-in Best Practices for Visual Exploration: A number of visual exploration best practices embedded within the product. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. To enable or disable dynamic sourcing for an Intelligent Cube. The tooltip will show the dataset type listed as a Super Cube. ACTION: 1. Education. x Attributes used in the filter should also be on the Intelligent Cube’s definition. Trending Articles. Our vision is to enable Intelligence Everywhere. Navigate to and run the Intelligent Cube report. x. This is from all MicroStrategy Business Intelligence clients platform. The Intelligent Cube Options dialog box opens. The Intelligent Cube Options dialog box opens. 29K. MicroStrategy recommends the following best practices to keep your system running smoothly and efficiently: Use the project life cycle of development, testing, production to fully test your reports, metrics, and other objects before releasing them to users. SAP HANA Query Execution. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. (Titled: "Cube broken aplysimple") No data is returned the following SQL view is seen: Report: cube broken applysimple Job: 198 Total Number of Passes: 1 Number of Intelligent Cube SQL Passes: 1 Number of Analytical Passes: 0 Intelligent Cubes Accessed:The Incremental Refresh feature allows users to update cube information without having to republish the entire cube. Discover MicroStrategy 2021 > It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. The Editor and Filter panels are stacked together by default. 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. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". An Enhancement Request for implementing this functionality is. PublishCube". x and later, users should make sure to take into account the following. 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. Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. Edit Intelligent Cubes from the new editor in Workstation at any time. 4 the connection mapping of the u… Number of Views 1. In MicroStrategy Developer or Web, log in to a project that contains Intelligent Cube reports. MicroStrategy is an enterprise business intelligence (BI) application software vendor. Number of Views 5. 31K. x product documentation "InMemoryAnalytics. From the results of single cube publish testing which records and compares the time spent for a single cube (4M rows) republish, JDBC driver has better performance than ODBC driver. MicroStrategy Internal Reference number for this technical note is KB483620 and DE128512. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. iCubes or Intelligent Cubes are objects that provide pre-cached data which can be queried on the reports. Definition. If the Intelligent Cube is at Month level, the user's report should also be at Month level. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from. 4. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. Intelligent Cubes. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;This section describes the ways in which you can design and create a MicroStrategy Report Services document. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. From the Data menu, select Configure Intelligent Cube. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in. IS_CUBE_INST_ID. The considerations and steps required to fully support dynamic sourcing are listed below: While many MicroStrategy features can be used with dynamic sourcing, some features may prevent the use of dynamic sourcing between reports and Intelligent Cubes. x? Intelligence Portal, Query Tone, Rapid Application Development, MicroStrategy Intelligent Cubes, The Foundation For Intelligent E-Business, The Integrated Business Intelligence Platform Built For The Enterprise, The Platform For Intelligent E-Business, The Scalable Busin ess Intelligence Platform To enable or disable dynamic sourcing for an 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. Object Migration Best Practices. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. The report retrieves data from Cube B now. 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. Since this is the first time the cube and cube based objects are being migrated into Production, there is no conflict resolution and all the new objects are copied into. Try to include only information that would be imperative at-a-glance. Likewise, Analysis Services, Oracle Essbase, and TM1 store data. Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. MicroStrategy version 9. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines Place. 1. This section describes only the most basic guidelines. Our vision is to enable Intelligence Everywhere. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. 10. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. The ID is found with the heading. Updating Intelligent Cubes without re-processing: Incremental Refresh. 84K. A bar in the microchart represents that the report is covered by the Intelligent Cube and no bar means that report is not covered by the Intelligent Cube. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Afterwards the cube will start executing. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. Privileges are given on a per-user basis, some of which are also per-Application. Using. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. Open the Workstation window. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. 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. Filename. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. IS_PROJ_ID. 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. Published: Jan 29, 2019;. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. However, if the. Published August 27, 2020 By akrish1982. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. This can. Number of Views 8. MDX Cube Reporting Guide Version 10. 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. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. 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%. IS_CUBE_REP_ID. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Intelligent Cube Using Microstrategy 9. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. Published: Dec 31, 2018; Last updated: Jul 25, 2023Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. The cube population process is the one that retrieves the information from the Warehouse and transfer it to the MicroStrategy Intelligence Server memory in a format which can readily be consumed by different reports requests. MicroStrategy’s new Gateway connector can enable analysts to derive new. 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. From the Data menu, select Configure Intelligent Cube. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. C:Program Files (x86)MicroStrategyWeb ASPxWEB-INFlog. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. KB485674: Create Super Cube from Excel file and update it with a script in. 2. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. Number of Views 18. 4. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. 0, the only way to create an intelligent cube (also. Refer to Product Manual for more detailed information. What to read next? Nothing to see here. 3 - Check the Make Intelligent. Analyze the low performance query using DBA knowledge, add. Click Finish. Memory Storage for document or dossier. x. These. x. Because every company is a data company—no matter which market it competes in. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Published: Dec 31, 2018; Last updated: Jul 25, 2023 Intelligence Everywhere. In a MicroStrategy Web dashboard, from the File menu, choose Dashboard Properties. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). While some duplicate columns in a MicroStrategy schema are necessary or benign, a user may experience issues that require the assistance of Technical Support in. It improves 30% performance in. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. We're using a RaspberryPi with Sense HAT to capture telemetry, which is directly pushed in a MicroStrategy In-Memory cube. x to 11. Place Intelligence Server close to the both the data warehouse and the metadata repository. In MicroStrategy Command Manager 10. A dataset is a set of data that can be displayed on a document. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". E. 0. x. 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. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. The Training Metric Wizard opens. x a new concept is introduced called Intelligent Cubes. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. If you need to delegate administrative responsibilities among several people, create a. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. 4. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. x - 10. This can be done in one node of the cluster because the information is stored in the metadata then used. ISBN: 9781785884405. KB441987: Best Practices for increasing performance of publishing. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. To enable. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Counts the number of jobs from reports not based on Intelligent Cubes but selected by the engine to go against an Intelligent Cube because the objects on the report matched what is on the Intelligent Cube. 8. Generate Oracle AWR report or monitor the database to identify the low performance query. Best practices for supporting dynamic sourcing. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and cube optimization techniques for MicroStrategy. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more cardinality means the attribute with more different elements, for example in the Tutorial project the. Instead of always executing against the data warehouse. Before MicroStrategy 10. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. KB441236. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). Description: Intelligent Cube design and utilization; how to build cubes. x environment, Cache Hit Count or the Last Hit Time of a. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. From the results of single cube publish testing which records and compares the time spent for a single cube (4M rows) republish, JDBC driver has better performance than ODBC driver. To enable. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. The related section is located in. x Intelligent Cube status indication and workflow This section describes the ways in which you can design and create a MicroStrategy Report Services document. 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. view reports. x releases, and the new Multi-table Data Import (MTDI) cubes. OLAP vs MTDI and Best Practices. Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. Object Manager cannot undo the copying and replacing of objects. 4. First, define one visualization as the source. In MicroStrategy Desktop 9. The Dynamic Sourcing feature in MicroStrategy OLAP Services 9. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. Hardware requirements and recommendations. With OLAP Services features, your report designers can create Intelligent Cube reports. 3. 2. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. 1. The SQL-based DI model is described in Providing Data Internationalization. It serves as the starting point for new developers to getThis article describes the best practices for using dynamic sourcing in MicroStrategy. The MicroStrategy Cloud Environment (MCE or MicroStrategy Cloud) is a platform-as-a-service (PaaS) offering that MicroStrategy manages on its customers’ behalf as a unique Amazon Web Services (AWS) or Microsoft Azure implementation. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. Object Migration is the process of migrating or moving objects from one environment to another environment. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. DESCRIPTION: Starting MicroStrategy 10. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. The maximum file size of dashboard (. x Number of Views 8. 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). 4. To create an Intelligent Cube by creating XQuery. Intelligent cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. MicroStrategy’s In-memory technology is engineered to meet the. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. Report runtime performance for reports accessing Intelligent Cubes can be negatively affected as the Intelligent Cube must first be loaded into Intelligence Server. It serves as the starting point for new developers to get This article describes the best practices for using dynamic sourcing in MicroStrategy. Because a single Intelligent Cube cannot connect to more than one data warehouse, using a. x. Office Intelligence, MicroStrategy Office. Trending Articles. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. x. Dedicate a machine for the metadata repository. Place intelligence server close to the both the data warehouse and the metadata repository. To achieve the best performance possible, it's important to delete all unused objects like datasets, visualizations, tabs (for VIs. You can edit project-level cache and Intelligent Cube settings. The user then updates the cube. In your Datasets panel, hover over the name of your dataset. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. x, create a simple Intelligent Cube with attribute Category and metric Revenue. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Right mouse click on the cube, and “Search for dependent subscriptions” as shown below; it shows two subscriptions have been created based on the Intelligent Cube. The dossier shows 4 cubes instances while in workstation there are 6 cubes instance for an intelligent cube as shown below: The missing cube instance GUID could be found in Mstr. 1 To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. x. The syntax is: FileLocation is the path to the saved test file. 11, a new feature is available for performance optimization when dealing with derived attributes. Number of Views 1. Save the Report and close. A document that uses the Intelligent Cube as a dataset. KB5370: What does each cache status mean in MicroStrategy Intelligence Server 9. Web log. Description. Publish the Intelligent Cube by executing it on either of the nodes. Prior to MicroStrategy 2020 the Maximum % of growth of an intelligent cube due to indexes governing setting was used to limit the growth of Intellgent cubes over time due to the creation of indexes. KB442526. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. x - 10. In MicroStrategy Intelligence Server 9. KB31566: MicroStrategy 9. Talk to an expert. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. 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. 4. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and cube optimization techniques for MicroStrategy. Refer to Product Manual for more detailed information. 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"Best Practices Super Cubes in MicroStrategy 2019. 4. Starting in MicroStrategy 10. 0. You should periodically reevaluate the system and update it based on actual system performance and use. The objects stored in the metadata are reusable. Intelligent Cube design and utilization; how to build cubes, schedule them,. The metadata is a central repository, which stores all the objects used by it. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence ServerThis article describes features that are not supported when using Dynamic Sourcing. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. x?This is a guest blog post co-written by Amit Nayak at Microstrategy. 4. Either import tables using Warehouse Catalog in MicroStrategy Developer or create Intelligent Cubes directly using MicroStrategy Web Data Import with the 'Databases' option. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more. View the report in either Grid View or Grid and Graph View. MicroStrategy Platform-intelligence server is an improved testing system for big business questions. Publisher (s): Packt Publishing. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. 5 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version shownDrilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. For example, derived metrics can be used to subtract the data of one. Publish the Intelligent Cube by executing it on either of the nodes. x).