Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. 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’. Rather than returning data from the data warehouse for a single. The Data Transfer Rate varies from 27 to 28 Mb/s. exe using the command line. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. KB321029: In MicroStrategy 10. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. Expand the Object Templates category, select General, and. KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best Practices . If the Intelligent Cube must be re-processed based on a metric. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. Dedicate a machine for the metadata repository. 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. Select Intelligent Cubes > General > Intelligent Cube File directory. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn Enterprise Manager 10. DESCRIPTION: Starting MicroStrategy 10. KB41988: Is it possible to add prompts to Intelligent Cubes in MicroStrategy Developer 9. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. The Intelligent Cube Options dialog box opens. Place Intelligence Server close to the both the data warehouse and the metadata repository. Getting Started with MicroStrategy; Modern BI; BI project life cycle; Meet MicroStrategy 10; Deploying MicroStrategy 10; BI tips; Summary; 2. Version 10. The tooltip will show the dataset type listed as a Super Cube. Filename. ACTION: 1. This can be done in one node of the cluster because the information is stored in the metadata then used. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Defining the partition for Super Cubes. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. 3. MicroStrategy version 9. x Intelligent Cube status indication and workflow This section describes the ways in which you can design and create a MicroStrategy Report Services document. 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. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. #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. Run report off cube. Build world-class enterprise Business Intelligence solutions with MicroStrategy 10 About This Book Fix the gap between BI tools and. x. A set of data is returned from the. 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. Refer to Product Manual for more detailed information. x?Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Expand Intelligent Cubes, and then select General. KB5370: What does each cache status mean in MicroStrategy Intelligence Server 9. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. 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. 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. application performance and security best practices. When an Intelligent Cube is published, the Intelligent. OLAP cubes best practices. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesIn MicroStrategy 9. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. Our MicroStrategy Admin certification training course lets you master MicroStrategy administration. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. To achieve the best performance possible, it's important to delete all unused objects like datasets, visualizations, tabs (for VIs. CAUSE: It is designed behavior that History List subscription job cannot be assigned to other than the user who is creating the subscription. Object Migration Best Practices. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. It lets you various. In Intelligent Cube editor, the default display attribute forms cannot be modified after choosing "Use the following attribute forms" and adding a new attribute form in "Attribute Display". x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. Intelligent Cube Using Microstrategy 9. Complete the "sessionState" field (e. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Query Optimization 2. 46K. 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. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. Conditional metrics. x and 10. When an Intelligent Cube is in this status, any reports based on this cube have. x MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. 13K. Setting Up an Analytics Semantic Layer and Public Objects. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. KB33244: Are there any limits imposed on Intelligent Cube size in. STEPS TO REPRODUCE 1. Why MicroStrategy Why MicroStrategy; Customer StoriesMaintaining data access security. x Intelligent Cube status indication and workflow. 3 - Check the Make Intelligent. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. 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%. x. MicroStrategy Dossier Design Best Practices for Performance. Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. 3. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. 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 multiple tables. 4 the connection mapping of the u… Number of Views 1. SAP HANA Query Execution. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. Best practices for mapping MDX. e. Prior to MicroStrategy 2020 the Maximum % of growth of an intelligent cube due to indexes governing setting was used to limit the growth of Intellgent cubes over time due to the creation of indexes. x Intelligent Cubes. GUID of the Intelligent Cube instance in memory. To create an Intelligent Cube by creating XQuery. Before MicroStrategy 10. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. KB47254: How to create a subscription to refresh Intelligent Cubes using MicroStrategy Command Manager 9. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. x improves the performance of user reports by executing reports against published Intelligent Cubes, when the SQL generation engine is able to determine that the cube contains all information required for the report. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). The New Intelligent Cube dialog box opens. When you choose to filter data within another dossier, you also have the option to pass the filter conditions in the source dossier to the. KB37579: Dynamic Sourcing is not used when an Intelligent Cube includes a metric defined as Sum (fact A / fact B) in MicroStrategy 9. 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. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Use MicroStrategy Developer, Office, or Web. x. Choose one of the following options: Full Refresh: This is the default. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". 0. 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. MDX, CSI" in Web. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 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 data set and click Prepare Data. 3. 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. x. MicroStrategy Platform is an enterprise analytics, data management, and BI software platform for managing big data. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. 1. Please make sure that this is disabled. 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. 8 to help improve the performance of Quick Search on MicroStrategy Web. Number of Views 2. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. 1K. While some duplicate columns in a MicroStrategy schema are necessary or benign, a user may experience issues that require the assistance of Technical Support in. mstr) file size (MB) setting. Edit Intelligent Cubes from the new editor in Workstation at any time. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. The syntax is: FileLocation is the path to the saved test file. Intelligent Cubes Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. 1. MicroStrategy Platform-intelligence server is an improved testing system for big business questions. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines Place. Discover MicroStrategy 2021 > It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. MicroStrategy Developer, MicroStrategy Web 및 MicroStrategy Office 사용자는 데이터 웨어하우스에 대해 SQL을 다시 실행할 필요 없이 Intelligent Cube 내의. PlatformAnalytics. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. 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. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. 4. Navigate to the folder location of the Intelligent Cube. x-10. 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. 4. Trending Articles. KB415730. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. 15K. 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. The Java XML API log will record all the XML communications between Intelligence Server and Web. Create a Report 'R3' with 'Country' attribute. 0, the only way to create an intelligent cube (also. A set of data is returned from the data warehouse and saved directly to the Intelligence Server memory. IsCubeRepStats, but not in PA warehouse tables LU_CACHE or fact_latest_cube_cache . Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. 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. 3. These. 4. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. This can be encountered when you're dealing with raw data volumes which have not yet been processed through an ETL. The Full Refresh option is the default. with Gateway Agent enabled and disabled. x. x, it is possible for administrators to setup encryption of result caches that are saved to disk. 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. 0 has a dedicated section to memory used for Intelligent Cubes. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. Business Intelligence. 0. Following are the features, which make intelligent cubes useful. 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. The SQL-based DI model is described in Providing Data Internationalization. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 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. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. There is a distributed database for the MicroStrategy metadata and statistics. Details on MicroStrategy recommendations can be found in this TN. Watch on. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Hardware requirements and recommendations. However unlike MicroStrategy it cannot join data between different cubes into the a single visualization. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. An Intelligent Cube has been created in a project. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. 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. -10. 3. x? Number of Views 5. Click Select. 10/12 videos | 6H 47M 28S total runtime. Click All Objects View. Select Build a Query and click Next. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. A report that runs against the Intelligent Cube. Dossier shows different data when In-Memory Intelligent Cube dataset is changed to Live mode. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. 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. Notice surprising patterns with visualizations. Hands-On Learning in MicroStrategy. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. 2. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. 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. 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. Save the Report and close. Excel file: 800M. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. 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. This article also provides a workaround to avoid this behavior. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. 4. The target visualizations only display data that also appears in the source. 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. 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. 13K KB31566: MicroStrategy 9. x, but not to publish it, the minimum privileges that the Administrator would need to. MicroStrategy’s new Gateway connector can enable analysts to derive new. 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. Start a Pilot Solutions Powerful analytics for any industry. Required Status to Perform Action. 2. OLAP vs MTDI and Best Practices. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Number of Intelligent. There are multiple components and services replying on MicroStrategy Messaging Services. VI). Dedicate a machine for the metadata repository. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. It must be ensured that the Windows NT account used to run the MicroStrategy Intelligence Server on every node has access to the shared folders. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1. Text and CSV files: Varies depending on the Intelligence Server memory. Open Command Manager and type the following commands to execute the Intelligent Cubes. x Attributes used in the filter should also be on the Intelligent Cube’s definition. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Object Manager cannot undo the copying and replacing of objects. Derived metrics are easy to create and can be made on-the-fly when you are viewing or creating a report, allowing you to create a metric while focusing on a given report. The Editor and Filter panels are stacked together by default. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. Intelligent Cubes. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. KB485159: Enable support for Security Filter with Top and Bottom Range Attributes in Data Import Intelligent cubes and Fix the security hole in Connect Live Data Import Intelligent cubes MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Number of Views 1. Because every company is a data company—no matter which market it competes in. Such instances can be a problem, as they may impact the accuracy of your data analysis. 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. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. For detailed information refer to the System Administration Help. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in 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. The Intelligent Cube Options dialog box opens. x environment, Cache Hit Count or the Last Hit Time of a. ” in the Help menu of your software. Compound attributes and joint element lists. Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. In the Navigation pane, click , next to Datasets. 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. Overview. The Intelligent Cube Options dialog box opens. 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. 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. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. x: Back up metadata before copying any objects. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Now that that’s settled, let’s jump into some best practices for. In your Datasets panel, hover over the name of your dataset. 2. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 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. Starting in MicroStrategy 10. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. The data in this cube is as given below. Description. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Best practices for supporting dynamic sourcing. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. als Berichtsobjekte oder Berichtsfilter einschließen. 2) Choose "Database" and select the 3rd option to "Pick tables". The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. Create a Report 'R3' with 'Country' attribute. The Intelligent Cube opens in the Report Editor. Click Databases . 2. To do so, you can take advantage of URL API. Privileges are given on a per-user basis, some of which are also per-Application. 2. 98K. 4. KB32618: How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. 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. Therefore we need 20GB RAM memory to store the cube. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. Click 'Add External Data' and then 'File From Disk'. It performs reporting requests through windows, web, and remote interfaces. 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. MDX Cube Reporting Guide Version 10. x - 10. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. IS_CUBE_ACT_ID. With OLAP Services features, your report designers can create Intelligent Cube reports. 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. You can control users' access to data with security filters. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. It remains available, but is not enforced if it is less than the default value of 100000. 5. First, you open a blank document and select a report to use as the document's dataset. Create Cube B which contains all objects in the report and publish it . 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. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. Learn more about it at MicroStrategy. A dataset is a set of data that can be displayed on a document. 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. More about Feature flags can be found in this article. Education. By default, the location configured will be a relative path where ". Configure a Cluster with a Centralized Cache. Right-click the dataset, and choose Schedule. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location.