The Subscription Creation Wizard opens. Name the different export. 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. If you use Enterprise Manager (EM),. Right-click an Intelligent Cube and select Delete. 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 . Place intelligence server close to the both the data warehouse and the metadata repository. 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. The view filter cannot filter out other elements as shown below:The cube associated with the . The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. The ability to view or edit certain settings is determined by a user's privileges. 40. Click Select. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. 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. The status of each Intelligent Cube is listed in the. Create a report based off the cube in Step 1 that includes the description form for Category. Comparing OLAP and MTDI cubes. Publish the cube. Number of. When an Intelligent Cube. intelligence company. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. For more information on security filters, see the System Administration Guide. 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. Created narrowcast services to email /send to a directory either report service documents in PDF or excel files. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. MicroStrategy Intelligence Server . The Intelligent Cube Options dialog box opens. Edit Intelligent Cubes from the new editor in Workstation at any time. You can edit project-level cache and Intelligent Cube settings. View the report in either Grid View or Grid and Graph View. Overview. Save the workflow in . The default value is 256 megabytes. Intelligent cubes support time zone based reporting. 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. Find Cube Task . The maximum value is 9,999,999 and the minimum value is 0. If you are upgrading to MicroStrategy 11. This article notes how support for transformation metrics in Dynamic Sourcing works. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. The Intelligent Cube opens in the Report Editor. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Because the filters are applied to the master data in the Intelligent. The Intelligent Cube Options dialog box opens. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. ; 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. Select an Environment from the upper-left drop-down. All necessary privileges are included in the Administrator role by default. View reports vs Cubes as datasetsTo unpublish an Intelligent Cube. Provides the last cube row count. 0 MicroStrategy releases. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Every time that a user does something in MicroStrategy, like. 11 on Unix/Linux Number of Views 2. xUse the same attribute in filter in Intelligent Cube and incremental refresh filter. Cube and Cache Metric Names. Intelligent Cubes erstellen. File subscriptions save the report or document as an Excel or PDF file to a disk location on the network. To schedule the publication of Intelligent Cubes. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. Information to use MicroStrategy OLAP Services features, including Intelligent Cubes, derived metrics, derived elements, dynamic aggregation, view filters, and dynamic sourcing. 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. 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. Sharing data. HIDDEN: Whether or not the Intelligent Cube is hidden, returned as a boolean value. Users of Intelligent Cubes in MicroStrategy 9. x This is a new feature introduced in MicroStrategy version 9. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. The Intelligent Cube Monitor is displayed. Creating an Intelligent cube is similar to creating a report. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. Name the different export. 1, Data Import allows users to maintain intelligent cubes from external Excel files. It accesses and joins 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. 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. This document discusses a specific case regarding how security filters are applied when the Intelligent Cube has non-aggregatable metrics. 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 executed in. Publish the specified Intelligent Cube to the Intelligence Server, so that it can be used by reports. This issue was reviewed by our Technology team for feasibility and will not be scoped for a code fix in any upcoming MicroStrategy release. Defining Intelligent Cube refresh settings. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . However, Intelligent cube publishing performance may be affected with the agent enabled. 7 or later, non-distributive metrics do not return correct data because the Engine does double aggregation due to the optimization done in DE81833. What are advantages of cubes? It perform fast It Schedule the Cube It is used for Drilling It helps in Data Sharing. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. 3. 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. Navigate to and run the Intelligent Cube report. 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. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. MicroStrategy Intelligence Server . To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. 0: PDF export comparison. Par défaut, elle est définie sur 32 000. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. 1 and 10. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. 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. 4. 1. The following diagram depicts the role of the intelligent cube. Add data from existing reports, documents, and Intelligent Cubes. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. 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. 1, Windows 2003 and UNIX. In MicroStrategy 9. Right-click an application and choose Properties. Although this technique improves document performance, the amount of time required to publish an Intelligent Cube increases as it grows in size. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Subsequently the requests made by other users can. 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. Publish Intelligent Cube statement. From the Edit menu, select Training Metric Wizard. CAUSE. 3. The Query Engine runs the SQL required to refresh the data in the Intelligent Cube. If you are upgrading to MicroStrategy 11. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Administering MicroStrategy: Managing the Intelligence Platform User privileges and data access Monitoring and tracking the analytics system Administering MicroStrategy Mobile. Disconnect from the project source and restart both Intelligence servers. 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. g. What is HyperIntelligence? In 2019, MicroStrategy invented a new solution for a conventional problem in the analytics industry. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. 4 to MSTR 2019 U2. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. 6, the MicroStrategy PDF Exporter (also known as New Export Engine or NEE) service has been added to support exporting from. You can add data for your Intelligent. 39. 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. Each user that connects to the MicroStrategy Intelligence server and/or project has a unique. KB485226: Intelligent Cube size increases irrespective of the "Maximum % growth of Intelligent cube to 50%" governing setting. Click here to view details about the Intelligent Cube Monitor. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. x. The Intelligent Cube Monitor is displayed. Confidential, Hyderabad, India Dec 03 to. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. This option is enabled by default. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). This defect is addressed in MicroStrategy 11. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. 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. Recorded at World 2021. Main features of mstrio-py allows to access MicroStrategy data: Connect to your MicroStrategy environment using Connection class (see code_snippets) Note: to log into Library and use mstrio-py user needs to have UseLibrary privilege. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. In MicroStrategy 10. The Intelligent Cube Monitor is shown in the image below. This property can only be enabled through Workstation. For example, the attributes Year and Region and the metrics Cost and Revenue are included in the Intelligent Cube shown in the image above. 5. Afterwards the cube will start executing. 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). Save the file in . This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. Number of Views 391. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. In addition to creating reports directly, you can use the Freeform SQL Editor or Query Builder Editor to create an Intelligent Cube. KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. 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‘. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. Learning Resources. I have I-cubes with billions of rows stored in memory. 4. 2. Loading. Navigate to the Data Refresh category. Click All Objects View. 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. "The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. Select the Data Partition category. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". 4. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. MicroStrategy online help and PDF manuals (available both online and in printed format) use standards to help you identify certain types of content. Import and filter data from a OlapCube, SuperCube or Report into a Pandas DataFrame (see code. 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. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. 4. Drilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. The Intelligent Cube opens in the Report Editor. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. 18K. Browse to and select a previously saved Intelligent Cube on which to build your report. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory reduces response time for reports using them. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. Email subscriptions deliver a report or document to one or more email addresses. In the New Intelligent Cube dialog box, select the MDX Sources tab. About this book. Expand Intelligent Cubes, and then select General. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. CAUSE: This is working as designed. The maximum cube size is set by the "Maximum cube size allowed for download" field (in MicroStrategy Developer, in the Project Configuration dialog box, choose Intelligence Cubes > General) Users with security filters subscribing to a Visual Insight dossier built on a cubeUpdate 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. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. On the toolbar, choose Data > Configure Intelligent Cube. Intelligent Cubes. 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. 41. If the welcome page is shown, review the information and click Next. 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. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Defining the partition for Super Cubes. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. x releases, and the new Multi-table Data Import (MTDI) cubes. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. Number of Views 1. In MicroStrategy Web, you can. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. Configure a Cluster with a Centralized Cache. The ability to view or edit certain settings is determined by a user's privileges. 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. Depending on location set at the project level, one or none of the Intelligence server nodes will be able. idx file is cleaned up. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports. Browse to the folder location to store Intelligent Cubes, and then click OK. Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. 4. In MicroStrategy Developer, browse to an Intelligent Cube. Right mouse click on the cube and choose Schedule 3. • OLAP cubes that can be entirely based on memory. Intelligent Cubes. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. However, after publishing,. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 5 GB, the Data Transfer from Datasource(s) time is 77. The fact that the Intelligent Cube resides on the. To enable or disable dynamic sourcing for an Intelligent Cube. MicroStrategy OLAP Services is an extension to MicroStrategy Intelligence Server that allows MicroStrategy Web and Desktop users to manipulate Intelligent Cubes™. . 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. You can also apply this security when users create reports that connect to an Intelligent Cube. Creating Intelligent Cubes based on. Decision Maker、Intelligent E-Business、Personalized Intelligence Portal、Query Tone、Rapid Application Development、MicroStrategy Intelligent Cubes、The Foundation For Intelligent E-Business 、The Integrated Business Intelligence Platform Built For The Enterprise 、 The Platform For Intelligent E-Business、The Scalable Business. Save the Intelligent Cube. You can return data from your data warehouse and save it to Intelligence Server memory, rather than directly displaying the results in a report. In the left pane, click All Settings. To effectively create a HyperIntelligence dataset, your data must have attributes with either one-to-one relationships or many-to-one relationships. From the Data menu, select Configure Intelligent Cube. 4. This property can only be enabled through Workstation. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 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. 4. Choose Data > Configure Intelligent Cube. Select other schedule options as required, and click OK. MicroStrategy 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. 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. Right-click the dataset, and choose Schedule. Pages 272 Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Rather than returning data from the data warehouse for a single. Create a Report 'R3' with 'Country' attribute. Sharing data. The display of data is handled by the reports that access the Intelligent Cube. 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. In the left panel, click Cubes. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. 1 and 10. Beginning in MicroStrategy 10. x -10. MicroStrategy will continue to investigate and post updates as soon as they are. 0: Balance MicroStrategy Server threadsReporting on an Intelligent Cube provides quick access to data, as the data has been pre-aggregated. 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. Published: 4월 6, 2017. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Upgrade to those versions to take advantage of the fix. Select the data set and click Prepare Data. However, importing data from a Google Drive Spreadsheet requires some additional setup. For more information on the Intelligent Cube Maximum. The Intelligent Cube Editor opens. This article also provides a workaround to avoid this behavior. Select an Environment from the upper-left drop-down. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Download the attached PDF for an in-depth understanding of Object Migration best practices. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Intelligent Cubes can be partitioned,. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 0. Multiple reports can access a single. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. 3. This file stores cache matching. This data can be used to create a. Results 1 - 20 of 100 What are the feature flag options and what do they accomplish in MicroStrategy Web 10. Have full control over result, element, and object caches in a project. 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. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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 population process could be expensive in time and memory if the cube is large. x product documentation "InMemoryAnalytics. Limit data to specific values: Filters 4. Click OK. 0. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. To enable or disable dynamic sourcing for an Intelligent Cube. An Intelligent Cube has been created in a project. Published: Apr 6, 2017. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Build. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. You can control users' access to data with security filters. From the Data menu, select Configure Intelligent Cube. x This is a new feature introduced in MicroStrategy version 9. 88K KB41697: "The Intelligent Cube must be published before this report can be executed. 0 MicroStrategy releases. 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. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. Republish DI Cube. 4. 40. LIST PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "<intelligent_cube_name>" | GUID <instance_guid>) FOR PROJECT "<project_name>"; An enhancement request has been raised to have the ability to use “cube as trigger”. The Intelligent Cube must be published before this report can execute. To view embedded fonts in Web, the fonts must be installed on the Intelligence Server machine. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. . The Parallel Query Execution is an advanced property which determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results faster and publish Intelligent cubes. 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. 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;. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. 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. See Memory Mapped Files for Intelligent Cubes for more. Managing Intelligent Cubes. Right-click the dataset, and choose Schedule. In the Data Source column, select the checkboxes for the tables to update. 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. 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. KB30713: Data outside a user's security filter are indirectly available through set qualifications used in Intelligent Cubes in MicroStrategy OLAP Services; KB30714: Handling of security filters with multiple qualifications applied to Intelligent Cube view reports in MicroStrategy OLAP Services; Article Reference Number: KB99998 In the Navigation pane, click Monitors. The following table summarizes the test results of some test scenarios against Oracle 19c. The ability to view or edit certain settings is determined by a user's privileges. Watch on. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. 4. The default value is 256 megabytes. Query Generation. If you are upgrading to MicroStrategy 11. When an Intelligent Cube is in this status, any reports based on this cube have. als Berichtsobjekte oder Berichtsfilter einschließen. 6.