The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Intelligent Cubes. Using Database Write-back Functionality to Enable Decision-Making. Public folder or a specific user folder can be selected for the creation of intelligent cubes in MicroStrategy. Both products' features range. you will work on MicroStrategy intelligent cubes which are multi-dimensional cubes that are shared as a single in-memory. A solution for this issue is available in current releases but need turn on via registry key setting. Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 89 reviews while MicroStrategy is ranked 8th in BI (Business Intelligence) Tools with 12 reviews. Instead of always executing against the data warehouse. MicroStrategy supports dimensional models well, but does not require a dimensional model. Save the Intelligent Cube. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Mention the features that are not supported by intelligent cube? Ans: Features that are not supported by intelligent cubes are: Prompt. To ensure your project has it enabled, check: 1. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. To schedule an Intelligent Cube to be updated. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. MicroStrategy is an enterprise BI application software. / -- HyperIntelligenceTM Offering Delivers Groundbreaking Zero-Click Analytics Experience MicroStrategy Incorporated (Nasdaq: MSTR), a leading worldwide provider of enterprise analytics and mobility software, today announced that MicroStrategy 201 9, the industry's first and only enterprise platform for HyperIntelligence,. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. When an Intelligent Cube is defined to support a language, data is available for the Intelligent Cube in that language. Choose File > New > Intelligent Cube. 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’. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 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. KB440835: In MicroStrategy 10. For a list of objects and features that. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. 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. 3. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. 2021 Update 6 (Août 2022) MicroStrategy Workstation. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. Flex Builder 3 support for creating powerful Internet applications with robust business intelligence. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. Report: The results of a report are used to populate the Intelligent Cube. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. MicroStrategy 9. Rather than returning data from the data warehouse for a. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the 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. MicroStrategy takes advantage of key Mapbox features that enable dossier authors to create beautiful and performant visualizations. Alternatively, you can enable caching on selected reports. 16: Intelligent Cube dirty. Ans: A report cache is a result set from an executed report that is stored on MicroStrategy Intelligence Server. 5 GB, the Data Transfer from Datasource(s) time is 77. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 4 HF 2 or 10. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 6, when users created a Dashboard or a Document using a Connect-Live Cube, using Metric Qualification with an output level that is lower than the template level and created at least 2 layers of nested aggregation on top of the cube metrics, the iServer crashes. What is a cube in Microstrategy? Intelligent Cubes: A shared Intelligent Cube (called 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 enables the development of datasets via data importing, instead of creating and modifying each new dataset from scratch. The Data Partition options are displayed. Recommends Intelligent Cube definitions for Intelligent Cubes that could be connected to by reports using dynamic sourcing. Overview What is MicroStrategy Analytics? MicroStrategy Analytics is an enterprise business analytics and mobility platform. Answer: Go with dossier. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. To learn more about Intelligent Cube Data Partition, please refer to KB237803. 0 Intelligent and Web servers for development, test and production environments. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. 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. "Navigate to the folder location of the Intelligent Cube. Users don’t have to mention the cube to which they want to connect. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. In the left panel, click Cubes. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. They have to log into the platform. x and newer. 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. 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. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. Create a report based off the cube in Step 1 that includes the description form for Category. However, importing data from a Google Drive Spreadsheet requires some additional setup. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. Your SQL Server analysis is accessible to the MicroStrategy platform as a Report, Datamart, Intelligent Cube, or on-demand retrieval using live mode. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. Right-click the Intelligent Cube, and select Edit. Datasets API. You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube. Its 64-bit architecture supports in-memory analytics with "Intelligent Cubes" (or OLAP reports cached in memory as data sets). In MicroStrategy Developer, browse to an Intelligent Cube. 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. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. MicroStrategy Intelligence Server. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. When these Intelligent Cubes are cached in memory, report manipulations, such as adding derived metrics and derived elements, formatting, and drilling within the Intelligent Cube, take considerably less time. In MicroStrategy Web 9. 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 default value is 256 megabytes. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. Project Configuration: Intelligence Cubes -> General 2. Some of the obvious benefits of this tool are its excellent data analytics capabilities, extreme scalability, and superior results. Publish the Intelligent Cube by executing it on either of the nodes. Choose Data > Configure Intelligent Cube. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Select other schedule options as required, and click OK. The Dynamic Sourcing feature in MicroStrategy OLAP Services 9. Click OK. • Created Intelligent Cubes and performed sharing to reduce the database load and decreasing the report execution time by using the cube services. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. Click the MicroStrategy icon at the upper left of any page and select History List. Normalize Intelligent Cube data in the Database using. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Normalize Intelligent Cube data in the Database. Publish the Cube, and create the following Dossier:. This report is prompted on time. Explain an Intelligent Cube? Instead of returning data from the data warehouse for a single report ,we can return sets of data from our data warehouse and save them directly to Microstrategy. The Intelligent Cube opens in the Report Editor. This returns results much faster than querying the data warehouse. Users of Intelligent Cubes in MicroStrategy 9. However, you cannot create a card based on a live-connect MDX/SAP 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. 0. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. The Report Editor opens. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. With OLAP Services features, your report designers can create Intelligent Cube reports. Choose Data > Configure Intelligent Cube. 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. Right-click the project and select Project Configuration. Recommended method by MSTR. 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. • Used Narrowcast Server for timely delivery. Mention the features that are not supported by intelligent cube? Ans: Features that are not supported by intelligent cubes are: Prompt. Select data population for Intelligent Cubes. OLAP Cube Advantages . Strong semantic layer to define all the business rules and tightly coupled. 4. x. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. Choose one of the following options: Full Refresh: This is the default. To effectively create a HyperIntelligence dataset, your data must have attributes with either one-to-one relationships or many-to-one relationships. Edit Intelligent Cubes from the new editor in Workstation at any time. 0. It is possible for the users to use it as a web-based or a desktop tool. 3. Stand out in a crowd. This copy of report data is stored in Intelligence Server memory only. - 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. ACTION: A fix for this issue is included in MicroStrategy 10. The first is to enable report caching at the project level. Required Status to Perform Action. the scheduler that manages the data lake updates, the ability to initiate an on-demand cube refresh immediately after the data lake update is complete. 4. Select Intelligent Cubes > General > Intelligent Cube File directory. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties dialog. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. See KB484738 for more information. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. You can mention the two features which the Intelligent Cube doesn’t support and they are OLAP Service and the second is Prompts. Drag and drop the objects into the report grid from the Report Objects pane. For a description of all Intelligent Cube statuses, see. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. 0, while MicroStrategy is rated 8. In the left pane, click Intelligent Cubes. In MicroStrategy Tutorial Project, create an In-Memory Intelligent Cube by importing the following Database Tables. Set the path for the cube cache file directory to . Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. . 1. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Right-click an Intelligent Cube and select Delete. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. The path for cube files must be shared as "ClusterCube". Using MicroStrategy Developer, log in to a project connected to an MDX cube source. OLAP services: Derived metrics and viewed filters cannot be supported. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 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 MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 4. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Create a security filter on the region attribute such as region not in list central. In Developer, from the File menu select New, and then Intelligent Cube. To Create an Intelligent Cube Using Freeform SQL or Query Builder. 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. . You must belong to the System Administrators group to use this feature. The Intelligent Cube Options dialog box opens. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. The following table summarizes the test results of some test scenarios against Oracle 19c. In the Data Source column, select the checkboxes for the tables to update. 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. To enable. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. The New Grid dialog box opens. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. (Intelligent Cube configuration is not relevant in MicroStrategy 8. Create a subset. MicroStrategy Intelligence Cube. x releases. MicroStrategy Developer, MicroStrategy Web, and MicroStrategy Office users can slice and dice data in reports within the Intelligent Cubes without having to re-execute SQL against the data warehouse. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes ” and we will be able to select our optimal option. CREATOR: User who created the Intelligent Cube cache, returned as a string. For information about general rules that apply when security filters are applied on view reports based on Intelligent Cubes, refer to the. For additional information on how Data Scientists and users of other analytics tools can use MicroStrategy, visit the MicroStrategy Community. 1, Data Import allows users to maintain intelligent cubes from external Excel files. · Update the schema in 2-tier. 0 has a dedicated section to memory used for Intelligent Cubes. Recommends and creates Intelligent Cubes that could provide data to reports using dynamic sourcing. Select the Allow reports to drill outside the Intelligent Cube check box. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. During card design, select from different widgets, matrix views, and card header formats to best display data. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Refer to the following MicroStrategy Knowledge base document for general remarks on security filter application to Intelligent Cubes where not all of the security attributes are found. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. The Intelligent Cube opens in the Report Editor. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Select other schedule options as required, and click OK. Navigate to the folder location of the Intelligent Cube. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Metrics and attributes are created once and used across different types of reports. Browse to and select a previously saved Intelligent Cube on which to build your report. 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. Slice and dice features are awesome. Share query results in-memory across multiple dossiers and reports. Complex metrics here refer to metrics which are defined using multiple. Telcos need network capacity planning and optimization by correlating network usage, subscriber density, along with traffic and location data. Although the company’s platform was traditionally deployed on premises, customers increasingly wanted to create. 4. In the Object name field, type a descriptive name for the Intelligent Cube. x-10. The Intelligent Cube refresh settings are recommended if the data in the. 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. MicroStrategy 9. . x?. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. On. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. MicroStrategy administrators can automatically ensure that business users always have the most current information by configuring the Intelligent Cube data to expire or. Recorded at World 2021. MicroStrategy 9. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. Drag and drop the objects into the report grid from the Report Objects pane. Browse to an Intelligent Cube, select it, and then click OK. Multiple reports can access a single. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . As an extension of MicroStrategy Intelligence Server, OLAP Services uses Intelligent Cube Technology—an in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. Published: Nov 19, 2018; Last updated: Nov 18, 2022;The Full Refresh option is the default. Analyze SQL Server data with multiple tools. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Login to MicroStrategy Web, create a cube with the function of Data Import 2. The objects in the source cubes will control how the security filter will be applied. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. This can improve the performance of. 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. Strong semantic layer to define all the business rules and tightly coupled. 4. Run a dossier based on the cube. In Developer, log into a project. Providing Intelligent Cube data. See Managing Intelligent Cubes. 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. Right-click an Intelligent Cube and select Delete. To change the status of an Intelligent Cube, right-click that Intelligent Cube and select the desired action from the list. To build an Intelligent Cube. I assume both these "cubes" organize data in a way that is easy and fast to use for dimensional queries, but I don't think you can import directly an Oracle cube into. Creates the Intelligent Cubes you decide should be created. Sharing data. 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 . Intelligent Cube storage on disk mirrors report cache storage. The. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Enable users to interact with personalized chat for further product discovery. Subsequently the requests made by other users can. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. Although the directory filed shows the same location as the source project, cubes are saved to a. Benefits of Intelligent Cubes include: Greater Efficiency - Intelligent Cubes are automatically generated and shared among all users whenever a. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. Recommends Intelligent Cube definitions for Intelligent Cubes that could be connected to by reports using dynamic sourcing. Select the data set and click Prepare Data. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. The Intelligence Cube is updated (republished) based on the cube republish setting. 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. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. 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%. Microsoft BI based on real PeerSpot user reviews. By default, the location configured will be a relative path where ". CONTENT: Enable cube. 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. Traditional Report Caching in MicroStrategy is done on a matching basis. 4 types: matching caches, history caches, matching-history caches, and xml caches. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. NAME: The name of the Intelligent Cube, returned as a string. Create a report based on above Cube and add the prompt in view filter. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". The ability to view or edit certain settings is determined by a user's privileges. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. The most obvious workflows where you can expect to see performance improvements: Project loading during MicroStrategy Intelligence server startup Intelligent cubes are generated automatically when a new report is run against the data warehouse. x and 10. 20. This article describes the Intelligent Cube Population options available in MicroStrategy MicroStrategy provides ETL, data warehousing and data mining for data analysis. Publish the cube. The top reviewer of Microsoft BI writes "User friendly,. This report is prompted on time. com Format: A MicroStrategy Online Training Video blog. You can create and analyze new reports in real time. Users don’t have to mention the cube to which they want to connect. Check the number of CPU cores. The Full Refresh option is the default. The Intelligent Cube Monitor is displayed. To view the details of an Intelligent Cube, double-click that Intelligent Cube. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. ACTION: This issue has been fixed in MicroStrategy 10. The following diagram depicts the role of the intelligent cube. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. Two unique methods to implement Intelligent Cube Technology: •Personal Intelligent Cubes. Teradata suggests the use of fully normalized physical schemas (specifically, Third Normal Form or 3NF). Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. Updating Intelligent Cubes without re-processing: Incremental Refresh. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. 0. Speed: Aggregating (Summarizing) the data for performance with processing Cube. If the Intelligent Cube must be re-processed based on a metric. Do not normalize Intelligent Cube data. Visit the data visualization and data dashboard galleries for inspiration. 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. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. 4, Command Manager script for listing. Select the Intelligent Cubes tab. Dynamic Sourcing. Select a schedule from the Schedule drop-down list. Navigate to the Data Refresh category. This can be done by selecting Run Report in the toolbar. To enable or disable dynamic sourcing for an Intelligent Cube. xCreate Intelligent Cube Reports. This article describes best practices to be taken when using a Teradata database in MicroStrategy. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. However, if the. In the Data Source column, select the checkboxes for the tables to update. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. In either case, the Intelligence Server is responsible for determining the lists of distinct attribute elements, and this operation is always case sensitive. MicroStrategy 2021 Update 9 introduces the ability to create Intelligent cube reports based on an Intelligent cube. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. 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). With OLAP Services features, your report designers can create Intelligent Cube reports. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. 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. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. Choose one of the following options: Full Refresh: This is the default. x. Description: Intelligent Cube design and utilization; how to build cubes.