Expand Intelligent Cubes, and then select General. Pros and Cons. The article discusses a known situation in MicroStrategy 10. Select the schedule you had created in step 2 and in the Intelligent Cubes field, select the desired Intelligent Cube as seen below: 6. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. 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’. A MicroStrategy Report Services document displays your organization's data in a format. In addition, multiple logical tables can represent the same physical table. The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. Choose File > New > Intelligent Cube. By default, the report template used is the same as the Intelligent Cube's template. It will remain available, but the setting will not. Strong semantic layer to define all the business rules and tightly coupled. This issue has been classified as a defect by MicroStrategy. It is shared by all processes running on the machine, including the operating system. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. 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. conf and add the following lines. Intelligent Cubes are multidimensional cubes (sets of data) that exist on the MicroStrategy Intelligence Server memory and can be shared among different users. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. What BO customers are interested in knowing 3A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. III. This dataset needs to contain all data in the required granularity. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 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. 3. The. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. x. In MicroStrategy Developer, right-click on the project and select Project. Um Cubes zu erstellen, müssen Sie über die folgenden zusätzlichen Privilegien verfügen: Verwenden Sie den Intelligent Cube Editor, um auf alle Merkmale und Funktionen zum Erstellen von Cubes zuzugreifen. x. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. Type of action against the Intelligent Cube: •In MicroStrategy 11. 1. The Intelligent Cube Options dialog box opens. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Cube Advisor opens. If the Intelligent Cube must be re-processed based on a metric. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. Öffnen Sie das Workstation-Fenster. Datasets API. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. HyperAndroid Go to the Account tab. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Also, verify that the /<path_to_the_location>/core. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. When a machine runs out of virtual memory, processes on the machine are no longer able. Share query results in-memory across multiple dossiers and reports. x? To answer this question, the "Query Engine finish time" is marked when the warehouse query step for generating the Intelligent Cube finishes. 4. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Providing Intelligent Cube data. 0. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. OR, to convert an existing filter into a security filter, click Import. 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. 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". You can edit project-level cache and Intelligent Cube settings. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. * MicroStrategy does have support for dynamic sourcing with MDX sources. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Integer ID of the Intelligent Cube report that was published, if any. x. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. Providing Intelligent Cube data. GUID of the Intelligent Cube instance in memory. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. microstrategy. If removing the view filter does not. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. Choose Data > Configure Intelligent Cube. 2. 2, it is possible to load an Intelligent Cube into memory on all the nodes of the cluster, after the Intelligent Cube finishes publication on one node. However, the cube monitor doesn’t show partition related information. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Create the MIN (CurrentDateTime ()) metric. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. 3. In the Data Source column, select the checkboxes for the tables to update. log without functional impact. MicroStrategy AI is here. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Contact the MicroStrategy Technical Support for an update on this enhancement request. After execution. Like cache update subscriptions, Intelligent Cube. Transactions. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. Defining the partition for Super Cubes. You may share the Intelligent Cube as a single copy in memory. Create Schema Objects. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. You cannot create a card based on a live-connect MDX/SAP cube. This Python 3 / MicroStrategy 10. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. Edit Intelligent Cubes from the new editor in Workstation at any time. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. In addition, multiple logical tables can represent the same physical table. You can control users' access to data with security filters. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. In MicroStrategy Integrity Manager 10. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. 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. SYMPTOM Users may notice that duplicate cube instances are created after an intelligent cube that had a neutral locale is updated with a multilingual. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. 9 and 10. You can add data for your Intelligent. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). certify() to certify / decertify an existing super cube. When using an Intelligent Cube, you already have an in memory dataset. For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. Click All Objects View. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). 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. Create Cube2 with the Region attribute and the metric created in step 1. x, updating an Intelligent Cube returns "Cube Manager: number of c… Number of Views 1. IS_PROJ_ID. Refer to the following sections for a list of features that can and cannot be used with. 2. Note: The maximum file size that can be imported is 100 MB. Create a report with this Intelligent Cube and execute the report --> one row with 4 element returned. The requests are granted or denied according to user-configured limits on the amount of. For more information on the Intelligent Cube Maximum. 2. 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. IS_CUBE_ACT_ID. zip file, with the. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. This defect is addressed in MicroStrategy 11. 2 – The data is being pushed to MicroStrategy Intelligent. In MicroStrategy, users can trace MicroStrategy Intelligent Cube activity via the Cube Server Trace which can be enabled through MicroStrategy Diagnositcs Configuration as seen below: The following section displays excerpt from the Cube Server trace when different actions are. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. A set of data is returned from the. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. This difference is roughly equal to the size of the Intelligent Cube footprint in-memory versus the size of the compressed disk cache. Forecast Sales. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. MicroStrategy HyperIntelligence is the next step in the future of data analytics. Known Limitations and Challenges in MicroStrategy 2019 Update 2 HyperIntelligence for Office. 4. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 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. 3. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. In MicroStrategy Desktop 9. If the data in the Intelligent Cube is outdated. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. 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. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). This allows for more power and control over data for MicroStrategy. Slice and dice features are awesome. Along with. The Full Refresh option is the default. Software Categories. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. 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. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. xA warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. 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. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. 7. Navigate to the folder location of the Intelligent Cube. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. When you run reports in MicroStrategy, they collect the warehouse data. reg file on UNIX/Linux operating systems. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. 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. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. mstr file is a zipped file of object definition package and cube files. The Full Refresh option is the default. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. Use Cube Advisor to create Intelligent Cubes: 1. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. The ability to view or edit certain settings is determined by a user's privileges. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. The Maximum RAM usage (Mbytes) memory limit can be defined per project. It is shared by all processes running on the machine, including the operating system. Choose your preferred method to share the logs. Edit Intelligent Cubes from the new editor in Workstation at any time. Published: 4월 6, 2017. Create a dossier and add subset R from Existing Dataset. 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. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. In MicroStrategy 9. File subscriptions save the report or document as an Excel or. For example, Create a report with an attribute with only one attribute form. 0 votes. Click here to view details about the Intelligent Cube Monitor. This will reduce the memory usage from 150GB to 100GB. Edit SQL Transactions in Reports. Integer ID of the project where the Intelligent Cube is stored. Users with different security filters can use the same Intelligent Cube data. Right-click an Intelligent Cube and select Delete. table_name: is the name of a table. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. Mclean, Virginia. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. HyperAndroid Go to the Account tab. 4. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. MicroStrategy logical tables do not necessarily represent physical tables. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Create Cube1 with the Region attribute and the metric created in step 1. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. Browse to and select a previously saved Intelligent Cube on which to build your report. If desired, user can create a dashboard immediately from the imported data. Explain the process of creating intelligent cubes in MicroStrategy? Public folder or a specific user folder can be. First, you open a blank document and select a report to use as the document's dataset. On the toolbar, choose Data > Configure Intelligent Cube. Based on the previous explanation, you should only create derived attributes or metrics whenever. IS_CUBE_INST_ID. 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. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. These VLDB properties control the method by which the report data are normalized. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. 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. Click View Logs, to display the share icon in the upper-left. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. The following diagram depicts the role of the intelligent cube. table_id: is the guid of a table. Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available. The Intelligent Cube opens in the Report Editor. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 3 - Check the Make Intelligent Cubes. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Create a report on this intelligent cube with the month attribute and the count of day metric. Starting from MicroStrategy 9. In other words, the new column will NOT get mapped automatically in the existing Intelligent Cube. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. x. On the left side of the page, click Logs and then Export Logs to save the file. The Intelligent Cube opens in the Report Editor. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Go to the Report -> Data->Intelligent Cube Options->Point grid to. 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. Edit Project-Level Cache and Intelligent Cube Settings. 5 GB, the Data Transfer from Datasource(s) time is 77. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. 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. For more information on security filters, see the System Administration Guide. There's a reason we're at the top of the list. To enable or disable dynamic sourcing for an Intelligent Cube. The limitations of Microstrategy are not worth. Published: Apr 6, 2017. Measures the time duration an operation executed against cubes. Under VLDB settings > Query Optimizations > Data Population for Intelligent Cubes admins need to test all the following options: - Normalize Intelligent Cube data in the database. Use Case 4. The memory used by Intelligence Server is limited by the machine's virtual memory. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. 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. How to configure, monitor, and manage Intelligent Cubes. MicroStrategy logical tables do not necessarily represent physical tables. To do so, you can take advantage of URL API. 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. 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. Otherwise, it will increase the percentage to 200% if the "Maximum % of growth of intelligent cube due to indexes" governing rule. Download the files from the MicroStrategy download site. 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. This data is to apply the calculations. In MicroStrategy 10. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. MicroStrategy Analytics cubes are easy to create and deploy. To add an existing report or Intelligent Cube as a dataset. It is also more difficult or impossible for someone reporting on Intelligent Cube. STEPS TO REPRODUCE: 1) Add external dataset. The **_objects folder with a size of 277G. Starting with MicroStrategy Intelligence Server 9. Extensively used “Apply Simple” function for creating attributes. An enhancement Request has been reported to the MicroStrategy Technology team. The Incremental Refresh Options dialog box opens. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. 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. In MicroStrategy Web, open the document in Design Mode or Editable Mode. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Cube Limitations. In MicroStrategy Developer, log in to a project source with administrative privileges. Run sudo vi /etc/sysctl. Dynamic Sourcing. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. IS_CUBE_INST_ID. 0. 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. 0 has a dedicated section to memory used for Intelligent Cubes. . The data used for this example is. Select an Environment from the upper-left drop-down. 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. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Intelligent. The related section is located in. MicroStrategy Tutorial is used in this example. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. In this case, the dataset is a MicroStrategy Intelligent Cube. Create an Intelligent Cube with attributes Year, Month and Region; 4. x. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). The change journal logs now process the type, version, and name for databases configured in an environment. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. The dataset is a set of data that can be displayed on the document. Use the drop-down under the filter summary section to switch the server nodes. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. x, but not to publish it, the minimum privileges that the Administrator would need to. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. 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. This import bridge imports MicroStrategy logical tables as Dimensions. 11. Open the. In MicroStrategy 10. BUILD Because the in-memory ROLAP Cubes operate below the User Security and Prompting layers, they are able to serve a very wide variety of requests and. When a remote accesses this cube, the cube is loaded into memory of the. 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. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. The New Intelligent Cube dialog box opens. Published: Apr 6, 2017. 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. The Attribute Index An Intelligent Cube is an In-Memory data structure which holds information from a source in a readily accessible format for quick access. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. CAUSE. Job ID for the action on the Intelligent Cube. x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. 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. Run the Report and check the SQL View. x Intelligent Cube status indication and workflow . IS_PROJ_ID. Rather than returning data from the data warehouse for a single. 0. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. 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. 2. Traditional Report Caching in MicroStrategy is done on a matching basis. Select one: To create a new security filter, click New. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. x. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The Intelligent Cube must not be re-processed based on a metric. Number of Views 1. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. From the Data menu, select Add Dataset. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. 0: Balance MicroStrategy Server threadsDescription The . The Intelligent Cube Options dialog box opens. When using an Intelligent Cube, you already have an in memory dataset.