Expand Intelligent Cubes, and then select General. Microstrategy is used to interact on Hadoop, Microsoft SQL Server Tables, and SSAS MDX Cubes. This technical document covers a known issue affecting MicroStrategy Secure Analytics Enterprise 10. • Optimizi ng performance with Intelligent Cubes • Determining the order of calculation • Sharing reports using export, print, or by subscribing to report deliveries 1. From the Data menu, select Configure Intelligent Cube. Select a schedule from the Schedule drop-down list. Right mouse click on the cube and choose Schedule 3. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. Right-click the Intelligent Cube, and select Edit. Publish the Cube, and create the following Dossier:. Intelligent Cubes. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. For more information on cube partitioning, download this PDF. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Create Intelligent Cubes. blogspot. To enable or disable dynamic sourcing for an Intelligent Cube. 3. Expand the Object Templates category, select General, and. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. 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. However, you cannot create a card based on a live-connect MDX/SAP cube. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Server Logout. 4. Create an attribute element prompt for the. The Intelligent Cube Options dialog box opens. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. 4. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. There is a distributed database for the MicroStrategy metadata and. The ability to view or edit certain settings is determined by a user's privileges. x -10. x? Users may note that it is possible to limit the number of rows of data returned when publishing Intelligent Cubes, via the 'Final Result Rows' for 'Intelligent Cubes' located in the Project Configuration Editor. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. 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). Localizing Intelligent Cubes in multiple languages. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. 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. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Along with storing Intelligent Cubes in. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Required Status to Perform Action. You can also define when Intelligent Cubes. Save the Report and close. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. MicroStrategy will continue to investigate and post updates as soon as they are. When a remote accesses this cube, the cube is loaded into memory of the. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. 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. 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. • Meta data that is very scalable and can reach beyond 1TB. 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. Description: Intelligent Cube design and utilization; how to build cubes. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. x and 10. (MDX) for interactively accessing cube databases from SAP, Microsoft AnalysisThis setting also defines when Intelligent Cubes are saved to secondary storage, as described in Storing Intelligent Cubes in Secondary Storage. Discover MicroStrategy 2021 > Events; Customer Success; Enterprise Analytics; Retail; World 2021;By using a single Intelligent Cube to support all the security filters for a project, data access security is implemented automatically with minimal burden on Intelligence Server memory. Navigate to and run the Intelligent Cube report. 3. Have full control over result, element, and object caches in a project. However, Intelligent cube publishing performance may be affected with the agent enabled. 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. Results 1 - 20 of 100 What are the feature flag options and what do they accomplish in MicroStrategy Web 10. To view an Intelligent Cube stored in your History List. A document that uses the Intelligent Cube as a dataset. 4. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. 3 - Check the Make Intelligent Cubes. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. x. Administer Caches. If you are upgrading to MicroStrategy 11. . Right-click an application and choose Properties. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. Exceptions: When the Report contains the following features which are not supported in Intelligent Cubes, it’s exempt from this feature: Custom Groups ; Consolidations; Derived Element; Cause: This is a known issue in MicroStrategy. Total Cubes This section displays the total count of cubes by status. x CAUSE: The user is missing the "Administer Subscriptions" privilege under "Administration" in. Reproduce Steps Definingderivedelementfunctionalityandformatting 156 Interactionwithotherreportingfeatures 169 6. Browse to the folder location to store Intelligent Cubes, and then click OK. 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. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. 6, users now have the option to select MSTR as the Delivery format for email and file subscriptions as shown below: MicroStrategy Intelligence Server. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. MicroStrategy OLAP Services is an extension to MicroStrategy Intelligence Server that allows MicroStrategy Web and Desktop users to manipulate Intelligent Cubes™. Published: 4월 6, 2017. 1 and 10. MicroStrategy World 2014: Scaling MicroStrategy at eBay - Download as a PDF. 11 on Unix/Linux Number of Views 2. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. - Normalize Intelligent Cube data in the. ACTION: A fix for this issue is included in MicroStrategy 10. This template includes the following tasks: Creates a new metadata. Same datasets available for MicroStrategy and TableauCan also be leverage in other analytic applications like SAS and RNo 2 billion row limit. The cube population process could be expensive in time and memory if the cube is large. The total number of Intelligent Cubes for a project that are stored in Intelligence Server memory is compared to the limit you define. All necessary privileges are included in the Administrator role by default. All necessary privileges are included in the Administrator role by default. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. MicroStrategy Intelligence Server . This section contains the following information: Managing Intelligent Cubes: Intelligent Cube Monitor Governing Intelligent Cube Memory Usage, Loading, and Storage The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. The blog series consists of four blog posts: Unlocking Data Value #1: SAP BTP Data and Analytics overview: Learn about our objectives, SAP products, and real. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. The Platform Analytics project comes with three Intelligence Cubes that support nine Dossiers that can be run right after installation to check if everything is functioning properly. For more details on enabling the setting. Click OK. In MicroStrategy Developer, log in to a project source with administrative privileges. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. If the objects (metrics/attributes) on an Intelligent Cube have restricted access (via ACLs), such cubes will be implicitly treated as live-connection cubes and hence won't be eligible for use with delivery as an MSTR fileThe Intelligent Cube Editor offers control over advanced properties. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. Depending on location set at the project level, one or none of the Intelligence server nodes will be able. Users don’t have to mention the cube to which they want to connect. Vn (with metric Mn from source cube Cn). Publish the cube. 1. Select the data set and click Prepare Data. Sharing data. In MicroStrategy Developer, browse to an Intelligent Cube. x releases, and the new Multi-table Data Import (MTDI) cubes. 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. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. 10. 4. 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. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. INTELLIGENT_CUBE_MAX_RAM: The maximum size in memory of all Intelligent. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. From the Data menu, select Configure Intelligent Cube. MicroStrategy Web allows you to merge two or more Intelligent Cubes. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Expand Intelligent Cubes, and then select General. idx file is cleaned up. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. HIDDEN: Whether or not the Intelligent Cube is hidden, returned as a boolean value. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. To schedule an Intelligent Cube to be updated. 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. An Intelligent Cube is a. Visit the data visualization and data dashboard galleries for inspiration. Open the cube report in Design View. Published: Nov 19, 2018; Last updated: Nov 18, 2022;MicroStrategy version 9. 1 and 10. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. To enable or disable dynamic sourcing for an Intelligent Cube. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. 4,. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. Disabling parallel query execution by default allows you to first verify that your reports and Intelligent Cubes are executing correctly prior to any parallel query. Place intelligence server close to the both the data warehouse and the metadata repository. KB485673: When "Create Intelligent Cubes by database connection" is enabled, the cube published with the latest data can't… Number of Views 157 KB484562: Intelligence Cubes are not published via subscriptions to both nodes of cluster in MicroStrategy 2019 and later. The Schedule dialog box opens for your dataset, showing the tables in your dataset. 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. Drag and drop the objects into the report grid from the Report Objects pane. Add data from existing reports, documents, and Intelligent Cubes. With this release, architects can design or edit Intelligent Cubes directly from Workstation: Architects can design and create Intelligent Cubes to combine. The partition attribute is the attribute that is used to divide. This privilege is part of OLAP Services. 6, the MicroStrategy PDF Exporter (also known as New Export Engine or NEE) service has been added to support exporting from Visual Insight / Dossier to PDF format. Publish, unpublish, delete, and update Intelligent Cubes. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. You can control users' access to data with security filters. Create the MIN (CurrentDateTime ()) metric. Both properties are located in the Query Optimizations folder in the VLDB property editor. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Consider the following example based on the MicroStrategy Tutorial project. 11/10. Intelligent Cube design and utilization; how to build cubes, schedule them,. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Currently, project duplication does not involve Intelligent Cube File Directory. Users with different security filters can use the same Intelligent Cube data. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. x releases, and the new Multi-table Data Import (MTDI) cubes. In MicroStrategy 9. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. 2. This. 1 and 10. 1 and 10. You must belong to the System Administrators group to use this feature. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Object Migration Best Practices. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 11+, derived attributes are evaluated at the source when all the required columns come from the same table- which is the case for most users. The old cube files don't have this property, so new IDs will be generated every. Edit Intelligent Cubes from the new editor in Workstation at any time. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. bat format. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. In this video I will explain the different cube refresh options and show you how to refresh Intelligent Cubes using incremental refresh reports in MicroStrat. 1 and 10. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. MicroStrategy Education is committed to the success of every MicroStrategy practitioner. Reporting on Intelligent Cubes also allows you to use all of the OLAP Services features, including derived elements, which allow you to group attribute elements in a report on. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. To display PDF bookmarks with the correct font, the language pack must be installed on the viewer's machine. 5. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. A user logged in to a MicroStrategy Intelligence Server. This article explains how a cube and its cache become synchronized in a clustered environment. Choose one of the following options: Full Refresh: This is the default. Select an Environment from the upper-left drop-down. In the left pane, click Intelligent Cubes. When the subscription has been configured, click. Intelligent Cubes. Intelligent Cube storage on disk mirrors report cache storage. Select the Intelligent Cubes tab. Provides the last cube row count. The "Refresh Cube Subscription Editor" allows for a "Name", "Schedule", and "Delivery Notification" to be set. . 18K. The Training Metric Wizard opens. Export to PDF, web sort, document design. INTELLIGENT_CUBE_MAX_NO: The maximum number of Intelligent Cubes allowed in the project, returned as an integer. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. MicroStrategy will monitor the data repository and/or cube memory requirement of the Enterprise Manager and/or Platform Analytics. 3. All necessary privileges are included in the Administrator role by default. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. File subscriptions save the report or document as an Excel or PDF file to a disk location on the network. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. Par défaut, elle est définie sur 32 000. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. In the Navigation pane, click Applications. Publish to PDF (22) Ratings. Build a cube of customer data that’s relevant to all employees and publish it. Choose File > New > Intelligent Cube. x. Analyzing SQL and For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. • Reports can consist of documents with customized HTML format. 1 and 10. If the Intelligent Cube must be re-processed based on a metric. 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. 56K. Is it possible to limit the number of rows returned by users running view reports against Intelligent Cubes from Developer and Web 9. MicroStrategy Intelligent Cubes Eliminate the Need to Maintain a Proprietary Cube Environment and Redundant Hardware and Databases In order to provide BI functionality, many vendors use proprietary cubes, which require additional hardware storage 7 4%: Breakdown of TCO for IT Infrastructure workloads over a five-year period. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. This can improve the performance of. 1 and 10. To learn more about Intelligent Cube Data Partition, please refer to KB237803. x and newer. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Use the drop-down under the filter summary section to switch the server nodes. 0. 4, MSTR file is an available export format for individual Visual Insight dashboards from MicroStrategy Web and MicroStrategy Desktop. The Intelligent Cube Options dialog box opens. Set Intelligent Cubes to Publish and Trigger initial Object Migration. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. Run the Report and check the SQL View. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. MicroStrategy Developer et MicroStrategy Web peuvent extraire de manière incrémentielle les lignes d'élément d'Intelligence Server. Navigate to the folder location of the Intelligent Cube. In HTML View and PDF View, a dashboard is displayed as a static document. , in search results, to enrich docs, and more. Con: The copy of report data in Intelligence Server memory only applies to a single report. 0. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Report Versioning (19) Ratings. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. For more information on the Intelligent Cube Maximum. Creating Intelligent Cubes is as easy as creating reports. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 23: Find Intelligent Cube. •PDF. The Intelligent Cube opens in the Report Editor. In versions prior to MicroStrategy Intelligence Server 9. 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. 0: Balance MicroStrategy Server threadsReporting on an Intelligent Cube provides quick access to data, as the data has been pre-aggregated. Right-click an application and choose Properties. Edit Project-Level Cache and Intelligent Cube Settings. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. KB19654: How to obtain the Report Execution. Explain an Intelligent Cube? Instead of returning data from the data warehouse for a single report ,we can return sets of data from our data warehouse and save them directly to Microstrategy. Click Select. Create Cube1 with the Region attribute and the metric created in step 1. Interested in learning more about Platform Analytics or new MicroStrategy features? Visit the Learning Center on Community! Or feel free to visit our Documentation pages for product information. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. An Intelligent Cube is an In-Memory data structure which holds. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. 4. On the toolbar, choose Data > Configure Intelligent Cube. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesKB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. After each unload/reload, and running the Dossiers against the cube, the duplicate Element Block files will be dumped into the same *****_objects folder. WORKAROUND: Two possible workarounds which may be feasible, depending on the situation are:Select Intelligent Cubes > General > Intelligent Cube File directory. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. 4. 1 and 10. The Report Editor opens. This property can only be enabled through Workstation. Required Status to Perform Action. If you are upgrading to MicroStrategy 11. This option allows users to collaborate and develop an application schema over time by merging smaller, independent datasets into one Intelligent Cube. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. You can return data from your data warehouse and save it to Intelligence Server memory, rather than directly displaying the results in a report. Créer des cubes Intelligent Cube par connexion à la base de données: Cochez cette case pour définir vos cubes intelligents à utiliser et prendre en charge le. 0. Subscriptions in an internationalized. This has been fixed in. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Overview. Browse to an Intelligent Cube, select it, and then click OK. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Query Generation. Defining Intelligent Cube refresh settings. KB485226: Intelligent Cube size increases irrespective of the "Maximum % growth of Intelligent cube to 50%" governing setting. Name the different export. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. In MicroStrategy Developer, log in to a project source using administrative privileges. Two unique methods to implement Intelligent Cube Technology: •Personal Intelligent Cubes: You can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as. Browse to and select a previously saved Intelligent Cube on which to build your report. 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. Go to the "All Objects View" option in the top left corner. Create a report based off the cube in Step 1 that includes the description form for Category. Click OK. In a clustered environment, each node in a cluster must share its result caches and intelligent cubes with the other nodes, so all clustered machines have the latest cache information. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. Intelligent Cubes: MicroStrategy’s Intelligent Cubes are pre-aggregated, in-memory data structures that enhance the performance of queries. This option is enabled by default. Subsequently the requests made by other users can. 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)". x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. Publish Intelligent Cube statement. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. Navigate to the Data Refresh category. With Oracle 11g, the integration with Oracle OLAP Cubes is transparent to MicroStrategy, because now cubes can be defined as Materialized Views (MV) and Oracle will rewrite SQL queries to these MV. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. . 2) Add a new User to the ACL list of the Intelligent Cube object and deny the Execute permission (this prevents the user from re-publishing this particular cube) 3) The user will then need to create an Intelligent Cube report off of the Intelligent cubeMicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. For example, analysts can export interactive dashboards and reports to PDF format, allowing executives to access and review critical information without needing direct access to the BI platform. The storage for Intelligent Cubes was not setup properly. 5. The Intelligent Cube Options dialog box opens. 1, Windows 2003 and UNIX.