What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Document Number: 09481030. An Intelligent Cube has been created in a project. Talk to an expert. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. CAUSE: It is designed behavior that History List subscription job cannot be assigned to other than the user who is creating the subscription. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. 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. 10 MicroStrategy Design Challenges Design Tips & Best Practices for MicroStrategy BI Architects and Developers. Number of Views 5. 1 To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. To create an Intelligent Cube by creating XQuery. To enable. Following are the features, which make intelligent cubes useful. This can be done in one node of the cluster because the information is stored in the metadata then used. Intelligent Cubes can function in a similar fashion to result caches: they. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. Using attributes defined in this way can save space as compared to attributes that use character strings for their ID forms. Refer to Product Manual for more detailed information. 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. Right-click the dataset, and choose Schedule. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. 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. Learn more about it at MicroStrategy. These. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Click Create and choose Add External Data. In Developer, log in to a project with a user account with administrative privileges. x In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Create Cube B which contains all objects in the report and publish it . 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. System Sizing Guidelines The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. IS_CUBE_INST_ID. 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. Choose one of the following options: Full Refresh: This is the default. In MicroStrategy Desktop 9. 4. Following are the. The path for cache files must be shared as "ClusterCaches". x releases, and the new Multi-table Data Import (MTDI) cubes. KB31566: MicroStrategy 9. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. The Schedule dialog box opens for your dataset, showing the tables in your dataset. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. 18K. Required Status to Perform Action. Document number: 09481030Our product specialists walk you through best practices for successfully setting up and configuring the out-of-the-box tool Platform Analytics tool. All the attribute forms are in bold type and will display in Intelligent cube reports. . Edit Project-Level Cache and Intelligent Cube Settings. Run report off cube. 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. More about Feature flags can be found in this article. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. ElasticSearch is an open-source search engine based on Lucene that provides multitenant-capable full-text search capabilities. Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. The tooltip will show the dataset type listed as a Super Cube. x. Place Intelligence Server close to the both the data warehouse and the metadata repository. 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. 4. The dataset is a set of data that can be displayed on the document. It depends on the cube. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. Query Optimization 2. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. Place Intelligence Server close to the both the data warehouse and the metadata repository. x-10. An Intelligent Cube is an In-Memory data structure which. Expand the Object Templates category, select General, and. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. A set of data is returned from the. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version shown in “About MicroStrategy. Best practices for mapping MDX. rare practice (British Columbia Ministry of Education, 2011, p. /ClusterCube. It performs reporting requests through windows, web, and remote interfaces. Save the Report and close. Lastly, you will learn to use Hadoop for MicroStrategy reporting. KB5370: What does each cache status mean in MicroStrategy Intelligence Server 9. x. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. STEPS TO REPRODUCE 1. Click Databases . If user downloads the . 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. SAP HANA Query Execution. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. Visit the data visualization and data dashboard galleries for inspiration. Edit Intelligent Cubes from the new editor in Workstation at any time. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Description: Intelligent Cube design and utilization; how to build cubes. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. In Developer, from the File menu select New, and then Intelligent Cube. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . 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. Excel file: 800M. The solution is to republish the cube after upgrading instead of reusing old cube caches. One of the first steps in formatting HyperIntelligence cards is to choose the best-fit template. 3. Create a Report 'R3' with 'Country' attribute. Forecast Sales. You should periodically reevaluate the system and. The Java XML API log will record all the XML communications between Intelligence Server and Web. 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. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. 4. Therefore we need 20GB RAM memory to store the cube. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. 4. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. x and later When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. 0 MicroStrategy releases. Watch on. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. 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. Transformation metrics, under the following conditions: -A metric with the same formula and transformation exists in the Intelligent Cube. For example, derived metrics can be used to subtract the data of one. This will create an Intelligent Cube for the data of the Excel file to be accessed. Integer ID of the Intelligent Cube report that was published, if any. Retail Optimize sales across channels. A list of data sources available in this project appear. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). 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. 4. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. Ensure your data does not exceed the following maximum file sizes: File from disk: 4G. x?This is a guest blog post co-written by Amit Nayak at Microstrategy. 4. x Intelligent Cube status indication and workflow This section describes the ways in which you can design and create a MicroStrategy Report Services document. 4. KB442424: Best Practices for MicroStrategy Messaging Services. 4. It illustrates tips and tricks, such as enabling parallel data fetch, enabling the correct number of partitions, enabling partition on the appropriate attribute, and using cubes vs. x Attributes used in the filter should also be on the Intelligent Cube’s definition. If the Intelligent Cube must be re-processed based on a metric. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn Enterprise Manager 10. Relationships with Multi-Table Data Import. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. MicroStrategy 9. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. Define MicroStrategy Best practices for development, testing. 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. table_name: is the name of a table. KB31566: MicroStrategy 9. Recorded at World 2021. For best practices on compatibility and interoperability, as it relates to upgrading a MicroStrategy system,. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. ACTION: 1. The. Webinars. Creating an Intelligent cube is similar to creating a report. To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor, select Create Freeform SQL report. A document that uses the Intelligent Cube as a dataset. Refer to the following sections for a list of features that can and cannot be used with. x: Ability to encrypt cache files stored to disk. 3. (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. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Required Status to Perform Action. These are meant to restrict the ability to perform certain privileged actions. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy environment. KB36667: Best practices for Dynamic Sourcing in MicroStrategy. 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. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". When an Intelligent Cube is published, the Intelligent. The attached document details the differences between OLAP and MTDI cubes, including the basis for the performance profile of each and the available. 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. MicroStrategy Platform is an enterprise analytics, data management, and BI software platform for managing big data. From the Data menu, select Configure Intelligent Cube. Why MicroStrategy Why MicroStrategy; Customer StoriesMaintaining data access security. IS_CUBE_ACT_ID. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. x) or OLAP (first generation of in memory cubes, introduced in 9. Now that that’s settled, let’s jump into some best practices for. 84K KB441987: Best Practices for increasing performance of publishing large Intelligent CubesAn Intelligent Cube report is created in MicroStrategy 9. All articles. Report runtime performance for reports accessing Intelligent Cubes can be negatively affected as the Intelligent Cube must first be loaded into Intelligence Server. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Save the Report and close. KB439693: Best practices for MicroStrategy 10. The Java XML API log will record all the XML communications between Intelligence Server and Web. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. KB33244: Are there any limits imposed on Intelligent Cube size in. 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. To learn more about Super Cubes and relevant best practices, refer to the following Community Article:In MicroStrategy 11. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. MicroStrategy version 9. Starting in MicroStrategy 10. 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. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 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. MCE features a fully optimized version of the MicroStrategy Intelligence Platform built specifically forThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. If you use Enterprise Manager, dedicate a machine for the Enterprise. For detailed information refer to the System Administration Help. Text and CSV files: Varies depending on the Intelligence Server memory. Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. Likewise, Analysis Services, Oracle Essbase, and TM1 store data. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. The Dynamic Sourcing feature in MicroStrategy OLAP Services 9. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the Object. Conditional metrics. x? Number of Views 5. The ID is found with the heading. with Gateway Agent enabled and disabled. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. MDX, CSI" in Web. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. It serves as the starting point for new developers to get This article describes the best practices for using dynamic sourcing in MicroStrategy. 1. Publish the cube. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. 86K KB31566: MicroStrategy 9. 4. Community & Support Search Discussions Open A Case View My CasesThere are some Enhancement Requests opened to improve the behavior, which is to make cubes accessible by remote nodes after restarting a single node. 15K. Once you select a specific. 84K. Afterwards MTDI cubes should appear as visible from default. 3. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. For example, these reports go from basic execution pointers, quarterly deals by item. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. 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. x: Back up metadata before copying any objects. MicroStrategy is an enterprise business intelligence (BI) application software vendor. Education. The report and Intelligent Cube must be based on the same source MDX cube. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. Click Finish. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. Go to the "All Objects View" option in the top left corner. 1 and 10. 5. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. It happens in MicroStrategy Developer 9. 1319 views | February 11, 2021 45:05. By default, the template is 3x3. It serves as the starting point for new developers to getThis article describes the best practices for using dynamic sourcing in MicroStrategy. Object Manager cannot undo the copying and replacing of objects. Intelligent Cube refresh options supported for dynamic sourcingMicroStrategy 10. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. This includes "Personalized Intelligent Cube" reports (which have the same structure as OLAP Services reports in MicroStrategy 8. x) and view reports based on MicroStrategy 9. Published: Apr 6, 2017. 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. Web XML API log. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. x). 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. Then, select a page from a different dossier that you want to filter as the target. There is a distributed database for the MicroStrategy metadata and statistics. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 0 has a dedicated section to memory used for Intelligent Cubes. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Number of Views 15. ACTION This. Rather than returning data from the data warehouse for a single. 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. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. 0. Best Practice for interview Preparation Techniques in MicroStrategy. xTo Create a Report that Accesses an Intelligent Cube. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. x. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. WORKAROUND . User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. This section describes only the most basic guidelines. x and 10. 8. x a new concept is introduced called Intelligent Cubes. Overview. There are multiple ways to intervene the database to generate a better SQL execution plan. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. A report that runs against the Intelligent Cube. Part 1. In MicroStrategy 10. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. IS_CUBE_INST_ID. First, define one visualization as the source. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. It is capable to deal with the high formatted reports and. 4. rare practice (British Columbia Ministry of Education, 2011, p. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. 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 columns ID1 and ID2 correspond to attributes and M1 corresponds to a metric. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 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. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Create an attribute element prompt for the. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. This command will list the table information only when the intelligent cube is a super cube. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. If you need to delegate administrative responsibilities among several people, create a. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. Before MicroStrategy 10. 4. 0, the only way to create an intelligent cube (also. Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. 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. The user then updates the cube. mstr file then uploads to another Intelligence Server without the user's specific database connection, the user will need to republish the cube first. In the Data Source column, select the checkboxes for the tables to update. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes" The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 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). A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. The metadata is a central repository, which stores all the objects used by it. KB441987: Best Practices for increasing performance of publishing. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. This feature is best illustrated with an example. Build world-class enterprise Business Intelligence solutions with MicroStrategy 10 About This Book Fix the gap between BI tools and. 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. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. Because every company is a data company—no matter which market it competes in. The range of analytical functionality of MicroStrategy is supplemented by the features and processing power provided by SQL Data Warehouse. The default value is 256 megabytes. If you are using or plan to use MicroStrategy Intelligent Cubes, and you plan to implement data internationalization, it is recommended that you use a SQL-based DI model. If the Intelligent Cube must be re-processed based on a metric. Best practices for supporting dynamic sourcing. The Data Transfer Rate varies from 27 to 28 Mb/s. Job ID for the action on the Intelligent Cube. 4. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. The tooltip will show the dataset type listed as a Super Cube. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Place intelligence server close to the both the data warehouse and the metadata repository. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. Defining the partition for Super Cubes. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple 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. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 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. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence ServerThis article describes features that are not supported when using Dynamic Sourcing. 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. 8 to help improve the performance of Quick Search on MicroStrategy Web. KB41988: Is it possible to add prompts to Intelligent Cubes in MicroStrategy Developer 9. E. Set the path for the cube cache file directory to . In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . You can edit project-level cache and Intelligent Cube settings. This is from all MicroStrategy Business Intelligence clients platform. 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. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Updating Intelligent Cubes without re-processing: Incremental Refresh. 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. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the.