The following table summarizes the test results of some test scenarios against Oracle 19c. 2. Modify or remove the view filter to attempt to return data for the report. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Edit Intelligent Cubes from the new editor in Workstation at any time. Alternatively, you can enable caching on selected reports. 0. In the Data Source column, select the checkboxes for the tables to update. 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. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. x. You can edit project-level cache and Intelligent Cube settings. Choose your environment, project, and Intelligent Cube as your dataset type. By default, MicroStrategy Command Manager handles cube publication synchronously (i. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. To add an existing report or Intelligent Cube as a dataset. Choose one of the following options: Full Refresh: This is the default. Seamlessly create Intelligence Cube Reports. 2. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. After the previous changes, you'll have to save the cube and republish it. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. The Modeling service must be configured correctly to use this feature. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. * MicroStrategy does have support for dynamic sourcing with MDX sources. The user then updates the cube. Starting from MicroStrategy 9. Why MicroStrategy Why MicroStrategy; Customer StoriesHyperIntelligence is a new addition to MicroStrategy Workstation that allows analysts to inject analytics and intelligence directly into every user's experience. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Web Open the Settings page (right click the extension and select Options). The Intelligent Cube opens in the Report Editor. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. In MicroStrategy Integrity Manager 10. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. The Intelligent Cube must not be re-processed based on a metric. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. When you first click on "Add External Data" and a list of connectivity options come up, there is now a small icon at the top left, that allows you to filter the connections for those that support Live Connect. 4. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Add Year Id and Quarter. For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. In MicroStrategy 9. Recorded at World 2021. Import and save data from a file in a folder location. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. The Intelligent Cube Options dialog box opens. 2. 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. Designing and creating documents: An overview. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. 3. The MicroStrategy Intelligence Server 9. 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. To build an Intelligent Cube. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. You must belong to the System Administrators group to use this feature. When a machine runs out of virtual memory, processes on the machine are no longer able. Although the directory filed shows the same location as the source project, cubes are saved to a. 4 the connection mapping of the u… Number of Views 1. x. 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. For example, Create a report with an attribute with only one attribute form. Published: Apr 6, 2017. However, the cube monitor doesn’t show partition related information. An Intelligent Cube publication takes significantly long to complete publication (several hours). 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. Select one: To create a new security filter, click New. 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 following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Choose Data > Configure Intelligent Cube. 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. This is due to the fact that adding prompts to Intelligent Cubes is not supported. 4. x and newer. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 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. 7. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to. 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. Create an Intelligent Cube with this attribute and publish. MicroStrategy Web: Web Server. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. 2. For more information on Intelligent Cube sizes, refer to the following MicroStrategy Knowledge Base technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. ACTION:In MicroStrategy Intelligence Server, how does the project configuration setting "Load Intelligent Cubes on startup" work in a clustered environment?To Create an Intelligent Cube Using Freeform SQL or Query Builder. 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. It will remain available, but the setting will not be enforced if set below the default value of 100000. The related section is located in. mstr suffix. Documentation on the REST API is at developer. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. After execution. The New Grid dialog box opens. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Most likely several, different fact tables are uses for each query. Integer ID of the project where the Intelligent Cube is stored. Node 2. To define an incremental refresh report. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. 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. By default, there is a system hierarchy on the cube. By default, the report template used is the same as the Intelligent Cube's template. The Schedule dialog box opens for your dataset, showing the tables in your dataset. 3. To view an Intelligent Cube stored in your History List. Click Select. Datasets API. You can create and analyze new reports in real time. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. When user imports data into MicroStrategy Analytics Desktop , the data is saved as 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. 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 New Intelligent Cube dialog box opens. 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. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 2 – The data is being pushed to MicroStrategy Intelligent. 5 GB, the Data Transfer from Datasource(s) time is 77. x environment . The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. For more details on enabling the setting. Log on to the machine where you are installing one or more MicroStrategy products. x - 10. The updates to the Intelligent Cube must be according to attributes only. This article notes how support for transformation metrics in Dynamic Sourcing works. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. Rather than returning data from the data warehouse for a. xA warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. 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. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. BUILD Because the in-memory ROLAP Cubes operate below the User Security and Prompting layers, they are able to serve a very wide variety of requests and. Choose File > New > Intelligent Cube. In MicroStrategy 10. IS_CUBE_REP_ID. MicroStrategy is the only comprehensive analytics vendor that supports big data analytics with native connectors to HDFS to access petabytes of data in real time. 9 and 10. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. 1 and 10. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. This is the same requirement to create or run a static report in Workstation. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. Advanced category, select the Balance MicroStrategy Server threads check box. Mclean, Virginia. Limited mobile capabilities compared to the latest BI tools like MicroStrategy. When a remote accesses this cube, the cube is loaded into memory of the. Run sudo vi /etc/sysctl. You can add data for your Intelligent. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available. 4. All MicroStrategy security settings are respected when interacting with MicroStrategy. 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 . Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 3. To enable or disable dynamic sourcing for an Intelligent Cube. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. 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. In the Navigation pane, click , next to Objects. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. 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. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. STEPS TOP REPRODUCE: 1. To build an Intelligent Cube. When a machine runs out of virtual memory, processes on the machine are no longer able. 0 has a dedicated section to memory used for Intelligent Cubes. Most likely several, different fact tables are uses for each query. x If the Administrator wants to create a user that is. All cubes respect the governing setting. MicroStrategy 10 will report the following. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. 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. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Rather than returning data from the data warehouse for a. The change journal logs now process the type, version, and name for databases configured in an environment. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. zip file, with the. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. 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. 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. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). STEPS TO REPRODUCE: 1) Add external dataset. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Limiting the Maximum Report Size. Integer ID of the project where the Intelligent Cube is stored. When using MicroStrategy and Teradata, the best approach is to. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. exe file. ACTION: A fix for this issue is included in MicroStrategy 10. Published: Apr 6, 2017. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. x, when there are multiple fact tables available to perform the fact extension, different fact table are used by the analytical engine for the fact extension in Connect Live and In-Memory Intelligent 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. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). To Create an Intelligent Cube Using Freeform SQL or Query Builder. Select the Allow reports to drill outside the Intelligent Cube check box. 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. In MicroStrategy 9. x or 10. 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. If the data in the Intelligent Cube is outdated. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. x releases, and the new Multi-table Data Import (MTDI) cubes. From the Data menu, select Add Dataset. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. 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. The Modeling service must be configured correctly to use this feature. This is a known issue with Data Import functionality in version 10. 79K. In addition, multiple logical tables can represent the same physical table. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. 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. 15K. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. The New Grid dialog box opens. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. Vn (with metric Mn from source cube Cn). Contact the MicroStrategy Technical Support for an update on this enhancement request. Type of action against the Intelligent Cube: • Enable partitioning in OLAP cubes To enable cube partitioning in OLAP cubes, follow the steps in the olap_partition video. 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. Create Schema Objects. 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. 3 - Check the Make Intelligent. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. With OLAP Services features, your report designers can create Intelligent Cube reports. If the Intelligent Cube must be re-processed based on a metric. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Upgrade to those versions to take advantage of the fix. This defect is addressed in MicroStrategy 11. 3. For a detailed explanation of the Cube Status values, see KB31566: MicroStrategy 9. The Intelligent Cube refresh settings are recommended if the data in the. These VLDB properties control the method by which the report data are normalized. 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. 11. e. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. MicroStrategy logical tables do not necessarily represent physical tables. Within the set. Dynamic Sourcing is a new feature of MicroStrategy 9 OLAP Services that automatically checks a report request, and sources data from a MicroStrategy Intelligent Cube wherever possible. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. It is also more difficult or impossible for someone reporting on Intelligent Cube. A document that uses the Intelligent Cube as a dataset. 0. 2. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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. 2. An Intelligent Cube is. 3. IS_CUBE_INST_ID. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. Moreover, you may generate among the various reports of many users. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. Create an intelligent cube report with Year and three derived metrics and enable "Aggregate from base" as shown below: Insert view filter "Year in list (2009)". This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. Using any other database should not have any implications, given that TPT is only applicable to Teradata. A set of data is returned from the. Navigate to the Data Refresh category. If you are upgrading to MicroStrategy 11. x. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". This is the same requirement to create or run a static report in Workstation. CAUSE. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Senior Lead, Application Support. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. What BO customers are interested in knowing 3A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Refer to the following sections for a list of features that can and cannot be used with. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). You can control users' access to data with security filters. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). Providing Intelligent Cube data. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Provides the last cube row count. In MicroStrategy Analytics Enterprise Web 10 onewards, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI) which has been renamed as Super Cubes in MSTR 2019. Strong semantic layer to define all the business rules and tightly coupled. Also, verify that the /<path_to_the_location>/core. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. 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. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. Cube Advisor opens. Drag and drop the objects into the report grid from the Report Objects pane. Creating an Intelligent cube is similar to creating a report. The display of data is handled by the reports that access the Intelligent Cube. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. 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. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions: A metric with the same formula and transformation exists in the Intelligent Cube. Create a report with Year on the rows and Revenue on the columns. 4. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. 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 Analytics cubes are easy to create and deploy. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Related Articles. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. x Dynamic sourcing extends the accessibility of Intelligent Cubes by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. 0 MicroStrategy releases. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. 4 GB or higher. x. x - 10. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. To review and create recommended Intelligent Cubes using Cube Advisor. Note: The maximum file size that can be imported is 100 MB. Specify a name and location for the new security filter and click Save. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Otherwise, it will increase the percentage to 200% if the "Maximum % of growth of intelligent cube due to indexes" governing rule. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. III. This means any report you create will have caching enabled by default. 1 or above, to pick up the fix, enable project level setting "Data Engine. Strong semantic layer to define all the business rules and tightly coupled. Pros and Cons. Pros and Cons. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. The Intelligence Server checks to see if there is an existing cache for the same Report. Answer: Go with dossier. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Along with. 4. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect 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. MicroStrategy logical tables do not necessarily represent physical tables. In the Navigation pane, click Monitors. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. 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. In the Refresh Policy column, choose one of the following options:Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. "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'. Navigate to the folder location of the Intelligent Cube. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. Share query results in-memory across multiple dossiers and reports. x. There are some further steps after this, including Analytical Engine step, etc. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. certify() to certify / decertify an existing super cube. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. The Full Refresh option is the default. . Consider the following example based on the MicroStrategy Tutorial project. 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. This is set to 32,000 by default. Share query results in-memory across multiple dossiers and. For more details on enabling the setting, refer to Change Data Engine VersionCertify a super cube¶ Use SuperCube. Intelligent Cubes can be based on MicroStrategy data or imported data. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Cube and Cache Metric Names. Why is This Happening? MicroStrategy uses different default encoding for Linux (UTF-8) and Windows (Non UTF-8). The data used for this example is. x. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. The Modeling service must be configured correctly to use this feature. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. microstrategy. Under VLDB settings > Query Optimizations > Data Population for Intelligent Cubes admins need to test all the following options: - Normalize Intelligent Cube data in the database. 4. com. When using an Intelligent Cube, you already have an in memory dataset. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes.