Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. View the report in either Grid View or Grid and Graph View. To enable or disable dynamic sourcing for an Intelligent Cube. It remains available, but is not enforced if it is less than the default value of 100000. First, you open a blank document and select a report to use as the document's dataset. 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. 3. You must belong to the System Administrators group to use this feature. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. 4. Users cannot trigger or schedule cube republishing. 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. Designing and creating documents: An overview. 2. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. Rather than returning data from the data warehouse for a. Select the Allow reports to drill outside the Intelligent Cube check box. Intelligent cubes support time zone based reporting. This dataset needs to contain all data in the required granularity. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Run a dossier based on the cube. The ability to view or edit certain settings is determined by a user's privileges. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. KB222608: In a clustered environment in MicroStrategy 9. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. These reports allow data to be returned from the data. 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. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. In MicroStrategy Developer, log in to a project source with administrative privileges. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Use Cube Advisor to create Intelligent Cubes: 1. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). x and 10. Intelligent Cube storage on disk mirrors report cache storage. 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. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. the project configuration: ACTION . When using an Intelligent Cube, you already have an in memory dataset. 143; asked Oct 2, 2014 at 14:58. x. Drill up, down, and sideways to get a 360-view of. The Full Refresh option is the default. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. This will reduce the memory usage from 150GB to 100GB. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Strong semantic layer to define all the business rules and tightly coupled. When a remote accesses this cube, the cube is loaded into memory of the. 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. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. 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. Forecast Sales. 4. 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. Designing and creating documents: An overview. Select an Environment from the upper-left drop-down. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Log on to the machine where you are installing one or more MicroStrategy products. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Related Articles. Job ID for the action on the Intelligent Cube. 86K KB31566: MicroStrategy 9. 3 - Check the Make Intelligent Cubes. Overview. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. When a machine runs out of virtual memory, processes on the machine are no longer able. Publish the cube. This dataset needs to contain all data in the required granularity. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. 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. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Open the. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Choose your environment, project, and Intelligent Cube as your dataset type. Cube Limitations. 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. 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. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. MicroStrategy 10 will report the following. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. 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. Moreover, you can return a data. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. 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. 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. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. Expand the Object Templates category, select General, and from the. 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. 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. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Can. If desired, user can create a dashboard immediately from the imported data. 3 - Check the Make Intelligent. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. Both properties are located in the Query Optimizations folder in the VLDB property editor. 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. 0 MicroStrategy releases. Type of action against the Intelligent Cube: • Enable partitioning in OLAP cubes To enable cube partitioning in OLAP cubes, follow the steps in the olap_partition video. The Incremental Refresh Options dialog box opens. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. location_path: is the folder where the intelligent cube. This import bridge imports MicroStrategy logical tables as Dimensions. Why is This Happening? MicroStrategy uses different default encoding for Linux (UTF-8) and Windows (Non UTF-8). Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The change journal logs now process the type, version, and name for databases configured in an environment. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Node 2. In the Drilling area, clear the Use default settings check box. In MicroStrategy Analytics Enterprise Web 10 onewards, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI) which has been renamed as Super Cubes in MSTR 2019. . Solution This issue has been addressed in MicroStrategy 2021. "The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. x -10. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. This is set to 32,000 by default. There's a reason we're at the top of the list. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. To build an Intelligent Cube. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. table_id: is the guid of a table. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Intelligent Cubes can be based on MicroStrategy data or imported data. If the Intelligent Cube must be re-processed based on a metric. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. You can control users' access to data with security filters. 1 release. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Run sudo vi /etc/sysctl. Once activated, the user loads the cube in memory. To add an existing report or Intelligent Cube as a dataset. In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . 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. 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’. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. 0. The Security Filter Editor opens. Click the MicroStrategy icon at the upper left of any page and select History List. 15K. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. 2 – The data is being pushed to MicroStrategy Intelligent. 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. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. The Intelligence Server checks to see if there is an existing cache for the same Report. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. 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. 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. Create Cube B which contains all objects in the report and publish it . Use this option under the following conditions: If the data in the Intelligent Cube is outdated. CAUSE. MicroStrategy logical tables do not necessarily represent physical tables. When using an Intelligent Cube, you already have an in memory dataset. 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. You cannot create a card based on a live-connect MDX/SAP cube. This data is to apply the calculations. x using Command Manager. The Intelligent Cube Monitor is displayed. From the Categories list, expand Options, and then select General. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. If you are upgrading to MicroStrategy 11. This Knowledge base article describes limitations in using security filters and intelligence cubes. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. 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. Provides the last cube row count. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. Web Open the Settings page (right click the extension and select Options). The Intelligent Cube opens in the Report Editor. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. x, but not to publish it, the minimum privileges that the Administrator would need to. Choose one of the following options: Full Refresh: This is the default. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. 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. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. Locate and run the Setup. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. In MicroStrategy 9. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Intelligent Cubes. IS_CUBE_REP_ID. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). x. Choose your preferred method to share the logs. Published: Apr 6, 2017. Edit Intelligent Cubes from the new editor in Workstation at any time. 4 the connection mapping of the u… Number of Views 1. 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. Create Schema Objects. The Intelligent Cube Options dialog box opens. 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. The first is to enable report caching at the project level. 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. Create a Report 'R3' with 'Country' attribute. MicroStrategy Tutorial is used in this example. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Documentation on the REST API is at developer. Report: The results of a report are used to populate the Intelligent Cube. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Job ID for the action on the Intelligent Cube. 4. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. xA warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. IS_CUBE_INST_ID. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Select the Security Filters tab. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. 17. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. Intelligent Cubes are a more aggressive form of caching and allow multiple reports to be stored in the Cube (which is effectively a large cached report stored in memory on the. 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Integer ID of the Intelligent Cube report that was published, if any. Feb 2020 - May 2022 2 years 4 months. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. Create a report based on above Cube and add the prompt in view filter. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 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. Mclean, Virginia. With OLAP Services features, your report designers can create Intelligent Cube reports. You can control users' access to data with security filters. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. 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. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. 0 votes. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. 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. This import bridge imports MicroStrategy logical tables as Dimensions. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. x. All cubes respect the governing setting. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. Intelligence Server Statistics . com The Maximum RAM usage (Mbytes) memory limit can be defined per project. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. 3. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. This enterprise analytics tool works seamlessly across web-based content, mobile devices, and Microsoft Outlook to bring answers to people through relevant, context-based analytics. 0: Balance MicroStrategy Server threadsDescription The . A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. This property can only be enabled through Workstation. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. 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. 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. Traditional Report Caching in MicroStrategy is done on a matching basis. 4. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. Number of Views 5. To define an incremental refresh report. IS_CUBE_REP_ID. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. This allows for more power and control over data for MicroStrategy. Dynamic Sourcing. These VLDB properties control the method by which the report data are normalized. 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. . 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . 1, Intelligent Cubes have a new feature to update information without republishing it. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. 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. A valid CPU architecture is provided in parentheses () to clarify the operating system software certified or supported for Intelligence Server. Because the filters are applied to the master data in the Intelligent. Select the data set and click Prepare Data. A report that runs against the Intelligent Cube. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. The cube is based on a MDX datasource, specifically SAP BW. Required Status to Perform Action. Number of Views 523. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. STEPS TO REPRODUCE 1. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. An Intelligent Cube has been created in a project. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. Select the Security Filters tab. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. 3. The Maximum RAM usage (Mbytes) memory limit can be defined per project. 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. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. x a new concept is introduced called Intelligent Cubes. Choose Data > Configure Intelligent Cube. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Along with. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). 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. Data Population for Intelligent Cubes. 2. x. Cube Advisor opens. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. The objects in the source cubes will control how the security filter will be applied. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. Integer ID of the Intelligent Cube report that was published, if any. 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. MicroStrategy Analytics cubes are easy to create and deploy. iCubes, however, has some limitations and thereby needs to be used judiciously based on the need. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. metrics in the intelligent cube or in the MicroStrategy schema and application objects. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 4. 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. MicroStrategy logical tables do not necessarily represent physical tables. The Intelligent Cube refresh settings are recommended if the data in the. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 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. x, create a simple Intelligent Cube with attribute Category and metric Revenue. You may share the Intelligent Cube as a single copy in memory. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. zip and use 7Zip, or similar tools, to unzip it. The **_objects folder with a size of 277G. 2. Share query results in-memory across multiple dossiers and reports. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. The data used for this example is. 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. From the Data menu, select Configure Intelligent Cube. The cube leverages both memory and a file on the disk, so data is quickly reloaded into memory when required. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. In MicroStrategy Integrity Manager 10. Before MicroStrategy 10. 9 and 10. 0. The Modeling service must be configured correctly to use this feature. Open the. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. This is the same requirement to create or run a static report in Workstation. 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%. IS_CUBE_ACT_ID. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. Since Intelligent Cubes function simply as. 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. Published: 4월 6, 2017. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. 2. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Publish the Intelligent Cube by executing it on either of the nodes. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. OR, to convert an existing filter into a security filter, click Import. IS_CUBE_ACT_ID. microstrategy. Select the schedule you had created in step 2 and in the Intelligent Cubes field, select the desired Intelligent Cube as seen below: 6. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. Pros and Cons. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. In addition, multiple logical tables can represent the same physical table. Cube and Cache Metric Names. Share query results in-memory across multiple dossiers and. 3. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. After execution.