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. Intelligent Cube storage on disk mirrors report cache storage. When using MicroStrategy and Teradata, the best approach is to. The Intelligent Cube Monitor is displayed. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 3. x. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. MicroStrategy logical tables do not necessarily represent physical tables. From the Data menu, select Add Dataset. 4 the connection mapping of the u… Number of Views 1. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. CAUSE. Create a report with this Intelligent Cube and execute the report --> one row with 4 element returned. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. for a script with several commands, one of which being a cube publication command, the. You can create and analyze new reports in real time. Most likely several, different fact tables are uses for each query. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. 4. The user then updates the cube. 0: Balance MicroStrategy Server threadsDescription The . Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. With OLAP Services features, your report designers can create Intelligent Cube reports. Index: P = Processing A = Active L = Loaded D = Dirty F = Filed M = Monitoring Information Dirty When a user executes an Intelligent Cube, the initial status is P. 2. Once an Intelligent cube is created and then published so its data is available, multiple reports can be created to connect to the Intelligent cube. com. Choose your preferred method to share the logs. Create Schema Objects. 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. Advanced category, select the Balance MicroStrategy Server threads check box. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. In the Drilling area, clear the Use default settings check box. If you are upgrading to MicroStrategy 11. This is the most popular MicroStrategy Interview Question asked in an interview. Starting with MicroStrategy Intelligence Server 9. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. 4. Create Cube1 with the Region attribute and the metric created in step 1. Republish the same cube, and a new cube instance is generated. Cube Limitations. Execute the report and view the SQL:MicroStrategy enables users to pull subsets of data, which could be up to hundreds of Gigabytes, from a Big Data source into an in-memory cube, and build reports/dossiers from the cube. For more information on security filters, see the System Administration Guide. ACTION: A fix for this issue is included in MicroStrategy 10. x, but not to publish it, the minimum privileges that the Administrator would need to. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. MicroStrategy 9 ships a new utility called MicroStrategy Cube Advisor to assist in the use of the Dynamic Sourcing functionality in MicroStrategy OLAP Services 9. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. 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. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. x - 10. This table is not populated unless at least one of the Advanced Statistics Collection Options are selected in the Statistics category of the Project Configuration Editor. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. 0. For the steps to define an incremental refresh report, refer to:Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. 0 votes. In reality, an . • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Constant Value: 220 (0x000000dc)When enabling the option to "Fetch data slices in parallel from the warehouse" from the Intelligent Cube Options > Data Partitions menu, TPT is required to be disabled on the database side when using Teradata as a Warehouse. The Intelligent Cube must not be re-processed based on a metric. Slice and dice features are awesome. 0. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. Creating an Intelligent cube is similar to creating a report. In Enterprise Manager 10. Intelligent Cubes are a more aggressive form of caching and allow multiple reports to be stored in the Cube (which is effectively a large cached report stored in memory on the. This will work as a regular SQL comparison In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:Total number of columns: The number of columns of data that the Intelligent Cube contains. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. This is controlled by the Python script. Because the filters are applied to the master data in the Intelligent. Users cannot trigger or schedule cube republishing. Open the. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. III. This is due to the fact that adding prompts to Intelligent Cubes is not supported. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Intelligent Cubes can be based on MicroStrategy data or imported data. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. x - 10. The default value is 256 megabytes. In addition, multiple logical tables can represent the same physical table. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. Strong semantic layer to define all the business rules and tightly coupled. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. The MicroStrategy Intelligence Server 9. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Steps To Reproduce 1. The display of data is handled by the reports that access the Intelligent Cube. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Share query results in-memory across multiple dossiers and reports. To review and create recommended Intelligent Cubes using Cube Advisor. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version. For more details on enabling the setting. Expand the Object Templates category, select General, and from the. Strong semantic layer to define all the business rules and tightly coupled. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. This applies for example to Cubes created via MicroStrategy Web client. You can use. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 2. STEPS TO REPRODUCE 1. 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. Intelligent. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 2. x and newer. Like cache update subscriptions, Intelligent Cube. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. However, if the. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. When you run reports in MicroStrategy, they collect the warehouse data. 2. Pros and Cons. These reports allow data to be returned from the data. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. The article discusses a known situation in MicroStrategy 10. The objects in the source cubes will control how the security filter will be applied. Publish the cube. mstr suffix. MicroStrategy 10 will report the following. Extensively used “Apply Simple” function for creating attributes. 5 GB . If the data in the Intelligent Cube is outdated. If you are upgrading to MicroStrategy 11. 4. Scalable Analytics. Click the MicroStrategy icon at the upper left of any page and select History List. The Modeling service must be configured correctly to use this feature. 1. 3 - Check the Make Intelligent Cubes. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Vn (with metric Mn from source cube Cn). com The Maximum RAM usage (Mbytes) memory limit can be defined per project. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. All necessary privileges are included in the Administrator role by default. When a remote accesses this cube, the cube is loaded into memory of the. x If the Administrator wants to create a user that is. Updating Intelligent Cubes without re-processing: Incremental Refresh. While this can improve performance of these reports. Rather than returning data from the data warehouse for a. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Pros and Cons. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Intelligent cubes support time zone based reporting. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. 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"You can edit project-level cache and Intelligent Cube settings. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Pros and Cons. Click View Logs, to display the share icon in the upper-left. The Intelligent Cube must be published before this report can execute. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. x - 10. The maximum number of Intelligent Cubes that can be loaded onto Intelligence Server for this project. Measures the time duration an operation executed against cubes. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. For more information on security filters, see the System Administration Guide. Most likely several, different fact tables are uses for each query. ADD: the refresh policy is Add new data. Create an attribute element prompt for the. Along with. Maintaining data access security. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. In the Navigation pane, click Monitors. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. A report instance is the version of the report results that Intelligence Server holds in memory for cache and working set results. For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. Job ID for the action on the Intelligent Cube. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. The ability to view or edit certain settings is determined by a user's privileges. For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. This difference is roughly equal to the size of the Intelligent Cube footprint in-memory versus the size of the compressed disk cache. Download the files from the MicroStrategy download site. Using any other database should not have any implications, given that TPT is only applicable to Teradata. Refer to the following MicroStrategy Knowledge Base. 9 and 10. microstrategy. Traditional Report Caching in MicroStrategy is done on a matching basis. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. HyperAndroid Go to the Account tab. x. 4. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. Cube Limitations. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to its memory limit. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. For more details on enabling the setting, refer to Change Data Engine VersionCertify a super cube¶ Use SuperCube. Creating an Intelligent cube is similar to creating a report. 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. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. " 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'. You can control users' access to data with security filters. MicroStrategy logical tables do not necessarily represent physical tables. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. x and 10. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". You may share the Intelligent Cube as a single copy in memory. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Mclean, Virginia. The MicroStrategy Tutorial project uses aggregate tables by default. In other words, the new column will NOT get mapped automatically in the existing Intelligent Cube. Choose one of the following options: Full Refresh: This is the default. Published: 4월 6, 2017. 17. Refer to the following sections for a list of features that can and cannot be used with. The New Grid dialog box opens. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. The Intelligent Cube is opened in the Report Editor. KB442630: CSI optimization for improving the in-memory query execution for many. Total Cubes This section displays the total count of cubes by status. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. 2) Choose "Database" and select the 3rd option to "Pick tables". Choose your environment, project, and Intelligent Cube as your dataset type. The requests are granted or denied according to user-configured limits on the amount of. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. MicroStrategy version 9. After execution. x or 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. x. 4. OR, to convert an existing filter into a security filter, click Import. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. 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. Instantly analyze any amount of data without in-memory limitations of MicroStrategy intelligent data models. To build an Intelligent Cube. However, OLAP Services provides MOLAP and ROLAP analysis on the same report, which offers many distinct benefits, summarized below: Using OLAP Services, you can get fast response times for reports that use data directly from in-memory Intelligent Cubes, instead of from the data warehouse. Complex metrics here refer to metrics which are defined using multiple. BACKGROUND: When configuring a MicroStrategy Intelligence Server cluster, special configuration must be made in order for the Intelligence Server cluster nodes to be able to access report and document caches, intelligent cubes, history list messages, and session recovery files that were created on other nodes of the cluster. Drag and drop the objects into the report grid from the Report Objects pane. This can be seen even when the actual total memory consumption of the Intelligent Cubes loaded for this Project is below the configured Governing Setting. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. This template includes the following tasks: Creates a new metadata. Create a Report 'R3' with 'Country' attribute. The first is to enable report caching at the project level. Before MicroStrategy 10. Since an Intelligent Cube is structured similarly to a Relational Database the method of retrieving data from the Intelligent Cube, Cube Subsetting Instructions, is very similar to. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. For example, the above Data Import fails even though the actual utilization of the Intelligent Cubes are 5388mb out of 12000mb, and the Data Import Manager from MicroStrategy. Choose Databases. 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. Under Refresh type, select one of the following options. By default, MicroStrategy Command Manager handles cube publication synchronously (i. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. 3. Using mstrio as a MicroStrategy Intelligence Server administration tool¶For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. In the left panel, click Cubes. This issue has been classified as a defect by MicroStrategy. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. MicroStrategy tests on at least one of the CPU chipsets within a set of binary-compatible CPU architectures for purposes of certifying and supporting operating systems with MicroStrategy products. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. x. In a MicroStrategy Intelligence Server clustered environment, it is observed that dynamic sourcing does work against Intelligent Cubes available on a remote node, after updating the schema. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. 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" You can edit project-level cache and Intelligent Cube settings. Publish the Intelligent Cube by executing it on either of the nodes. conf and add the following lines. In the Data Source column, select the checkboxes for the tables to update. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. Cube Cache Hit: Download MSTR File with Cube Cache Hit: Indicates a user exported a dossier object based on cube as an MSTR file and hits the cube cache. Note: The maximum file size that can be imported is 100 MB. It is recommended that the Excel file size should not exceed 1GB. With OLAP Services features, your report designers can create Intelligent Cube reports. Select an Environment from the upper-left drop-down. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Intelligent Cube memory usage for each node in a clustered environment. 9 and 10. This can improve the performance of. 4. Edit SQL Transactions in Reports. Data in Intelligent cubes can be either marked as available for time zone conversion when running objects against it or set within a specific time zone. 1 – Python program gets and processes the data from a Data Source. This property can only be enabled through Workstation. An example of this behavior for a relatively small cube is shown in the screen shots below:The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Use Case 4. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. ACTION This. Dossier Datasets do not include all the Security Filter attributes, and one of the Datasets are Connect Live Data Import Dataset, it may have security concerns. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. To view an Intelligent Cube stored in your History List. 1, Intelligent Cubes have a new feature to update information without republishing it. Slice and dice features are awesome. Data Population for Intelligent Cubes. IS_CUBE_ACT_ID. Upgrade to those versions to take advantage of the fix. This article notes how support for transformation metrics in Dynamic Sourcing works. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. MicroStrategy HyperIntelligence is the next step in the future of data analytics. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . . The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. IS_CUBE_INST_ID. There's a reason we're at the top of the list. 0. x This is a new feature introduced in MicroStrategy version 9. 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. 2. If the indexes are needed again,. In MicroStrategy Developer, right-click on the project and select Project. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The New Grid dialog box opens. Select the schedule you had created in step 2 and in the Intelligent Cubes field, select the desired Intelligent Cube as seen below: 6. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. Based on the previous explanation, you should only create derived attributes or metrics whenever. Intelligent Cube file directory: Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. MicroStrategy Web: Web Server. IS_CUBE_ACT_ID. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. A set of data is returned from the. 4. x. You must belong to the System Administrators group to use this feature. The Full Refresh option is the default. 0. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. mstr file is actually a . Software Categories. 10 or earlier, outer join to Lookup table in a dashboard/dossier report based on Intelligent Cube with joint element list filter will not work, and incorrect CSI will be generated when both attributes used in the filter are present in visualization. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. g. How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. xThis article describes the Intelligent Cube Population options available in MicroStrategyPlease also see this article for more details: Data Engine changes in MicroStrategy 2021 release Acronym used: "CSI", which stands for "Cube Subsetting Instruction". To do this, edit the report in developer and go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose the new target cube: Create Cube A and a report based on it. Click View Logs, to display the share icon in the upper-left. An Intelligent Cube is a. IS_PROJ_ID. 5. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. Integer ID of the Intelligent Cube report that was published, if any. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. If no data is returned for a report that is connected to an Intelligent Cube, this can be caused by the following scenarios: The view filter for the report is too restrictive (see View Filters ). This is a known issue with Data Import functionality in version 10. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. 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%. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. metrics in the intelligent cube or in the MicroStrategy schema and application objects. This dataset needs to contain all data in the required granularity. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Intelligent Cubes. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. The. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube.