x and newer. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Instantly analyze any amount of data without in-memory limitations of MicroStrategy intelligent data models. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Dynamic Sourcing is a new feature of MicroStrategy 9 OLAP Services that automatically checks a report request, and sources data from a MicroStrategy Intelligent Cube wherever possible. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. The Intelligent Cube must be published before this report can execute. This import bridge imports MicroStrategy logical tables as Dimensions. Dossiers automatically adjust to look great on any screen. On the left side of the page, click Logs and then Export Logs to save the file. Number of Views 5. 4. This can. This Python 3 / MicroStrategy 10. MicroStrategy Web: Web Server. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Data Population for Intelligent Cubes. If you are upgrading to MicroStrategy 11. Create a report with the year and quarter attributes and the profit metric. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. 2. Technically this will result is different queries on the database, due to the fact that each calculation level is different. The Intelligent Cube opens in the Report Editor. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. 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. . A document is used to format data from multiple datasets in a single display of presentation quality. MicroStrategy Professional Services for high performance. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. Öffnen Sie das Workstation-Fenster. To Create an Intelligent Cube Using Freeform SQL or Query Builder. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . mstr file is actually a . MicroStrategy Analytics cubes performance is best in the industry from performance point of view. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. MicroStrategy 10 will report the following. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Data modeling is the structuring of an organization's data assets into an applicable logical model. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. While this can improve performance of these reports. These VLDB properties control the method by which the report data are normalized. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. Expand the Object Templates category, select General, and. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. 17. cube; oracle12c; cubes; microstrategy; Jorgechu. Designing and creating documents: An overview. Loading. 0 MicroStrategy releases. 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. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. To enable. 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. Documents . Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. Scalable Analytics. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Number of Views 523. 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. This folder needs to be shared as 'ClusterCube'. This article describes how to trace Intelligent Cube activity. Both properties are located in the Query Optimizations folder in the VLDB property editor. Browse to the filter you want to convert and click Open. The aim of this KB is to have a look at the Live connected intelligent cubes performance considerations as it’s necessary to understand how many steps are involved in the process, of course each step consumes time, hence the more steps the more time will take a dossier to. All necessary privileges are included in the Administrator role by default. The memory used by Intelligence Server is limited by the machine's virtual memory. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. To Create a Report that Accesses an Intelligent Cube. 0 MicroStrategy releases. Publish the cube. 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. To add an existing report or Intelligent Cube as a dataset. In the Refresh Policy column, choose one of the following options:Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. Right-click an Intelligent Cube and select Delete. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 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. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. Once an Intelligent cube is created and then published so its data is available, multiple reports can be created to connect to the Intelligent cube. 3. Cube Advisor opens. x and 10. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. In this case, the dataset is a MicroStrategy Intelligent Cube. 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. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. To Create a Report that Accesses an Intelligent Cube. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Moreover, you may generate among the various reports of many users. MicroStrategy logical tables do not necessarily represent physical tables. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. STEPS TO REPRODUCE 1. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Vn (with metric Mn from source cube Cn). Create Schema Objects. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. Expand Intelligent Cubes, and then select General. Providing Intelligent Cube data. Strong semantic layer to define all the business rules and tightly coupled. 4. 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. 3. 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. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 3. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. 0. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. In the New Intelligent Cube dialog box, select the MDX Sources tab. Cube Limitations. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. The Intelligent Cube must not be re-processed based on a metric. The following diagram depicts the role of the intelligent cube. When you run reports in MicroStrategy, they collect the warehouse data. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Specify a name and location for the new security filter and click Save. x - 10. With in-memory ROLAP, some selected portions of the global virtual cube are populated with actual data as ROLAP Cubes (Intelligent Cube); as you see presented here in the drawing. IS_CUBE_INST_ID. Share query results in-memory across multiple dossiers and reports. To view an Intelligent Cube stored in your History List. Add External Data. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Limiting the Maximum Report Size. 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 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. These reports allow data to be returned from the data. STG_IS_CUBE_REP_STATS. Create a report on this intelligent cube with the month attribute and the count of day metric. If the Intelligent Cube must be re-processed based on a metric. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. Cube Advisor opens. 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. 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. The objects in the source cubes will control how the security filter will be applied. On the left side of the page, click Logs and then Export Logs to save the file. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. x a new concept is introduced called Intelligent Cubes. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. In addition, multiple logical tables can represent the same physical table. Recorded at World 2021. 1 and 10. Strong semantic layer to define all the business rules and tightly coupled. Select one: To create a new security filter, click New. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. In addition, multiple logical tables can represent the same physical table. Because the filters are applied to the master data in the Intelligent. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Published: Apr 6, 2017. The Intelligent Cube Options dialog box opens. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. A document that uses the Intelligent Cube as a dataset. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. Transactions. Related Articles. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. 4. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. With OLAP Services features, your report designers can create Intelligent Cube reports. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. Import and save data from a file in a folder location. IS_CUBE_ACT_ID. Click the “Add history list subscription” link near the bottom of the screen to open the. How to configure, monitor, and manage Intelligent Cubes. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. A set of data is returned from the. Pros and Cons. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. No data is returned for the report. It remains available, but is not enforced if it is less than the default value of 100000. log without functional impact. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. Go to the Report -> Data->Intelligent Cube Options->Point grid to. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. x Dynamic sourcing extends the accessibility of Intelligent Cubes by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements. To enable or disable dynamic sourcing for an Intelligent Cube. View the report in either Grid View or Grid and Graph View. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Once an Intelligent cube is created and then published so its data is available, multiple reports can be created to connect to the Intelligent cube. The . It is recommended that the Excel file size should not exceed 1GB. Cube Limitations. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. 2. 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. 2. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. 15K. 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. Select an Environment from the upper-left drop-down. Before MicroStrategy 10. 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. You can create and analyze new reports in real time. Open the. If the Intelligent Cube must be re-processed based on a metric. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. Intelligent Cube storage on disk mirrors report cache storage. Alternatively, you can enable caching on selected reports. To build an Intelligent Cube. HyperAndroid Go to the Account tab. This KB answers a question regarding memory limitations for In-Memory data import for MicroStrategy 10. When a remote accesses this cube, the cube is loaded into memory of the. The data used for this example. Intelligent Cube memory usage for each node in a clustered environment. By default, this is set to 32,000. table_name: is the name of a table. The MicroStrategy Tutorial project uses aggregate tables by default. 4. Case A: Security Filter attribute is related to attributes placed on the grid. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. 2. Another way to use caching in MicroStrategy is through Intelligent Cubes. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Since an Intelligent Cube is structured similarly to a Relational Database the method of retrieving data from the Intelligent Cube, Cube Subsetting Instructions, is very similar to. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. Most likely several, different fact tables are uses for each query. 3. 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. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. 9 and 10. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. This is the same requirement to create or run a static report in Workstation. 0 has a dedicated section to memory used for Intelligent Cubes. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. Job ID for the action on the Intelligent Cube. Intelligent Cubes can be based on MicroStrategy data or imported data. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. Browse to and select a previously saved Intelligent Cube on which to build your report. You can create and analyze new reports in real time. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. By default, there is a system hierarchy on the cube. From the Categories list, expand Options, and then select General. To view this field, the Intelligent Cube must be published at least once. This will reduce the memory usage from 150GB to 100GB. When using an Intelligent Cube, you already have an in memory dataset. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. 5 GB. When using an Intelligent Cube, you already have an in memory dataset. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Along with. x. After execution. The user then updates the cube. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Choose Databases. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. In MicroStrategy Developer, right-click on the project and select Project. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. You cannot create a card based on a live-connect MDX/SAP cube. The Cubes are modeled with a built-for-purpose modeling thus requiring additional schema work instead of directly leveraging the already-built schema model MicroStrategy Cube Advisor recommends and automatically creates an optimal set of in-memory cubes based on usage patterns for different users accessing the BI system. The Modeling service must be configured correctly to use this feature. Use the drop-down under the filter summary section to switch the server nodes. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. IS_CUBE_REP_ID. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Select one: To create a new security filter, click New. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. The Full Refresh option is the default. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. Starting with MicroStrategy Intelligence Server 9. This dataset needs to contain all data in the required granularity. x and 10. Published: 4월 6, 2017. Select the schedule you had created in step 2 and in the Intelligent Cubes field, select the desired Intelligent Cube as seen below: 6. Traditional Report Caching in MicroStrategy is done on a matching basis. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Job ID for the action on the Intelligent Cube. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". MicroStrategy logical tables do not necessarily represent physical tables. Also, verify that the /<path_to_the_location>/core. This is the most popular MicroStrategy Interview Question asked in an interview. Using any other database should not have any implications, given that TPT is only applicable to Teradata. x to 11. GUID of the Intelligent Cube instance in memory. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. 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. Create a report with this Intelligent Cube and execute the report --> one row with 4 element returned. To access the MicroStrategy Installation Wizard. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. 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. Cube Cache Hit: Download MSTR File with Cube Cache Hit: Indicates a user exported a dossier object based on cube as an MSTR file and hits the cube cache. Intelligent Cube storage on disk mirrors report cache storage. 2. the project configuration: ACTION . For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. 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. Integer ID of the Intelligent Cube report that was published, if any. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. 3. x, but not to publish it, the minimum privileges that the Administrator would need to. The Full Refresh option is the default. Defining Intelligent Cube refresh settings. This can be seen in the screenshot below. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. 3. x and newer. metrics in the intelligent cube or in the MicroStrategy schema and application objects. 56K. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. When running MicroStrategy Intelligence Server 9. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. 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. If desired, user can create a dashboard immediately from the imported data. Intelligent. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. e. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. Slice and dice features are awesome. Check in Developer that the stopped node is in Maintenance Mode. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Intelligent Cubes. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. 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. Create an Intelligent Cube with this attribute and publish. x and newer. If a new column is added to the data import data source and the cube is republished, there is no effect. IS_CUBE_ACT_ID. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Intelligent cubes support time zone based reporting. You may share the Intelligent Cube as a single copy in memory. The default value is 256 megabytes. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Developed reports for MicroStrategy Web users. Create a report based off the cube in Step 1 that includes the description form for Category. Published: Apr 6, 2017. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. However, if the. 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. 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. Save the Cube with Connect Live Data Access Mode. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. x - 9. The Intelligent Cube Options dialog box opens. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. 5 GB .