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. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. Description. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. 0. Solution Gallery. 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. Dedicate a machine for the metadata repository. IS_CUBE_ACT_ID. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Intelligent cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. Best practices for supporting dynamic sourcing. 4. Description. Updating Intelligent Cubes without re-processing: Incremental Refresh. We're using a RaspberryPi with Sense HAT to capture telemetry, which is directly pushed in a MicroStrategy In-Memory 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. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. MicroStrategy provides modern analytics on an open,. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. 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. There are multiple ways to intervene the database to generate a better SQL execution plan. Create a report based on above Cube and add the prompt in view filter. This can be done in one node of the cluster because the information is stored in the metadata then used. Author (s): Dmitry Anoshin, Himani Rana, Ning Ma. Designing and creating documents: An overview. 1. 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. Description. Number of Views 18. GUID of the Intelligent Cube instance in memory. Set the path for the cube cache file directory to . 31K. g. x Intelligent Cube status indication and workflow. Intelligent Cubes erstellen. Number of Views 15. Relationships with Multi-Table Data Import. 27K. Best Practice for interview Preparation Techniques in MicroStrategy. In direct connection deployments, client products (such as MicroStrategy Developer) should also. 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. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. 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. x. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. x. 3. 0 MicroStrategy releases. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. Hands-On Learning in MicroStrategy. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. Click the Cube Mapping tab. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. , 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. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. Webinars. x. exe using the command line. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). Number of Views 15. MicroStrategy - Architecture. 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. xTo Create a Report that Accesses an Intelligent Cube. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. x - 10. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn Enterprise Manager 10. x, with the Intelligence Server running on Linux, the image in the. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. This will create an Intelligent Cube for the data of the Excel file to be accessed. Best practices to design or utilize mobile dashboards in offline mode in MicroStrategy Mobile. Document number: 09481030Our product specialists walk you through best practices for successfully setting up and configuring the out-of-the-box tool Platform Analytics tool. 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. • 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. x-10. Lastly, you will learn to use Hadoop for MicroStrategy reporting. Excel file: 800M. 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. 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. 4. Discover MicroStrategy 2021 > It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. The dataset is a set of data that can be displayed on the document. Choose one of the following options: Full Refresh: This is the default. Intelligent Cubes. Intelligent Cube refresh options supported for dynamic sourcing MicroStrategy 10. x. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Retail Optimize sales across channels. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. x and newer? Number of Views 4. Existing best practice recommendations for needle and syringe programs are out of date. Recorded at World 2021. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. Choose File > New > Intelligent Cube. 2: Active. 1 or later, with the following characteristics:. A document that uses the Intelligent Cube as a dataset. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 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. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. Right mouse click on the cube, and “Search for dependent subscriptions” as shown below; it shows two subscriptions have been created based on the Intelligent Cube. The 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. When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. Go to the Intelligent Cube monitor to identify the cube instance ID: under the three-tier project source, Administration > System Monitors > Caches > Intelligent Cubes. 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. 46K. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. You will also work on real-world projects to gain hands-on experience. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. Transformation metrics, under the following conditions: -A metric with the same formula and transformation exists in the Intelligent Cube. x. ACTION:15. Version 9. This article describes the Intelligent Cube Population options available in MicroStrategy. x? Number of Views 5. First, you open a blank document and select a report to use as the document's dataset. MicroStrategy version 9. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The MicroStrategy certification training course is designed for those who wish to enhance their knowledge and skills in the field of Business Intelligence and Data Warehousing. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Publisher (s): Packt Publishing. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. Discover MicroStrategy 2021 > Events;It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. x - 10. Now that that’s settled, let’s jump into some best practices for. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 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. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). On the toolbar, choose Data > Configure Intelligent Cube. With OLAP Services features, your report designers can create Intelligent Cube reports. The report and Intelligent Cube must be based on the same source MDX cube. 0. 4. Either import tables using Warehouse Catalog in MicroStrategy Developer or create Intelligent Cubes directly using MicroStrategy Web Data Import with the 'Databases' option. SAP BW obtains data from R/3, CRM, SEM, or another SAP data source system. The maximum file size of dashboard (. However unlike MicroStrategy it cannot join data between different cubes into the a single visualization. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Business Intelligence. Locate the published cube, right-click on it and choose Quick View. Create an Intelligent Cube with attributes Year, Month and Region; 4. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. This article describes the Intelligent Cube Population options available in MicroStrategy. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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. Trending Articles. view reports. In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. Interact with the data in real time (with targeting, filtering, and more). If you use Enterprise Manager, dedicate a machine for the Enterprise. Defining Intelligent Cube refresh settings. The main open-source visualization tool, Kibana, that is used to connect to ElasticSearch is fairly limited in its visualization capabilities. Dossier shows different data when In-Memory Intelligent Cube dataset is changed to Live mode. x. Choose File > New > Intelligent Cube. 38K. 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. Run the Report and check the SQL View. Before MicroStrategy 10. To enable or disable dynamic sourcing for an Intelligent Cube. Recorded at World 2021. 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. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. Supported data structure and distribution on Gateway. 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. 2. Setting Up an Analytics Semantic Layer and Public Objects. x - 10. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. There are multiple components and services replying on MicroStrategy Messaging Services. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Type of action against the Intelligent Cube: •What is MicroStrategy? MicroStrategy is a Business Intelligence software that can be connected with any data including data files, big data, social media data, and so on to create and modify highly detailed reports and dashboards. x. Rather than returning data from the data warehouse for a single. Talk to an expert. Replace the first “/” by “” in the Intelligent Cube file directory option. To learn more about Super Cubes and relevant best practices, refer to the following Community Article:In MicroStrategy 11. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. Integer ID of the Intelligent Cube report that was published, if any. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. The Full Refresh option is the default. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Easily add or change pre- and post- SQL statements. Performance also refers to the speed of loading or rendering data via in-built features like scanning,. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. 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. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. If you use Enterprise Manager, dedicate a machine for the Enterprise Manager. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions:. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. 1. . How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. Click OK. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 4. Intelligence Server Statistics . To enable. Edit Intelligent Cubes from the new editor in Workstation at any time. Take a Data Import Cube similar to below. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Prompts in a report. Published: May 29, 2019; Last updated: Oct 29, 2019; Related versions: To build an Intelligent Cube. 4. x In 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. 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Expand Intelligent Cubes, and then select General. x - 10. IS_CUBE_INST_ID. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Create Intelligent Cube Reports; Explain different types of derived elements; Creating derived elements; Group and Filter derived elements;This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. For background, we will give a brief introduction about each. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. Create Cube B which contains all objects in the report and publish it . Compound attributes and joint element lists. You should periodically reevaluate the system and update it based on actual system performance and use. 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. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. 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. 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. You must belong to the System Administrators group to use this feature. Privileges are given on a per-user basis, some of which are also per-Application. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. Refer to the following sections for a list of features that can and cannot be used with. Select Build a Query and click Next. In the Data Source column, select the checkboxes for the tables to update. Then, select a page from a different dossier that you want to filter as the target. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. 29K. 1To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Number of Views 15. 88K. 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. Required Status to Perform Action. Number of Views 3. Following are the. 4 the connection mapping of the u… Number of Views 1. VI). 4. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. 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. 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. This is from all MicroStrategy Business Intelligence clients platform. An Intelligent Cube is a set of data that can be shared as a single in-memory copy, among many different reports created by multiple users. 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. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. How to configure, monitor, and manage Intelligent Cubes. 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. SAP HANA Query Execution. You can edit project-level cache and Intelligent Cube settings. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. The path for cache files must be shared as "ClusterCaches". KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. Best practices for mapping MDX. The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. 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. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. This article describes best practices to be taken when using a Teradata database in MicroStrategy. Part 1. Configure a Cluster with a Centralized Cache. 8. Go to the "All Objects View" option in the top left corner. McLean, Va. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 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. 3. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. Object Migration Best Practices. MicroStrategy 9. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. xMicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. Save the Report and close. Always consider to collect database statistics as the query execution plan is generated based on that. KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. ACTION: 1. OLAP vs MTDI and Best Practices. Refer to Product Manual for more detailed information. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. In the Navigation pane, click , next to Datasets. Publish the Intelligent Cube by executing it on either of the nodes. Rather than returning data from the data warehouse for a single. x and 10. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 0, the only way to create an intelligent cube (also. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. To do so, you can take advantage of URL API. 3 - Check the Make Intelligent Cubes. C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\log. Visit the data visualization and data dashboard galleries for inspiration. An Intelligent Cube is a set of data that can be shared as a single in-memory copy, among many different reports created by multiple users. The range of analytical functionality of MicroStrategy is supplemented by the features and processing power provided by SQL Data Warehouse. Definition. 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. MicroStrategy provides modern analytics on an open, comprehensive enterprise platform used by many of the […] This article describes best practices to be taken when using a Teradata database in MicroStrategy. Within the set. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. Number of Views 5. Resources Company Bitcoin Lightning Home Published: August 11, 2022 • 619 Views Advanced Properties for Intelligent Cubes MicroStrategy Workstation. Because a single Intelligent Cube cannot connect to more than one data warehouse, using a. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. Details on MicroStrategy recommendations can be found in this TN. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. Shipped vs Native. 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. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. In Developer, log in to a project with a user account with administrative privileges. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. ACTION This. 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. 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. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. A cube is imported into MicroStrategy (Development) and reports are built based on this cube. 4. The SQL-based DI model is described in Providing Data Internationalization. Source: MicroRooster. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. 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. 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. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. 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. Required Status to Perform Action. 4. In MicroStrategy Desktop 9. Defining the partition for Super Cubes. Place Intelligence Server close to the both the data warehouse and the metadata repository. View the report in either Grid View or Grid and Graph View. Memory Storage for document or dossier. Title: Mastering Business Intelligence with MicroStrategy. In MicroStrategy Desktop 9. In MicroStrategy 10.