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. 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. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. Only one cube file will be generated for each Intelligent cube on disk. The Intelligent Cube Options dialog box opens. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. The change journal logs now process the type, version, and name for databases configured in an environment. 0. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. Cube Advisor opens. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. When using an Intelligent Cube, you already have an in memory dataset. x and newer. Extensively used “Apply Simple” function for creating attributes. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. x using Command Manager. 0 has a dedicated section to memory used for Intelligent Cubes. 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. Defining the partition for Super Cubes. These reports allow data to be returned from the data. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Intelligent Cubes are multidimensional cubes (sets of data) that exist on the MicroStrategy Intelligence Server memory and can be shared among different users. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. 9 and 10. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. x and newer. 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. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 11. ADD: the refresh policy is Add new data. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. 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. Within the set. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. An Intelligent Cube is a. The Maximum RAM usage (Mbytes) memory limit can be defined per project. Once activated, the user loads the cube in memory. Note: The maximum file size that can be imported is 100 MB. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). This is a known issue with Data Import functionality in version 10. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. x. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. An enhancement Request has been reported to the MicroStrategy Technology team. This import bridge imports MicroStrategy logical tables as Dimensions. Right-click an Intelligent Cube and select Delete. The first is to enable report caching at the project level. Intelligent Cubes. 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. 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. Technically this will result is different queries on the database, due to the fact that each calculation level is different. 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. 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. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. When you run reports in MicroStrategy, they collect the warehouse data. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. ACTION This. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 4. Type of action against the Intelligent Cube: •In MicroStrategy 11. This import bridge imports MicroStrategy logical tables as Dimensions. When using MicroStrategy and Teradata, the best approach is to. If the indexes are needed again,. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. 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. To Create a Report that Accesses an Intelligent Cube. Published: Apr 6, 2017. STG_IS_CUBE_REP_STATS. Intelligent Cube storage on disk mirrors report cache storage. 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. Complex metrics here refer to metrics which are defined using multiple. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. This import bridge imports MicroStrategy logical tables as Dimensions. 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. Use Cube Advisor to create Intelligent Cubes: 1. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. While this can improve performance of these reports. Following are the features, which make intelligent cubes useful. Datasets API. GUID of the Intelligent Cube instance in memory. You can control users' access to data with security filters. This import bridge imports MicroStrategy logical tables as Dimensions. 2. reg file on UNIX/Linux operating systems. On the left side of the page, click Logs and then Export Logs to save the file. cube; oracle12c; cubes; microstrategy; Jorgechu. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. In MicroStrategy Developer, right-click on the project and select Project. Moreover, you may generate among the various reports of many users. 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. MicroStrategy logical tables do not necessarily represent physical tables. Providing Intelligent Cube data. Job ID for the action on the Intelligent Cube. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Like cache update subscriptions, Intelligent Cube. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. Create a security filter on the region attribute such as region not in list central. 0: Balance MicroStrategy Server threadsDescription The . 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. It is also more difficult or impossible for someone reporting on Intelligent Cube data to unintentionally cause re-execution against the data warehouse, preventing extra load on the data warehouse. 3. The Intelligent Cube opens in the Report Editor. - Normalize Intelligent Cube data in the. 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. If you are upgrading to MicroStrategy 11. 5 GB . 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. Create Cube2 with the Region attribute and the metric created in step 1. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. To use an attribute form. 3. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. Choose File > New > Intelligent Cube. KB222608: In a clustered environment in MicroStrategy 9. 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)". IS_PROJ_ID. Specify a name and location for the new security filter and click Save. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. A document that uses the Intelligent Cube as a dataset. There's a reason we're at the top of the list. This is controlled by the Python script. Use Case 4. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Before MicroStrategy 10. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. Run sudo vi /etc/sysctl. Designing and creating documents: An overview. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. A solution/code fix for this issue is not available in current releases but is. This. Go to the Report -> Data->Intelligent Cube Options->Point grid to. To view this field, the Intelligent Cube must be published at least once. To add an existing report or Intelligent Cube as a dataset. Defining Intelligent Cube refresh settings. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. They should have the “A, L, F” status (Active, Loaded, Filed). The Intelligent Cube Options dialog box opens. x. microstrategy. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. Click Select. 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. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). 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. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. The Intelligent Cube must be published before this report can execute. 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 ). Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. 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. Number of Views 8. 4. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. You can use Integrity Manager to perform a before and after test to identify which reports actually connect to a suggested Intelligent Cube and also to test data integrity. Although the directory filed shows the same location as the source project, cubes are saved to a. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. The objects in the source cubes will control how the security filter will be applied. To view an Intelligent Cube stored in your History List. Making the move from Developer to Workstation even smoother, users can now create Intelligent Cube Reports in Workstation. IS_CUBE_INST_ID. log without functional impact. In MicroStrategy 9. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. CAUSE. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. x. 2. Choose your environment, project, and Intelligent Cube as your dataset type. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. Otherwise, it will increase the percentage to 200% if the "Maximum % of growth of intelligent cube due to indexes" governing rule. Expand the Object Templates category, select General, and. x or 10. You must belong to the System Administrators group to use this feature. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. For more information on security filters, see the System Administration Guide. Comparing OLAP and MTDI cubes. How to configure, monitor, and manage Intelligent Cubes. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Create a report with Year on the rows and Revenue on the columns. Overview. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. 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 simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. Open the Workstation window. For example, an Intelligent Cube that contains data for the top 200 stores by. 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. If the data in the Intelligent Cube is outdated. There are some further steps after this, including Analytical Engine step, etc. This means any report you create will have caching enabled by default. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. 9 and 10. 143; asked Oct 2, 2014 at 14:58. 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. Maintaining data access security. 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. Documentation on the REST API is at developer. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. This Python 3 / MicroStrategy 10. 3 - Check the Make Intelligent Cubes. This Knowledge base article describes limitations in using security filters and intelligence 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. Create a Report 'R3' with 'Country' attribute. x. x. From the Categories list, expand Options, and then select General. Case A: Security Filter attribute is related to attributes placed on the grid. The Intelligent Cube is opened in the Report Editor. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Traditional Report Caching in MicroStrategy is done on a matching basis. 56K. This applies for example to Cubes created via MicroStrategy Web client. However, the cube monitor doesn’t show partition related information. 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Software Categories. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. In the left panel, click Cubes. The ability to view or edit certain settings is determined by a user's privileges. Create Cube1 with the Region attribute and the metric created in step 1. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. This template includes the following tasks: Creates a new metadata. Total Cubes This section displays the total count of cubes by status. Right-click the dataset, and choose Schedule. Browse to the filter you want to convert and click Open. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. The Select Dataset dialog box opens. Maintaining data access security. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Drag and drop the objects into the report grid from the Report Objects pane. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. The maximum number of Intelligent Cubes that can be loaded onto Intelligence Server for this project. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. 4. In MicroStrategy Developer, log in to a project source with administrative privileges. To enable or disable dynamic sourcing for an Intelligent Cube. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. This difference is roughly equal to the size of the Intelligent Cube footprint in-memory versus the size of the compressed disk cache. This is the most popular MicroStrategy Interview Question asked in an interview. Select an Environment from the upper-left drop-down. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. UPDATE: the refresh policy is Update existing data. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. This can be seen in the screenshot below. Documents . Pros and Cons. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. MicroStrategy Professional Services for high performance. Create a Data Import Live Intelligent Cube. 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. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. Report: The results of a report are used to populate the Intelligent Cube. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Choose your preferred method to share the logs. 4. Select one: To create a new security filter, click New. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. 2. STEPS TO REPRODUCE: 1) Add external dataset. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. table_name: is the name of a table. Cube Advisor opens. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. 88K. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. IS_PROJ_ID. The **_objects folder with a size of 277G. It is shared by all processes running on the machine, including the operating system. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. x. 4. 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. com. This can. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. Article Reference Number:The memory used by Intelligence Server is limited by the machine's virtual memory. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. 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. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. By default, this is set to 32,000. The Attribute Index An Intelligent Cube is an In-Memory data structure which holds information from a source in a readily accessible format for quick access. In addition, multiple logical tables can represent the same physical table. 2. An Intelligent Cube is. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. 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. Consolidate multiple MicroStrategy cubes into a single Kyvos data model without limitations on the data size or the number of dimensions that the model can hold. When running MicroStrategy Intelligence Server 9. 3. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. No data is returned for the report. For more information on security filters, see the System Administration Guide. All necessary privileges are included in the Administrator role by default. MicroStrategy HyperIntelligence is the next step in the future of data analytics. Navigate to the folder location of the Intelligent Cube. Strong semantic layer to define all the business rules and tightly coupled. In the Navigation pane, click , next to Objects. MicroStrategy Web: Web Server. x environment . A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 2. Then it generates a report. With OLAP Services features, your report designers can create Intelligent Cube reports. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Add External Data. Click the “Add history list subscription” link near the bottom of the screen to open the. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Along with. The Intelligent Cube opens in the Report Editor. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. To change these behaviors, see: Publishing Intelligent Cubes Without Loading Them into Intelligence Server Memory Loading Intelligent Cubes when Intelligence Server Starts If. Intelligent Cubes. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. xA warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. 17. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Dossiers automatically adjust to look great on any screen. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. The Intelligence Server checks to see if there is an existing cache for the same Report. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. In MicroStrategy 10. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. Loading. Intelligence Server Statistics Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. 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. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. IS_CUBE_ACT_ID. This KB answers a question regarding memory limitations for In-Memory data import for MicroStrategy 10. 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. Select the schedule you had created in step 2 and in the Intelligent Cubes field, select the desired Intelligent Cube as seen below: 6. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. This dataset needs to contain all data in the required granularity. Users of Intelligent Cubes in MicroStrategy 9. See full list on community. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. 2) Choose "Database" and select the 3rd option to "Pick tables". Drag and drop the objects into the report grid from the Report Objects pane. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. To enable or disable dynamic sourcing for an Intelligent Cube. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. Save the Report and close. This data is to apply the calculations. g. Intelligent Cube storage on disk mirrors report cache storage. 5 GB. 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. Known Limitations and Challenges in MicroStrategy 2019 Update 2 HyperIntelligence for Office. Number of Views 5. 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. Create an attribute element prompt for the.