For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. Number of Views 1. 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. The Intelligent Cube refresh settings are recommended if the data in the. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. When a remote accesses this cube, the cube is loaded into memory of the. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. In MicroStrategy 10. Results 1 - 20 of 100 What are the feature flag options and what do they accomplish in MicroStrategy Web 10. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. Save the Report and close. Maximum memory usage for Intelligent Cubes (MB) Defines the amount of data required for all Intelligent Cubes to limit the amount of Intelligent Cube data stored in Intelligence Server memory at one time for a project. User Review of MicroStrategy Analytics: 'Microstrategy is used as a reporting solution in my work environment. You can edit project-level cache and Intelligent Cube settings. You can update and modify the document in Design View. Build a cube of customer data that’s relevant to all employees and publish it. 1 and 10. Intelligent cubes support time zone based reporting. This provides ROLAP-type analysis without having to re-execute against the data warehouse. The old cube files don't have this property, so new IDs will be generated every. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. 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. 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. Intelligent Cubes. WORKAROUND: Two possible workarounds which may be feasible, depending on the situation are:Select Intelligent Cubes > General > Intelligent Cube File directory. xUse the same attribute in filter in Intelligent Cube and incremental refresh filter. 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. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Indicates a user exported a view report or a cube-based document or a cube-based dossier to PDF and hits the cube cache. Please contact MicroStrategy Technical Support for an update on this issue. To view embedded fonts in Web, the fonts must be installed on the Intelligence Server machine. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. Expand Intelligent Cubes, and then select General. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Drag and drop the objects into the report grid from the Report Objects pane. The ability to view or edit certain settings is determined by a user's privileges. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions = 12. Recorded at World 2021. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. You can add data for your Intelligent. MicroStrategy reference numbers for this technical note are KB442285 and DE101600. This command will list the table information only when the intelligent cube is a super cube. In MicroStrategy Web 9. 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. It depends on the cube. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. 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. 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. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. In the left panel, click Cubes. This will reduce the memory usage from 150GB to 100GB. Click here to view details about the Intelligent Cube Monitor. To schedule an Intelligent Cube to be updated. 1 and 10. Intelligent Cubes erstellen. 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. x releases, and the new Multi-table Data Import (MTDI) cubes. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. x - 10. Right-click the dataset, and choose Schedule. As of MicroStrategy Secure Enterprise 10. The SQL Engine matches a view report, or a report that uses dynamic sourcing, with the corresponding Intelligent Cube. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. 4. From the Data menu, select Configure Intelligent Cube. For more information on cube partitioning, download this PDF. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. 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. To enable. Choose one of the following options: Full Refresh: This is the default. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. Right-click an application and choose Properties. This section. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Con: The copy of report data in Intelligence Server memory only applies to a single report. Con: The copy of report data in Intelligence Server memory only applies to a single report. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Total Cubes This section displays the total count of cubes by status. PATH: The path to the Intelligent Cube, returned as a string. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 0 MicroStrategy releases. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. In versions prior to MicroStrategy Intelligence Server 9. 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. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Publish the cube. Beginning in MicroStrategy 10. The MicroStrategy Intelligence Server 9. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 2. 1 and 10. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Users don’t have to mention the cube to which they want to connect. This article explains how a cube and its cache become synchronized in a clustered environment. Object Migration is the process of migrating or moving objects from one environment to another environment. Click the MicroStrategy icon at the upper left of any page and select History List. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Click Select. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X". For more information on the Intelligent Cube Maximum. You can also define when Intelligent Cubes. 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. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. In MicroStrategy Web, you can. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Place intelligence server close to the both the data warehouse and the metadata repository. The Report Editor opens with all of the objects of the Intelligent Cube. 2 billion row limit for Intelligent Cubes (240GB cube)Linear scalabilityReduce dependency Sub 5 second response time. 0. In the left pane, click All Settings. The following table summarizes the test results of some test scenarios against Oracle 19c. "Maintaining data access security. Information to use MicroStrategy OLAP Services features, including Intelligent Cubes, derived metrics, derived elements, dynamic aggregation, view filters, and dynamic sourcing. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 0. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. This VLDB property has the following options: Disable parallel query execution (default): All queries for MicroStrategy reports and Intelligent Cubes are processed sequentially. Overview. These Intelligent Cubes can be loaded into memory when they are needed. 4. What is HyperIntelligence? In 2019, MicroStrategy invented a new solution for a conventional problem in the analytics industry. 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. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 0. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. 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. The Cube API supports DDA cubes and MDX cubes, in addition to Intelligent cubes. An Intelligent Cube has been created in a project. The fact that the Intelligent Cube resides on the. While still exposed, the settings will not take effect if. Creating Intelligent Cubes is as easy as creating reports. If the Intelligent Cube must be re-processed based on a metric. Publishing Intelligent Cubes. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. x. To Create a Report that Accesses an Intelligent Cube. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Query Generation. x a new concept is introduced called Intelligent Cubes. 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. The Intelligent Cube Monitor is displayed. To learn more about Intelligent Cube Data Partition, please refer to KB237803. Intelligent Cube storage on disk mirrors report cache storage. Easily add or change pre- and post- SQL statements. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. 0. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. The following diagram depicts the role of the intelligent cube. The Intelligent Cube Monitor provides information about published Intelligent Cubes, as well as Intelligent Cube usage statistics. Users with different security filters can use the same Intelligent Cube data. This template includes the following tasks: Creates a new metadata. All necessary privileges are included in the Administrator role by default. 54K KB31040: How to enable font size smaller than. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Intelligent Cubes. MicroStrategy Intelligence Server . If the welcome page is shown, review the information and click Next. There is a distributed database for the MicroStrategy metadata and. Select the data set and click Prepare Data. 4. In the Navigation pane, click Applications. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data. 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. For more information on security filters, see the System Administration Guide. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. 5 GB, the Data Transfer from Datasource(s) time is 77. The New Grid dialog box opens. 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. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. 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. Configure metric aggregations, null handling, indexing, and more. In MicroStrategy Developer, log in to a project source with administrative privileges. Business users might not want MicroStrategy to build any M:M Relationship tables while publishing the Intelligent Cube In-Memory due to the following reasons: 1) It distorts the actual relationship between a tuple of 3 or more attributes related to each other through M:M relationship in Project Schema by creating individual tables and joining. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. The Export Engine formats a report or document for export as a PDF, Excel workbook, or XML. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. MicroStrategy Developer et MicroStrategy Web peuvent extraire de manière incrémentielle les lignes d'élément d'Intelligence Server. The Analytics Server creates and manages Intelligent Cubes, a multi-dimensional cache structure that speeds up access to frequently used data. 1 and 10. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. 4. 4. In MicroStrategy Developer, browse to an Intelligent Cube. Number of Views 1. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. The Intelligent Cube Options dialog box opens. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. 11/10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Definition. This can be seen in the screenshot below. It uses Business Scenarios to provide examples of each concept. 1 and 10. Visit the data visualization and data dashboard galleries for inspiration. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. The dataset is a set of data that can be displayed on the document. The Intelligent Cube opens in the Report Editor. MicroStrategy Library. 1 and 10. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks. To view an Intelligent Cube stored in your History List. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. The Subscription Editor opens. In MicroStrategy 9. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. This Knowledge base article describes how when creating an Intelligence cubes using functions that pass through the database return "There is no data for this result. Publish the Cube, and create the following Dossier:. Open the Workstation window. ; 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. This document discusses a specific case regarding how security filters are applied when the Intelligent Cube has non-aggregatable metrics. 3. On the toolbar, choose Data > Configure Intelligent Cube. 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. 438832. Publish Intelligent Cube statement. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Microstrategy is used to interact on Hadoop, Microsoft SQL Server Tables, and SSAS MDX Cubes. Drilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Use the table below as a guide to determine whether switching to a single Intelligent Cube as dataset can improve the performance in your environment: 3. To enable. Intelligent Cubes are part of the OLAP Services add-on to Intelligence Server. A dataset is a MicroStrategy report that is used on a document and all of the report's elements–attributes, custom groups, consolidations, and metrics. 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. Microstrategy's Visual Insight is used as a self service tool replacing Pivot tables & graph building in Excel. 4. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Description: Intelligent Cube design and utilization; how to build cubes. 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. 1 and 10. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. Both products' features range. 0 has a dedicated section to memory used for Intelligent Cubes. KB19654: How to obtain the Report Execution. The cube instance is located from the Intelligent Cube Manager, when a subset report, or a standard report that uses dynamic caching, is executed. Allows the user to. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Open the Workstation window. grouping attributes MicroStrategy Cloud Creating attributes on dossiers Filtering reports, metrics, and attribute groups Filtering dossiers Improving performance with intelligent cubes Preparing complex data for enhanced storytelling Visualizing, filtering, and linking your data Designing documents Building enterprise mobile applications 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‘. View the report in either Grid View or Grid and Graph View. Expand Intelligent Cubes, and then select General. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 15K. However, after publishing,. Select other schedule options as required, and click OK. Introduction to MicroStrategy BI Architecture . In HTML View and PDF View, a dashboard is displayed as a static document. Login to MicroStrategy Web, create a cube with the function of Data Import 2. From the Data menu, select Configure Intelligent Cube. x releases, and the new Multi-table Data Import (MTDI) cubes. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The display of data is handled by the reports that access the Intelligent Cube. In addition to creating reports directly, you can use the Freeform SQL Editor or Query Builder Editor to create an Intelligent Cube. KB442453: Dossier loses the font format when exported to PDF file in MicroStrategy 10. The cube population process could be expensive in time and memory if the cube is large. 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. From the Data menu, select Configure Intelligent Cube. Until then, efectively delivering the last. Intelligent Cubes can be partitioned,. Intelligent Cubes. The New Intelligent Cube dialog box opens. LIST ALL INTELLIGENT CUBES IN FOLDER "Intelligent Cubes" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Administer Caches. Required Status to Perform Action. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. Created narrowcast services to email /send to a directory either report service documents in PDF or excel files. We empower you with the skills to get the most out of your analytics investment. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. INTELLIGENT_CUBE_MAX_NO: The maximum number of Intelligent Cubes allowed in the project, returned as an integer. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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)". 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 storage for Intelligent Cubes was not setup properly. •PDF. Select other schedule options as required, and click OK. 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. The Intelligent Cube Options dialog box opens. Choose Data > Configure Intelligent Cube. 4, MSTR file is an available export format for individual Visual Insight dashboards from MicroStrategy Web and MicroStrategy Desktop. 4,. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. 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. When the subscription has been configured, click. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. For more details on enabling the setting. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. KB314273: Response regarding replacement of interactive PDF and MHT files . About this book. • Reports can consist of documents with customized HTML format. For example, for a project, result caches on each node that has. Right-click the Intelligent Cube, and select Edit. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Multiple reports can access a single. 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. Build. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. Navigate to the folder location of the Intelligent Cube. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. 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. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. In the left pane, click Intelligent Cubes. 1,000Drilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. Expand Intelligent Cubes, and then select General. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. Subsequently the requests made by other users can. This command can get the correct cube status and table status only when the cube is being refreshed or published in the same session between Command Manager and Intelligence Server as this command's. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. metrics in the intelligent cube or in the MicroStrategy schema and application objects. Dedicate a machine for the metadata repository. From the File menu, select New, and then select Intelligent Cube. Drag and drop the objects into the report grid from the Report Objects pane. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. 4. Run the Report and check the SQL View. 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. The. On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. 9 The MicroStrategy REST API has been unified and expanded to include the following REST API families: Authentication API; Browsing API; Cubes API; Datasets API; Datasource Management API; Dossiers and Documents API; Emails API; Library API;. Intelligent Cube file directory Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Browse to and select a previously saved Intelligent Cube on which to build your report. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. 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. Select to move project-related objects, administration objects, or merge entire projects together. 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. MicroStrategy Web allows you to merge two or more Intelligent Cubes. 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. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. This. The Data Partition options are displayed. 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. 41. Select an Environment from the upper-left drop-down. 4. This image shows a cube with three dimensions (though really, the number of dimensions that can be contained within a cube are limitless): products, customers (by country) and posting date (year). Click Create on any folder page, point to New Report, and select Intelligent Cube Report. This knowledge base article assumes that the user has a month attribute whose format is YYYYMM as shown below and s/he wants to delete more than 12 months’. To enable or disable dynamic sourcing for an Intelligent Cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Published: Nov 19, 2018; Last updated: Nov 18, 2022;MicroStrategy version 9. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. This can improve the performance of. 3. Click OK. Browse to the folder location to store Intelligent Cubes, and then click OK. 2015-06-04 MicroStrategy Product Manuals 2015-02-01 MicroStrategy Product Manuals The OLAP Services Guide covers information on MicroStrategy OLAP. Introduction to advanced analytics 3. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. 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. 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. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. 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. 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. 1 and 10. " If you try to edit these MicroStrategy Connector cubes, you may be. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes.