x. MicroStrategy logical tables do not necessarily represent physical tables. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. 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. The updates to the Intelligent Cube must be according to attributes only. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. The Intelligent Cube must be published before this report can execute. In MicroStrategy Desktop 9. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Starting with MicroStrategy Intelligence Server 9. Like cache update subscriptions, Intelligent Cube. Otherwise, it will increase the percentage to 200% if the "Maximum % of growth of intelligent cube due to indexes" governing rule. Steps To Reproduce 1. Intelligent Cubes. Total Cubes This section displays the total count of cubes by status. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. x. 4. With OLAP Services features, your report designers can create Intelligent Cube reports. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Select an Environment from the upper-left drop-down. 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. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. All necessary privileges are included in the Administrator role by default. Maintaining data access security. Answer: Go with dossier. 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. Choose your environment, project, and Intelligent Cube as your dataset type. All necessary privileges are included in the Administrator role by default. 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. Node 1. They should have the “A, L, F” status (Active, Loaded, Filed). Along with. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). 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. These reports allow data to be returned from the data. Create a second report with the year and quarter attributes and the revenue metric. Right-click an Intelligent Cube and select Delete. The **_objects folder with a size of 277G. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below:This article describes features that are not supported when using Dynamic Sourcing. Strong semantic layer to define all the business rules and tightly coupled. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. . 56K. 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. Users cannot trigger or schedule cube republishing. The New Grid dialog box opens. 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)". 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. The related section is located in. 0. This is the same requirement to create or run a static report in Workstation. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. To review and create recommended Intelligent Cubes using Cube Advisor. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. The Intelligent Cube Monitor is displayed. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. To build an Intelligent Cube. 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. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Most likely several, different fact tables are uses for each query. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Run a dossier based on the cube. Expand the Object Templates category, select General, and. Moreover, you can return a data. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. Created Intelligent Cubes to solve the performance issues. 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. Select one: To create a new security filter, click New. The first column provides the Intelligent Cube name, and the second column provides the full path to the Command Manager script files used to publish the. 0. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. Creating an Intelligent cube is similar to creating a report. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version. 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‘. Intelligent Cube storage on disk mirrors report cache storage. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 0. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 5 GB, the Data Transfer from Datasource(s) time is 77. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. Limited mobile capabilities compared to the latest BI tools like MicroStrategy. Integer ID of the Intelligent Cube report that was published, if any. 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. The limitations of Microstrategy are not worth. 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. Choose Databases. E. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. Browse to and select a previously saved Intelligent Cube on which to build your report. Number of Views 1. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Data modeling is the structuring of an organization's data assets into an applicable logical model. x Intelligent Cube status indication and workflow . Use the drop-down under the filter summary section to switch the server nodes. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Create a report based off the cube in Step 1 that includes the description form for Category. In MicroStrategy 9. Navigate to the Data Refresh category. 1. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. HyperAndroid Go to the Account tab. The cube is based on a MDX datasource, specifically SAP BW. Drag and drop the objects into the report grid from the Report Objects pane. zip file, with the. 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. To change these behaviors, see: Publishing Intelligent Cubes Without Loading Them into Intelligence Server Memory Loading Intelligent Cubes when Intelligence Server Starts If. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. To Create a Report that Accesses an Intelligent Cube. Öffnen Sie das Workstation-Fenster. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. 4 the connection mapping of the u… Number of Views 1. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). MicroStrategy Analytics cubes performance is best in the industry from performance point of view. 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. x - 10. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. You may share the Intelligent Cube as a single copy in memory. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Developed reports for MicroStrategy Web users. 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. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. Moreover, you may generate among the various reports of many users. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Create an Intelligent Cube with this attribute and publish. x environment . It will remain available, but the setting will not. This template includes the following tasks: Creates a new metadata. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Save the Cube with Connect Live Data Access Mode. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. The. The Modeling service must be configured correctly to use this feature. Within the set. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. To enable or disable dynamic sourcing for an Intelligent Cube. Measures the time duration an operation executed against cubes. 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. To view this field, the Intelligent Cube must be published at least once. 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. For example, Create a report with an attribute with only one attribute form. In Developer, from the File menu select New, and then Intelligent Cube. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. Drag and drop the objects into the report grid from the Report Objects pane. If a new column is added to the data import data source and the cube is republished, there is no effect. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. 3. Easily add or change pre- and post- SQL statements. Technically this will result is different queries on the database, due to the fact that each calculation level is different. 4. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. The data load process moves this table's information to the IS_CUBE_REP_STATS table, which has. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Log on to the machine where you are installing one or more MicroStrategy products. com. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. 4. Why is This Happening? MicroStrategy uses different default encoding for Linux (UTF-8) and Windows (Non UTF-8). Refer to the following MicroStrategy Knowledge Base. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . 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. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. Intelligent Cubes. 0. After execution. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Job ID for the action on the Intelligent Cube. 2. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Select the Allow reports to drill outside the Intelligent Cube check box. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. This Knowledge base article describes limitations in using security filters and intelligence cubes. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. For a detailed explanation of the Cube Status values, see KB31566: MicroStrategy 9. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 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. IS_CUBE_INST_ID. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. It remains available, but is not enforced if it is less than the default value of 100000. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. Recorded at World 2021. Add External Data. Go to the Report -> Data->Intelligent Cube Options->Point grid to. By default, this is set to 32,000. View the report in either Grid View or Grid and Graph View. Web Open the Settings page (right click the extension and select Options). Seamlessly create Intelligence Cube Reports. In the Navigation pane, click Monitors. When a machine runs out of virtual memory, processes on the machine are no longer able. In versions prior to MicroStrategy Intelligence Server 9. ACTION This. The interface has changed a bit. Create Schema Objects. IS_CUBE_REP_ID. If the Intelligent Cube must be re-processed based on a metric. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. Traditional Report Caching in MicroStrategy is done on a matching basis. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. 2) Choose "Database" and select the 3rd option to "Pick tables". 6 and higher. This is the most popular MicroStrategy Interview Question asked in an interview. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Integer ID of the project where the Intelligent Cube is stored. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Choose Data > Configure Intelligent Cube. Integer ID of the project where the Intelligent Cube is stored. Transactions. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Choose File > New > Intelligent Cube. The Intelligent Cube must not be re-processed based on a metric. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. The Intelligent Cube is opened in the Report Editor. To review and create recommended Intelligent Cubes using Cube Advisor. In the Drilling area, clear the Use default settings check box. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 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. Pros and Cons. Why MicroStrategy Why MicroStrategy; Customer StoriesHyperIntelligence is a new addition to MicroStrategy Workstation that allows analysts to inject analytics and intelligence directly into every user's experience. Create a report based on above Cube and add the prompt in view filter. UPDATE: the refresh policy is Update existing data. The Intelligent Cube Options dialog box opens. conf and add the following lines. Create Cube B which contains all objects in the report and publish it . In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. 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. 1 release. Once an Intelligent cube is created and then published so its data is available, multiple reports can be created to connect to the Intelligent cube. Integer ID of the Intelligent Cube report that was published, if any. This folder needs to be shared as 'ClusterCube'. 5 GB. 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. 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. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. Choose your preferred method to share the logs. 3. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. STEPS TOP REPRODUCE: 1. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. 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. IS_CUBE_INST_ID. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. 2. 3. 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. The status of each Intelligent Cube is listed in the. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). The Maximum RAM usage (Mbytes) memory limit can be defined per project. Expand the Object Templates category, select General, and from the Show templates for the. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Choose one of the following options: Full Refresh: This is the default. 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. Maintaining data access security. To view an Intelligent Cube stored in your History List. A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. To do this, edit the report in developer and go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose the new target cube: Create Cube A and a report based on it. KB442449: Dossier Performance: Connect Live performance considerations. 15K. The display of data is handled by the reports that access the Intelligent Cube. MicroStrategy Tutorial is used in this example. 86K KB31566: MicroStrategy 9. Add Year Id and Quarter. 4. You cannot create a card based on a live-connect MDX/SAP cube. Right-click an Intelligent Cube and select Delete. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. 0: Balance MicroStrategy Server threadsDescription The . Can. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. Intelligence Server Statistics Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. mstr file is actually a . When using MicroStrategy and Teradata, the best approach is to. Open the. This import bridge imports MicroStrategy logical tables as Dimensions. Strong semantic layer to define all the business rules and tightly coupled. The data used for this example. For the steps to define an incremental refresh report, refer to:Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. 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. Loading × Sorry to interruptnumber_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. However, if the Intelligent Cube Monitor on the other node is checked, the size of the same Intelligent Cube will be smaller. 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. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). In MicroStrategy Web, open the document in Design Mode or Editable Mode. In the Navigation pane, click , next to Objects. STEPS TO REPRODUCE 1. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. 9 and 10. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. IS_PROJ_ID. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The default value is 256 megabytes. Only one cube file will be generated for each Intelligent cube on disk. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. Records statistics related to Intelligent Cube manipulations. Job ID for the action on the Intelligent Cube. For more information on security filters, see the System Administration Guide. "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 releases, and the new Multi-table Data Import (MTDI) cubes. location_path: is the folder where the intelligent cube. Dossiers automatically adjust to look great on any screen. 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 . In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. You can control users' access to data with security filters. For more information on security filters, see the System Administration Guide. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. 3. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. Click Select. For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. The view filter cannot filter out other elements as shown below:Data Modeling. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Intelligent cubes support time zone based reporting. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. IS_CUBE_INST_ID. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. To customize your filename, please refer to the man page of core(5). 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. Edit Intelligent Cubes from the new editor in Workstation at any time. 2. If no data is returned for a report that is connected to an Intelligent Cube, this can be caused by the following scenarios: The view filter for the report is too restrictive (see View Filters ). In a BI platform, the logical data model is designed and built using current user requirements. The memory used by Intelligence Server is limited by the machine's virtual memory. Cube and Cache Metric Names. 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. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help.