Required Status to Perform Action. Typically, a cube is setup to be published at regular intervals and is saved in the server's main memory, eliminating the time-consuming need to query the Big. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Integer ID of the Intelligent Cube report that was published, if any. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. They should have the “A, L, F” status (Active, Loaded, Filed). A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 1. 4. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. MicroStrategy Analytics cubes are easy to create and deploy. This import bridge imports MicroStrategy logical tables as Dimensions. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. If you are upgrading to MicroStrategy 11. x. 1. This. 4. This article notes how support for transformation metrics in Dynamic Sourcing works. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. Create a report with the year and quarter attributes and the profit metric. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Providing Intelligent Cube data. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. Cube Advisor opens. First, you open a blank document and select a report to use as the document's dataset. Recorded at World 2021. In addition, multiple logical tables can represent the same physical table. x - 9. Providing Intelligent Cube data. 4. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. This issue has been classified as a defect by MicroStrategy. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. The ability to view or edit certain settings is determined by a user's privileges. x. You can control users' access to data with security filters. Browse to the filter you want to convert and click Open. Defining Intelligent Cube refresh settings. Right-click an Intelligent Cube and select Delete. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. STEPS TO REPRODUCE 1. x. 4. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. 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. metrics in the intelligent cube or in the MicroStrategy schema and application objects. Report: The results of a report are used to populate the Intelligent Cube. 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. The default value is 256 megabytes. There's a reason we're at the top of the list. 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. For example, Create a report with an attribute with only one attribute form. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. e. zip and use 7Zip, or similar tools, to unzip it. IS_PROJ_ID. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. 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. My complaint is that a lot of the new stuff just works in the "import data into an intelligent cube" model and not the good old metadata. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Most likely several, different fact tables are uses for each query. The. By default, the report template used is the same as the Intelligent Cube's template. Edit SQL Transactions in Reports. 2. If the Intelligent Cube must be re-processed based on a metric. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Navigate to the Data Refresh category. 3. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. Moreover, you can return a data. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":The peak memory for publishing an Intelligent cube is much larger in Winodws than Linux if the data contains ASCII characters. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. exe file. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Edit Intelligent Cubes from the new editor in Workstation at any time. This is the same requirement to create or run a static report in Workstation. ACTION: A fix for this issue is included in MicroStrategy 10. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. Intelligent Cubes can be based on MicroStrategy data or imported data. Article Reference Number:The memory used by Intelligence Server is limited by the machine's virtual memory. Right-click the dataset, and choose Schedule. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. 5. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. Designing and creating documents: An overview. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Share query results in-memory across multiple dossiers and reports. 1 Hotfix 6, it is not possible to use the Attribute Name macro in the filename of a bursted document when the document uses an Intelligent Cube create via Data Import as a dataset as the Intelligent Cube's attributes are not in the actual project schema. Pros and Cons. All necessary privileges are included in the Administrator role by default. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. mstr suffix. By default, MicroStrategy Command Manager handles cube publication synchronously (i. When an Intelligent Cube is in this status, any reports based on this cube have. Expand Intelligent Cubes, and then select General. Select an Environment from the upper-left drop-down. To do so, you can take advantage of URL API. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Prerequisites to creating Intelligent Cubes. Complex metrics here refer to metrics which are defined using multiple. ACTION This. Number of Views 1. 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. 2. Number of Views 523. Defining the partition for Super Cubes. The updates to the Intelligent Cube must be according to attributes only. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. 15K. x - 10. 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. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. In MicroStrategy 9. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. Open the. Navigate to and run the Intelligent Cube report. When a machine runs out of virtual memory, processes on the machine are no longer able. Refer to the following MicroStrategy Knowledge base document for general remarks on security filter application to Intelligent Cubes where not all of the security attributes are found. com The Maximum RAM usage (Mbytes) memory limit can be defined per project. Download the files from the MicroStrategy download site. Using Database Write-back Functionality to Enable Decision-Making. Choose File > New > Intelligent Cube. 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. 1 or above, to pick up the fix, enable project level setting "Data Engine. You can create and analyze new reports in real time. The data used for this example. Dossiers automatically adjust to look great on any screen. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Required Status to Perform Action. 3. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Under Refresh type, select one of the following options. Cube Advisor opens. This applies for example to Cubes created via MicroStrategy Web client. 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. 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 ). Along with. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Integer ID of the project where the Intelligent Cube is stored. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). 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. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. 8. 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. 0: Balance MicroStrategy Server threadsDescription The . If the indexes are needed again,. Users with different security filters can use the same Intelligent Cube data. Total Cubes This section displays the total count of cubes by status. Otherwise, it will increase the percentage to 200% if the "Maximum % of growth of intelligent cube due to indexes" governing rule. Dynamic Refresh: The Intelligent Cube's filter is. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. 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. Right-click an Intelligent Cube and select Delete. Öffnen Sie das Workstation-Fenster. 1 – Python program gets and processes the data from a Data Source. 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. An Intelligent Cube has been created in a project. 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. MicroStrategy Intelligence Cube. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 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. The data used for this example is. This is a known issue with Data Import functionality in version 10. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. STG_IS_CUBE_REP_STATS. 3. With OLAP Services features, your report designers can create Intelligent Cube reports. 4. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. STEPS TOP REPRODUCE: 1. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. The first column provides the Intelligent Cube name, and the second column provides the full path to the Command Manager script files used to publish the. A report instance is the version of the report results that Intelligence Server holds in memory for cache and working set results. Click the MicroStrategy icon at the upper left of any page and select History List. x. 5 GB. 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. 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. Starting from MicroStrategy 9. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 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. In MicroStrategy 10. 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. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. Run the Report and check the SQL View. 4. Creating an Intelligent cube is similar to creating a report. Modeling is creating information that describes another set of data. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. Enable core dumping. To change these behaviors, see: Publishing Intelligent Cubes Without Loading Them into Intelligence Server Memory Loading Intelligent Cubes when Intelligence Server Starts If. Open the Workstation window. 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. The New Intelligent Cube dialog box opens. 11. The MicroStrategy Tutorial project uses aggregate tables by default. Intelligent Cube storage on disk mirrors report cache storage. Email subscriptions deliver a report or document to one or more email addresses. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Intelligent. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Integer ID of the project where the Intelligent Cube is stored. com. On the toolbar, choose Data > Configure Intelligent Cube. table_name: is the name of a table. Click View Logs, to display the share icon in the upper-left. microstrategy. Solution This issue has been addressed in MicroStrategy 2021. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. certify() to certify / decertify an existing super cube. For example, an Intelligent Cube that contains data for the top 200 stores by. By profiling the Intelligent Cube publication (as per KB30699 - How to measure the Intelligent Cube performance parameters for time and memory in the MicroStrategy Intelligence Server 9. 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 the use of dynamic sourcing between reports and Intelligent Cubes. 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. You can add data for your Intelligent. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. Intelligent Cube memory usage for each node in a clustered environment. If a new column is added to the data import data source and the cube is republished, there is no effect. In MicroStrategy Desktop 9. log without functional impact. Use the drop-down under the filter summary section to switch the server nodes. The New Grid dialog box opens. This is the same requirement to create or run a static report in Workstation. First, you open a blank document and select a report to use as the document's dataset. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 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. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. microstrategy. Create a second report with the year and quarter attributes and the revenue metric. 2. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. It is especially useful when data. x. It remains available, but is not enforced if it is less than the default value of 100000. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. 0. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. In the left panel, click Cubes. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. KB222608: In a clustered environment in MicroStrategy 9. 3. x. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. Export data frames from RStudio to MicroStrategy in-memory cubes. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. In the Drilling area, clear the Use default settings check box. By default, there is a system hierarchy on the cube. Creating an Intelligent cube is similar to creating a report. Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. Published: Apr 6, 2017. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. Run both. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Together with the Reports API, this API is often referred to as the JSON Data API. 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. The Intelligent Cube opens in the Report Editor. The default value is 256 megabytes. 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. 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. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. The Intelligence Server checks to see if there is an existing cache for the same Report. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. To view an Intelligent Cube stored in your History List. The change journal logs now process the type, version, and name for databases configured in an environment. From the Categories list, expand Options, and then select General. Number of Views 8. With in-memory ROLAP, some selected portions of the global virtual cube are populated with actual data as ROLAP Cubes (Intelligent Cube); as you see presented here in the drawing. Only one cube file will be generated for each Intelligent cube on disk. 0. 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. The Incremental Refresh Options dialog box opens. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. Data Population for Intelligent Cubes. The Cubes are modeled with a built-for-purpose modeling thus requiring additional schema work instead of directly leveraging the already-built schema model MicroStrategy Cube Advisor recommends and automatically creates an optimal set of in-memory cubes based on usage patterns for different users accessing the BI system. 3. Specify a name and location for the new security filter and click Save. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. 2. Number of Views 1. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. The Intelligent Cube Options dialog box opens. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. Although the directory filed shows the same location as the source project, cubes are saved to a. The Modeling service must be configured correctly to use this feature. Publish the cube. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. 2. 2) Choose "Database" and select the 3rd option to "Pick tables". This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. The following diagram depicts the role of the intelligent cube. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. x) • MSI_STATS_PROP (properties table that MicroStrategy Intelligence Server uses to initialize statistics logging) • IS_SESSION_STATS (server session statistics)In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Note: The maximum file size that can be imported is 100 MB. To review and create recommended Intelligent Cubes using Cube Advisor. 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. Strong semantic layer to define all the business rules and tightly coupled. Maintaining data access security. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . IS_CUBE_ACT_ID. Intelligent cubes support time zone based reporting. Created Intelligent Cubes to solve the performance issues. Using any other database should not have any implications, given that TPT is only applicable to Teradata. To build an Intelligent Cube. For reports and Intelligent Cubes that do not use MultiSource Option or database gateway support to access multiple data sources, all queries are processed sequentially. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. x and newer. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. The Intelligent Cube Monitor is displayed. 1. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Number of Views 5. 4. Easily add or change pre- and post- SQL statements. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. MicroStrategy Web: Web Server. g. While this can improve performance of these reports.