OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. Now that that’s settled, let’s jump into some best practices for. The syntax is: FileLocation is the path to the saved test file. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. Choose one of the following options: Full Refresh: This is the default. This. KB31566: MicroStrategy 9. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). 2. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. 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. Select data population for Intelligent Cubes. 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 must belong to the System Administrators group to use this feature. The main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loaded. STEPS TO REPRODUCE: 1) Add external dataset. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. 929 views · January 17, 2021. Existing best practice recommendations for needle and syringe programs are out of date. If the Intelligent Cube must be re-processed based on a metric. Required Status to Perform Action. Publish the Intelligent Cube by executing it on either of the nodes. The maximum file size of dashboard (. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. If user downloads the . Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Details on MicroStrategy recommendations can be found in this TN. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. com Format: A MicroStrategy Online Training Video blog. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. Filename. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. 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. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. x. 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). KB442525. Place Intelligence Server close to the both the data warehouse and the metadata repository. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. Number of Views 18. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. Navigate to the Data Refresh category. Part 1. 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. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. Dynamic Sourcing. By default, the template is 3x3. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. C:Program Files (x86)MicroStrategyWeb ASPxWEB-INFlog. Privileges are given on a per-user basis, some of which are also per-Application. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. 31K. Object Manager cannot undo the copying and replacing of objects. It performs reporting requests through windows, web, and remote interfaces. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. 2: Active. The data in this cube is as given below. Number of Views 2. 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. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. For example, if the Intelligent Cube contains data for 2008, 2009 and 2010, and the filter or report returns data for 2009, all the data for 2009 is deleted from the cube. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. 4. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. Starting in MicroStrategy 10. MicroStrategy OLAP Services는 분석 엔진으로 조작할 수 있는 보고서의 메모리 내 버전인 Intelligent Cube의 개념을 사용합니다. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. Object Migration is the process of migrating or moving objects from one environment to another environment. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. 4. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. 8. Getting Started with MicroStrategy; Modern BI; BI project life cycle; Meet MicroStrategy 10; Deploying MicroStrategy 10; BI tips; Summary; 2. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 3. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. x. 0, the only way to create an intelligent cube (also. Accessibility and 508 Compliance. 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. Job ID for the action on the Intelligent Cube. MicroStrategy 9. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. Expand Intelligent Cubes, and then select General. This article covers best practices for the following topics: 1. 1. Disconnect from the project source and restart both Intelligence servers. Best practices: Importing data into MicroStrategy Web; Importing data from a data source; Previewing, modifying, and refining your data before importing; Editing, republishing, and linking imported data; Configuring OAuth parameters for data sources integrated using Data Import; Scheduling updates for an Intelligent Cube created using imported dataThis issue has been classified as a none defect by MicroStrategy. Choose File > New > Intelligent Cube. This command will list the table information only when the intelligent cube is a super cube. 98K. Education. Integer ID of the project where the Intelligent Cube is stored. KB441236. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. KB441987: Best Practices. g. 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. 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. als Berichtsobjekte oder Berichtsfilter einschließen. Right-click the project and select Project Configuration. 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. This can be done in one node of the cluster because the information is stored in the metadata then used. x product documentation "InMemoryAnalytics. Click OK. Recorded at World 2021. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 3. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. Our MicroStrategy Admin certification training course lets you master MicroStrategy administration. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Published August 27, 2020 By akrish1982. SAP BW obtains data from R/3, CRM, SEM, or another SAP data source system. It will track and log all communications at the “XML API. KB441987: Best Practices for increasing performance of publishing. 438832. However, if the. IS_CUBE_INST_ID. IsCubeRepStats, but not in PA warehouse tables LU_CACHE or fact_latest_cube_cache . In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. KB33244: Are there any limits imposed on Intelligent Cube size in. Recorded at World 2021. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. MicroStrategy Best Practices Removing Duplicate Rows Sometimes you need to deal with a data source that has duplicated data. Please make sure that this is disabled. x? Number of Views 5. Designing and creating documents: An overview. The. The Intelligent Cube Options dialog box opens. There are multiple ways to intervene the database to generate a better SQL execution plan. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. 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. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. Open Command Manager and type the following commands to execute the Intelligent Cubes. In the Data Source column, select the checkboxes for the tables to update. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. 1K. x Intelligent Cube status indication and workflow. 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. For example, these reports go from basic execution pointers, quarterly deals by item. 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. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). with Gateway Agent enabled and disabled. KB14009: In a clustered MicroStrategy Intelligence Server 9. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. 4. The default value is 256 megabytes. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. 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. This will render the attribute as an image. 1 or later, with the following characteristics:. 1To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Published: Apr 6, 2017. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. Creating an Intelligent cube is similar to creating a report. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. 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 shownWhen configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. x releases. 3. Best practices for mapping MDX. 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. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. A document is used to format data from multiple datasets in a single display of presentation quality. 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. 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. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Our vision is to enable Intelligence Everywhere. Business Intelligence. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. In MicroStrategy Command Manager 10. Published: 4월 6, 2017. xMicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. Connectivity. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Module 14: Practices on MicroStrategy Best . MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. 0. Create Cube A and a report based on it. If you use Enterprise Manager, dedicate a machine for the Enterprise Manager. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. This paper provides an overview of MicroStrategy and Azure SQL Data Warehouse (SQL DW) architectures and best practices for integrating the two technologies to deliver business intelligence at scale. 11, a new feature is available for performance optimization when dealing with derived attributes. Use MicroStrategy Developer, Office, or Web. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. McLean, Va. Excel file: 800M. 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. x?Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. File from URL: Unlimited. VI). Interact with the data in real time (with targeting, filtering, and more). Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. 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. In section General at the bottom of displayed window there is a check box with option "Hidden". x. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. You should periodically reevaluate the system and update it based on actual system performance and use. It lets you various. 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. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. x. x Intelligent Cube status indication and workflow. This section describes only the most basic guidelines. 4 the connection mapping of the u… Number of Views 1. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. In Developer, from the File menu select New, and then Intelligent Cube. Published: Jan 29, 2019;. , 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. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. 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. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. Number of Views 3. 1. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. If you use Enterprise Manager (EM), dedicate a machine for. 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. IS_CUBE_ACT_ID. 4. x: Back up metadata before copying any objects. mstr) file size (MB) setting. 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. 0 has a dedicated section to memory used for Intelligent Cubes. Save the Report and close. CAUSE: It is designed behavior that History List subscription job cannot be assigned to other than the user who is creating the subscription. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 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. To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor, select Create Freeform SQL report. Number of Views 15. 13K KB31566: MicroStrategy 9. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformHello<br><br>Please allow me to elucidate how my data analyst skills can significantly contribute to your organisation's business growth. 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. To learn more about Super Cubes and relevant best practices, refer to the following Community Article:In MicroStrategy 11. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. Published: How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. MicroStrategy Platform is an enterprise analytics, data management, and BI software platform for managing big data. 10/12 videos | 6H 47M 28S total runtime. It improves 30% performance in. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. x. Transformation metrics, under the following conditions: -A metric with the same formula and transformation exists in the Intelligent Cube. This article describes the Intelligent Cube Population options available in MicroStrategy. A dataset is a set of data that can be displayed on a document. x: Back up metadata before copying any objects. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Tell a story with your data using the dossier chapter/page format. 8: Monitoring information dirty. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The Training Metric Wizard opens. 1 To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. 0. The attached document details the differences between OLAP and MTDI cubes, including the basis for the performance profile of each and the available. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. Will it affect the performance of already existing MicroStrategy components?How to Start and Stop Intelligence Server Services in Microstrategy By Mohan Vamsi PentakotaOverview of MicroStrategy Training in Chennai. Go to the "All Objects View" option in the top left corner. Relationships with Multi-Table Data Import. Defining the partition for Super Cubes. Query Generation. 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. Version 9. When a derived attribute is built off of data from a single live data import cube, then the calculation of the derived attribute will be pushed down into the query against the data source rather than being done in the. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. KB31566: MicroStrategy 9. 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. Share query results in-memory across multiple dossiers and. Intelligence Server Statistics . Option 1: Publish the cube in the Intelligence Server node not being in Maintenance Mode. table_name: is the name of a table. To access the setting, in MicroStrategy Developer right-click on the project and select Project Configuration…Then, In the Project Configuration dialog box, choose Project Definition >. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. 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. . For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. VI). In the grid display of the report, hold down the CTRL key and select multiple attribute elements within the same 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 the use of dynamic sourcing between reports and Intelligent Cubes. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. KB442526. 3. KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best Practices . Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. E. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load processes. Best practices for supporting dynamic sourcing. 4. The following diagram depicts the role of the intelligent cube. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. Publish the cube. Always consider to collect database statistics as the query execution plan is generated based on that. Description. Generate Oracle AWR report or monitor the database to identify the low performance query. Integer ID of the project where the Intelligent Cube is stored. Number of Views 3. 10. For detailed information refer to the System Administration Help. After the Intelligent Cube has finished republishing, the Cube. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. MCE features a fully optimized version of the MicroStrategy Intelligence Platform built specifically forThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. The ability to view or edit certain settings is determined by a user's privileges. Hands-On Learning in MicroStrategy. Report runtime performance for reports accessing Intelligent Cubes can be negatively affected as the Intelligent Cube must first be loaded into Intelligence Server. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. The Intelligent Cube opens in the Report Editor. In MicroStrategy Developer or Web, log in to a project that contains Intelligent Cube reports. 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. Publish the Intelligent Cube by executing it on either of the nodes. To identify if your cube is MTDI or OLAP it’s really simple, if the cube was created through the Data Import Web Interface (“Add External Data” section on MicroStrategy Web. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Either import tables using Warehouse Catalog in MicroStrategy Developer or create Intelligent Cubes directly using MicroStrategy Web Data Import with the 'Databases' option. This article describes the Intelligent Cube Population options available in MicroStrategy. mtc is the name of the saved test file. In Developer, log in to a project with a user account with administrative privileges. 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. Web log. Create Intelligent Cube Reports; Explain different types of derived elements; Creating derived elements; Group and Filter derived elements;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. PlatformAnalytics. mstr file then uploads to another Intelligence Server without the user's specific database connection, the user will need to republish the cube first. ” in the Help menu of your software. x. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. MicroStrategy Platform-intelligence server is an improved testing system for big business questions. For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. x?This is a guest blog post co-written by Amit Nayak at Microstrategy. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. Refer to the following sections for a list of features that can and cannot be used with. 46K. The Data Transfer Rate varies from 27 to 28 Mb/s. #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. x - 10. The path for cache files must be shared as "ClusterCaches". , 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. Intelligent Cube Using Microstrategy 9. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. x releases, and the new Multi-table Data Import (MTDI) cubes. x. The Intelligent Cube opens in the Report Editor. Select a database configured for SAP HANA.