The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. For more information on security filters, see the System Administration Guide. A discussion of pre-MicroStrategy 2020 behavior can be found in the article, KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. ; In-depth knowledge of fundamental data warehousing concepts such as entity relational modelling, dimensional modelling, star and snowflake schemas, modelling data marts, front and back room architectures, security and. Restart the MicroStrategy Intelligence Server. Build a cube of customer data that’s relevant to all employees and publish it. Dynamic Sourcing. It takes you from setting up and configuring MicroStrategy to security and administration. MicroStrategy for Tableau allows you to fetch data from reports or cubes that reside in MicroStrategy projects into Tableau Public (also known as Tableau Desktop). In MicroStrategy Tutorial Project, create an In-Memory Intelligent Cube by importing the following Database Tables. This includes the following: To review and create recommended Intelligent Cubes using Cube Advisor. See Managing Intelligent Cubes. The objects in the source cubes will control how the security filter will be applied. If no data is returned for a report that is connected to an Intelligent Cube, this can be caused by the following scenarios: The view filter for the report is too restrictive (see View Filters ). In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 20. Intelligent Cubes. x. To do so, you can take advantage of URL API. MicroStrategy comparison, we will tackle four aspects of the platforms: user interface, data sources integration, visualizations, and pricing. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. Ans: A report cache is a result set from an executed report that is stored on MicroStrategy Intelligence Server. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. 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. CREATOR: User who created the Intelligent Cube cache, returned as a string. 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%. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. Intelligent Cubes. 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. This file stores cache matching. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. With OLAP Services features, your report designers can create Intelligent Cube reports. Multi-pass SQL is required to answer analytical questions that cannot be. If the welcome page is shown, review the information and click Next. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. MicroStrategy takes advantage of key Mapbox features that enable dossier authors to create beautiful and performant visualizations. If removing the view filter does not. Expand Intelligent Cubes, and then select General. Click the MicroStrategy icon at the upper left of any page and select History List. Click All Objects View. Con: The copy of report data in Intelligence Server memory only applies to a single report. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties dialog. In MicroStrategy Web 9. 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. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. The first part discusses the behavior of both the MicroStrategy semantic SQL Query engine layer and the Snowflake temporary. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. The partition attribute is the attribute that is used to divide. Save the Report and close. However, you cannot create a card based on a live-connect MDX/SAP cube. Add objects such as attributes, metrics, and so on for the Intelligent Cube, the same. 9 and above. x and newer. you will work on MicroStrategy intelligent cubes which are multi-dimensional cubes that are shared as a single in-memory. 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. This report is prompted on time. Expand the Object Templates category, select General, and. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". What are the advantages of cubes in MicroStrategy? Ans: The advantages of cubes are: Supports derived metric creations;. MicroStrategy OLAP Services uses the concept of Intelligent Cube, an in-memory version of a report that can be manipulated by the Analytical Engine. 3. 3. It will remain available, but the setting will not. The Data Partition options are displayed. Right-click the project and select Project Configuration. It allows users to customize data visualizations and build personalized real-time dashboards. Recommends Intelligent Cube definitions for Intelligent Cubes that could be connected to by reports using dynamic sourcing. This article describes best practices to be taken when using a Teradata database in MicroStrategy. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. 0 MicroStrategy releases. The prompt in the document is an attribute qualification prompt on the same attribute that is common to. An example of this behavior for a relatively small cube is shown in the screen shots below:Right-click the report and select Edit. Cube and Cache Metric Names. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Multi-pass SQL . Sharing data. MicroStrategy administrators can automatically ensure that business users always have the most current information by configuring the Intelligent Cube data to expire or. ) As long as each node is using the same server definition, the setting of the cache and history list locations in the Intelligence Server configuration only needs to be done once; however, the creation of the shared folders will need to be done on each node. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":Using MicroStrategy, manufacturers can run Big Data analytics on disparate sources to achieve perfect order rates and quality, and to get in-depth consumption patterns. Visit the data visualization and data dashboard galleries for inspiration. Click OK. Choose one of the following options: Full Refresh: This is the default. Create a subset. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. These restrictions are applied automatically when creating prompts. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. This is particularly useful when there exist many Intelligent Cubes that have to be published but require a high amount of memory in the process so executing them, all at the same time is not feasible. Traditional Report Caching in MicroStrategy is done on a matching basis. In Developer, from the File menu select New, and then Intelligent Cube. The Intelligent Cube Monitor is displayed. This can improve the performance of reports, which get executed against an Intelligent Cube, without having to manually find and select the Intelligent. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. CONTENT: Enable cube. Share query results in-memory across multiple dossiers and reports. With OLAP Services features, your report designers can create Intelligent Cube reports. Public folder or a specific user folder can be selected for the creation of intelligent cubes in MicroStrategy. Right mouse click on the cube and choose Schedule 3. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. To build an Intelligent Cube. 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. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Defining the partition for Super Cubes. 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’. This is the most popular MicroStrategy Interview Question asked in an interview. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. Choose File > New > Intelligent Cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. 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. 2. Updating Intelligent Cubes without re-processing: Incremental Refresh. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Normalize Intelligent Cube data in the Database using. •The platform is based on an in-memory architecture that can partition cubes and process data in. 19. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. Although the directory filed shows the same location as the source project, cubes are saved to a. When an Intelligent Cube is published, the Intelligent. Recommends and creates Intelligent Cubes that could provide data to reports using dynamic sourcing. The Report Editor opens. This can be done by selecting Run Report in the toolbar. MicroStrategy and other OLAP tools incorporate intelligent and secure Cube data sharing capabilities, ensuring the secure sharing of data. Open the Workstation window. What are the features which the Intelligence cube doesn’t support generally? This is basically a trick question and is generally asked from those who have experience in the Microstrategy tool. From the Data menu, select Configure Intelligent Cube. 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. 19. Select the Allow reports to drill outside the Intelligent Cube check box. The Dynamic Sourcing feature in MicroStrategy OLAP Services 9. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Speed: Aggregating (Summarizing) the data for performance with processing Cube. idx file is cleaned up. Learn more about it at MicroStrategy. If no data is returned for a report that is connected to an Intelligent Cube, this can be caused by the following scenarios: The view filter for the report is too restrictive (see View Filters ). The reports accessing Intelligent Cubes can use all of the OLAP Services features for analysis and reporting. LIST ALL INTELLIGENT CUBES IN FOLDER "Intelligent Cubes" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. Right-click the Intelligent Cube, and select Edit. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. x a new concept is introduced called Intelligent Cubes. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. 0. Advantages of OLAP Tools. Solution for In a variety of methods, MicroStrategy produces intelligent cubes. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. STEPS TO REPRODUCE: 1. When an Intelligent Cube is defined to support a language, data is available for the Intelligent Cube in that language. 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%. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. 1. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. In the Navigation pane, click Applications. If the Intelligent Cube must be re-processed based on a metric. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. 39. The Schedule dialog box opens for your dataset, showing the tables in your dataset. OLAP services: Derived metrics and viewed filters cannot be supported. The user experience is confusing for the users. 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. Professional Summary. The MicroStrategy Intelligence Server 9. Telcos using MicroStrategy can run. You can also supply a MicroStrategy Enterprise Manager report to include more information on the performance benefits of each Intelligent Cube as part of your dynamic sourcing strategy. x releases. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. Slice and dice features are awesome. Select Empty Intelligent Cube and click OK. MicroStrategy 9. The Full Refresh option is the default. The Intelligent Cube Options dialog box opens. 1. Metrics and attributes are created once and used across different types of reports. Save the Intelligent Cube. Multiple reports can access a single. The fact that the Intelligent Cube resides on the. On. In either case, the Intelligence Server is responsible for determining the lists of distinct attribute elements, and this operation is always case sensitive. KB46934: Reports created from a MicroStrategy Data Import Intelligent cube are hidden in MicroStrategy Web. Choose one of the following options: Full Refresh: This is the default. The MicroStrategy OLAP Services Guide lists the features that prevent Intelligent Cubes from being available for dynamic sourcing. Users don’t have to mention the cube to which they want to connect. " maps to the Intelligence Server working directory (when using default locations, this will be C:\Program Files (x86)\MicroStrategy\Intelligence Server). For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. If you do not use connection mapping, leave this check box cleared. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Disconnect from the project source and restart both Intelligence servers. By using a single Intelligent Cube to support all the security filters for a project, data access security is implemented automatically with minimal burden on Intelligence Server memory. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. To learn more, read our detailed. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesIn the Navigation pane, click Monitors. Microstrategy is actually based on the single meta-data repository. You can create and analyze new reports in real time. 2. Intelligent Cubes are automatically built once and stored in MicroStrategy’s unified metadata on the centralized server, where they can be shared across the enterprise. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. In most cases, the automation in the semantic layer provides more considerable resource savings than maintaining multiple custom SQL query Intelligent Cubes in memory that do not relate to each other. The Save Intelligent Cube As dialog box opens. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Create an attribute element prompt for the. Intelligent Cube storage on disk mirrors report cache storage. Total Cubes This section displays the total count of cubes by status. HIDDEN: Whether or not the Intelligent Cube is hidden, returned as a boolean value. 6 plus years in Data warehousing, Business Intelligence systems, OLAP environments and tools. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. MicroStrategy Analytics cubes are easy to create and deploy. See KB484738 for more information. In Developer, log into a project. Select the Intelligent Cubes tab. This will work as a regular SQL comparison In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:MicroStrategy provides a powerful analytics and mobility software platform that its customers use to gain actionable intelligence from their data and deliver answers to 100 percent of their workforce through innovative solutions. The New Grid dialog box opens. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Create Cube2 with the Region attribute and the metric created in step 1. Choose Data > Configure Intelligent Cube. 0. The application is named MicroStrategy Cube. CAUSE: This is a known issue in MicroStrategy 10. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. The New Intelligent Cube dialog box opens. Users don’t have to mention the cube to which they want to connect. MicroStrategy 9. The. Refer to the tech note below for more information: KB32502 - Support for transformation metrics for Dynamic Sourcing in MicroStrategy OLAP ServicesNormalize Intelligent Cube data in Intelligence Server (typically faster, but may temporarily use more memory in Intelligence Server). An Intelligent Cube has been created in a project. One of the main advantages of OLAP is that it allows you to perform complex and fast queries on large amounts of data. It turns data into reports for making and executing key organization decisions. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Click Select. Number of Views 1. You can edit project-level cache and Intelligent Cube settings. Strong semantic layer to define all the business rules and tightly coupled. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn 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. You must belong to the System Administrators group to use this feature. 4. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. This is due to the fact that adding prompts to Intelligent Cubes is not supported. Intelligent Cubes as datasets. 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. In the left pane, click Intelligent Cubes. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. The **_objects folder with a size of 277G. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Then the warehouse will have to repeat similar calculations for each report. After a report. 2. (Intelligent Cube configuration is not relevant in MicroStrategy 8. x. You can also create Intelligent Cubes by directly querying your data. MicroStrategy vs. The Report Editor opens with all of the objects of the Intelligent Cube. From the Data menu, select Configure Intelligent Cube. SYMPTOMS: After duplication of a project in Developer that has a user-defined Intelligent Cube cache location, Intelligent Cubes created within the new project are not saved to the location specified in Intelligent Cube File Directory in Project Configuration. Reports cannot combine data from multiple Intelligent Cubes. · Update the schema in 2-tier and reload the project from the Project Monitor. Schedule administrative tasks and reports to run during off-peak hours, so that they do not adversely affect system performance. 11 it is possible to have split child hierarchy attributes join through a shared fact table rather than through a parent with Data Import Cubes. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. Platform Analytics is the new monitoring tool in MicroStrategy 11. The path for cache files must be shared as "ClusterCaches". 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. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. To schedule an Intelligent Cube to be updated. 3. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. If you are upgrading to MicroStrategy 11. Both properties are located in the Query Optimizations folder in the VLDB property editor. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. A Quick View window opens, with detailed information about the Intelligent Cube. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. Traditional Report Caching in MicroStrategy is done on a matching basis. Microsoft BI based on real PeerSpot user reviews. Click All Objects View. An Intelligent Cube is an In-Memory data structure which. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. A MicroStrategy Business Intelligence Developer can earn US$117,000/year – Indeed. 0 MicroStrategy releases. Click OK. - Full of advanced features like data storage in MicroStrategy cubes for faster reporting times, advanced grouping and filtering, ability to write your own SQL in the backend, ability to customize using SDK interface - MicroStrategy Mobile is game changer. Vn (with metric Mn from source cube Cn). Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. Refresh. Rather than returning data from the data warehouse for a. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . To build an Intelligent Cube. QUESTIONIn 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. Mention what are the business benefits of Microstrategy Narrowcast Server? Ans: The business benefits of Microstrategy Narrowcast Server is that it provides an inexpensive way to send corporate information to. e. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. This article also provides a workaround to avoid this behavior. Dossiers automatically adjust to look great on any screen. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Exporting Multiple Grids to Microsoft Excel. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. By storing your data in your Intelligence. Select the Create Intelligent Cubes by database connection check box. 17. - Normalize Intelligent Cube data in the. - Normalize Intelligent Cube data in the. x -10. The Intelligent Cube Options dialog box opens. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. 3. MicroStrategy 2021 Update 9 introduces the ability to create Intelligent cube reports based on an Intelligent cube. arrow_forward Explore the use of computational systems in the field of artificial intelligence and machine learning, emphasizing the role of GPUs and TPUs. Normalize Intelligent Cube data in the Database. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Create the metric levels log file used to track the use of dynamic sourcing. . From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. This template includes the following tasks: Creates a new metadata. NAME: The name of the Intelligent Cube, returned as a string. Before 10. MicroStrategy needs to define which one they will use. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. 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. Subsequently the requests made by other users can. IBM Cognos Conversion Startup Program Key Benefits 14 Convert to MicroStrategy to Enable the Intelligent Enterprise. Select the data set and click Prepare Data. The ability to view or edit certain settings is determined by a user's privileges. blogspot. 50. To change the status of an Intelligent Cube, right-click that Intelligent Cube and select the desired action from the list. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. Answer: Go with dossier. For information on locating and using this Enterprise Manager report, see Enterprise Manager report for Cube Advisor . The Intelligent Cube Options dialog box opens. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. The Intelligent Cube opens in the Report Editor. You may have an existing entry, other than unlimited. xCreate Intelligent Cube Reports. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. From the Categories list, expand Options, and then select General. Configurez les agrégations de mesures, la gestion des valeurs nulles, l’indexation, etc. 15K. 1,000Indicates a user published an intelligence cube from any tool (Web, Developer, etc). When using an Intelligent Cube, you already have an in memory dataset. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. During card design, select from different widgets, matrix views, and card header formats to best display data. Although it seems at first sight that the resolution of intelligence in small business is competitive, you will quickly find that the addition of all required units quickly raises the price to levels close to cognos. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. x and 10. The. Login to MicroStrategy Web, create a cube with the function of Data Import 2. The following table summarizes the test results of some test scenarios against Oracle 19c. Instead of always executing against the data warehouse. 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. For more information on the Intelligent Cube Maximum. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. You can perform all of your reporting and data analysis requirements within an Intelligent cube without executing against the data warehouse. In the Object name field, type a descriptive name for the Intelligent Cube. The New Intelligent Cube dialog box opens. Configure a Cluster with a Centralized Cache. KB442264 : In-Memory query against Intelligent Cube incorrectly does a cross join instead of joining through available tables using which the attributes could be joined. Right-click the report and select Edit.