This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. 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. Create an intelligent cube report with Year and three derived metrics and enable "Aggregate from base" as shown below: Insert view filter "Year in list (2009)". Instantly analyze any amount of data without in-memory limitations of MicroStrategy intelligent data models. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Implicit degradation occurs when the Intelligent cube report level is not compatible with the fact level of any metric being used in the Intelligent Cube (Fact Editor > Tools > Show Fact Entry Level) so a cross join between the fact table and the report level attribute is needed resulting in a fact extension and disabling Dynamic Sourcing for that specific Intelligent. Constant Value: 220 (0x000000dc)When enabling the option to "Fetch data slices in parallel from the warehouse" from the Intelligent Cube Options > Data Partitions menu, TPT is required to be disabled on the database side when using Teradata as a Warehouse. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. This can be seen in the screenshot below. Right-click the dataset, and choose Schedule. MicroStrategy tests on at least one of the CPU chipsets within a set of binary-compatible CPU architectures for purposes of certifying and supporting operating systems with MicroStrategy products. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. 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. The Maximum RAM usage (Mbytes) memory limit can be defined per project. This will reduce the memory usage from 150GB to 100GB. Click the MicroStrategy icon at the upper left of any page and select History List. Select the Security Filters tab. 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. IS_CUBE_REP_ID. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Select the Allow reports to drill outside the Intelligent Cube check box. The Intelligent Cube must be published before this report can execute. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. You must belong to the System Administrators group to use this feature. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. 4. 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. The status of each Intelligent Cube is listed in the. Job ID for the action on the Intelligent Cube. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Another way to use caching in MicroStrategy is through Intelligent Cubes. x. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. 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. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. Open the. From the Data menu, select Add Dataset. Answer: Go with dossier. However, if the Intelligent Cube Monitor on the other node is checked, the size of the same Intelligent Cube will be smaller. The Intelligent Cube opens in the Report Editor. Create a report based off the cube in Step 1 that includes the description form for Category. Enable core dumping. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. This import bridge imports MicroStrategy logical tables as Dimensions. This can. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. See full list on community. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. 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. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. File subscriptions save the report or document as an Excel or. Create an Intelligent Cube with attributes Year, Month and Region; 4. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 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. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 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. MicroStrategy 9 ships a new utility called MicroStrategy Cube Advisor to assist in the use of the Dynamic Sourcing functionality in MicroStrategy OLAP Services 9. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. This. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. log without functional impact. 4. However, if the. MicroStrategy AI is here. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. 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. By default, this is set to 32,000. HyperAndroid Go to the Account tab. 86K KB31566: MicroStrategy 9. 4. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. 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. Records statistics related to Intelligent Cube manipulations. A set of data is returned from the. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. Loading. 2) Choose "Database" and select the 3rd option to "Pick tables". Limited mobile capabilities compared to the latest BI tools like MicroStrategy. Documentation on the REST API is at developer. Publish the Intelligent Cube by executing it on either of the nodes. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. When you run reports in MicroStrategy, they collect the warehouse data. In command manager run the following commands: TRIGGER EVENT "<event_name>";Instead, reports created off of the cube will continue to hit the outdated cube. Number of Views 1. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. An enhancement Request has been reported to the MicroStrategy Technology team. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. From the Categories list, expand Options, and then select General. Check in Developer that the stopped node is in Maintenance Mode. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 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. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. The change journal logs now process the type, version, and name for databases configured in an environment. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Intelligence Server Statistics . This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. In the New Intelligent Cube dialog box, select the MDX Sources tab. When using an Intelligent Cube, you already have an in memory dataset. If you are upgrading to MicroStrategy 11. This Python 3 / MicroStrategy 10. OR, to convert an existing filter into a security filter, click Import. 4. Published: 4월 6, 2017. CAUSE. Refer to the following MicroStrategy Knowledge Base. Job ID for the action on the Intelligent Cube. There are some further steps after this, including Analytical Engine step, etc. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. x This is a new feature introduced in MicroStrategy version 9. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Before MicroStrategy 10. To build an Intelligent Cube. 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. Alternatively, you can enable caching on selected reports. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. 0. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. IS_CUBE_INST_ID. 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. 4. Intelligent. 2. 3. Forecast Sales. 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. Navigate to the Data Refresh category. KB442449: Dossier Performance: Connect Live performance considerations. It is recommended that the Excel file size should not exceed 1GB. 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. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. You can add data for your Intelligent. x. 2. An Intelligent Cube is. Create a dossier and add subset R from Existing Dataset. table_id: is the guid of a table. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. MicroStrategy Intelligence Cube. Defining the partition for Super Cubes. This is the same requirement to create or run a static report in Workstation. 2. x using Command Manager. g. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. 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. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. x or 10. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. The following diagram depicts the role of the intelligent cube. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. 2. This is a known issue with Data Import functionality in version 10. They should have the “A, L, F” status (Active, Loaded, Filed). Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. GUID of the Intelligent Cube instance in memory. Run the Report and check the SQL View. For example, Create a report with an attribute with only one attribute form. This allows for more power and control over data for MicroStrategy. 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. 3. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. 5 GB . Strong semantic layer to define all the business rules and tightly coupled. Integer ID of the Intelligent Cube report that was published, if any. MicroStrategy version 9. HyperAndroid Go to the Account tab. 3. 3. 4. 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. From the Data menu, select Configure Intelligent Cube. To enable or disable dynamic sourcing for an Intelligent Cube. Integer ID of the project where the Intelligent Cube is stored. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Drag and drop the objects into the report grid from the Report Objects pane. The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. Required Status to Perform Action. In MicroStrategy 10. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Consider the following example based on the MicroStrategy Tutorial project. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. If the indexes are needed again, they are reloaded into memory from disk, instead of being regenerated. Refer to the following sections for a list of features that can and cannot be used with. Modify or remove the view filter to attempt to return data for the report. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Only one cube file will be generated for each Intelligent cube on disk. When using an Intelligent Cube, you already have an in memory dataset. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. mstr suffix. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. Locate and run the Setup. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. In other words, the new column will NOT get mapped automatically in the existing Intelligent Cube. The New Grid dialog box opens. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. An Intelligent Cube is a. Data modeling is the structuring of an organization's data assets into an applicable logical model. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. The MicroStrategy Tutorial project uses aggregate tables by default. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. 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. Data in Intelligent cubes can be either marked as available for time zone conversion when running objects against it or set within a specific time zone. 2. This data is to apply the calculations. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super 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. 0. x, updating an Intelligent Cube returns "Cube Manager: number of c… Number of Views 1. Use the drop-down under the filter summary section to switch the server nodes. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. To Create a Report that Accesses an Intelligent Cube. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. microstrategy. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 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. The Intelligent Cube Options dialog box opens. x releases, and the new Multi-table Data Import (MTDI) cubes. Starting with MicroStrategy Intelligence Server 9. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Upgrade to those versions to take advantage of the fix. Number of Views 1. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. In the Navigation pane, click , next to Objects. However, the cube monitor doesn’t show partition related information. Developed reports for MicroStrategy Web users. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. Use Case 4. mstr file is actually a . Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. If the Intelligent Cube must be re-processed based on a metric. This is set to 32,000 by default. x and newer. In MicroStrategy Desktop 9. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. 5 GB. 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. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. SYMPTOM Users may notice that duplicate cube instances are created after an intelligent cube that had a neutral locale is updated with a multilingual. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Add External Data. Open the Workstation window. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 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. x to 11. It is especially useful when data. 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. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. There's a reason we're at the top of the list. 0 MicroStrategy releases. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. The. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. x a new concept is introduced called Intelligent Cubes. 0 MicroStrategy releases. for a script with several commands, one of which being a cube publication command, the. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. If removing the view filter does not. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Feb 2020 - May 2022 2 years 4 months. 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. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Open the. Execute the report and view the SQL:MicroStrategy enables users to pull subsets of data, which could be up to hundreds of Gigabytes, from a Big Data source into an in-memory cube, and build reports/dossiers from the cube. From the Data menu, select Configure Intelligent Cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 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. 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. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 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. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. 1. When running MicroStrategy Intelligence Server 9. e. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. GUID of the Intelligent Cube instance in memory. MicroStrategy Tutorial is used in this example. This template includes the following tasks: Creates a new metadata. 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. 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. It involves only fetching a portion of the data that the user wants, instead of storing all data in-memory as a normal Intelligent Cube. In MicroStrategy Desktop 9. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Node 1. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. This import bridge imports MicroStrategy logical tables as Dimensions. The following table summarizes the test results of some test scenarios against Oracle 19c. To build an Intelligent Cube. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. The display of data is handled by the reports that access the Intelligent Cube. 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. In MicroStrategy Web, open the document in Design Mode or Editable Mode. 4. Select the data set and click Prepare Data. Click All Objects View. Prerequisites to creating Intelligent Cubes. They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. In the Refresh Policy column, choose one of the following options:Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. Explain the process of creating intelligent cubes in MicroStrategy? Public folder or a specific user folder can be. The **_objects folder with a size of 277G. In MicroStrategy Developer, right-click on the project and select Project. 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. In MicroStrategy 10. Create a Data Import Live Intelligent Cube. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. The Modeling service must be configured correctly to use this feature. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Article Reference Number:The memory used by Intelligence Server is limited by the machine's virtual memory. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. x. The objects in the source cubes will control how the security filter will be applied. The Modeling service must be configured correctly to use this feature. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. You can create and analyze new reports in real time. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Required Status to Perform Action. If the data in the Intelligent Cube is outdated. To access the MicroStrategy Installation Wizard. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. An Intelligent Cube publication takes significantly long to complete publication (several hours). Email subscriptions deliver a report or document to one or more email addresses. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. To define an incremental refresh report. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). Intelligent Cubes are multidimensional cubes (sets of data) that exist on the MicroStrategy Intelligence Server memory and can be shared among different users. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Integer ID of the project where the Intelligent Cube is stored. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 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 general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. zip and use 7Zip, or similar tools, to unzip it. In MicroStrategy 10. "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'. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Answer: Go with dossier. Although the directory filed shows the same location as the source project, cubes are saved to a. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The cube is based on a MDX datasource, specifically SAP BW. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The. com The Maximum RAM usage (Mbytes) memory limit can be defined per project. The MicroStrategy Intelligence Server 9. For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. There's a reason we're at the top of the list. Overview. Create an attribute element prompt for the. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. 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. In MicroStrategy 9. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. Integer ID of the Intelligent Cube report that was published, if any. Cube Limitations. The article discusses a known situation in MicroStrategy 10. If desired, user can create a dashboard immediately from the imported data.