For detailed information about Intelligent Cubes, see the In-memory Analytics Help. Intelligent Cubes can be partitioned,. 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. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. In a clustered environment, each node in a cluster must share its result caches and intelligent cubes with the other nodes, so all clustered machines have the latest cache information. Published: May 15, 2018;This document provides settings that can be adjusted to help decrease Intelligent Cube publication times in MicroStrategy Secure Enterprise 10. This issue prevents the nodes in a MicroStrategy cluster to successfully load the remote Intelligent Cubes into memory once the MicroStrategy Intelligence Server node is restarted. Set the path for the cube cache file directory to . Configure metric aggregations, null handling, indexing, and more. The following table summarizes the test results of some test scenarios against Oracle 19c. CSI after fix: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. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. The display of data is handled by the reports that access the Intelligent Cube. However, you cannot create a card based on a live-connect MDX/SAP cube. Microstrategy is used to interact on Hadoop, Microsoft SQL Server Tables, and SSAS MDX Cubes. 1. The dataset is a set of data that can be displayed on the document. Required Status to Perform Action. x. 1 and 10. x product documentation "InMemoryAnalytics. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Introduction to advanced analytics 3. Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. Query Generation. The New Intelligent Cube dialog box opens. This will work as a regular SQL comparison. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. To schedule an Intelligent Cube to be updated. 1 and 10. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. You can edit project-level cache and Intelligent Cube settings. Find Cube Task . 1 release. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. Total Cubes This section displays the total count of cubes by status. The view filter cannot filter out other elements as shown below:The cube associated with the . Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Sharing data. Choose File > New > Intelligent Cube. x and newer. Export to PDF filter summaries include the full attribute and metric. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. Every time that a user does something in MicroStrategy, like. If you are upgrading to MicroStrategy 11. The Intelligent Cube Monitor is shown in the image below. The status of each Intelligent Cube is listed in the. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. To enable. Configure a Cluster with a Centralized Cache. 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. Microstrategy's Visual Insight is used as a self service tool replacing Pivot tables & graph building in Excel. Watch on. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. Export to PDF, web sort, document design. The maximum value is 9,999,999 and the minimum value is 0. 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. You can also define when Intelligent Cubes. For example, analysts can export interactive dashboards and reports to PDF format, allowing executives to access and review critical information without needing direct access to the BI platform. This template includes the following tasks: Creates a new metadata. The New Grid dialog box opens. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. The default value is 256 megabytes. the project configuration: ACTION . This property can only be enabled through Workstation. Click Select. Share query results in-memory across multiple dossiers and reports. 4. The related section is located in. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. •PDF. bat format. However, Intelligent cube publishing performance may be affected with the agent enabled. If you are upgrading to MicroStrategy 11. 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. KB442630: CSI optimization for improving the in-memory query execution for many. Check the location of the new cube cache and notice that it is saved in the default location, i. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. What is HyperIntelligence? In 2019, MicroStrategy invented a new solution for a conventional problem in the analytics industry. KB440822. You can control users' access to data with security filters. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . The Training Metric Wizard opens. 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. 4. To enable or disable dynamic sourcing for an Intelligent Cube. View the report in either Grid View or Grid and Graph View. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 11. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. 4. Publish, unpublish, delete, and update Intelligent Cubes. intelligence company. PUBLISH INTELLIGENT CUBE ("name" IN FOLDER "folder_name" | GUID "guid") [ASYNCHRONOUS] FOR PROJECT "project_name"; where: "name" is the name of the Intelligent Cube to be published, of. Narrowcast Server, MicroStrategy Intelligence Server 8i, Oracle 10g/9i, Informatica Designer 8. table_name: is the name of a table. You can update and modify the document in Design View. Sharing data. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. Use the drop-down under the filter summary section to switch the server nodes. In Developer, log into a project. HIDDEN: Whether or not the Intelligent Cube is hidden, returned as a boolean value. 4. What is MicroStrategy? MicroStrategy is a Business Intelligence software that can be connected with any data including data files, big data, social media data, and so on to create and modify highly detailed reports and dashboards. This section. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. This Knowledge base article describes how when creating an Intelligence cubes using functions that pass through the database return "There is no data for this result. Click OK. 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. The Intelligent Cube Options dialog box opens. Create a report based off the cube in Step 1 that includes the description form for Category. idx file is cleaned up. 1 and 10. There is a distributed database for the MicroStrategy metadata and. Analyzing SQL and For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. 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. To Create an Intelligent Cube Using Freeform SQL or Query Builder. In the left pane, click All Settings. This issue was reviewed by our Technology team for feasibility and will not be scoped for a code fix in any upcoming MicroStrategy release. xUse the same attribute in filter in Intelligent Cube and incremental refresh filter. Select a schedule from the Schedule drop-down list. The Platform Analytics project comes with three Intelligence Cubes that support nine Dossiers that can be run right after installation to check if everything is functioning properly. Localizing Intelligent Cubes in multiple languages. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. . KB485226: Intelligent Cube size increases irrespective of the "Maximum % growth of Intelligent cube to 50%" governing setting. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. . The MicroStrategy Intelligence Server 9. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. Choose File > New > Intelligent Cube. Intelligent Cubes: MicroStrategy’s Intelligent Cubes are pre-aggregated, in-memory data structures that enhance the performance of queries. The reports created from the shared sets of data are. Right-click an application and choose Properties. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. KB19654: How to obtain the Report Execution. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. 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. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. 18K. Click OK. Starting in MicroStrategy 10. An Intelligent Cube has been created in a project. 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 . To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Creating Intelligent Cubes is as easy as creating reports. 4. This data can then be shared as a single in-memory copy, among many different reports created by multiple users. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. MicroStrategy 9. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. You can also apply this security when users create reports that connect to an Intelligent Cube. Create an intelligent cube report with Year and three derived metrics and enable "Aggregate from base" as shown below: Insert view filter "Year in list (2009)". 4,. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. 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. Select an Environment from the upper-left drop-down. In MicroStrategy Developer, log in to a project source with administrative privileges. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. See Memory Mapped Files for Intelligent Cubes for more. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. 11/10. 40. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. The Intelligent Cube Options dialog box opens. All necessary privileges are included in the Administrator role by default. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Intelligent Cubes. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. The Intelligent Cube opens in the Report Editor. In MicroStrategy 2020, the password can be found in the Default_Accounts. The Intelligent Cube Options dialog box opens. For example, for a project, result caches on each node that has. The New Grid dialog box opens. In MicroStrategy Developer, log in to a project source using administrative privileges. Solution:If you have a Distribution Services license, you can subscribe multiple users to an individual report or document through MicroStrategy Web (see To Create a Subscription in MicroStrategy Web). MicroStrategy The ability to view or edit certain settings is determined by a user's privileges. Because the filters are applied to the master data in the Intelligent. PATH: The path to the Intelligent Cube, returned as a string. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. grouping attributes MicroStrategy Cloud Creating attributes on dossiers Filtering reports, metrics, and attribute groups Filtering dossiers Improving performance with intelligent cubes Preparing complex data for enhanced storytelling Visualizing, filtering, and linking your data Designing documents Building enterprise mobile applications Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. 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. This is the most popular MicroStrategy Interview Question asked in an interview. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. 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). Replace a slice of data in an Intelligent cube using a single incremental cube refresh step. In the left pane, click Intelligent Cubes. Intelligent Cubes provide the fast response time and analytic calculations that are often associated with MOLAP cubes. WORKAROUND: Two possible workarounds which may be feasible, depending on the situation are:Select Intelligent Cubes > General > Intelligent Cube File directory. 11 on Unix/Linux Number of Views 2. The Intelligent Cube Options dialog box opens. 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. Indicates a user exported a view report or a cube-based document or a cube-based dossier to PDF and hits the cube cache. 0 has a dedicated section to memory used for Intelligent Cubes. Intelligent Cube data can also be stored in secondary storage, such as a hard disk, on the machine hosting Intelligence Server. 24: Update Intelligent Cube. Select the data set and click Prepare Data. If you are upgrading to MicroStrategy 11. Main Features. In HTML View and PDF View, a dashboard is displayed as a static document. You must belong to the System Administrators group to use this feature. In addition to creating reports directly, you can use the Freeform SQL Editor or Query Builder Editor to create an Intelligent Cube. Subsequently the requests made by other users can. 5. Introduction to visual insight microstrategy visual. 1 and 10. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. Right-click an Intelligent Cube and select Delete. The objects in the source cubes will control how the security filter will be applied. Select to move project-related objects, administration objects, or merge entire projects together. The Analytics Server creates and manages Intelligent Cubes, a multi-dimensional cache structure that speeds up access to frequently used data. Browse to an Intelligent Cube, select it, and then click OK. 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. A document is used to format data from multiple datasets in a single display of presentation quality. Number of Views 391. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. These VLDB properties control the method by which the report data are normalized. This provides ROLAP-type analysis without having to re-execute against the data warehouse. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). The SQL Engine matches a view report, or a report that uses dynamic sourcing, with the corresponding Intelligent Cube. 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. txt file. Navigate to the Data Refresh category. While still exposed, the settings will not take effect if. Before MicroStrategy 10. Create an attribute element prompt for the. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Use MicroStrategy Developer, Office, or Web. The cube population process could be expensive in time and memory if the cube is large. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). 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 Developer, log in to a project source with administrative privileges. If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. Save the workflow in . Privilege. 0. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. NAME: The name of the Intelligent Cube, returned as a string. 4. For more information, see. 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 storage for Intelligent Cubes was not setup properly. These Intelligent Cubes can be loaded into memory when they are needed. Defining the partition for Super Cubes. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Number of Views 8. In the Data Source column, select the checkboxes for the tables to update. Administer Caches. What are advantages of cubes? It perform fast It Schedule the Cube It is used for Drilling It helps in Data Sharing. When an Intelligent Cube. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Choose File > New > Report. Add or remove nodes in a cluster, and set the default cluster membership. Navigate to the folder location of the Intelligent Cube. 54K KB31040: How to enable font size smaller than. 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. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. To test the new batch file, the user can execute the batch file by entering its file location in the command line as shown below. 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 following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is executed in. 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. The Intelligent Cube must be published before this report can execute. All articles. Administering MicroStrategy: Managing the Intelligence Platform Securing user privileges and data access Monitoring and tracking the analytics system. Right-click the Intelligent Cube to store in secondary storage and select Save to Disk. 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. Right-click the Intelligent Cube, and select Edit. User Review of MicroStrategy Analytics: 'Microstrategy is used as a reporting solution in my work environment. Use the drop-down under the filter summary section to switch the server nodes. 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. 1. Right-click the project and select Project Configuration. Server Logout. Intelligent Cubes as datasets. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. MicroStrategy Intelligence Server . This command will list the table information only when the intelligent cube is a super cube. x CAUSE: The user is missing the "Administer Subscriptions" privilege under "Administration" in. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Place intelligence server close to the both the data warehouse and the metadata repository. 15K. If the welcome page is shown, review the information and click Next. MicroStrategy Web allows you to merge two or more Intelligent Cubes. Select an Environment from the upper-left drop-down. Publish the cube. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. The. For more details on enabling the setting, refer to Change Data Engine Version. The Intelligent Cube Options dialog box opens. 11+, derived attributes are evaluated at the source when all the required columns come from the same table- which is the case for most users. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. Publish Intelligent Cube statement. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. The Intelligent Cube Monitor provides information about published Intelligent Cubes, as well as Intelligent Cube usage statistics. If the objects (metrics/attributes) on an Intelligent Cube have restricted access (via ACLs), such cubes will be implicitly treated as live-connection cubes and hence won't be eligible for use with delivery as an MSTR fileThe Intelligent Cube Editor offers control over advanced properties. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This is because with this feature enabled, the element block ID will be saved to the new cube cache. This option is enabled by default. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. 10. 0. This copy of report data is stored in Intelligence Server memory only. 1 and 10. (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. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. Browse to and select a previously saved Intelligent Cube on which to build your report. In MicroStrategy Developer, log in to a project source with administrative privileges. The "Refresh Cube Subscription Editor" allows for a "Name", "Schedule", and "Delivery Notification" to be set. Interested in learning more about Platform Analytics or new MicroStrategy features? Visit the Learning Center on Community! Or feel free to visit our Documentation pages for product information. Defining the partition for Super Cubes. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data. Right-click the dataset, and choose Schedule. 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. 3 - Check the Make Intelligent. 6. •. Published: 4월 6, 2017. The Intelligent Cube Options dialog box opens. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. 6, the MicroStrategy PDF Exporter (also known as New Export Engine or NEE) service has been added to support exporting from Visual Insight / Dossier to PDF format. Intelligent cubes are generated automatically when a new report is run against the data warehouse. In MicroStrategy Developer, browse to an Intelligent Cube. This can improve the performance of. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Intelligent Cubes. 0. 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. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. /ClusterCube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Drag and drop the objects into the report grid from the Report Objects pane. Pages 272 Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e. Add data from existing reports, documents, and Intelligent Cubes. 0 MicroStrategy releases. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. The fact that the. Par défaut, elle est définie sur 32 000. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. For detailed information about Intelligent Cubes. Administer database connections. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. Create a Report 'R3' with 'Country' attribute.