4. Web log. Updating Intelligent Cubes without re-processing: Incremental Refresh. Support. Hands-On Learning in MicroStrategy. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. If user downloads the . 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. Recorded at World 2021. x, create a simple Intelligent Cube with attribute Category and metric Revenue. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. 4. * MicroStrategy does have support for dynamic sourcing with MDX sources. Please contact MicroStrategy Technical Support for an update. The Schedule dialog box opens for your dataset, showing the tables in your dataset. x) or OLAP (first generation of in memory cubes, introduced in 9. 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. Intelligent Cubes can function in a similar fashion to result caches: they. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in. 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. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. Webinars. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. An Intelligent Cube has been created in a project. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. xIn order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. The maximum file size of dashboard (. Notice surprising patterns with visualizations. 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’. In Developer, log in to a project with a user account with administrative privileges. This presentation helps users understand MicroStrategy's in-memory architecture. A cube is imported into MicroStrategy (Development) and reports are built based on this cube. DESCRIPTION: Starting MicroStrategy 10. KB415730. GUID of the Intelligent Cube instance in memory. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. The Full Refresh option is the default. Option 1: Publish the cube in the Intelligence Server node not being in Maintenance Mode. First, you open a blank document and select a report to use as the document's dataset. 2. Disconnect from the project source and restart both Intelligence servers. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube. Source: MicroRooster. Hardware requirements and recommendations. Open the Workstation window. x. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. Right-click the project and select Project Configuration. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. Starting in MicroStrategy 10. Text and CSV files: Varies depending on the Intelligence Server memory. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. IS_CUBE_INST_ID. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. One of the first steps in formatting HyperIntelligence cards is to choose the best-fit template. Select Intelligent Cubes > General > Intelligent Cube File directory. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. exe using the command line. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. 35K. -10. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. A set of data is returned from the. It serves as the starting point for new developers to getThis article describes the best practices for using dynamic sourcing in MicroStrategy. Required Status to Perform Action. When an Intelligent Cube is published, the Intelligent. x. Because every company is a data company—no matter which market it competes in. x installation and deployment. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. Conditional metrics. Check the location of the new cube cache and notice that it is saved in the default location, i. Create Cube B which contains all objects in the report and publish it . Cause This is a known issue with. 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. Release date: July 2016. . . x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. 3. In this case, the dataset is a MicroStrategy Intelligent Cube. Recorded at World 2021. Choose File > New > Intelligent Cube. 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. Intelligent Cube Using Microstrategy 9. Why MicroStrategy Why MicroStrategy; Customer StoriesMaintaining data access security. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". Supported data structure and distribution on Gateway. x. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. 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. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. 86K KB31566: MicroStrategy 9. 8. This command will deactivate the Intelligent Cube cache so reports from this Intelligent Cube will not be able to run while it is being re-published. The. KB47254: How to create a subscription to refresh Intelligent Cubes using MicroStrategy Command Manager 9. 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%. 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. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. 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. 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. 10 MicroStrategy Design Challenges Design Tips & Best Practices for MicroStrategy BI Architects and Developers. 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. Watch on. If you need to delegate administrative responsibilities among several people, create a. In the Refresh Policy column, choose one of the following options:The MicroStrategy Intelligence Server will execute all children datasets on the dashboard by either generating SQL and running this against the data warehouse, or by fetching data from a cache. 4. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. 0. 0, the only way to create an intelligent cube (also. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. Object Migration is the process of migrating or moving objects from one environment to another environment. Create a Report 'R3' with 'Country' attribute. 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. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. Before MicroStrategy 10. Select Build a Query and click Next. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. Rather than returning data from the data warehouse for a. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. 3 - Check the Make Intelligent Cubes. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. 3. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. They were used to improve subsequent query. x to 11. 3. MicroStrategy Best Practices Removing Duplicate Rows Sometimes you need to deal with a data source that has duplicated data. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the. Existing best practice recommendations for needle and syringe programs are out of date. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. als Berichtsobjekte oder Berichtsfilter einschließen. x Intelligent Cubes. 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. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. All the attribute forms are in bold type and will display in Intelligent cube reports. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. 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. x and later, users should make sure to take into account the following. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. x and later; For information on Report Services Document caching, refer to the following MicroStrategy Knowledge Base Document: KB11693: New Feature in MicroStrategy 9 – Report Services Document CachingAnalyzed the requirements and designed Intelligent Cubes, Estimated Cube Size and recommended system memory to support Cubes. In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. Excel file: 800M. 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. Description. 4. For details, please refer to the Technical Note below. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Best practices for mapping MDX. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Run report off cube. The main open-source visualization tool, Kibana, that is used to connect to ElasticSearch is fairly limited in its visualization capabilities. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. Before MicroStrategy 10. Therefore we need 20GB RAM memory to store the cube. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the Object. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. 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. If you use Enterprise Manager, dedicate a machine for the Enterprise. Disable catalog cache via Developer. Expand Intelligent Cubes, and then select General. This documentation is intended to provide some guidelines for BI administrators to maintain Messaging Services. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. MicroStrategy OLAP Services는 분석 엔진으로 조작할 수 있는 보고서의 메모리 내 버전인 Intelligent Cube의 개념을 사용합니다. 1. Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. (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. Tell a story with your data using the dossier chapter/page format. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. KB485674: Create Super Cube from Excel file and update it with a script in. A set of data is returned from the. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. Object Manager cannot undo the copying and replacing of objects. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. KB37579: Dynamic Sourcing is not used when an Intelligent Cube includes a metric defined as Sum (fact A / fact B) in MicroStrategy 9. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. x. MicroStrategy Platform is an enterprise analytics, data management, and BI software platform for managing big data. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. 4. Click the Cube Mapping tab. A set of data is returned from the data warehouse and saved directly to the Intelligence Server memory. To stay current with the best available scientific evidence and ensure that people have. xKB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. For background, we will give a brief introduction about each. Take a Data Import Cube similar to below. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. 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. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Best practices for supporting dynamic sourcing. C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\log. System Sizing Guidelines The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. For more information on security filters, see the System Administration Guide. Always consider to collect database statistics as the query execution plan is generated based on that. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Intelligent Cube Using Microstrategy 9. 4: Persisted. Integer ID of the project where the Intelligent Cube is stored. 1 and 10. Designing and creating documents: An overview. 38K. Number of Intelligent. Microstrategy Dossiers With the release of MicroStrategy 10. Afterwards the cube will start executing. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. x?This is a guest blog post co-written by Amit Nayak at Microstrategy. /ClusterCube. Number of Views 1. 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. 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" The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. the project configuration: ACTION . 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. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Number of Views 8. Go to the "All Objects View" option in the top left corner. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. 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. MicroStrategy is an enterprise business intelligence (BI) application software vendor. This will render the attribute as an image. CAUSE: This is working as designed. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. Author (s): Dmitry Anoshin, Himani Rana, Ning Ma. With OLAP Services features, your report designers can create Intelligent Cube reports. Details on MicroStrategy recommendations can be found in this TN. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. In MicroStrategy, users can trace MicroStrategy Intelligent Cube activity via the Cube Server Trace which can be enabled through MicroStrategy Diagnositcs Configuration as seen below: The following section displays excerpt from the Cube Server trace when different actions are performed on the MicroStrategy Intelligent Cube. 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. Likewise, Analysis Services, Oracle Essbase, and TM1 store data. MicroStrategy Internal Reference number for this technical note is KB483620 and DE128512. File from URL: Unlimited. 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. 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. The Java XML API log will record all the XML communications between Intelligence Server and Web. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The second part discusses the common challenges and better practices on using Snowflake as a warehouse in MicroStrategy, and the third part discusses making it available to business users and self-service users. In the Navigation pane, click , next to Datasets. 3. Generate Oracle AWR report or monitor the database to identify the low performance query. 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. There are multiple components and services replying on MicroStrategy Messaging Services. Creating an Intelligent cube is similar to creating a report. Query Generation. For example, the objects developed in a development environment can be copied to a UAT environment to. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . The Intelligent Cube Options dialog box opens. 929 views · January 17, 2021. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. Complete the "sessionState" field (e. Title: Mastering Business Intelligence with MicroStrategy. Best practice to split large files in Linux Operating Systems. 10. This will create an Intelligent Cube for the data of the Excel file to be accessed. 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. What are the methods to implement Intelligent cube technology in MicroStrategy? Intelligent cubes allow a user to access OLAP service features on reports, a shared set of data can be shared among multiple reports. It performs reporting requests through windows, web, and remote interfaces. Community & Support Search Discussions Open A Case View My CasesThere are some Enhancement Requests opened to improve the behavior, which is to make cubes accessible by remote nodes after restarting a single node. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. You can control users' access to data with security filters. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. MicroStrategy Platform-intelligence server is an improved testing system for big business questions. 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. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. iCubes or Intelligent Cubes are objects that provide pre-cached data which can be queried on the reports. The ID is found with the heading. 7. This feature is best illustrated with an example. 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 . 0. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. The Intelligent Cube Options dialog box opens. The Full Refresh option is the default. The Java XML API log will record all the XML communications between Intelligence Server and Web. Click Select. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. 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. If prompting is not a requirement for this dataset then the best method to improve performance is to directly utilize the Intelligent Cube within the Dossier to reduce both the. 5. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. It serves as the starting point for new developers to get This article describes the best practices for using dynamic sourcing in MicroStrategy. 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. By default, the location configured will be a relative path where ". Available PA data is stored in the cube that has a default limit set to 20GB or RAM. 2. table_name: is the name of a table. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. In the grid display of the report, hold down the CTRL key and select multiple attribute elements within the same attribute. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. 0. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. 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 shown in “About MicroStrategy. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. Start a Pilot Solutions Powerful analytics for any industry. Document Number: 09481030. e. Description Starting in MicroStrategy 2021 Update 1, you can connect to the on-premise database from the MicroStrategy cloud via Gateway Agent. rare practice (British Columbia Ministry of Education, 2011, p. Best practices to design or utilize mobile dashboards in offline mode in MicroStrategy Mobile. x. 10/12 videos | 6H 47M 28S total runtime. When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. Number of Intelligent Cube Publishes: Number of Cube Publishes: Counts the number of times a cube was published. mtc is the name of the saved test file. Number of Views 5. Memory Storage for document or dossier. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. x ODBC calls by default. The Intelligent Cube opens in the Report Editor. Using. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. Edit Intelligent Cubes from the new editor in Workstation at any time. IS_PROJ_ID. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. 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. Recommended for Platform Administrators, System Administrators, and Intelligence Directors, this session provides a foundational understanding of how Platform Analytics works and the reporting capabilities it offers. KB441987: Best Practices. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. The cube population process could be expensive in time and memory if the cube is large. Dedicate a machine for the metadata repository. It lets you various. McLean, Va. You will also work on real-world projects to gain hands-on experience. Best Practices for MicroStrategy Messaging Services. All articles. 29K. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Learn more about it at MicroStrategy. 4. Forecast Sales.