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 **_objects folder with a size of 277G. Drag and drop the objects into the report grid from the Report Objects pane. There's a reason we're at the top of the list. x. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. e. IS_CUBE_INST_ID. Create a report based on above Cube and add the prompt in view filter. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. No data is returned for the report. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Node 2. 0. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. Feb 2020 - May 2022 2 years 4 months. If the Intelligent Cube must be re-processed based on a metric. However, the cube monitor doesn’t show partition related information. This can improve the performance of. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. It is especially useful when data. * MicroStrategy does have support for dynamic sourcing with MDX sources. By default, this is set to 32,000. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. This applies for example to Cubes created via MicroStrategy Web client. The New Grid dialog box opens. Loading. For example, an Intelligent Cube that contains data for the top 200 stores by. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. 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 user still needs the privilege for re-publishing Intelligent Cubes, but just need this restricted for particular cubes), while still allowing this user to perform Visual Insight analysis on the cubes information. In the Navigation pane, click , next to Objects. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. For more information on security filters, see the System Administration Guide. Check in Developer that the stopped node is in Maintenance Mode. x a new concept is introduced called Intelligent Cubes. Provides the last cube row count. Browse to the filter you want to convert and click Open. Technically this will result is different queries on the database, due to the fact that each calculation level is different. 0. Based on the previous explanation, you should only create derived attributes or metrics whenever. 2 – The data is being pushed to MicroStrategy Intelligent. Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available. 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. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. Integer ID of the Intelligent Cube report that was published, if any. 0 has a dedicated section to memory used for Intelligent Cubes. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The default value is 256 megabytes. 4. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. Documents . To enable. 0. log without functional impact. exe file. STG_IS_CUBE_REP_STATS. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. A workaround is available in the current document. The article discusses a known situation in MicroStrategy 10. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Documentation on the REST API is at developer. Pros and Cons. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. IS_CUBE_INST_ID. Node 1. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. 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. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. 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’. Recorded at World 2021. This is set to 32,000 by default. Measures the time duration an operation executed against cubes. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. You can use. 1 release. If the Intelligent Cube must be re-processed based on a metric. With OLAP Services features, your report designers can create Intelligent Cube reports. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. 4 the connection mapping of the u… Number of Views 1. The New Grid dialog box opens. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. These reports allow data to be returned from the data. Intelligent Cubes are a more aggressive form of caching and allow multiple reports. 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. Dynamic Refresh: The Intelligent Cube's filter is. x. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 9 and 10. 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. IS_PROJ_ID. File subscriptions save the report or document as an Excel or. 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. All MicroStrategy security settings are respected when interacting with MicroStrategy. Run a dossier based on the cube. Report: The results of a report are used to populate the Intelligent Cube. Although the directory filed shows the same location as the source project, cubes are saved to a. Run the Report and check the SQL View. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. x. 0: Balance MicroStrategy Server threadsDescription The . We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. When running MicroStrategy Intelligence Server 9. Answer: Go with dossier. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. reg file on UNIX/Linux operating systems. Edit Intelligent Cubes from the new editor in Workstation at any time. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. A user logs out of a MicroStrategy Project by scheduler. Alternatively, you can enable caching on selected reports. 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. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Easily add or change pre- and post- SQL statements. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP 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. 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. 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. x. x. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. 0 votes. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). HyperAndroid Go to the Account tab. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 1. This is the most popular MicroStrategy Interview Question asked in an interview. Moreover, you can return a data. Öffnen Sie das Workstation-Fenster. Browse to and select a previously saved Intelligent Cube on which to build your report. Slice and dice features are awesome. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Like cache update subscriptions, Intelligent Cube. Another way to use caching in MicroStrategy is through Intelligent Cubes. zip file, with the. In addition, multiple logical tables can represent the same physical table. If you are upgrading to MicroStrategy 11. Rather than returning data from the data warehouse for a. cube_name: is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes. For example, Create a report with an attribute with only one attribute form. Download the files from the MicroStrategy download site. 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. Browse to the filter you want to convert and click Open. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. The Intelligent Cube Monitor is displayed. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Dossiers automatically adjust to look great on any screen. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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. You can create and analyze new reports in real time. 143; asked Oct 2, 2014 at 14:58. 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. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. After execution. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. Number of Views 5. Number of Views 1. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. They should have the “A, L, F” status (Active, Loaded, Filed). In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. for a script with several commands, one of which being a cube publication command, the. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. While this can improve performance of these reports. Developed reports for MicroStrategy Web users. 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. Job ID for the action on the Intelligent Cube. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. Within the set. x Dynamic sourcing extends the accessibility of Intelligent Cubes by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements. IS_CUBE_REP_ID. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. 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. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. This is a known issue with Data Import functionality in version 10. 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. Expand Intelligent Cubes, and then select General. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Together with the Reports API, this API is often referred to as the JSON Data API. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. 5 GB. 0. Specify a name and location for the new security filter and click Save. 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. HyperAndroid Go to the Account tab. . 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. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Updating Intelligent Cubes without re-processing: Incremental Refresh. 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. x releases, and the new Multi-table Data Import (MTDI) cubes. "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'. 3. MicroStrategy version 9. When a machine runs out of virtual memory, processes on the machine are no longer able. conf and add the following lines. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. 3. Publish the Intelligent Cube by executing it on either of the nodes. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The Intelligent Cube opens in the Report Editor. Click View Logs, to display the share icon in the upper-left. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. A MicroStrategy Report Services document displays your organization's data in a format. This can be seen in the screenshot below. Click the MicroStrategy icon at the upper left of any page and select History List. For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. If the data in the Intelligent Cube is outdated. 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. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 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. If the Intelligent Cube must be re-processed based on a metric. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. 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. Number of Views 8. 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. If the indexes are needed again, they are reloaded into memory from disk, instead of being regenerated. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. 11. x to 11. Expand the Object Templates category, select General, and from the Show templates for the. After the previous changes, you'll have to save the cube and republish it. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. Use the drop-down under the filter summary section to switch the server nodes. By default, the report template used is the same as the Intelligent Cube's template. It is shared by all processes running on the machine, including the operating system. Click the “Add history list subscription” link near the bottom of the screen to open the. 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. If a new column is added to the data import data source and the cube is republished, there is no effect. Edit Intelligent Cubes from the new editor in Workstation at any time. This data is to apply the calculations. 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. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. x -10. To Create a Report that Accesses an Intelligent Cube. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. MicroStrategy logical tables do not necessarily represent physical tables. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. It remains available, but is not enforced if it is less than the default value of 100000. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. 1 or above, to pick up the fix, enable project level setting "Data Engine. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. To Create a Report that Accesses an Intelligent Cube. 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. 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. In addition, multiple logical tables can represent the same physical table. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. III. Dossier Datasets do not include all the Security Filter attributes, and one of the Datasets are Connect Live Data Import Dataset, it may have security concerns. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. This. 0 MicroStrategy releases. 4. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. A schedule is defined in Python code. Open the Workstation window. Required Status to Perform Action. xThis article describes the Intelligent Cube Population options available in MicroStrategyPlease also see this article for more details: Data Engine changes in MicroStrategy 2021 release Acronym used: "CSI", which stands for "Cube Subsetting Instruction". Right-click an Intelligent Cube and select Delete. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. You may share the Intelligent Cube as a single copy in memory. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesSTEPS TO REPRODUCE. When you run reports in MicroStrategy, they collect the warehouse data. This import bridge imports MicroStrategy logical tables as Dimensions. In the left panel, click Cubes. For more information on Intelligent Cube sizes, refer to the following MicroStrategy Knowledge Base technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. If the Intelligent Cube must be re-processed based on a metric. x and newer. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. Intelligent Cube storage on disk mirrors report cache storage. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. KB222608: In a clustered environment in MicroStrategy 9. The following diagram depicts the role of the intelligent cube. For example, an Intelligent Cube that contains data for the top 200 stores by Profit must be re-calculated every time it is updated, and thus must use the Full Refresh option. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. Choose one of the following options: Full Refresh: This is the default. By default, MicroStrategy Command Manager handles cube publication synchronously (i. metrics in the intelligent cube or in the MicroStrategy schema and application objects. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. IS_PROJ_ID. 3. the project configuration: ACTION . The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. This means you can manually change the suffix to . Create a report with the year and quarter attributes and the profit metric. Exit all Windows applications before beginning the installation process. 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 Categories list, expand Options, and then select General. The Cubes are modeled with a built-for-purpose modeling thus requiring additional schema work instead of directly leveraging the already-built schema model MicroStrategy Cube Advisor recommends and automatically creates an optimal set of in-memory cubes based on usage patterns for different users accessing the BI system. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. Users with different security filters can use the same Intelligent Cube data. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Modeling is creating information that describes another set of data. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 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. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. Export data frames from RStudio to MicroStrategy in-memory cubes. 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. In this case, the dataset is a MicroStrategy Intelligent Cube. Intelligent Cubes can be based on MicroStrategy data or imported data. In MicroStrategy 10. The first is to enable report caching at the project level. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. Add External Data. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. To enable or disable dynamic sourcing for an Intelligent Cube. 4. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. 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. My complaint is that a lot of the new stuff just works in the "import data into an intelligent cube" model and not the good old metadata. Software Categories. x - 10. Senior Lead, Application Support. In a MicroStrategy Intelligence Server clustered environment, it is observed that dynamic sourcing does work against Intelligent Cubes available on a remote node, after updating the schema. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Intelligent. x and 10. x. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). 3. Slice and dice features are awesome. This is the same requirement to create or run a static report in Workstation. In MicroStrategy Integrity Manager 10. If desired, user can create a dashboard immediately from the imported data. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. Go to the Report -> Data->Intelligent Cube Options->Point grid to. MicroStrategy Intelligence Cube. The New Intelligent Cube dialog box opens. Defining Intelligent Cube refresh settings. Data modeling is the structuring of an organization's data assets into an applicable logical model. Creating an Intelligent cube is similar to creating a report. Technically this will result is different queries on the database, due to the fact that each calculation level is different. In MicroStrategy Desktop 9. 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. . Click View Logs, to display the share icon in the upper-left. 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. 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‘. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. 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. Create Cube1 with the Region attribute and the metric created in step 1. MicroStrategy Web: Web Server. In MicroStrategy Web, open the document in Design Mode or Editable Mode. Memory Storage for document or dossier.