10 or earlier, outer join to Lookup table in a dashboard/dossier report based on Intelligent Cube with joint element list filter will not work, and incorrect CSI will be generated when both attributes used in the filter are present in visualization. x. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. 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. Choose one of the following options: Full Refresh: This is the default. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. Click the “Add history list subscription” link near the bottom of the screen to open the. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. Republish the same cube, and a new cube instance is generated. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. You cannot create a card based on a live-connect MDX/SAP cube. Locate and run the Setup. To enable or disable dynamic sourcing for an Intelligent Cube. Slice and dice features are awesome. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. x. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. IS_CUBE_ACT_ID. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. 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. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. You cannot create a card based on a live-connect MDX/SAP cube. * MicroStrategy does have support for dynamic sourcing with MDX sources. The first is to enable report caching at the project level. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. Published: Apr 6, 2017. Defining the partition for Super Cubes. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. MicroStrategy logical tables do not necessarily represent physical tables. ACTION This. Loading. 1. 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. Feb 2020 - May 2022 2 years 4 months. x. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. A set of data is returned from the. The dataset is a set of data that can be displayed on the document. 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. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. IS_CUBE_INST_ID. This can be seen even when the actual total memory consumption of the Intelligent Cubes loaded for this Project is below the configured Governing Setting. for a script with several commands, one of which being a cube publication command, the. It is also more difficult or impossible for someone reporting on Intelligent Cube. Senior Lead, Application Support. The data load process moves this table's information to the IS_CUBE_REP_STATS table, which has. 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 ). Save the Cube with Connect Live Data Access Mode. x and 10. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. location_path: is the folder where the intelligent cube. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 6 and higher. Software Categories. Strong semantic layer to define all the business rules and tightly coupled. III. By default, the report template used is the same as the Intelligent Cube's template. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. com. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Technically this will result is different queries on the database, due to the fact that each calculation level is different. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. You can control users' access to data with security filters. x. Edit Intelligent Cubes from the new editor in Workstation at any time. mstr suffix. This applies for example to Cubes created via MicroStrategy Web client. Because the filters are applied to the master data in the Intelligent. Within the set. 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. x. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. Dynamic Sourcing. They should have the “A, L, F” status (Active, Loaded, Filed). Required Status to Perform Action. This is controlled by the Python script. From the Data menu, select Add Dataset. 2. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Users with different security filters can use the same Intelligent Cube data. An Intelligent Cube publication takes significantly long to complete publication (several hours). Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. 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. 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. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. Why is This Happening? MicroStrategy uses different default encoding for Linux (UTF-8) and Windows (Non UTF-8). 2. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesSTEPS TO REPRODUCE. This can. Edit SQL Transactions in Reports. Forecast Sales. 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 following table summarizes the test results of some test scenarios against Oracle 19c. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. 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. 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. Add External Data. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. Edit Intelligent Cubes from the new editor in Workstation at any time. iCubes, however, has some limitations and thereby needs to be used judiciously based on the need. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. To enable. Select one: To create a new security filter, click New. Total Cubes This section displays the total count of cubes by status. Once activated, the user loads the cube in memory. Slice and dice features are awesome. Run both. 4. KB442630: CSI optimization for improving the in-memory query execution for many. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. If the Intelligent Cube must be re-processed based on a metric. g. 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. It will remain available, but the setting will not. Create Schema Objects. 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. 2. Intelligent Cube storage on disk mirrors report cache storage. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. An Intelligent Cube is. The. It is especially useful when data. 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 . 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. IS_PROJ_ID. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. This knowledge base article assumes that the user has a month attribute whose format is YYYYMM as shown below and s/he wants to delete more than 12 months’. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The default value is 256 megabytes. 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. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. In MicroStrategy Developer, right-click on the project and select Project. Go to the Report -> Data->Intelligent Cube Options->Point grid to. Subsequently the requests made by other users can seamlessly hit this new intelligent cube. 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. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. Web Open the Settings page (right click the extension and select Options). Choose Data > Configure Intelligent Cube. You can use Integrity Manager to perform a before and after test to identify which reports actually connect to a suggested Intelligent Cube and also to test data integrity. To customize your filename, please refer to the man page of core(5). Related Articles. 3 - Check the Make Intelligent Cubes. In MicroStrategy Integrity Manager 10. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. zip file, with the. Technically this will result is different queries on the database, due to the fact that each calculation level is different. When using an Intelligent Cube, you already have an in memory dataset. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. 3. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. 3. MicroStrategy Tutorial is used in this example. Providing Intelligent Cube data. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. The default file location for Intelligent Cubes is defined in the Project Configuration as '. Strong semantic layer to define all the business rules and tightly coupled. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. exe file. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. 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. IS_CUBE_ACT_ID. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. The Full Refresh option is the default. 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. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. This article notes how support for transformation metrics in Dynamic Sourcing works. Download the files from the MicroStrategy download site. 0. The Maximum RAM usage (Mbytes) memory limit can be defined per project. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. 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. 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. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. The Full Refresh option is the default. How to configure, monitor, and manage Intelligent Cubes. What BO customers are interested in knowing 3A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. The MicroStrategy Tutorial project uses aggregate tables by default. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. To access the MicroStrategy Installation Wizard. microstrategy. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Create Schema Objects. A document is used to format data from multiple datasets in a single display of presentation quality. microstrategy. . A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Dynamic Refresh: The Intelligent Cube's filter is. The Modeling service must be configured correctly to use this feature. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. 1 – Python program gets and processes the data from a Data Source. HyperAndroid Go to the Account tab. Log on to the machine where you are installing one or more MicroStrategy products. 3. You can add data for your Intelligent. x and 10. While this can improve performance of these reports. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. In MicroStrategy Desktop 9. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. Then it generates a report. (Does it sound like multisourcing for all the users without admin help?)Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that can be used by the Microstrategy Intelligence Server. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. 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:. 4. Share query results in-memory across multiple dossiers and. Click Select. 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. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. To review and create recommended Intelligent Cubes using Cube Advisor. Intelligent Cubes are multidimensional cubes (sets of data) that exist on the MicroStrategy Intelligence Server memory and can be shared among different users. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 3. Create Cube2 with the Region attribute and the metric created in step 1. Create a report on this intelligent cube with the month attribute and the count of day metric. Choose Databases. Web Open the Settings page (right click the extension and select Options). 2. x. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. This is the same requirement to create or run a static report in Workstation. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. Limiting the Maximum Report Size. By default, there is a system hierarchy on the cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). The Security Filter Editor opens. Based on the previous explanation, you should only create derived attributes or metrics whenever. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. The ability to view or edit certain settings is determined by a user's privileges. Refer to the following MicroStrategy Knowledge base document for general remarks on security filter application to Intelligent Cubes where not all of the security attributes are found. 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. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. x, create a simple Intelligent Cube with attribute Category and metric Revenue. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. KB442449: Dossier Performance: Connect Live performance considerations. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Required Status to Perform Action. 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. The user then updates the 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. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 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. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. 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. 2. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. GUID of the Intelligent Cube instance in memory. Additionally, your data needs to have attributes with either one-to-one relationships or many-to-one relationships. 4. IS_CUBE_ACT_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. Report: The results of a report are used to populate the Intelligent Cube. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. Published: Jun 29, 2018;KB321029: In MicroStrategy 10. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. Although the directory filed shows the same location as the source project, cubes are saved to a. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. 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. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. Use the drop-down under the filter summary section to switch the server nodes. The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. x releases, and the new Multi-table Data Import (MTDI) cubes. For more information on security filters, see the System Administration Guide. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. 7. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. This dataset needs to contain all data in the required granularity. 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. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Documentation on the REST API is at developer. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. Integer ID of the Intelligent Cube report that was published, if any. 4. 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. x a new concept is introduced called Intelligent Cubes. 4. 2) Choose "Database" and select the 3rd option to "Pick tables". You must belong to the System Administrators group to use this feature. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. MicroStrategy AE, even when the data is coming from an intelligent cube, MicroStrategy still needs to calculate the derived elements and depending on the data size and complexity sometimes these calculations can take minutes. Add Year Id and Quarter. Intelligent Cubes. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. These VLDB properties control the method by which the report data are normalized. However, the cube monitor doesn’t show partition related information. 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. Provides the last cube row count. All cubes respect the governing setting. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. com. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. The . A schedule is defined in Python code. Intelligent Cubes. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. It stores the non-normalized table into the MicroStrategy. 4. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. After the previous changes, you'll have to save the cube and republish it. Pros and Cons. 1 or above, to pick up the fix, enable project level setting "Data Engine. The Intelligent Cube must not be re-processed based on a metric. The article discusses a known situation in MicroStrategy 10. Navigate to the Data Refresh category. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 5 GB, the Data Transfer from Datasource(s) time is 77. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. Select the Security Filters tab. Prerequisites to creating Intelligent Cubes. 0 votes. When you run reports in MicroStrategy, they collect the warehouse data. In a BI platform, the logical data model is designed and built using current user requirements. Limited mobile capabilities compared to the latest BI tools like MicroStrategy. 4. Run sudo vi /etc/sysctl. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. 0. Both properties are located in the Query Optimizations folder in the VLDB property editor. Vn (with metric Mn from source cube Cn). Dossiers automatically adjust to look great on any screen. MicroStrategy Analytics cubes are easy to create and deploy. Following are the features, which make intelligent cubes useful. 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. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. This will work as a regular SQL comparison In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:Total number of columns: The number of columns of data that the Intelligent Cube contains. 5. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Expand Intelligent Cubes, and then select General. 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. MicroStrategy Intelligence Cube. Case A: Security Filter attribute is related to attributes placed on the grid. Published: Apr 6, 2017. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. Navigate to the folder location of the Intelligent Cube. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. The Intelligent Cube Monitor is displayed. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. If the Intelligent Cube must be re-processed based on a metric. Drag and drop the objects into the report grid from the Report Objects pane. Publish the cube. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 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. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns.