AboutMicroStrategyOLAPServices 6 OLAPServicesfeatures 7 ThebenefitsofusingOLAPServices 11 PrivilegesrequiredforDeveloperandWebusers 12 Reporttypes. Create a Report 'R3' with 'Country' attribute. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. See Memory Mapped Files for Intelligent Cubes for more. 6, users now have the option to select MSTR as the Delivery format for email and file subscriptions as shown below: MicroStrategy Intelligence Server. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. Login to MicroStrategy Web, create a cube with the function of Data Import 2. After upgrading to MicroStrategy 2019 Update 2 or above, republishing a cube created by the MicroStrategy connector may fail and produce the error, "Refreshing dataset failed. 1 release. For example, the attributes Year and Region and the metrics Cost and Revenue are included in the Intelligent Cube shown in the image above. x and newer. 4. What is HyperIntelligence? In 2019, MicroStrategy invented a new solution for a conventional problem in the analytics industry. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. Solution:If you have a Distribution Services license, you can subscribe multiple users to an individual report or document through MicroStrategy Web (see To Create a Subscription in MicroStrategy Web). Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". 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. Navigate to and run the Intelligent Cube report. If the Intelligent Cube must be re-processed based on a metric. 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. . 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. When an Intelligent Cube. 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. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. blogspot. To Create a Report that Accesses an Intelligent Cube. 1 and 10. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . Until then, efectively delivering the last. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Share query results in-memory across multiple dossiers and reports. Choose File > New > Intelligent Cube. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. Edit Intelligent Cubes from the new editor in Workstation at any time. Both tools allow you to plot interactive charts, graphs, and dashboards for comprehensive analysis. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice analysts to the most experienced Intelligence Center architects. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. The MicroStrategy Intelligence Server 9. x a new concept is introduced called Intelligent Cubes. Par défaut, elle est définie sur 32 000. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). You can update and modify the document in Design View. This property can only be enabled through Workstation. Open the cube report in Design View. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Definition. When an Intelligent Cube. Administering MicroStrategy: Managing the Intelligence Platform Securing user privileges and data access Monitoring and tracking the analytics system. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. 6 and higher. From the Data menu, select Configure Intelligent Cube. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. 4. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. The Subscription Editor opens. 4. Place intelligence server close to the both the data warehouse and the metadata repository. 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. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Beginning in MicroStrategy 10. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. The Intelligent Cube opens in the Report Editor. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. This copy of report data is stored in Intelligence Server memory only. The default value is 256 megabytes. The Intelligent Cube Monitor is displayed. The MicroStrategy analytics platform is consistently rated as the best in enterprise analytics and is used by many of the world’s most admired. In the left panel, click Cubes. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. All necessary privileges are included in the Administrator role by default. 11 on Unix/Linux Number of Views 2. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The **_objects folder with a size of 277G. . The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 4. 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. Privilege. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. By default this is set to 256 megabytes. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. 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. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Watch on. Introduction to visual insight microstrategy visual. Calculations changed for non-distributive metrics against Intelligence Cube after upgrading from 10. MicroStrategy Certified Professionals:In MicroStrategy OLAP Services, Transformation metrics used in standard reports can resolve against Intelligent Cubes only when the same Transformation metric exists in the Intelligent Cube. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Build a cube of customer data that’s relevant to all employees and publish it. 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. Find Cube Task . The Intelligent Cube Monitor provides information about published Intelligent Cubes, as well as Intelligent Cube usage statistics. 1 and 10. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Right-click an Intelligent Cube and select Delete. Click the Cube Mapping tab. The VLDB property, Attribute to Join When Key From Neither Side can be Supported by the Other Side becomes obsolete once you upgrade your data engine version to 2021. As of MicroStrategy Secure Enterprise 10. This will work as a regular SQL comparison. However, there are some differences in security filter resolution for reports that connect to Intelligent Cubes as compared to reports that directly access the. For example, the objects developed in a development environment can be copied to a UAT environment to. Users of Intelligent Cubes in MicroStrategy 9. The Intelligence Server brings the live-connect intelligent cube definition from the metadata and analyzes the information requested from that definition. Beginning with MicroStrategy Secure Enterprise 10. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. •PDF. 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. However, you cannot create a card based on a live-connect MDX/SAP cube. Results 1 - 20 of 100 What are the feature flag options and what do they accomplish in MicroStrategy Web 10. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Is it possible to limit the number of rows returned by users running view reports against Intelligent Cubes from Developer and Web 9. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. Select the Intelligent Cubes tab. 0. This data can then be shared as a single in-memory copy, among many different reports created by multiple users. These VLDB properties control the method by which the report data are normalized. In the Data Source column, select the checkboxes for the tables to update. In the Refresh Policy column, choose one of the following options:There are two main types of licenses available from the MicroStrategy product suite that come with privileges: Client product and Server product licenses. Each user that connects to the MicroStrategy Intelligence server and/or project has a unique. Creating an Intelligent cube is similar to creating a report. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. 3 - Check the Make Intelligent Cubes. " If you try to edit these MicroStrategy Connector cubes, you may be. Administer cluster. This section. The Subscription Editor opens. The Intelligent Cube opens in the Report Editor. 2 billion row limit for Intelligent Cubes (240GB cube)Linear scalabilityReduce dependency Sub 5 second response time. A document that uses the Intelligent Cube as a dataset. This property can only be enabled through Workstation. WORKAROUND: Two possible workarounds which may be feasible, depending on the situation are:Select Intelligent Cubes > General > Intelligent Cube File directory. Chapter 8: Improving performance with intelligent cubes Chapter 9: Preparing complex data for enhanced storytelling Chapter 10: Creating workflows for efficient storytelling. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. • MicroStrategy Intelligence Server (IS) allows threads with different priority and may be based on cost and other application factors. Right-click an Intelligent Cube and select Delete. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. Microstrategy's Visual Insight is used as a self service tool replacing Pivot tables & graph building in Excel. 0. MicroStrategy will monitor the data repository and/or cube memory requirement of the Enterprise Manager and/or Platform Analytics. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. Publish to PDF (22) Ratings. Slice and dice features are awesome. , in search results, to enrich docs, and more. Administering MicroStrategy: Managing the Intelligence Platform User privileges and data access Monitoring and tracking the analytics system Administering MicroStrategy Mobile. . Multiple reports can access a single. 1, Windows 2003 and UNIX. You can also define when Intelligent Cubes. 8 and up? KB439821 | Knowledge Article | 2670. The reports created from the shared sets of data are. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. INTELLIGENT_CUBE_MAX_NO: The maximum number of Intelligent Cubes allowed in the project, returned as an integer. 23: Find Intelligent Cube. In the left pane, click All Settings. Click here to view details about the Intelligent Cube Monitor. KB255633. 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. You can edit project-level cache and Intelligent Cube settings. 2. Publish the cube. Analyzing SQL and For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. PUBLISH INTELLIGENT CUBE ("name" IN FOLDER "folder_name" | GUID "guid") [ASYNCHRONOUS] FOR PROJECT "project_name"; where: "name" is the name of the Intelligent Cube to be published, of. 24: Update Intelligent Cube. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. To enable or disable dynamic sourcing for an Intelligent Cube. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. 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. 3. The Intelligent Cube Options dialog box opens. Afterwards the cube will start executing. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. The Intelligent Cube Monitor is displayed. 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. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports. 0. All necessary privileges are included in the Administrator role by default. metrics in the intelligent cube or in the MicroStrategy schema and application objects. Good Understanding of Intelligent cubes and Data mart design. The ability to view or edit certain settings is determined by a user's privileges. Disconnect from the project source and restart both Intelligence servers. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. Browse to and select a previously saved Intelligent Cube on which to build your report. MicroStrategy online help and PDF manuals (available both online and in printed format) use standards to help you identify certain types of content. Report Data Manipulation 5. An Intelligent Cube is an In-Memory data structure which holds information from a source in a readily accessible format for quick access. The storage for Intelligent Cubes was not setup properly. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. MicroStrategy Distribution Services MicroStrategy Distribution Services is the component of MicroStrategy Intelligence Server that performs the delivery of reports and dashboards in a full range of methods or locations (email, files, MicroStrategy history lists, or network printers) and formats (Excel, PDF, HTML, CSV, text, and so on). The Cube API supports DDA cubes and MDX cubes, in addition to Intelligent cubes. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. Upgrade to those versions to take advantage of the fix. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. This defect is addressed in MicroStrategy 11. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. MicroStrategy Intelligence Server . Open the Workstation window. View reports vs Cubes as datasetsTo unpublish an Intelligent Cube. Both properties are located in the Query Optimizations folder in the VLDB property editor. To schedule an Intelligent Cube to be updated. Choose Data > Configure Intelligent Cube. Total Cubes This section displays the total count of cubes by status. Intelligent Cubes. 4. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. Navigate to the Data Refresh category. Creating an Intelligent cube is similar to creating a report. It uses Business Scenarios to provide examples of each concept. Required Status to Perform Action. 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. 39. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1) Right click the intelligent cube and select Properties -> Security . Subsequently the requests made by. Choose one of the following options: Full Refresh: This is the default. 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. The Intelligent Cube Monitor is displayed. If your MicroStrategy project supports the localization of information into multiple languages, you can also support this localization to provide Intelligent Cubes in multiple languages. In the left pane, click Intelligent Cubes. 4. Localizing Intelligent Cubes in multiple languages. While still exposed, the settings will not take effect if. Click the MicroStrategy icon at the upper left of any page and select History List. On the toolbar, choose Data > Configure Intelligent Cube. Number of Views 1. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Same datasets available for MicroStrategy and TableauCan also be leverage in other analytic applications like SAS and RNo 2 billion row limit. If an attempt to load an Intelligent Cube is made that would exceed the limit, an Intelligent Cube is removed from Intelligence Server memory before the new Intelligent Cube is loaded into memory. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory reduces response time for reports using them. To display PDF bookmarks with the correct font, the language pack must be installed on the viewer's machine. 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. All necessary privileges are included in the Administrator role by default. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Defining the partition for Super Cubes. Click OK. Intelligent cubes support time zone based reporting. For more details on enabling the setting, refer to Change Data Engine Version. MicroStrategy World 2014: Scaling MicroStrategy at eBay - Download as a PDF. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. 40. Con: The copy of report data in Intelligence Server memory only applies to a single report. Easily add or change pre- and post- SQL statements. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. Expand Intelligent Cubes, and then select General. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. 1,000Drilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. 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. For detailed information about Intelligent Cubes. Select other schedule options as required, and click OK. ACTION: A fix for this issue is included in MicroStrategy 10. Published: Jun 29, 2018;Data Population for Intelligent Cubes. The ability to view or edit certain settings is determined by a user's privileges. 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. 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. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. The Intelligent Cube Editor 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. 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. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 54K KB31040: How to enable font size smaller than. Intelligent Cubes act as the layer between the data warehouse and MicroStrategy reports that analyze and display. 3. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. Appendixes The MicroStrategy Intelligence Server 9. LIST ALL INTELLIGENT CUBES IN FOLDER "Intelligent Cubes" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. This template includes the following tasks: Creates a new metadata. Integrity Manager can test the SQL of Intelligent Cubes even if they have not been published, but cannot test Intelligent Cube reports based on an unpublished Intelligent Cube. 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. x This is a new feature introduced in MicroStrategy version 9. Please contact MicroStrategy Technical Support for an update on this issue. ; You can create multiple cache, History List, Intelligent Cube, or Mobile subscriptions at one time for a user or user group using the Subscription Wizard. KB442453: Dossier loses the font format when exported to PDF file in MicroStrategy 10. Limit the use of derived attributes or derived metrics Derived elements like derived attributes and derived metrics are calculated on the fly by the MicroStrategy Analytical Engine, even when the data is coming from an intelligent cube, MicroStrategy still needs to calculate the derived elements and depending on the data size and. 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. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Intelligent Cubes can be partitioned,. The Report Editor opens. The default value is 256 megabytes. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Sharing data. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Although this technique improves document performance, the amount of time required to publish an Intelligent Cube increases as it grows in size. 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. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. An Intelligent Cube is an In-Memory data structure which. To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. Choose one of the following options: Full Refresh: This is the default. 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 . From the File menu, select New, and then select Intelligent Cube. Report Versioning (19) Ratings. Select an Environment from the upper-left drop-down. 11. 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 Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. To do so, you can take advantage of URL API. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. The display of data is handled by the reports that access the Intelligent Cube. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. 1 and 10. 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. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. The following table summarizes the test results of some test scenarios against Oracle 19c. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. . •. KB485226: Intelligent Cube size increases irrespective of the "Maximum % growth of Intelligent cube to 50%" governing setting. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. Dedicate a machine for the metadata repository. 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. See KB484738 for more 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. x This is a new feature introduced in MicroStrategy version 9. In order to set this limit, log on to MicroStrategy Desktop/Developer, right click on the desired project, and select “Project Configuration…” Navigate to Intelligent Cubes >> General, and enter your desired limit. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. To that end, we’ve designed a program of continuous training and certification for every role in your Intelligent Enterprise. The ability to view or edit certain settings is determined by a user's privileges. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Set the path for the cube cache file directory to . Watch on. 4. Intelligent Cubes provide the fast response time and analytic calculations that are often associated with MOLAP cubes. When a remote accesses this cube, the cube is loaded into memory of the. KB442630: CSI optimization for improving the in-memory query execution for many. In MicroStrategy 9. 10. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. mstr file is too large. Browse to the folder location to store Intelligent Cubes, and then click OK. intelligence company. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. The. About this book. For this reason, it is important to govern how much Intelligent Cube data can be stored on Intelligence Server. In versions prior to MicroStrategy Intelligence Server 9. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. x, with the Intelligence Server running on Linux, the. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. From the Data menu, select Configure Intelligent Cube. It depends on the cube. 4. For example, an Intelligent Cube includes Year and Quarter.