x product documentation "InMemoryAnalytics. Reports using Dynamic Sourcing do not hit the Intelligent Cube when using the NullToZero function in MicroStrategy 9. Select a database configured for SAP HANA. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. The. Start a Pilot Solutions Powerful analytics for any industry. 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. Configure a Cluster with a Centralized Cache. Supported data structure and distribution on Gateway. Therefore we need 20GB RAM memory to store the cube. 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. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Our MicroStrategy certification training helps you to learn the basics of MicroStrategy, so you can easily apply what you’ve learned in the real world. Trending Articles. When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. For an Intelligent Cube to satisfy the data requirements of a report, the Intelligent Cube and report must have matching settings for VLDB properties that can affect the data that. 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. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. 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. 3 - Check the Make Intelligent. 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. application performance and security best practices. 2. MicroStrategy Real-Time Analytics. Talk to an expert. The Java XML API log will record all the XML communications between Intelligence Server and Web. This article describes best practices to be taken when using a Teradata database in MicroStrategy. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. x and 10. KB441236. x ODBC calls by default. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. Description. The Intelligence Server will then join all the dataset results into one master table, called the virtual dataset or master dataset, to store in memory. ACTION:15. It will track and log all communications at the “XML API. KB442526. It serves as the starting point for new developers to get This article describes the best practices for using dynamic sourcing in MicroStrategy. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. . Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Required Status to Perform Action. 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. Run the Report and check the SQL View. More about Feature flags can be found in this article. KB415730. The cube population process could be expensive in time and memory if the cube is large. Create a Report 'R3' with 'Country' attribute. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. KB441987: Best Practices. e. From the Data menu, select Configure Intelligent Cube. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. x-10. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. You can edit project-level cache and Intelligent Cube settings. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Defining the partition for Super Cubes. Click OK. Expand Intelligent Cubes, and then select General. Connectivity. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence Server This article describes features that are not supported when using Dynamic Sourcing. 1 Department Architecture Department Architecture consists of a single server node for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. A set of data is returned from the data warehouse and saved directly to the Intelligence Server memory. By default, the location configured will be a relative path where ". (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. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Webinars. 98K. IS_CUBE_ACT_ID. 0 has a dedicated section to memory used for Intelligent Cubes. Module 14: Practices on MicroStrategy Best . 4. The Intelligent Cube Options dialog box opens. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. Interact with the data in real time (with targeting, filtering, and more). 0. Use MicroStrategy Developer, Office, or Web. Best practices for mapping MDX. 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. 438832. 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. Published: Apr 6, 2017. Getting Started with MicroStrategy. For example, these reports go from basic execution pointers, quarterly deals by item. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. 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. To achieve the best performance possible, it's important to delete all unused objects like datasets, visualizations, tabs (for VIs. Memory Storage for document or dossier. pdf", Dynamic Sourcing -> Best practices for supporting dynamic sourcing -> Dynamic Sourcing for Incrementally refreshed Intelligent Cubes In a MicroStrategy Web dashboard, from the File menu, choose Dashboard Properties. Conditional metrics. Rather than returning data from the warehouse, if it is placed in the memory (pre-cached), so the. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. 4. This presentation helps users understand MicroStrategy's in-memory architecture. MicroStrategy 9. 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'. 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. 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 >. x?Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 1180 views | February 10, 2021 29:25. 0. Published: How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. Number of Views 15. 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%. Always consider to collect database statistics as the query execution plan is generated based on that. 0, the only way to create an intelligent cube (also. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Dynamic Sourcing. 1. Analyze the low performance query using DBA knowledge, add. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines Place. Learn more about it at MicroStrategy. Now that that’s settled, let’s jump into some best practices for. 4. Rather than returning data from the data warehouse for a single. 4. The cube population process is the one that retrieves the information from the Warehouse and transfer it to the MicroStrategy Intelligence Server memory in a format which can readily be consumed by different reports requests. 4. MicroStrategy Intelligence Server will submit all queries as prepared statements if the following registry key is created on the Intelligence Server machine:To Create an Intelligent Cube Using Freeform SQL or Query Builder. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. 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. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. 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. 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. x releases. 4. 1. Edit Project-Level Cache and Intelligent Cube Settings. The default value is 256 megabytes. rare practice (British Columbia Ministry of Education, 2011, p. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the. Recorded at World 2021. Navigate to the Data Refresh category. MicroStrategy’s new Gateway connector can enable analysts to derive new. Office Intelligence, MicroStrategy Office. 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. On the toolbar, choose Data > Configure Intelligent Cube. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. This can improve the performance of. The first step in analyzing. To enable. Before MicroStrategy 10. Number of Views 15. Number of Views 15. The Full Refresh option is the default. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. 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. Overview. For details, please refer to the Technical Note below. 2) Choose "Database" and select the 3rd option to "Pick tables". Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. DESCRIPTION: Starting MicroStrategy 10. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. There are multiple components and services replying on MicroStrategy Messaging Services. 13K KB31566: MicroStrategy 9. The New Intelligent Cube dialog box opens. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. x. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Place intelligence server close to the both the data warehouse and the metadata repository. Create Cube B which contains all objects in the report and publish it . The GUID is part of the project's Intelligent Cube directory path. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. Web log. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. 4. x. Save the Report and close. 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. Navigate to and run the Intelligent Cube report. Query Generation 3. Replace the first “/” by “” in the Intelligent Cube file directory option. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. x installation and deployment. Updating Intelligent Cubes without re-processing: Incremental Refresh. This data is stored in cubes or other SAP objects. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. MicroStrategy Internal Reference number for this technical note is KB483620 and DE128512. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. This technical note outlines how to set. 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. Before MicroStrategy 10. 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. Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. In MicroStrategy 10. Description. Defining Intelligent Cube refresh settings. x and newer? Number of Views 4. File from URL: Unlimited. 2. Prompts in a report. 2: Active. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. 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. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. If you use Enterprise Manager, dedicate a machine for the Enterprise. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. The Intelligent Cube opens in the Report Editor. Rather than returning data from the data warehouse for a single. The tooltip will show the dataset type listed as a Super Cube. Build world-class enterprise Business Intelligence solutions with MicroStrategy 10 About This Book Fix the gap between BI tools and. 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. 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). How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. KB485674: Create Super Cube from Excel file and update it with a script in. Select Build a Query and click Next. KB441987: Best Practices for increasing. 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. In MicroStrategy Intelligence Server 9. 3. Dedicate a machine for the metadata repository. The range of analytical functionality of MicroStrategy is supplemented by the features and processing power provided by SQL Data Warehouse. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Take a Data Import Cube similar to below. Hardware requirements and recommendations. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn Enterprise Manager 10. The Full Refresh option is the default. 10. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Lastly, you will learn to use Hadoop for MicroStrategy reporting. Person-centred care is a collaborative approach in which health care professionals’ partner with patients to deliver personalized care with a focus on physical. g. 46K. Setting Up an Analytics Semantic Layer and Public Objects. Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. 0. als Berichtsobjekte oder Berichtsfilter einschließen. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 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. Run the Report and check the SQL View. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor, select Create Freeform SQL report. 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. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. Recommended for Platform Administrators, System Administrators, and Intelligence Directors, this session provides a foundational understanding of how Platform Analytics works and the reporting capabilities it offers. 86K KB31566: MicroStrategy 9. 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. A report that runs against the Intelligent Cube. Best practices for supporting dynamic sourcing. mtc is the name of the saved test file. The data in this cube is as given below. KB47254: How to create a subscription to refresh Intelligent Cubes using MicroStrategy Command Manager 9. Prerequisites to creating Intelligent Cubes. Privileges are given on a per-user basis, some of which are also per-Application. Right-click the project and select Project Configuration. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). x-10. In Developer, log in to a project with a user account with administrative privileges. 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. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube. In direct connection deployments, client products (such as MicroStrategy Developer) should also. Number of Views 5. 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. When we mention performance, we mean the speed by which HyperWeb scans keywords to present data via HyperIntelligence cards. 4. After completing your certification, you’ll receive a digital badge that highlights your accomplishment, which you can post on social media. Version 9. 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. From the Edit menu, select Training Metric Wizard. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. 1. 0 MicroStrategy releases. Click Create and choose Add External Data. ” in the Help menu of your software. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. When an Intelligent Cube is published, the Intelligent. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. 4. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Rather than returning data from the data warehouse for a. Microstrategy Dossiers With the release of MicroStrategy 10. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. x. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. Query Generation. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. In MicroStrategy Command Manager 10. 3. Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. Result caches: Report and document results that have already been calculated and processed, that are stored on the Intelligence Server machine so they can be retrieved more quickly than re-executing the request against the data warehouse. 3. Start Learning with us ACTE MicroStrategy. Description. Using attributes defined in this way can save space as compared to attributes that use character strings for their ID forms. The ID is found with the heading. rare practice (British Columbia Ministry of Education, 2011, p. To learn more about Super Cubes and relevant best practices, refer to the following Community Article: Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Change Journaling is enabled by default since MicroStrategy version 10. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. It is capable to deal with the high formatted reports and. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. The MicroStrategy Cloud Environment (MCE or MicroStrategy Cloud) is a platform-as-a-service (PaaS) offering that MicroStrategy manages on its customers’ behalf as a unique Amazon Web Services (AWS) or Microsoft Azure implementation. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 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. Created cube with lastname and any other attribute. This can be encountered when you're dealing with raw data volumes which have not yet been processed through an ETL. Compound attributes and joint element lists. To learn more about Super Cubes and relevant best practices, refer to the following Community Article:In MicroStrategy 11. Number of Views 18. The tooltip will show the dataset type listed as a Super Cube. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. 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. Watch on. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. 1. x: Back up metadata before copying any objects. The path for cube files must be shared as "ClusterCube". x? Intelligence Portal, Query Tone, Rapid Application Development, MicroStrategy Intelligent Cubes, The Foundation For Intelligent E-Business, The Integrated Business Intelligence Platform Built For The Enterprise, The Platform For Intelligent E-Business, The Scalable Busin ess Intelligence Platform To enable or disable dynamic sourcing for an Intelligent Cube. KB33244: Are there any limits imposed on Intelligent Cube size in. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. Required Status to Perform Action. Intelligent cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. Education. 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. -10. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. In the Data Source column, select the checkboxes for the tables to update. Number of Views 8. Place Intelligence Server close to the both the data warehouse and the metadata repository. 4: Persisted. E. Locate the published cube, right-click on it and choose Quick View. 3. Why MicroStrategy Why MicroStrategy; Customer StoriesMaintaining data access security. x - 10. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. By default, the template is 3x3. 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. One of the first steps in formatting HyperIntelligence cards is to choose the best-fit template. MicroStrategy Internal Reference Number for this technical note. CAUSE: It is designed behavior that History List subscription job cannot be assigned to other than the user who is creating the subscription. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. First, you open a blank document and select a report to use as the document's dataset. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Web log. 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. 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. Likewise, Analysis Services, Oracle Essbase, and TM1 store data. 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.