Choose your preferred method to share the logs. This defect is addressed in MicroStrategy 11. To build an Intelligent Cube. In MicroStrategy 10. OR, to convert an existing filter into a security filter, click Import. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. Alternatively, you can enable caching on selected reports. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. These reports allow data to be returned from the data. 5 GB. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Choose File > New > Intelligent Cube. A MicroStrategy Report Services document displays your organization's data in a format. 10 or earlier, outer join to Lookup table in a dashboard/dossier report based on Intelligent Cube with joint element list filter will not work, and incorrect CSI will be generated when both attributes used in the filter are present in visualization. 0. 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 zone. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. 4. the project configuration: ACTION . Number of Views 523. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. zip file, with the. This can be seen in the screenshot below. Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. Maintaining data access security. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. The Modeling service must be configured correctly to use this feature. Edit SQL Transactions in Reports. mstr suffix. MicroStrategy Analytics cubes are easy to create and deploy. In MicroStrategy 10. log without functional impact. This folder needs to be shared as 'ClusterCube'. SYMPTOMS: After duplication of a project in Developer that has a user-defined Intelligent Cube cache location, Intelligent Cubes created within the new project are not saved to the location specified in Intelligent Cube File Directory in Project Configuration. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. A set of data is returned from the. The Select Dataset dialog box opens. An Intelligent Cube is a. Rather than returning data from the data warehouse for a single. This KB answers a question regarding memory limitations for In-Memory data import for MicroStrategy 10. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. If the Intelligent Cube must be re-processed based on a metric. Expand the Object Templates category, select General, and. e. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Create Cube2 with the Region attribute and the metric created in step 1. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. If removing the view filter does not. If you are upgrading to MicroStrategy 11. The considerations and steps required to fully support dynamic sourcing are listed below: While many MicroStrategy features can be used with dynamic sourcing, some features may prevent the use of dynamic sourcing between reports and Intelligent Cubes. x. An enhancement Request has been reported to the MicroStrategy Technology team. x. For more information on security filters, see the System Administration Guide. 0 votes. Locate and run the Setup. To do this, edit the report in developer and go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose the new target cube: Create Cube A and a report based on it. Technically this will result is different queries on the database, due to the fact that each calculation level is different. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. x. In MicroStrategy Developer, right-click on the project and select Project. Intelligent Cube memory usage for each node in a clustered environment. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. When a remote accesses this cube, the cube is loaded into memory of the. Limiting the Maximum Report Size. After the previous changes, you'll have to save the cube and republish it. The Full Refresh option is the default. Defining Memory Limits for Intelligent CubesThis article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. The New Grid dialog box opens. Create a security filter on the region attribute such as region not in list central. The default value is 256 megabytes. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Enable core dumping. 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. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. 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. Using mstrio as a MicroStrategy Intelligence Server administration tool¶For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. MicroStrategy logical tables do not necessarily represent physical tables. Create an attribute element prompt for the. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. Documentation on the REST API is at developer. Integer ID of the Intelligent Cube report that was published, if any. The Intelligent Cube opens in the Report Editor. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. g. 4. Feb 2020 - May 2022 2 years 4 months. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. 4. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. When a machine runs out of virtual memory, processes on the machine are no longer able. There's a reason we're at the top of the list. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. This import bridge imports MicroStrategy logical tables as Dimensions. You must belong to the System Administrators group to use this feature. Because the filters are applied to the master data in the Intelligent. 4. Number of Views 1. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. MicroStrategy tests on at least one of the CPU chipsets within a set of binary-compatible CPU architectures for purposes of certifying and supporting operating systems with MicroStrategy products. It remains available, but is not enforced if it is less than the default value of 100000. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. MicroStrategy 9 ships a new utility called MicroStrategy Cube Advisor to assist in the use of the Dynamic Sourcing functionality in MicroStrategy OLAP Services 9. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. 4. When you run reports in MicroStrategy, they collect the warehouse data. This applies for example to Cubes created via MicroStrategy Web client. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. To build an Intelligent Cube. 3. For a detailed explanation of the Cube Status values, see KB31566: MicroStrategy 9. x in maintenance mode, it is recommended for users to enable the setting Cluster Synch Check Duplicate Cubes through the Windows registry or through the MSIReg. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. Updating Intelligent Cubes without re-processing: Incremental Refresh. 4. 4. Intelligent Cube storage on disk mirrors report cache storage. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Click here to view details about the Intelligent Cube Monitor. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. 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. x? To answer this question, the "Query Engine finish time" is marked when the warehouse query step for generating the Intelligent Cube finishes. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). It is also more difficult or impossible for someone reporting on Intelligent Cube data to unintentionally cause re-execution against the data warehouse, preventing extra load on the data warehouse. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. mstr file is actually a . MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. 3. A user logs out of a MicroStrategy Project by scheduler. 3. Open the Workstation window. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. 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. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. The New Grid dialog box opens. It is also more difficult or impossible for someone reporting on Intelligent Cube. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. For more information on the Intelligent Cube Maximum. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. To view an Intelligent Cube stored in your History List. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":The peak memory for publishing an Intelligent cube is much larger in Winodws than Linux if the data contains ASCII characters. However, OLAP Services provides MOLAP and ROLAP analysis on the same report, which offers many distinct benefits, summarized below: Using OLAP Services, you can get fast response times for reports that use data directly from in-memory Intelligent Cubes, instead of from the data warehouse. Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). IS_PROJ_ID. By default, there is a system hierarchy on the cube. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. This data is to apply the calculations. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. Open the Workstation window. exe file. IS_CUBE_REP_ID. 3. Create a Data Import Live Intelligent Cube. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. microstrategy. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version. In the left panel, click Cubes. In the Data Source column, select the checkboxes for the tables to update. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. Complex metrics here refer to metrics which are defined using multiple. 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. This is due to the fact that adding prompts to Intelligent Cubes is not supported. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. A valid CPU architecture is provided in parentheses () to clarify the operating system software certified or supported for Intelligence Server. In other words, the new column will NOT get mapped automatically in the existing Intelligent Cube. For more details on enabling the setting. MicroStrategy 10 will report the following. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. Cube Advisor opens. 2. The MicroStrategy Intelligence Server 9. Traditional Report Caching in MicroStrategy is done on a matching basis. An Intelligent Cube is. - Normalize Intelligent Cube data in the. Introduction. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. It is especially useful when data. These VLDB properties control the method by which the report data are normalized. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. 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. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. Easily add or change pre- and post- SQL statements. 1. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Run the Report and check the SQL View. In the Navigation pane, click , next to Objects. An Intelligent Cube has been created in a project. Choose one of the following options: Full Refresh: This is the default. To do so, you can take advantage of URL API. 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. This Knowledge base article describes limitations in using security filters and intelligence cubes. If the Intelligent Cube must be re-processed based on a metric. Users cannot trigger or schedule cube republishing. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes" You can edit project-level cache and Intelligent Cube settings. Recorded at World 2021. This table is not populated unless at least one of the Advanced Statistics Collection Options are selected in the Statistics category of the Project Configuration Editor. This means you can manually change the suffix to . com. In MicroStrategy Developer, right-click on the project and select Project. 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. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Published: 4월 6, 2017. Create a second report with the year and quarter attributes and the revenue metric. Refer to the following sections for a list of features that can and cannot be used with. Cube and Cache Metric Names. xA warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Select one: To create a new security filter, click New. 4. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Log on to the machine where you are installing one or more MicroStrategy products. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. com The Maximum RAM usage (Mbytes) memory limit can be defined per project. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. In addition, multiple logical tables can represent the same physical table. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. A solution/code fix for this issue is not available in current releases but is. To build an Intelligent Cube. Drag and drop the objects into the report grid from the Report Objects pane. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". Documentation on the REST API is at developer. Check it in the cube monitor and we can see its column Database Connection is not empty. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. STEPS TO REPRODUCE 1. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. For example, an Intelligent Cube that contains data for the top 200 stores by. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. The Full Refresh option is the default. Run sudo vi /etc/sysctl. A schedule is defined in Python code. 2. Node 2. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. This allows for more power and control over data for MicroStrategy. Open the. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 86K KB31566: MicroStrategy 9. x, updating an Intelligent Cube returns "Cube Manager: number of c… Number of Views 1. . Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. Published: Jun 29, 2018;KB321029: In MicroStrategy 10. 1, Intelligent Cubes have a new feature to update information without republishing it. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. x to 11. Published: Apr 6, 2017. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. NOTE: There is an inherent limit specific to importing Excel files due to using an internal Java component to extract the data from Excel files. With OLAP Services features, your report designers can create Intelligent Cube reports. When using MicroStrategy and Teradata, the best approach is to. Select the data set and click Prepare Data. The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. You may share the Intelligent Cube as a single copy in memory. Creating an Intelligent cube is similar to creating a report. This will reduce the memory usage from 150GB to 100GB. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. 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. Create a Report 'R3' with 'Country' attribute. By default, this is set to 32,000. The first column provides the Intelligent Cube name, and the second column provides the full path to the Command Manager script files used to publish the. Exit all Windows applications before beginning the installation process. The maximum number of Intelligent Cubes that can be loaded onto Intelligence Server for this project. ACTION This. The data used for this example is. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. Open the. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. The Intelligent Cube must be published before this report can execute. The view filter cannot filter out other elements as shown below:Data Modeling. 56K. 2. This is a known issue with Data Import functionality in version 10. Create a New Dossier. Along with. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. In MicroStrategy Web, open the document in Design Mode or Editable Mode. It involves only fetching a portion of the data that the user wants, instead of storing all data in-memory as a normal Intelligent Cube. Dynamic Sourcing. By default, the report template used is the same as the Intelligent Cube's template. Along with. It will remain available, but the setting will not. With OLAP Services features, your report designers can create Intelligent Cube reports. Browse to and select a previously saved Intelligent Cube on which to build your report. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. 4. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. You must belong to the System Administrators group to use this feature. This is the same requirement to create or run a static report in Workstation. 8. IS_CUBE_ACT_ID. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 1 Hotfix 6, it is not possible to use the Attribute Name macro in the filename of a bursted document when the document uses an Intelligent Cube create via Data Import as a dataset as the Intelligent Cube's attributes are not in the actual project schema. 2. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. On the left side of the page, click Logs and then Export Logs to save the file. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. 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. Reproduce Steps This level of system resources allows MicroStrategy Intelligence Server to fully use performance-improving technologies such as MicroStrategy OLAP Services, and to support optimal performance for MicroStrategy Report Services documents and dossiers and the other features of the MicroStrategy Product Suite. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. Consolidate multiple MicroStrategy cubes into a single Kyvos data model without limitations on the data size or the number of dimensions that the model can hold. 4. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Specify a name and location for the new security filter and click Save. Dossiers automatically adjust to look great on any screen. Select data population for Intelligent Cubes. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms for caching. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. Publish the Intelligent Cube by executing it on either of the nodes. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. However, if the. Click the “Add history list subscription” link near the bottom of the screen to open the. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 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. Cube Limitations. 17. The objects in the source cubes will control how the security filter will be applied. To customize your filename, please refer to the man page of core(5). x. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. "The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. For more information on Intelligent Cube sizes, refer to the following MicroStrategy Knowledge Base technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. 5 GB, the Data Transfer from Datasource(s) time is 77. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Email subscriptions deliver a report or document to one or more email addresses. Drag and drop the objects into the report grid from the Report Objects pane. Pros and Cons. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. Senior Lead, Application Support. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 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. If the data in the Intelligent Cube is outdated. This import bridge imports MicroStrategy logical tables as Dimensions. Create a report based on above Cube and add the prompt in view filter. In MicroStrategy Integrity Manager 10. IS_CUBE_INST_ID. To access the MicroStrategy Installation Wizard. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. 3. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes.