Define MicroStrategy Best practices for development, testing. STEPS TO REPRODUCE: 1) Add external dataset. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. 4. This command will deactivate the Intelligent Cube cache so reports from this Intelligent Cube will not be able to run while it is being re-published. 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. com Format: A MicroStrategy Online Training Video blog. x. All necessary privileges are included in the Administrator role by default. KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. The ID is found with the heading. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. x product documentation "InMemoryAnalytics. 11 it is possible to have split child hierarchy attributes join through a shared fact table rather than through a parent with Data Import Cubes. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. 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. 4. 4. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Option 1: Publish the cube in the Intelligence Server node not being in Maintenance Mode. 4. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Hardware requirements and recommendations. Document Number: 09481030. 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. Drag and drop the objects into the report grid from the Report Objects pane. KB441987: Best Practices for increasing. Excel file: 800M. Run the Report and check the SQL View. g. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. If prompting is not a requirement for this dataset then the best method to improve performance is to directly utilize the Intelligent Cube within the Dossier to reduce both the. Connectivity. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 0 MicroStrategy releases. Number of Views 8. Right-click the dataset, and choose Schedule. If you use Enterprise Manager, dedicate a machine for the Enterprise Manager. x Intelligent Cube status indication and workflow. Published: Apr 6, 2017. 4. 11, a new feature is available for performance optimization when dealing with derived attributes. 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. 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. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. Use MicroStrategy Developer, Office, or Web. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. xKB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Web log. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. Before MicroStrategy 10. The Full Refresh option is the default. These. x and later, users should make sure to take into account the following guidelinesIt describes how MicroStrategy Intelligence Server converts MDX cube source data and objects into MicroStrategy using MultiDimensional Expressions (MDX). Recorded at World 2021. It depends on the cube. 1 and 10. Connectivity. Click 'Add External Data' and then 'File From Disk'. Published: Dec 31, 2018; Last updated: Jul 25, 2023 Intelligence Everywhere. 2) Choose "Database" and select the 3rd option to "Pick tables". If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Best practices for mapping MDX. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. x and later, users should make sure to take into account the following. 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. Dedicate a machine for the metadata repository. 46K. 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. Currently, project duplication does not involve Intelligent Cube File Directory. 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. x, with the Intelligence Server running on Linux, the image in the. Best practices for supporting dynamic sourcing. 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. x, but not to publish it, the minimum privileges that the Administrator would need to. 0. III. (Titled: "Cube broken aplysimple") No data is returned the following SQL view is seen: Report: cube broken applysimple Job: 198 Total Number of Passes: 1 Number of Intelligent Cube SQL Passes: 1 Number of Analytical Passes: 0 Intelligent Cubes Accessed:The Incremental Refresh feature allows users to update cube information without having to republish the entire cube. x. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. Since the Quick Search indices make use of the Change Journaling data, they can easily update their existing indexes based on this data instead of having to do a full table scan. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. Defining Intelligent Cube refresh settings. Therefore we need 20GB RAM memory to store the cube. It serves as the starting point for new developers to get This article describes the best practices for using dynamic sourcing in MicroStrategy. 3. 1180 views | February 10, 2021 29:25. 4. View the report in either Grid View or Grid and Graph View. 5. KB47254: How to create a subscription to refresh Intelligent Cubes using MicroStrategy Command Manager 9. For details, please refer to the Technical Note below. Conditional metrics. First, define one visualization as the source. Relationships with Multi-Table Data Import. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. x - 10. 4. 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). Try to include only information that would be imperative at-a-glance. 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. 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. 3 - Check the Make Intelligent. 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. Because a single Intelligent Cube cannot connect to more than one data warehouse, using a. 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. 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. Because every company is a data company—no matter which market it competes in. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Number of Views 2. mstr file then uploads to another Intelligence Server without the user's specific database connection, the user will need to republish the cube first. By default, the template is 3x3. g. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. Then, select a page from a different dossier that you want to filter as the target. blogspot. 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. Number of Views 8. x environment, Cache Hit Count or the Last Hit Time of a. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. x. To build an Intelligent Cube. In section General at the bottom of displayed window there is a check box with option "Hidden". 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. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Also Oracle does not support data blending capabilities from the enterprise platform 3 Built-in Best Practices for Visual Exploration: A number of visual exploration best practices embedded within the product. Best Practice for interview Preparation Techniques in MicroStrategy. 3. The user then updates the cube. 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. Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. It will track and log all. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. The tooltip will show the dataset type listed as a Super Cube. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Create Cube A and a report based on it. SAP BW obtains data from R/3, CRM, SEM, or another SAP data source system. This article narrates large cubes appear in ‘LP’ status and some other cubes not shown up in cube monitor in MicroStrategy 2021 is due to loading cube info thread being blocked by loading the large cube instance. Do you have reports that currently access. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. x Intelligent Cube status indication and workflow This section describes the ways in which you can design and create a MicroStrategy Report Services document. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. To enable. 4. 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. KB442424: Best Practices for MicroStrategy Messaging Services. KB32618: How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. Integer ID of the Intelligent Cube report that was published, if any. Best practices for mapping MDX. Edit Intelligent Cubes from the new editor in Workstation at any time. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. table_name: is the name of a table. 4. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Change Journaling is enabled by default since MicroStrategy version 10. foundation to build a career in Analytics, proving expertise in using MicroStrategy. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. 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. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Web XML API log. Object Manager cannot undo the copying and replacing of objects. Open the Workstation window. 0. Rather than returning data from the data warehouse for a single. Using Object Manager, the above cube based reports are migrated into Production. Rather than returning data from the data warehouse for a. 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. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. OLAP vs MTDI and Best Practices. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. In the Data Source column, select the checkboxes for the tables to update. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. Consider a data import dataset which has been imported into MicroStrategy. x - 10. The range of analytical functionality of MicroStrategy is supplemented by the features and processing power provided by SQL Data Warehouse. Filename. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. 2: Active. After completing your certification, you’ll receive a digital badge that highlights your accomplishment, which you can post on social media. 1 To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. 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. x installation and deployment. From the Edit menu, select Training Metric Wizard. 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. Dedicate a machine for the metadata repository. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Intelligent Cube Using Microstrategy 9. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. Text and CSV files: Varies depending on the Intelligence Server memory. Dynamic Sourcing. 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. x-10. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;This section describes the ways in which you can design and create a MicroStrategy Report Services document. IS_CUBE_ACT_ID. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. Navigate to the Data Refresh category. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. Create a Report 'R3' with 'Country' attribute. Go to the Intelligent Cube monitor to identify the cube instance ID: under the three-tier project source, Administration > System Monitors > Caches > Intelligent Cubes. 4 the connection mapping of the u… Number of Views 1. In Developer, from the File menu select New, and then Intelligent Cube. 7. In Developer, log in to a project with a user account with administrative privileges. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. To Create an Intelligent Cube Using Freeform SQL or Query Builder. If the Intelligent Cube is at Month level, the user's report should also be at Month level. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. 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 Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube. Dedicate a machine for the metadata repository. Run report off cube. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. You should periodically reevaluate the system and update it based on actual system performance and use. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. It lets you various. Before MicroStrategy 2020, when using multiple tables cube and use fact extension, the Engine can generate multiple temp tables while there is a join path to use only one temporary table, which leads to an extra temporary table and impacts the. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 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. Analyze the low performance query using DBA knowledge, add. The default value is 256 megabytes. x and 10. 35K. Version 9. 4. IS_PROJ_ID. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. You can add data for your Intelligent. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. MicroStrategy has a metadata-driven architecture. The report and Intelligent Cube must be based on the same source MDX cube. x and newer? Number of Views 4. Setting Up an Analytics Semantic Layer and Public Objects. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. IS_CUBE_INST_ID. Version 10. Integer ID of the Intelligent Cube report that was published, if any. The following diagram depicts the role of the intelligent cube. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Run the Report and check the SQL View. x. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. Best Practice for interview Preparation Techniques in MicroStrategy. All the attribute forms are in bold type and will display in Intelligent cube reports. Select Intelligent Cubes > General > Intelligent Cube File directory. 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 >. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the Object. 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. Download the attached PDF for an in-depth understanding of Object Migration best practices. If the Intelligent Cube must be re-processed based on a metric. 0. Getting Started with MicroStrategy; Modern BI; BI project life cycle; Meet MicroStrategy 10; Deploying MicroStrategy 10; BI tips; Summary; 2. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. Starting in MicroStrategy 10. , 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. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. Publish the cube. Existing best practice recommendations for needle and syringe programs are out of date. MicroStrategy Developer, MicroStrategy Web 및 MicroStrategy Office 사용자는 데이터 웨어하우스에 대해 SQL을 다시 실행할 필요 없이 Intelligent Cube 내의. 2. Navigate to and run the Intelligent Cube report. KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best Practices . Getting Started with MicroStrategy. KB31566: MicroStrategy 9. This can be encountered when you're dealing with raw data volumes which have not yet been processed through an ETL. The syntax is: FileLocation is the path to the saved test file. Save the Report and close. IS_PROJ_ID. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. You can control users' access to data with security filters. 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". Integer ID of the project where the Intelligent Cube is stored. Query Optimization 2. 1. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. 13K KB31566: MicroStrategy 9. Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. x?The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. x a new concept is introduced called Intelligent Cubes. In MicroStrategy 10. For example, derived metrics can be used to subtract the data of one. 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. Number of Views 15. 1. x. Details on MicroStrategy recommendations can be found in this TN. MDX, CSI" in Web. If you need to delegate administrative responsibilities among several people, create a. 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. mstr) file size (MB) setting. Intelligent Cubes erstellen. 4. 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. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). KB41988: Is it possible to add prompts to Intelligent Cubes in MicroStrategy Developer 9. By moving the cursor over the microchart, a tooltip is displayed that lists the various reports that could connect to the Intelligent Cube using dynamic sourcing. 8 to help improve the performance of Quick Search on MicroStrategy Web. x Number of Views 8. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesThis technical note documents an issue that occurs when an Intelligent Cube created through Live Connection to an OLAP data source is migrated to another environment, with MicroStrategy Object Manager 10. Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. The solution is to republish the cube after upgrading instead of reusing old cube caches. 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. 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. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. 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. 10 MicroStrategy Design Challenges Design Tips & Best Practices for MicroStrategy BI Architects and Developers. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. 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. Integer ID of the project where the Intelligent Cube is stored. MDX Cube Reporting Guide Version 10. ISBN: 9781785884405. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. 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. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. Create a Report 'R3' with 'Country' attribute. KB485674: Create Super Cube from Excel file and update it with a script in. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. Select a database configured for SAP HANA. Number of Views 1. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. Published: May 29, 2019; Last updated: Oct 29, 2019; Related versions: To build an Intelligent Cube. 29K. 3. The columns ID1 and ID2 correspond to attributes and M1 corresponds to a metric. Ensure your data does not exceed the following maximum file sizes: File from disk: 4G. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics.