Intelligent cubes in microstrategy pdf. The partition attribute is the attribute that is used to divide. Intelligent cubes in microstrategy pdf

 
 The partition attribute is the attribute that is used to divideIntelligent cubes in microstrategy pdf  6

In MicroStrategy Web 9. Published: Apr 6, 2017. The Intelligent Cube Options dialog box opens. This will reduce the memory usage from 150GB to 100GB. Visit the data visualization and data dashboard galleries for inspiration. 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). Number of Views 1. 2. Both products' features range. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice analysts to the most experienced Intelligence Center architects. 2. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Push-Down Derived Attributes for Live Connection Cubes In MicroStrategy 10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. MicroStrategy World 2014: Scaling MicroStrategy at eBay - Download as a PDF. See Memory Mapped Files for Intelligent Cubes for more. Download the attached PDF for an in-depth understanding of Object Migration best practices. To learn more about Intelligent Cube Data Partition, please refer to KB237803. Subsequently the requests made by. mstr file is too large. If you are upgrading to MicroStrategy 11. Upgrade to those versions to take advantage of the fix. 40. Select the Intelligent Cubes tab. "The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. 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. MicroStrategy Developer et MicroStrategy Web peuvent extraire de manière incrémentielle les lignes d'élément d'Intelligence Server. You can use Integrity Manager to perform a before and after test to identify which reports actually connect to a suggested Intelligent Cube and also to test data integrity. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. The New Grid dialog box opens. 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. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. x: Ability to encrypt cache files stored to disk. The Intelligent Cube opens in the Report Editor. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. 2. As of MicroStrategy Secure Enterprise 10. Note that this document does NOT provide a value for all the given settings but provides a list of all possible settings that can help improve the Cube Publication times. 4. Watch on. HIDDEN: Whether or not the Intelligent Cube is hidden, returned as a boolean value. Dedicate a machine for the metadata repository. With OLAP Services features, your report designers can create Intelligent Cube reports. KB485673: When "Create Intelligent Cubes by database connection" is enabled, the cube published with the latest data can't… Number of Views 157 KB484562: Intelligence Cubes are not published via subscriptions to both nodes of cluster in MicroStrategy 2019 and later. Export to PDF, web sort, document design. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among. 4. 2. 4. The reports accessing Intelligent Cubes can use all of the OLAP Services features for analysis and reporting. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. Intelligence Server Statistics . Expand Intelligent Cubes, and then select General. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. However, importing data from a Google Drive Spreadsheet requires some additional setup. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. Providing Intelligent Cube data. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. 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. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". 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. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. ACTION: A fix for this issue is included in MicroStrategy 10. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Created narrowcast services to email /send to a directory either report service documents in PDF or excel files. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). 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;. Save the Report and close. (MDX) for interactively accessing cube databases from SAP, Microsoft AnalysisThis setting also defines when Intelligent Cubes are saved to secondary storage, as described in Storing Intelligent Cubes in Secondary Storage. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. This command can get the correct cube status and table status only when the cube is being refreshed or published in the same session between Command Manager and Intelligence Server as this command's. 15K. This property can only be enabled through Workstation. However, Intelligent cube publishing performance may be affected with the agent enabled. Use the table below as a guide to determine whether switching to a single Intelligent Cube as dataset can improve the performance in your environment: 3. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. 3. Privilege. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. Because the filters are applied to the master data in the Intelligent. Subsequently the requests made by other users can. Add data from existing reports, documents, and Intelligent Cubes. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. Vn (with metric Mn from source cube Cn). 1 and 10. With OLAP Services features, your report designers can create Intelligent Cube reports. Microstrategy's Visual Insight is used as a self service tool replacing Pivot tables &amp; graph building in Excel. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. To enable. x releases, and the new Multi-table Data Import (MTDI) cubes. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. Edit Project-Level Cache and Intelligent Cube Settings. 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’. Cube and Cache Metric Names. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. Published: 4월 6, 2017. Build. Limit the use of derived attributes or derived metrics Derived elements like derived attributes and derived metrics are calculated on the fly by the MicroStrategy Analytical Engine, even when the data is coming from an intelligent cube, MicroStrategy still needs to calculate the derived elements and depending on the data size and. 1 and 10. 4. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. " If you try to edit these MicroStrategy Connector cubes, you may be asked to log into the Library server. 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”. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. 6. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 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. 4. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. The blog series consists of four blog posts: Unlocking Data Value #1: SAP BTP Data and Analytics overview: Learn about our objectives, SAP products, and real. 3 - Check the Make Intelligent. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. MicroStrategy Web allows you to merge two or more Intelligent Cubes. The Subscription Editor opens. The caching of Intelligence Cubes in MicroStrategy Analytics is a game changer. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. In Developer, log in to a project with a user account with administrative privileges. Use MicroStrategy Developer, Office, or Web. The procedure below provides the steps to manually publish an Intelligent Cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Click the “Add history list subscription” link near the bottom of the screen to open the. 5. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. It depends on the cube. The Intelligent Cube Monitor is displayed. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. x. 4. 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. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 4 the connection mapping of the u… Number of Views 1. x clustered environments. 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. 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. KB46934: Reports created from a MicroStrategy Data Import Intelligent cube are hidden in MicroStrategy Web. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. 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. MicroStrategy 9. x - 10. For more information, see. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. 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. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. In MicroStrategy Developer, browse to an Intelligent Cube. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". Click OK. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Data in Intelligent cubes can be either marked as available for time zone conversion when running objects against it or set within a specific time. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. To Create a Report that Accesses an Intelligent Cube. 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. Name the different export. Creating Intelligent Cubes based on. 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. Enable Document Output Caching in PDF Turn on this option to enable document output caching. All necessary privileges are included in the Administrator role by default. When the subscription has been configured, click. Right-click an Intelligent Cube and select Delete. In MicroStrategy Developer, browse to an Intelligent Cube. Intelligent Cubes can be based on MicroStrategy data or imported data. The MicroStrategy Intelligence Server 9. Intelligent Cubes: MicroStrategy’s Intelligent Cubes are pre-aggregated, in-memory data structures that enhance the performance of queries. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 4. Intelligent cubes are generated automatically when a new report is run against the data warehouse. 1) Right click the intelligent cube and select Properties -> Security . 54K KB31040: How to enable font size smaller than. The Intelligent Cube Options dialog box opens. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. The Schedule dialog box opens for your dataset, showing the tables in your dataset. x. Within the set. 0. 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. The maximum value is 9,999,999 and the minimum value is 0. This can improve the performance of. In this case, the dataset is a MicroStrategy Intelligent Cube. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. The storage for Intelligent Cubes was not setup properly. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. 1, Windows 2003 and UNIX. 8 and up? KB439821 | Knowledge Article | 2670. Intelligent Cubes can be partitioned,. In the Refresh Policy column, choose one of the following options:There are two main types of licenses available from the MicroStrategy product suite that come with privileges: Client product and Server product licenses. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. A document that uses the Intelligent Cube as a dataset. MicroStrategy Intelligence Server . This copy of report data is stored in Intelligence Server memory only. Intelligent Cubes. The Intelligent Cube Options dialog box opens. 3. In MicroStrategy Integrity Manager 10. To plan for. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. Users don’t have to mention the cube to which they want to connect. Introduction to MicroStrategy BI Architecture . Publish to PDF (22) Ratings. Consider the following example based on the MicroStrategy Tutorial project. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. In versions prior to MicroStrategy Intelligence Server 9. Intelligent Cubes act as the layer between the data warehouse and MicroStrategy reports that analyze and display. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. After each unload/reload, and running the Dossiers against the cube, the duplicate Element Block files will be dumped into the same *****_objects folder. 4. Browse to the folder location to store Intelligent Cubes, and then click OK. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. From the Data menu, select Configure Intelligent Cube. This option is enabled by default. The fact that the. Login to MicroStrategy Web, create a cube with the function of Data Import 2. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory reduces response time for reports using them. 1 and 10. 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. 4. 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. This defect is addressed in MicroStrategy 11. Con: The copy of report data in Intelligence Server memory only applies to a single report. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. In the left panel, click Cubes. Open the Workstation window. Publish the cube. Every time that a user does something in MicroStrategy, like. Case A: Security Filter attribute is related to attributes placed on the grid. Currently, project duplication does not involve Intelligent Cube File Directory. Export to PDF filter summaries include the full attribute and metric. 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. Expand Intelligent Cubes, and then select General. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. You can edit project-level cache and Intelligent Cube settings. To display PDF bookmarks with the correct font, the language pack must be installed on the viewer's machine. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. While still exposed, the settings will not take effect if. 4. Information to use MicroStrategy OLAP Services features, including Intelligent Cubes, derived metrics, derived elements, dynamic aggregation, view filters, and dynamic sourcing. In MicroStrategy Developer, log in to a project source with administrative privileges. Drag and drop the objects into the report grid from the Report Objects pane. Click Select. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. For this reason, it is important to govern how much Intelligent Cube data can be stored on Intelligence Server. An Intelligent Cube is. For detailed information about Intelligent Cubes. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X". 4. Business users might not want MicroStrategy to build any M:M Relationship tables while publishing the Intelligent Cube In-Memory due to the following reasons: 1) It distorts the actual relationship between a tuple of 3 or more attributes related to each other through M:M relationship in Project Schema by creating individual tables and joining. From the Edit menu, select Training Metric Wizard. x releases, and the new Multi-table Data Import (MTDI) cubes. Easily add or change pre- and post- SQL statements. 4,. Together with the Reports API, this API is often referred to as the JSON Data API. . 1 and 10. Navigate to and run the Intelligent Cube report. The Intelligent Cube Monitor is displayed. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Introduction to visual insight microstrategy visual. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. KB442630: CSI optimization for improving the in-memory query execution for many. 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. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. In MicroStrategy 2020, the password can be found in the Default_Accounts. 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. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions: A metric with the same formula and transformation exists in the Intelligent Cube. Intelligent cubes support time zone based reporting. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. The cube population process could be expensive in time and memory if the cube is large. Due to the architecture of the MicroStrategy platform, if a customer chooses to utilize caching and intelligence cube capabilities, then application data files that are at-rest are backed up on MicroStrategy-managed Intelligence Servers for a minimum period of five days. 1 and 10. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. 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. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. STEPS TO REPRODUCE: 1. This is a known inconsistency in MicroStrategy analytical engine where it may pick different tables for fact extension against In-Memory vs Connect Live Intelligent Cubes. An Intelligent Cube is an In-Memory data structure which holds information from a source in a readily accessible format for quick access. To view an Intelligent Cube stored in your History List. 6, users now have the option to select MSTR as the Delivery format for email and file subscriptions as shown below: MicroStrategy Intelligence Server. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Add or remove nodes in a cluster, and set the default cluster membership. 40. 0. x This is a new feature introduced in MicroStrategy version 9. Multiple reports can access a single. Creating an Intelligent cube is similar to creating a report. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Créer des cubes Intelligent Cube par connexion à la base de données: Cochez cette case pour définir vos cubes intelligents à utiliser et prendre en charge le. 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. By the same token, our platform is also the source of valuable data. 1 and 10. 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. Click Close, then "Finish" on the "prepare data" view and save the cube. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. Recorded at World 2021. MicroStrategy reference numbers for this technical note are KB442285 and DE101600. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 3. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks. Click the MicroStrategy icon at the upper left of any page and select History List. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. Select an Environment from the upper-left drop-down. 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. The reports created from the shared sets of data are. Intelligent Cubes erstellen. Watch on. Navigate to the Data Refresh category. Open the Workstation window. The fact that the Intelligent Cube resides on the. . Creating Intelligent Cubes is as easy as creating reports. Intelligent Cubes provide the fast response time and analytic calculations that are often associated with MOLAP cubes. The Intelligent Cube Monitor is displayed. 1. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. 0. A user logged in to a MicroStrategy Intelligence Server. To schedule an Intelligent Cube to be updated. MicroStrategy will monitor the data repository and/or cube memory requirement of the Enterprise Manager and/or Platform Analytics. 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. Intelligent Cube design and utilization; how to build cubes, schedule them,. 0. Intelligent Cube storage on disk mirrors report cache storage. Select a schedule from the Schedule drop-down list. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. The. Depending on location set at the project level, one or none of the Intelligence server nodes will be able. Run the Report and check the SQL View. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. To enable or disable dynamic sourcing for an Intelligent Cube. School NIT Rourkela; Course Title DATA ANALYSIS 102; Uploaded By DeanElectronHummingbird14. Intelligent Cubes. Find Cube Task . Creating Intelligent Cubes is as easy as creating reports. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings.