All necessary privileges are included in the Administrator role by default. Specify a name and location for the new security filter and click Save. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. 3. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. IS_CUBE_REP_ID. 4. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Log on to the machine where you are installing one or more MicroStrategy products. x - 10. Users of Intelligent Cubes in MicroStrategy 9. Required Status to Perform Action. Share query results in-memory across multiple dossiers and reports. Number of Views 1. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. File subscriptions save the report or document as an Excel or. For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. 2. Since Intelligent Cubes function simply as. 0 votes. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. Both properties are located in the Query Optimizations folder in the VLDB property editor. 11. 5 GB, the Data Transfer from Datasource(s) time is 77. MicroStrategy is the only comprehensive analytics vendor that supports big data analytics with native connectors to HDFS to access petabytes of data in real time. This can be seen in the screenshot below. * MicroStrategy does have support for dynamic sourcing with MDX sources. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 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 following table summarizes the test results of some test scenarios against Oracle 19c. By default, there is a system hierarchy on the cube. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. For example, an Intelligent Cube includes the. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Run sudo vi /etc/sysctl. x. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. A solution/code fix for this issue is not available in current releases but is. Datasets API. The data used for this example is. Share query results in-memory across multiple dossiers and. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. These reports allow data to be returned from the data. com. 3. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. It will remain available, but the setting will not be enforced if set below the default value of 100000. Select the data set and click Prepare Data. Creating an Intelligent cube is similar to creating a report. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms for caching. 4 the connection mapping of the u… Number of Views 1. 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. Create a dossier and add subset R from Existing Dataset. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. 0. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. Data modeling is the structuring of an organization's data assets into an applicable logical model. A MicroStrategy Report Services document displays your organization's data in a format. x. While this can improve performance of these reports. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. This. Web Open the Settings page (right click the extension and select Options). Right-click an Intelligent Cube and select Delete. Job ID for the action on the Intelligent Cube. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Create Schema Objects. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. You must belong to the System Administrators group to use this feature. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. Check the status of the cubes in Developer. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. On the left side of the page, click Logs and then Export Logs to save the file. No data is returned for the report. KB222608: In a clustered environment in MicroStrategy 9. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. The Modeling service must be configured correctly to use this feature. the user still needs the privilege for re-publishing Intelligent Cubes, but just need this restricted for particular cubes), while still allowing this user to perform Visual Insight analysis on the cubes information. Defining the partition for Super Cubes. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. 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. However, a lot of the advanced functionality requires the good old metadata, and having everything cubed means you will need a shit ton of RAM very quickly. STEPS TO REPRODUCE: 1) Add external dataset. 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. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. To use an attribute form. x Intelligent Cube status indication and workflow . This import bridge imports MicroStrategy logical tables as Dimensions. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The Intelligent Cube Options dialog box opens. 4. For more information on the Intelligent Cube Maximum. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. Cube Limitations. Why MicroStrategy Why MicroStrategy; Customer StoriesHyperIntelligence is a new addition to MicroStrategy Workstation that allows analysts to inject analytics and intelligence directly into every user's experience. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. 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. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. For the steps to define an incremental refresh report, refer to:Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Open the Workstation window. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 4. x, when there are multiple fact tables available to perform the fact extension, different fact table are used by the analytical engine for the fact extension in Connect Live and In-Memory Intelligent Cube. 4. Intelligent. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. xThis article describes the Intelligent Cube Population options available in MicroStrategyPlease also see this article for more details: Data Engine changes in MicroStrategy 2021 release Acronym used: "CSI", which stands for "Cube Subsetting Instruction". x and 10. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. To Create a Report that Accesses an Intelligent Cube. To add an existing report or Intelligent Cube as a dataset. Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. 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. This defect is addressed in MicroStrategy 11. After the previous changes, you'll have to save the cube and republish it. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. x. Memory Storage for document or dossier. 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. x This is a new feature introduced in MicroStrategy version 9. . 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. After execution. Published: 4월 6, 2017. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. With OLAP Services features, your report designers can create Intelligent Cube reports. Choose Databases. 4. Exit all Windows applications before beginning the installation process. Create a report with this Intelligent Cube and execute the report --> one row with 4 element returned. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. IS_PROJ_ID. 0 MicroStrategy releases. Choose File > New > Intelligent Cube. Intelligent Cubes. IS_CUBE_INST_ID. 4. Open the. x and newer. for a script with several commands, one of which being a cube publication command, the. KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. This import bridge imports MicroStrategy logical tables as Dimensions. Users cannot trigger or schedule cube republishing. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. This means you can manually change the suffix to . MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. 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. Intelligent Cube memory usage for each node in a clustered environment. This will reduce the memory usage from 150GB to 100GB. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions: A metric with the same formula and transformation exists in the Intelligent Cube. You can create and analyze new reports in real time. KB442630: CSI optimization for improving the in-memory query execution for many. . III. 1. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. This Knowledge base article describes limitations in using security filters and intelligence cubes. 7. Limiting the Maximum Report Size. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Forecast Sales. In MicroStrategy 10. 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)". 3. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Drag and drop the objects into the report grid from the Report Objects pane. Create an Intelligent Cube with attributes Year, Month and Region; 4. Export data frames from RStudio to MicroStrategy in-memory cubes. 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. Updating Intelligent Cubes without re-processing: Incremental Refresh. The cube is based on a MDX datasource, specifically SAP BW. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. Measures the time duration an operation executed against cubes. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. This knowledge base article assumes that the user has a month attribute whose format is YYYYMM as shown below and s/he wants to delete more than 12 months’. The following diagram depicts the role of the intelligent cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Edit SQL Transactions in Reports. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). However, the cube monitor doesn’t show partition related information. You can create and analyze new reports in real time. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Modify or remove the view filter to attempt to return data for the report. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. If the indexes are needed again,. Integer ID of the Intelligent Cube report that was published, if any. The. All necessary privileges are included in the Administrator role by default. IS_CUBE_INST_ID. Based on the previous explanation, you should only create derived attributes or metrics whenever. MicroStrategy logical tables do not necessarily represent physical tables. Providing Intelligent Cube data. In MicroStrategy Web, open the document in Design Mode or Editable Mode. In MicroStrategy Developer, log in to a project source with administrative privileges. Although the directory filed shows the same location as the source project, cubes are saved to a. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. The Intelligent Cube refresh settings are recommended if the data in the. If desired, user can create a dashboard immediately from the imported data. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. 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. Slice and dice features are awesome. How to configure, monitor, and manage Intelligent Cubes. IS_PROJ_ID. 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. To enable or disable dynamic sourcing for an Intelligent Cube. 6 and higher. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. 3. The dataset is a set of data that can be displayed on the document. 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. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. OR, to convert an existing filter into a security filter, click Import. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. When a remote accesses this cube, the cube is loaded into memory of the. Cube Limitations. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. 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. HyperAndroid Go to the Account tab. A document is used to format data from multiple datasets in a single display of presentation quality. The Full Refresh option is the default. Web Open the Settings page (right click the extension and select Options). Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. There's a reason we're at the top of the list. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Create a New Dossier. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 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. Strong semantic layer to define all the business rules and tightly coupled. 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. conf and add the following lines. The Security Filter Editor opens. 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. 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. For example, Create a report with an attribute with only one attribute form. Total Cubes This section displays the total count of cubes by status. 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. Cube Advisor opens. It is recommended that the Excel file size should not exceed 1GB. 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). Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 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. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. Job ID for the action on the Intelligent Cube. 3 - Check the Make Intelligent. MicroStrategy 10 will report the following. The Intelligent Cube must not be re-processed based on a metric. Click View Logs, to display the share icon in the upper-left. Only one cube file will be generated for each Intelligent cube on disk. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. Typically, a cube is setup to be published at regular intervals and is saved in the server's main memory, eliminating the time-consuming need to query the Big. x to 11. Use the drop-down under the filter summary section to switch the server nodes. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. x and newer. The Intelligent Cube Options dialog box opens. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. - Normalize Intelligent Cube data in the. Edit Intelligent Cubes from the new editor in Workstation at any time. Intelligent cubes support time zone based reporting. Using Database Write-back Functionality to Enable Decision-Making. 56K. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. OR, to convert an existing filter into a security filter, click Import. In MicroStrategy Developer, right-click on the project and select Project. 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. certify() to certify / decertify an existing super cube. To define an incremental refresh report. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. Modeling is creating information that describes another set of data. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. The objects in the source cubes will control how the security filter will be applied. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 0 MicroStrategy releases. 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. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. 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. 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. 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. MicroStrategy HyperIntelligence is the next step in the future of data analytics. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The requests are granted or denied according to user-configured limits on the amount of. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. When you first click on "Add External Data" and a list of connectivity options come up, there is now a small icon at the top left, that allows you to filter the connections for those that support Live Connect. When you run reports in MicroStrategy, they collect the warehouse data. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Implicit degradation occurs when the Intelligent cube report level is not compatible with the fact level of any metric being used in the Intelligent Cube (Fact Editor > Tools > Show Fact Entry Level) so a cross join between the fact table and the report level attribute is needed resulting in a fact extension and disabling Dynamic Sourcing for that specific Intelligent. 3 - Check the Make Intelligent Cubes. An example of this behavior for a relatively small cube is shown in the screen shots below:The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. The memory used by Intelligence Server is limited by the machine's virtual memory. Navigate to the Intelligent Cube for which you want to define the incremental refresh. KB442449: Dossier Performance: Connect Live performance considerations. Create Cube1 with the Region attribute and the metric created in step 1. IS_CUBE_REP_ID. Therefore, the Cache Status is stored in the fact_latest_cube_cache and fact_action_cube_cache tables to track the latest, historical, and changing status over the life of the cube cache instance. This is controlled by the Python script. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). 1 and 10. From the Data menu, select Add Dataset. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to its memory limit. However, if the. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. First, you open a blank document and select a report to use as the document's dataset. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. Once activated, the user loads the cube in memory. A report that runs against the Intelligent Cube. It is shared by all processes running on the machine, including the operating system. 0 has a dedicated section to memory used for Intelligent Cubes. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. Another way to use caching in MicroStrategy is through Intelligent Cubes. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. 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 Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Senior Lead, Application Support. x or 10. The Select Dataset dialog box opens. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 2. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. For example, the above Data Import fails even though the actual utilization of the Intelligent Cubes are 5388mb out of 12000mb, and the Data Import Manager from MicroStrategy. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. BACKGROUND: When configuring a MicroStrategy Intelligence Server cluster, special configuration must be made in order for the Intelligence Server cluster nodes to be able to access report and document caches, intelligent cubes, history list messages, and session recovery files that were created on other nodes of the cluster. Select the schedule you had created in step 2 and in the Intelligent Cubes field, select the desired Intelligent Cube as seen below: 6. MicroStrategy Analytics cubes are easy to create and deploy. In a BI platform, the logical data model is designed and built using current user requirements. . The Security Filter Editor opens.