Create an attribute element prompt for the. KB222608: In a clustered environment in MicroStrategy 9. Publish the Intelligent Cube by executing it on either of the nodes. In addition, multiple logical tables can represent the same physical table. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Navigate to and run the Intelligent Cube report. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Using any other database should not have any implications, given that TPT is only applicable to Teradata. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Click View Logs, to display the share icon in the upper-left. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. 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. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. Complex metrics here refer to metrics which are defined using multiple. It will remain available, but the setting will not be enforced if set below the default value of 100000. Documents . . The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. MicroStrategy Professional Services for high performance. Related Articles. MicroStrategy Web: Web Server. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. Dossier Datasets do not include all the Security Filter attributes, and one of the Datasets are Connect Live Data Import Dataset, it may have security concerns. Create Schema Objects. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. 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. The Incremental Refresh Options dialog box opens. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. To view this field, the Intelligent Cube must be published at least once. Users of Intelligent Cubes in MicroStrategy 9. Data Population for Intelligent Cubes. Only one cube file will be generated for each Intelligent cube on disk. 0 has a dedicated section to memory used for Intelligent Cubes. The Security Filter Editor opens. 3 - Check the Make Intelligent. This. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. The Select Dataset dialog box opens. Create a Data Import Live Intelligent Cube. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Explain the process of creating intelligent cubes in MicroStrategy? Public folder or a specific user folder can be. ACTION: A fix for this issue is included in MicroStrategy 10. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. Designing and creating documents: An overview. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. By default, there is a system hierarchy on the cube. In MicroStrategy 9. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Starting with MicroStrategy Intelligence Server 9. 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. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the. x Intelligent Cube status indication and workflow . The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. x and newer. A set of data is returned from the. Contact the MicroStrategy Technical Support for an update on this enhancement request. Check the status of the cubes in Developer. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. table_name: is the name of a table. Measures the time duration an operation executed against cubes. Intelligent Cube memory usage for each node in a clustered environment. An Intelligent Cube is a. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . The. It is also more difficult or impossible for someone reporting on Intelligent Cube. table_id: is the guid of a table. By profiling the Intelligent Cube publication (as per KB30699 - How to measure the Intelligent Cube performance parameters for time and memory in the MicroStrategy Intelligence Server 9. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. My complaint is that a lot of the new stuff just works in the "import data into an intelligent cube" model and not the good old metadata. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. 1. In addition, multiple logical tables can represent the same physical table. x) • MSI_STATS_PROP (properties table that MicroStrategy Intelligence Server uses to initialize statistics logging) • IS_SESSION_STATS (server session statistics)In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. The New Grid dialog box opens. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Choose your preferred method to share the logs. Updating Intelligent Cubes without re-processing: Incremental Refresh. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Integer ID of the Intelligent Cube report that was published, if any. To build an Intelligent Cube. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). When an Intelligent Cube is in this status, any reports based on this cube have. 56K. 3. 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. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. reg file on UNIX/Linux operating systems. Log on to the machine where you are installing one or more MicroStrategy products. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. SYMPTOM Users may notice that duplicate cube instances are created after an intelligent cube that had a neutral locale is updated with a multilingual. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 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. MicroStrategy version 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. x, create a simple Intelligent Cube with attribute Category and metric Revenue. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. You cannot create a card based on a live-connect MDX/SAP cube. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. In the New Intelligent Cube dialog box, select the MDX Sources tab. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. Data modeling is the structuring of an organization's data assets into an applicable logical model. The data used for this example is. IS_CUBE_REP_ID. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). x releases, and the new Multi-table Data Import (MTDI) cubes. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. The requests are granted or denied according to user-configured limits on the amount of. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Drill up, down, and sideways to get a 360-view of. In MicroStrategy 10. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. You can use. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. STEPS TO REPRODUCE: 1) Add external dataset. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. SYMPTOMS: After duplication of a project in Developer that has a user-defined Intelligent Cube cache location, Intelligent Cubes created within the new project are not saved to the location specified in Intelligent Cube File Directory in Project Configuration. 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. Open the. IS_PROJ_ID. x. GUID of the Intelligent Cube instance in memory. Select the Security Filters tab. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. ACTION This. Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. This is the same requirement to create or run a static report in Workstation. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Using Database Write-back Functionality to Enable Decision-Making. This will work as a regular SQL comparison In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:Total number of columns: The number of columns of data that the Intelligent Cube contains. The Modeling service must be configured correctly to use this feature. 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. To enable or disable dynamic sourcing for an Intelligent Cube. Intelligent Cubes can be based on MicroStrategy data or imported data. In addition, multiple logical tables can represent the same physical table. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Intelligent. By default, MicroStrategy Command Manager handles cube publication synchronously (i. The limitations of Microstrategy are not worth. For example, an Intelligent Cube that contains data for the top 200 stores by Profit must be re-calculated every time it is updated, and thus must use the Full Refresh option. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. The following diagram depicts the role of the intelligent cube. If a new column is added to the data import data source and the cube is republished, there is no effect. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. x and newer. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Create the MIN (CurrentDateTime ()) metric. HyperAndroid Go to the Account tab. x If the Administrator wants to create a user that is. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The updates to the Intelligent Cube must be according to attributes only. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. Users cannot trigger or schedule cube republishing. It is especially useful when data. 4. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. 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. log without functional impact. These reports allow data to be returned from the data. x. You can edit project-level cache and Intelligent Cube settings. 11. 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:. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. 2. You can control users' access to data with security filters. Share query results in-memory across multiple dossiers and reports. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. Providing Intelligent Cube data. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. Create Cube B which contains all objects in the report and publish it . When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. 0. To Create a Report that Accesses an Intelligent Cube. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. Both properties are located in the Query Optimizations folder in the VLDB property editor. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. g. If desired, user can create a dashboard immediately from the imported data. cube; oracle12c; cubes; microstrategy; Jorgechu. the project configuration: ACTION . Click the “Add history list subscription” link near the bottom of the screen to open the. - Normalize Intelligent Cube data in the. 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. Import and save data from a file in a folder location. An Intelligent Cube publication takes significantly long to complete publication (several hours). mstr file is a zipped file of object definition package and cube files. MicroStrategy AE, even when the data is coming from an intelligent cube, MicroStrategy still needs to calculate the derived elements and depending on the data size and complexity sometimes these calculations can take minutes. 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. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Rather than returning data from the data warehouse for a single. 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. Advanced category, select the Balance MicroStrategy Server threads check box. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. Published: 4월 6, 2017. E. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Memory Storage for document or dossier. 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. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Cube Advisor opens. Integer ID of the project where the Intelligent Cube is stored. View the report in either Grid View or Grid and Graph View. There's a reason we're at the top of the list. The cube is based on a MDX datasource, specifically SAP BW. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. 2. In MicroStrategy Developer, right-click on the project and select Project. 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. CAUSE. Cube and Cache Metric Names. If removing the view filter does not. The Intelligent Cube opens in the Report Editor. Slice and dice features are awesome. 2) Choose "Database" and select the 3rd option to "Pick tables". Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. MicroStrategy logical tables do not necessarily represent physical tables. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 2. MicroStrategy logical tables do not necessarily represent physical tables. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 2. This import bridge imports MicroStrategy logical tables as Dimensions. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent 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. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. When a machine runs out of virtual memory, processes on the machine are no longer able. Edit Intelligent Cubes from the new editor in Workstation at any time. Maintaining data access security. 4. x a new concept is introduced called Intelligent Cubes. The following table summarizes the test results of some test scenarios against Oracle 19c. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. In MicroStrategy Developer, log in to a project source with administrative privileges. 1 or above, to pick up the fix, enable project level setting "Data Engine. 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. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. 3. x, but not to publish it, the minimum privileges that the Administrator would need to. The. 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. 4. 0 MicroStrategy releases. In the Navigation pane, click , next to Objects. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. 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. A document that uses the Intelligent Cube as a dataset. Designing and creating documents: An overview. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Node 1. Index: P = Processing A = Active L = Loaded D = Dirty F = Filed M = Monitoring Information Dirty When a user executes an Intelligent Cube, the initial status is P. 0. 10 or earlier, outer join to Lookup table in a dashboard/dossier report based on Intelligent Cube with joint element list filter will not work, and incorrect CSI will be generated when both attributes used in the filter are present in visualization. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. 1 – Python program gets and processes the data from a Data Source. If the data in the Intelligent Cube is outdated. Web Open the Settings page (right click the extension and select Options). x. Easily add or change pre- and post- SQL statements. Answer: Go with dossier. When using an Intelligent Cube, you already have an in memory dataset. Also, verify that the /<path_to_the_location>/core. Along with. In MicroStrategy 9. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 86K KB31566: MicroStrategy 9. 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. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Although the directory filed shows the same location as the source project, cubes are saved to a. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. microstrategy. 17. x. In Developer, from the File menu select New, and then Intelligent Cube. for a script with several commands, one of which being a cube publication command, the. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. 0. 0 MicroStrategy releases. In a MicroStrategy Intelligence Server clustered environment, it is observed that dynamic sourcing does work against Intelligent Cubes available on a remote node, after updating the schema. Exit all Windows applications before beginning the installation process. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. This can be seen even when the actual total memory consumption of the Intelligent Cubes loaded for this Project is below the configured Governing Setting. 0: Balance MicroStrategy Server threadsDescription The . MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. 4 GB or higher. Create a report with this Intelligent Cube and execute the report --> one row with 4 element returned. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 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. Create a security filter on the region attribute such as region not in list central. Intelligence Server Statistics . This is due to the fact that adding prompts to Intelligent Cubes is not supported. The Security Filter Editor opens. Pros and Cons. Right-click an Intelligent Cube and select Delete. In the Navigation pane, click Monitors. 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. 3. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Moreover, you may generate among the various reports of many users. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. In MicroStrategy Developer, log in to a project source with administrative privileges. Total Cubes This section displays the total count of cubes by status. Published: Jun 29, 2018;KB321029: In MicroStrategy 10. Refer to the following MicroStrategy Knowledge Base. Users with different security filters can use the same Intelligent Cube data. 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. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. Choose Databases. IS_CUBE_INST_ID. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. Type of action against the Intelligent Cube: •In MicroStrategy 11. Making the move from Developer to Workstation even smoother, users can now create Intelligent Cube Reports in Workstation. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Create an Intelligent Cube with this attribute and publish. MicroStrategy 10 will report the following. 2. Published: Apr 6, 2017. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. 4. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. 4. To enable. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. A MicroStrategy Report Services document displays your organization's data in a format. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. HyperAndroid Go to the Account tab. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. Locate and run the Setup. MicroStrategy Intelligence Cube. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. IS_CUBE_ACT_ID. Select the Allow reports to drill outside the Intelligent Cube check box. 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. Integer ID of the Intelligent Cube report that was published, if any. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. On the toolbar, choose Data > Configure Intelligent Cube. This article describes how to trace Intelligent Cube activity. This dataset needs to contain all data in the required granularity. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. Use Cube Advisor to create Intelligent Cubes: 1. Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). x? To answer this question, the "Query Engine finish time" is marked when the warehouse query step for generating the Intelligent Cube finishes. For more details on enabling the setting, refer to Change Data Engine VersionCertify a super cube¶ Use SuperCube. x. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. Select the data set and click Prepare Data. 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, 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. . Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube.