Because every company is a data company—no matter which market it competes in. Rather than returning data from the data warehouse for a. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. (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. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. 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. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. application performance and security best practices. pdf", Dynamic Sourcing -> Best practices for supporting dynamic sourcing -> Dynamic Sourcing for Incrementally refreshed Intelligent Cubes In a MicroStrategy Web dashboard, from the File menu, choose Dashboard Properties. Dedicate a machine for the metadata repository. Select data population for Intelligent Cubes. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. It remains available, but is not enforced if it is less than the default value of 100000. 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. The ID is found with the heading. Required Status to Perform Action. 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. 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. Description. 3. 3. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. Report runtime performance for reports accessing Intelligent Cubes can be negatively affected as the Intelligent Cube must first be loaded into Intelligence Server. Start a Pilot Solutions Powerful analytics for any industry. 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. Save the Report and close. x Number of Views 8. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. The attached document details the differences between OLAP and MTDI cubes, including the basis for the performance profile of each and the available. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. IS_PROJ_ID. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. MicroStrategy is an enterprise business intelligence (BI) application software vendor. McLean, Va. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions:. In MicroStrategy Developer or Web, log in to a project that contains Intelligent Cube reports. 10/12 videos | 6H 47M 28S total runtime. x. Filename. MicroStrategy Developer, MicroStrategy Web 및 MicroStrategy Office 사용자는 데이터 웨어하우스에 대해 SQL을 다시 실행할 필요 없이 Intelligent Cube 내의. The Intelligent Cube opens in the Report Editor. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. Right-click the dataset, and choose Schedule. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. 4. The report retrieves data from Cube B now. Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn Enterprise Manager 10. KB31566: MicroStrategy 9. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. OLAP vs MTDI and Best Practices. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. x) and view reports based on MicroStrategy 9. The ODBC connection uses 3. Using. The Intelligence Server will then join all the dataset results into one master table, called the virtual dataset or master dataset, to store in memory. Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. The user then updates the cube. 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. 0. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. Number of Views 611 KB46313: In a clustered environment, Intelligent Cube sizes are varied on different nodes of the cluster in the Intelligen…510 Ratings. We did internal performance test for both report execution and cube publishing. 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. You must belong to the System Administrators group to use this feature. This article outlines some best practices for HyperWeb performance optimization in MicroStrategy 2021. 4. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in. KB5370: What does each cache status mean in MicroStrategy Intelligence Server 9. 0. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 4: Persisted. Our MicroStrategy Admin certification training course lets you master MicroStrategy administration. If you are using or plan to use MicroStrategy Intelligent Cubes, and you plan to implement data internationalization, it is recommended that you use a SQL-based DI model. Hands-On Learning in MicroStrategy. x?Business Analyzer, MicroStrategy World, Application Development and Sophisticated Analysis, Best In Business Intelligence, Centralized Application Management, Information Like Water, Intelligence Through Every Phone, Intelligence To Every Decision Maker, Intelligent E-Business, Personalized. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. g. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. 84K KB441987: Best Practices for increasing performance of publishing large Intelligent CubesAn Intelligent Cube report is created in MicroStrategy 9. Trending Articles. Create a Report 'R3' with 'Country' attribute. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. We’ll summarize how you can use collected data to help you effectively and efficiently manage and maintain peak performance across your MicroStrategy ecosystem, and walk you through tips and. KB442526. x. Rather than returning data from the data warehouse for a single. By moving the cursor over the microchart, a tooltip is displayed that lists the various reports that could connect to the Intelligent Cube using dynamic sourcing. Web XML API log. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. KB14009: In a clustered MicroStrategy Intelligence Server 9. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. This will render the attribute as an image. Best practices for mapping MDX. 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. The status of each Intelligent Cube is listed in the. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. First, define one visualization as the source. Description. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Number of Views 15. Query Optimization 2. This can be achieved via the report level VLDB property > SQL Time. The main open-source visualization tool, Kibana, that is used to connect to ElasticSearch is fairly limited in its visualization capabilities. 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. MicroStrategy version 9. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. #Microstrategy Best Practices; #Microstrategy custom group; #Microstrategy dashboard; #Microstrategy delimited file; #microstrategy filter;Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines Place. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Publish the Intelligent Cube by executing it on either of the nodes. 3 - Check the Make Intelligent Cubes. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. with Gateway Agent enabled and disabled. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. In MicroStrategy Command Manager 10. intelligent cube use cases, and cube optimization techniques with MicroStrategy. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. x and later, users should make sure to take into account the following. All articles. However, if the. Best practices for supporting dynamic sourcing. 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. Navigate to the Data Refresh category. For more information on security filters, see the System Administration Guide. In MicroStrategy Desktop 9. The Schedule dialog box opens for your dataset, showing the tables in your dataset. 1 To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Accessibility and 508 Compliance. These Intelligent Cubes are created in a folder along with shortcuts to all the reports that can connect to the Intelligent Cube using dynamic sourcing. A set of data is returned from the. Starting in MicroStrategy 10. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. 3. Visit the data visualization and data dashboard galleries for inspiration. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. The report and Intelligent Cube must be based on the same source MDX cube. 1319 views | February 11, 2021 45:05. Set the path for the cube cache file directory to . x?This is a guest blog post co-written by Amit Nayak at Microstrategy. To enable. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. Open the Workstation window. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. , 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. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. Solution Gallery. 0, the only way to create an intelligent cube (also. x. 2. Web XML API log. Recorded at World 2021. x - 10. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. MicroStrategy - Architecture. 1. The Intelligent Cube Options dialog box opens. Use MicroStrategy Developer, Office, or Web. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. Setting Up an Analytics Semantic Layer and Public Objects. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. Microstrategy Dossiers With the release of MicroStrategy 10. The steps to create an intelligent cube are as follows: Navigate to the folder where you want to create an intelligent cube; the best practice is to create it under Public Objects | Reports . By the end of the book, you will become proficient in evaluating any BI software in order to choose the best one that meets all business requirements. 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. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. When you choose to filter data within another dossier, you also have the option to pass the filter conditions in the source dossier to the. Dozens of Intelligent Cube caches are invisible in one Intelligence Server among the six nodes cluster in MicroStrategy 2021 GA, is due to Intelligence Server starting up before mount of the cube shared location. 4. Best practice to split large files in Linux Operating Systems. 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. Connectivity. The SQL-based DI model is described in Providing Data Internationalization. Create Cube B which contains all objects in the report and publish it . x and 10. Defining Intelligent Cube refresh settings. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. MicroStrategy has a metadata-driven architecture. Interact with the data in real time (with targeting, filtering, and more). There is a distributed database for the MicroStrategy metadata and statistics. The Editor and Filter panels are stacked together by default. Such instances can be a problem, as they may impact the accuracy of your data analysis. 2. Click Select. xKB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. ACTION:15. Required Status to Perform Action. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Following are the. Query Generation. Object Migration Best Practices. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. This data is stored in cubes or other SAP objects. 1K. CAUSE: It is designed behavior that History List subscription job cannot be assigned to other than the user who is creating the subscription. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. x releases. In direct connection deployments, client products (such as MicroStrategy Developer) should also. x. Best Practices Privileges and Security Access in Workstation MicroStrategy has a rich security model that consists of three major components - privileges, security filters, and permissions. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. IsCubeRepStats, but not in PA warehouse tables LU_CACHE or fact_latest_cube_cache . x. 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. 1 or later, with the following characteristics:. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 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. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. VI). 4. CREATOR: User who created the Intelligent Cube cache, returned as a string. 4. 4 the connection mapping of the u… Number of Views 1. Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. Create Intelligent Cube Sharing Intelligent Cubes Enable ROLAP Enable Dynamic Source How to do Incremental Refresh. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Download the attached PDF for an in-depth understanding of Object Migration best practices. You should periodically reevaluate the system and update it based on actual system performance and use. KB439693: Best practices for MicroStrategy 10. Define MicroStrategy Best practices for development, testing. It is capable to deal with the high formatted reports and. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. For detailed information refer to the System Administration Help. Then, select a page from a different dossier that you want to filter as the target. If user downloads the . KB442525. When an Intelligent Cube is in this status, any reports based on this cube have. x-10. Complete the "sessionState" field (e. 4. Select Build a Query and click Next. From the Data menu, select Configure Intelligent Cube. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 3 - Check the Make Intelligent. 7. 2. The tooltip will show the dataset type listed as a Super Cube. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. view reports. Expand Intelligent Cubes, and then select General. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. 5K KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best PracticesMicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. SHOPMAN, powered by MicroStrategy, delivers sensor data, inventory management, and financial data to enable users make data-driven. Click OK. Edit Intelligent Cubes from the new editor in Workstation at any time. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. For an Intelligent Cube to satisfy the data requirements of a report, the Intelligent Cube and report must have matching settings for VLDB properties that can affect the data that. Create Cube A and a report based on it. C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\log. 0, the only way to create an intelligent cube (also. 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. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. KB442424: Best Practices for MicroStrategy Messaging Services. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. 86K KB31566: MicroStrategy 9. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The New Intelligent Cube dialog box opens. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. If the Intelligent Cube must be re-processed based on a metric. Created cube with lastname and any other attribute. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. After the Intelligent Cube has finished republishing, the Cube. Integer ID of the Intelligent Cube report that was published, if any. Currently, project duplication does not involve Intelligent Cube File Directory. 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. This feature is best illustrated with an example. If you need to delegate administrative responsibilities among several people, create a. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. rare practice (British Columbia Ministry of Education, 2011, p. 13K KB31566: MicroStrategy 9. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. blogspot. Now that that’s settled, let’s jump into some best practices for. If the Intelligent Cube is at Month level, the user's report should also be at Month level. /ClusterCube. Dossier shows different data when In-Memory Intelligent Cube dataset is changed to Live mode. E. Intelligent Cube Using Microstrategy 9. 11 it is possible to have split child hierarchy attributes join through a shared fact table rather than through a parent with Data Import Cubes. 4, the below command does not work for Data Import cube: LIST [ALL] PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "<intelligent_cube_name>" [FOLDER "<folder_name>"]) FOR PROJECT "<project_name>" However using cube GUID will return correct result: CAUSE: This is a. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. If the Intelligent Cube must be re-processed based on a metric. Intelligent Cube Using Microstrategy 9. In section General at the bottom of displayed window there is a check box with option "Hidden". x - 10. Afterwards MTDI cubes should appear as visible from default. x product documentation "InMemoryAnalytics. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. This article describes best practices to be taken when using a Teradata database in MicroStrategy. How to Import Data from a SAP HANA Database Into MicroStrategy Web. 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. SAP BW obtains data from R/3, CRM, SEM, or another SAP data source system. Number of Views 1. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. If you use Enterprise Manager, dedicate a machine for the Enterprise. 4. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. 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 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. KB41988: Is it possible to add prompts to Intelligent Cubes in MicroStrategy Developer 9. Discover MicroStrategy 2021 > Events;It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. 35K. Best Practice for interview Preparation Techniques in MicroStrategy. File from URL: Unlimited. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. All necessary privileges are included in the Administrator role by default. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. Expand Intelligent Cubes, and then select General. Choose File > New > Intelligent Cube. x Intelligent Cube status indication and workflow. 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. To create an Intelligent Cube by creating XQuery. The Full Refresh option is the default. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. To build an Intelligent Cube. 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. To stay current with the best available scientific evidence and ensure that people have. Starting in MicroStrategy 10. Intelligent Cubes Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. Select Intelligent Cubes > General > Intelligent Cube File directory. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. GUID of the Intelligent Cube instance in memory. Open Command Manager and type the following commands to execute the Intelligent Cubes. Object Migration is the process of migrating or moving objects from one environment to another environment. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. ACTION This. Create a report based on above Cube and add the prompt in view filter. Click the Cube Mapping tab. Click All Objects View. 27K. Learn more about it at MicroStrategy. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. 1180 views | February 10, 2021 29:25. Dedicate a machine for the metadata repository. To learn more about Super Cubes and relevant best practices, refer to the following Community Article: Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. There are multiple ways to intervene the database to generate a better SQL execution plan. 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. x, it is possible for administrators to setup encryption of result caches that are saved to disk. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. The report and Intelligent Cube must be based on the same source MDX cube. 3. Notice surprising patterns with visualizations. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 4. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. x. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. xMicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9.