MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. Report: The results of a report are used to populate the Intelligent Cube. Also, verify that the /<path_to_the_location>/core. 1, Intelligent Cubes have a new feature to update information without republishing it. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. CAUSE. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 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. Strong semantic layer to define all the business rules and tightly coupled. 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. Select the Allow reports to drill outside the Intelligent Cube check box. Select one: To create a new security filter, click New. Edit Intelligent Cubes from the new editor in Workstation at any time. 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. 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. Drag and drop the objects into the report grid from the Report Objects pane. When running MicroStrategy Intelligence Server 9. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. Solution This issue has been addressed in MicroStrategy 2021. 3. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. The default value is 256 megabytes. Open the Workstation window. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. 4 the connection mapping of the u… Number of Views 1. The Intelligent Cube opens in the Report Editor. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. Mclean, Virginia. First, you open a blank document and select a report to use as the document's dataset. Select the Security Filters tab. These VLDB properties control the method by which the report data are normalized. x - 10. x, updating an Intelligent Cube returns "Cube Manager: number of c… Number of Views 1. A workaround is available in the current document. Number of Views 1. Defining Intelligent Cube refresh settings. Under Refresh type, select one of the following options. 0. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The requests are granted or denied according to user-configured limits on the amount of. By default, there is a system hierarchy on the cube. Job ID for the action on the Intelligent Cube. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. A report that runs against the Intelligent Cube. Most likely several, different fact tables are uses for each query. 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. For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. Add Year Id and Quarter. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Data modeling is the structuring of an organization's data assets into an applicable logical model. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. To review and create recommended Intelligent Cubes using Cube Advisor. Navigate to the folder location of the Intelligent Cube. If the Intelligent Cube must be re-processed based on a metric. If removing the view filter does not. 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. x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Browse to and select a previously saved Intelligent Cube on which to build your report. Steps To Reproduce 1. x This is a new feature introduced in MicroStrategy version 9. Providing Intelligent Cube data. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Cube Advisor opens. Choose Databases. x. 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. 2. Create an Intelligent Cube with this attribute and publish. 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. "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'. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. 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. In addition, multiple logical tables can represent the same physical table. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. In Enterprise Manager 10. When you run reports in MicroStrategy, they collect the warehouse data. 0. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. MicroStrategy logical tables do not necessarily represent physical tables. You can use. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. You must belong to the System Administrators group to use this feature. Both properties are located in the Query Optimizations folder in the VLDB property editor. In MicroStrategy 9. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. 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. - Normalize Intelligent Cube data in the. Open the. Technically this will result is different queries on the database, due to the fact that each calculation level is different. IS_CUBE_REP_ID. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Dynamic Refresh: The Intelligent Cube's filter is. 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. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. 7. Intelligent Cube memory usage for each node in a clustered environment. 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. 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. MicroStrategy HyperIntelligence is the next step in the future of data analytics. x in maintenance mode, it is recommended for users to enable the setting Cluster Synch Check Duplicate Cubes through the Windows registry or through the MSIReg. 5. Edit Intelligent Cubes from the new editor in Workstation at any time. For more details on enabling the setting. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 4. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. exe file. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Create a dossier and add subset R from Existing Dataset. The New Intelligent Cube dialog box opens. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. x using Command Manager. 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. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. 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. While this can improve performance of these reports. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. This dataset needs to contain all data in the required granularity. STEPS TOP REPRODUCE: 1. Pros and Cons. Total Cubes This section displays the total count of cubes by status. By default, the report template used is the same as the Intelligent Cube's template. Expand Intelligent Cubes, and then select General. Extensively used “Apply Simple” function for creating attributes. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Overview. 3. To build an Intelligent Cube. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. STEPS TO REPRODUCE: 1) Add external dataset. Open the. 0. Use Case 4. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to. 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%. 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. An Intelligent Cube publication takes significantly long to complete publication (several hours). Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. In the New Intelligent Cube dialog box, select the MDX Sources tab. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. For instance, let’s say you have an Intelligent Cube with 2 million rows and 10 attributes and 5 Expand Intelligent Cubes, and then select General. Exit all Windows applications before beginning the installation process. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. The MicroStrategy Intelligence Server 9. 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. These VLDB properties control the method by which the report data are normalized. Use Cube Advisor to create Intelligent Cubes: 1. 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%. With OLAP Services features, your report designers can create Intelligent Cube reports. for a script with several commands, one of which being a cube publication command, the. However, if the Intelligent Cube Monitor on the other node is checked, the size of the same Intelligent Cube will be smaller. 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. The Security Filter Editor opens. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. When using MicroStrategy and Teradata, the best approach is to. microstrategy. This defect is addressed in MicroStrategy 11. To review and create recommended Intelligent Cubes using Cube Advisor. Designing and creating documents: An overview. This import bridge imports MicroStrategy logical tables as Dimensions. IS_CUBE_REP_ID. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. In Developer, from the File menu select New, and then Intelligent Cube. HyperAndroid Go to the Account tab. Right-click an Intelligent Cube and select Delete. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. A solution/code fix for this issue is not available in current releases but is. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Expand the Object Templates category, select General, and from the. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. You can control users' access to data with security filters. Intelligence Server Statistics . 4. In the Data Source column, select the checkboxes for the tables to update. Comparing OLAP and MTDI cubes. Web Open the Settings page (right click the extension and select Options). MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. It is shared by all processes running on the machine, including the operating system. Then it generates a report. Publish the Intelligent Cube by executing it on either of the nodes. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. In the Navigation pane, click , next to Objects. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. 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. This. Vn (with metric Mn from source cube Cn). Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 0. 2. Explain the process of creating intelligent cubes in MicroStrategy? Public folder or a specific user folder can be. Intelligent Cube file directory Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. Choose File > New > Intelligent Cube. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. To customize your filename, please refer to the man page of core(5). Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. com. 5 GB, the Data Transfer from Datasource(s) time is 77. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. . KB35600: Users are unable to restore attributes' default display settings through the attribute display option in the data menu for an Intelligent Cube in MicroStrategy Developer 9. 8. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. Create an attribute element prompt for the. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Create Cube2 with the Region attribute and the metric created in step 1. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. A MicroStrategy Report Services document displays your organization's data in a format. x and newer. The considerations and steps required to fully support dynamic sourcing are listed below: While many MicroStrategy features can be used with dynamic sourcing, some features may prevent the use of dynamic sourcing between reports and Intelligent Cubes. Publish the Intelligent Cube by executing it on either of the nodes. metrics in the intelligent cube or in the MicroStrategy schema and application objects. All necessary privileges are included in the Administrator role by default. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. Right-click an Intelligent Cube and select Delete. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available. IS_CUBE_INST_ID. 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. 4. Cube Limitations. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Click here to view details about the Intelligent Cube Monitor. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. A document is used to format data from multiple datasets in a single display of presentation quality. 0. 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. Run a dossier based on the cube. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Select an Environment from the upper-left drop-down. The Intelligence Server checks to see if there is an existing cache for the same Report. An example of this behavior for a relatively small cube is shown in the screen shots below:The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Recorded at World 2021. Create Schema Objects. Export data frames from RStudio to MicroStrategy in-memory cubes. This Python 3 / MicroStrategy 10. 4. You cannot create a card based on a live-connect MDX/SAP cube. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. Defining the partition for Super Cubes. 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. Intelligent Cube file directory: Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. The Full Refresh option is the default. microstrategy. In the Navigation pane, click Monitors. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. For more information on security filters, see the System Administration Guide. The Modeling service must be configured correctly to use this feature. 143; asked Oct 2, 2014 at 14:58. On the toolbar, choose Data > Configure Intelligent Cube. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Pros and Cons. 2. The Intelligent Cube Options dialog box opens. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. Modify or remove the view filter to attempt to return data for the report. 2. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. conf and add the following lines. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. The **_objects folder with a size of 277G. Create Cube1 with the Region attribute and the metric created in step 1. E. Slice and dice features are awesome. In addition, multiple logical tables can represent the same physical table. HyperAndroid Go to the Account tab. The Modeling service must be configured correctly to use this feature. 11. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. This can improve the performance of. 3. x and newer. Check in Developer that the stopped node is in Maintenance Mode. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. View the report in either Grid View or Grid and Graph View. In versions prior to MicroStrategy Intelligence Server 9. For example, an Intelligent Cube includes the. Transactions. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. See full list on community. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. KB222608: In a clustered environment in MicroStrategy 9. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Publish the cube. 2) Choose "Database" and select the 3rd option to "Pick tables". Create a New Dossier. mstr file is actually a . Technically this will result is different queries on the database, due to the fact that each calculation level is different. Introduction. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. IS_PROJ_ID. 4. 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. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. The Select Dataset dialog box opens. After execution. Slice and dice features are awesome. 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. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. location_path: is the folder where the intelligent cube. If the data in the Intelligent Cube is outdated. Web Open the Settings page (right click the extension and select Options). Share query results in-memory across multiple dossiers and. This import bridge imports MicroStrategy logical tables as Dimensions. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. log without functional impact. Create a report with the year and quarter attributes and the profit metric. 5. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. Documentation on the REST API is at developer. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. The Modeling service must be configured correctly to use this feature. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. Complex metrics here refer to metrics which are defined using multiple. In addition, multiple logical tables can represent the same physical table. KB442449: Dossier Performance: Connect Live performance considerations. Save the Cube with Connect Live Data Access Mode. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. 15K. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. 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‘. Data Population for Intelligent Cubes. The related section is located in. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. You can add data for your Intelligent. Provides the last cube row count. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. x. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. After the previous changes, you'll have to save the cube and republish it. . Intelligent. 4. In addition, multiple logical tables can represent the same physical table. Limiting the Maximum Report Size. Prerequisites to creating Intelligent Cubes. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Download the files from the MicroStrategy download site. Integer ID of the Intelligent Cube report that was published, if any. x? To answer this question, the "Query Engine finish time" is marked when the warehouse query step for generating the Intelligent Cube finishes. 3. When a machine runs out of virtual memory, processes on the machine are no longer able. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. The interface has changed a bit. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. MicroStrategy logical tables do not necessarily represent physical tables. Node 2. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Check the status of the cubes in Developer. 0 MicroStrategy releases. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. Browse to the filter you want to convert and click Open. 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.