In the Datasets panel, double-click attributes and metrics to add them to the visualization. Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. How the user answers the question determines what data is displayed on the report when it is returned from your data source. This is now feasible beginning in MicroStrategy 2019. . For example, users can have a smart compound metric and a component metric of this compound smart metric on the grid in the document. Click the Options icon . Select the Dropdown Icon () on the right-hand side of the title bar. A compound grid with more than one column set is being used (image for reference): While looking normal in the dossier: After exporting to excel, the rows are not. A setting in MicroStrategy Web 9. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. See the previous images above to see how the row headers should now appear. See the previous images above to see how the row headers should now appear. Compound grid export via Office add-in. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. In the Gallery, click Compound Grid . Fields. KB298312: Subtotal of a compound metric doesn’t show correctly in Visual Insight in MicroStrategy Web. Click on Dossiers in the left panel of Workstation. Create two compound metrics C1_R=Cost(1)/Revenue and C1_R_PM=C1_R/. To reproduce in MicroStrategy Tutorial: Create a simple report with one attribute and one metric. x and 10. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to. From the Insert menu, point to Widgets, and then select Microcharts. For example, a document contains two Grid/Graphs. This document provides the steps to accomplish the same. Notice that a joint child relationship can be one-to-many or many-to-many. Wählen Netz > Zusammengesetztes Gitter . A Grid/Graph is created for the Regional Revenue dataset. MicroStrategy recommends that when choosing your colors, to keep the 60-30-10 rule in mind. 4 and later. x When a security filter is used, different users get different report results when the same report is being executed, hence there might be a need to include the name of the user who generated the report in the grid to differentiate the. 11. To select how the Grid/Graph is displayed, use the View mode property. Select More Options at the bottom of the pane. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Using the Connector. Continue with the previous Steps 2 and 3 above. View standard reports in MicroStrategy Library to get a simple, grid view of data. But, this can also be done with this. 364 subscribers. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. When users make selection on grid selector in MicroStrategy Web 9. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. The Profit metric is a simple sum of the Profit fact. Use the Visualization Gallery to perform the following tasks: Select a visualization's type. The Grouping panel is displayed. An input box will be displayed with a list of recommended questions based. The example above will now return 77. 4. Required prompts without any default answers remain open while optional prompts without default defaults answers are closed with an empty answer. General Settings. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Creating a 'Compound Grid' 4100 views | September 04, 2020 02:40. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. In the Datasets panel, double-click attributes and metrics to add them to the visualization. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. This document provides the steps to accomplish the same. Insert an HTML container (and not an image) and insert the script below. Reports are now available to use and interact with in MicroStrategy Library: View standard reports in MicroStrategy Library to get a simple, grid view of data. Locate the Request Geospatial key button above the products session and click on Mapbox Key : Each key is DSI specific. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. The report using in this example has the following structure when executed in Web or Developer: Region,Income Bracket, Metrics, Revenue. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. We recommend the latest version. Here the many-to-many relationship is converted into a compound attribute relationship. 678 views 2 years ago MicroStrategy 2020. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). A compound grid requires at least one attribute and one metric. This groups them, but doesn't label them quite yet. Query Stage: Retrieve data from the warehouse. x, users can define a custom subtotal for a metric that returns a value that a compound level metric would return. A grid is an essential element of data analysis. The first pass calculates Sales; the second pass calculates Item Sold. This means that two calling centers from different regions can share the same Call_Ctr_id. Cross-tab Stage: Pivot and display sorting and page-by. A Grid/Graph is a container that is placed in a document and which displays a standard MicroStrategy grid or graph report. Upon making this selection, the row headers will now be merged. This is an excerpt from my presentation at the July meeting of the San Francisco Bay Area MicroStrate. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. Relate tables contain the ID columns of two or more attributes, which will define associations between them. A blank visualization appears in the dossier. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. For example, users can have a smart compound metric and a component metric of this compound smart metric on the grid in the document. Microstrategy Dossiers With the release of MicroStrategy 10. . 1) Create Metric 1 which is the sum of the fact that is to be in the columns. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. x-10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Use compound. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. 2. Step 2: Connect the atoms to each other with single bonds to form a “skeleton structure. In the top toolbar, click Insert Visualization . Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. 364 subscribers. Populate & Evaluate Stage: Fill report data for display. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. The following schema shows which setting takes precedence when set at different levels. The Configure Transactions Editor opens. In the list of categories on the left, click Subtotals. The one on the left, which is displayed as a grid, shows revenue by region. Order: The sort order of the row or column. Choose Grid > Compound Grid . In the Gallery, click Compound Grid . A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. Select 'Export to Excel' to generate a new Excel document. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. Step 1: Figure out how many electrons the molecule must have, based on the number of valence electrons in each atom. Learn how to switch to a compound grid, add column sets in this new visualization. In the Run Modes area, select the format (s) in which the document can be exported: •. A normal attribute represents a single hierarchy level (for example, Month). in Microstrategy Dossier, is it possible to create 2 rows of header, such that the first row is the grouping information and spans to number of columns to identify as a. MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy R Integration, MicroStrategy Report Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services, MicroStrategy Usher, MicroStrategy Web, MicroStrategy Workstation, MicroStrategy World, Usher, and Zero-Click Intelligence. Microstrategy Document Editor Sections Important Notes: The Layout area is in the center of the Document Editor interface and provides the framework for precisely controlling where controls (such as text fields, grid and graph reports, images, and widgets) are displayed when the document is viewed in different display modes, printed,. New workaround Attribute left outer join effect in MicroStrategy Web. Learn how to build custom grids using MicroStrategy Documents. The data from the report is used to populate the Grid/Graph. "IIf([REGION2]. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Learn more. Only Year 2000 data is returned in the grid:foundation of the Intelligence Server worflows scheduling and and teams to best-in-class automates the capture administrators to. Create a Report Services Document 2. This article describes how to display username on the report grid with MicroStrategy Developer 9. MicroStrategy AI is here. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Compensating Transactions. The graph legend or axes can be formatted as well. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. 4 and. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. mtc is the name of the saved test file. Drag and drop the . MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. Double click on your Report Filter and you’ll now have the option to add an Advanced Qualification: You can then provide the code for the ApplyComparison. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. MicroStrategy Library is an interactive application of the MicroStrategy Business Intelligence platform that lets business users harness the analytical power of MicroStrategy in a simple, clean and modern user interface. Cross-tab stage. Excel with formatting: The report is exported and displayed as a Microsoft Excel spreadsheet. Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. In the Editor panel, right-click the attribute or metric to sort and choose Advanced Sort. exe using the command line. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the Metric Join Type set at the Database Instance Level: The subject of Outer Joins is a very broad one, however, as a. To do so, you must link a Transaction Services report to a grid or to text fields in a panel stack. Create a metric that sums the fact Units Sold. Once you add a grid visualization to a dossier, you can format it. Select 'Export to Excel' to generate a new Excel document. ドシエを開きます。. Why MicroStrategy Why MicroStrategy Why MicroStrategy. If an error does not appear, view your Compound Grid and notice the subtotals on the grid are not appearing for the attributes from the second column set. Slicing means that the data for each available item in the selector is calculated in advance when the document is first displayed. 11?; Knowledge Base: Annotate. This means that every calling center has its own unique ID. When drawing the structure of an ion, be sure to add/subtract electrons to account for the charge. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. To Add a Target Visualization to Your Dossier: Open the dossier with the visualization. 4. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. Even if the source attribute is not included in the Grid/Graph, the data is still. Passing prompt answers for an element prompt when the attribute has a compound ID. All Grid Fonts: Select font formatting options for all text. You need to compare the number of units sold today to the number of units sold from January 1 through today. Profit is not displayed on the Grid/Graph, nor is it in the data source for the Grid/Graph. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. For SAP BW, the following syntax may be used. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Create a Report Services Document 2. 3. mstrc”. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. . From the Visualizations panel, select Grid . Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. [ONAME:Compound Grid]: This is the name of the object. The compound join saves memory space and processing time on the Intelligence Server executing the document. x, select 'Project Documentation' from the Tools menu to start the wizard. Note how a grid is returned with the total when there are no rows of data: Cause This is a known issue in MicroStrategy 10. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. To set this option on the user level: Click on the User Preferences within Web Preferences, and then Grid display. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. For the Time hierarchy, the offset can. Creating a 'Compound Grid' 4100 views | September 04, 2020 02:40. To Add a Target Visualization to Your Dossier: Open the dossier with the visualization. In MicroStrategy Web, open the document in Design or Editable Mode. The following general formatting options are available to format data cells, columns, and rows in the grid visualization: Enable Banding: Select this checkbox to apply alternating colors to rows in the grid. Microstrategy Dossiers With the release of MicroStrategy 10. Using images in Microstrategy reports. x, non-aggregatable metrics are used for this kind of calculation. The Grid/Graph (referred to simply as a report) can be directly associated with one dataset or with multiple datasets. 3. Make two grids with different attributes and metrics in each 3. You can tag multiple users or user groups in a comment. But this behavior can be changed by using the 'From Clause Order' VLDB property under the 'Joins' folder. In Comments, enter @. Learn more. Begin by choosing a dominant color which will dictate the look and feel of 60% of your dossier, or the majority of the interface. In the top toolbar, click Insert Visualization . You can also apply a set of color and shading schemes to all the objects on a graph report. Create a Report Services Document 2. This document provides the steps to accomplish the same. Introduction to Grids. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Go to project configuration by right clicking on specific project (You need admin rights to do this). MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . NOTE: Modifying the key form will trigger required updates when saving. The Grouping Properties dialog box opens. Select one of the following options: Grid, to display the control as a standard MicroStrategy grid report with rows and columns of attributes and metrics. NOTE: Modifying the key form will trigger required updates when saving. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. Overview of level metrics in MSTR. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. 最上部のツールバーで、 [ビジュアリゼーションを挿入] をクリックします。. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. In diesem Lernprogramm erfahren Sie, wie Sie zu einer zusammengesetzten Tabelle wechseln, Spaltensätze innerhalb der zusammengesetzten Tabelle hinzufügen und einen einfachen Anwendungsfall für die Nutzung dieses neuen Visualisierungstyps finden. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. HTML: The grid report is exported to an HTML file. Set Data Engine Version setting to 11 or. x, users may notice that the row headers are not merged, like shown below:Design compound visualizations or add rich text boxes and images. Ragged Hierarchies. The Export to Excel option will now appear. It can be set at the project and user level. The option to Delete unused managed objects allows a MSTR Admin to force a search and delete of those managed objects which no longer are in use by the project (no longer have dependants). This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. is not running the latest Microstrategy for office so I'd like to ask if this issue is A)known. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. Excel with formatting: The report is exported and displayed as a Microsoft Excel spreadsheet. If the document is being displayed on an iOS device, you can link the report to the cells of a transaction table. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. In our. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. A compound grid requires at least one attribute and one metric. The selection bar opens, and the heat map is labeled as the Source. This section helps you choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. So the row for Music will not display in the grid. exe to this machine. [01]. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. x, follow the steps below:. Make two grids with different attributes and metrics in each 3. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. But, this can also be done with this. replace (truncates and replaces the data) This Knowledge Base article introduces "mstrio," Python and R packages which provide an interface for the MicroStrategy REST APIs. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. Specify the desired delivery options including recipient address, subscription name. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. 1919 views | September 04, 2020. Select More Options at the bottom of the pane. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. Creating a grid report. You can define metrics by using the available functions to analyze your data and determine business measures. A blank visualization appears in the dossier. 4. To use Natural Language Query, go to the Dossier Authoring interface (Web, Workstation, or Desktop), and click on the insight icon located at the top right corner: . See full list on blog. To export a report while viewing it: Click the name of a report to display it. In the Editor panel, click Add Column Set to create another column set. How to Share a Dossier. [データセット] パネルで、アトリビュートとメトリックをダブルクリックし、ビジュアリゼーションに追加し. In the right corner of the dashboard, change the. From the Visualizations panel, select Grid . Click Share > Library Access. Most data on a document is free one or more underlying datasets. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. With MicroStrategy 2020 Patch Installer, our customers get centralized solution for applying critical fixes to any version of the. Microstrategy Dossiers With the release of MicroStrategy 10. The color is displayed in Presentation Mode in MicroStrategy Web. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. J2EE environment:Year-To-Date Transformation Example. You can also apply a set of color and shading schemes to all the objects on a graph report. 678 views 2 years ago MicroStrategy 2020. How to Share a Dossier. Do not forget to enable Subtotal (F11). For example, a document contains two Grid/Graphs. In this case, the only object in the columns for this grid is the metric "Revenue". And leverage the Page-By function to focus your analysis on one element. Name, [Measures]. 11. Creating Powerful (and Beautiful) Dossiers. Click the Connect button to launch the connector. mstrc, please open something similar to Notepad. This is now feasible beginning in MicroStrategy 2019. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Dossiers have two grid visualizations: Grid and Compound Grid. Click Continue if the Preview Connector warning message pops up. In MicroStrategy Web 2019 and above, when running a dossier with row headers centered in the middle (vertically) of the grid, row headers do not appear correctly as you scroll down. 2) Create Metric2 as the RunningSum of Metric1. Create a report with Year on the rows and Revenue on the columns. In the Editor panel, click Add Column Set to create another column set. 1 documents inside an iframe. 4074 views · September 04, 2020. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Erstellen einer „zusammengesetzten Tabelle“. In the Editor Panel, right-click the attribute in Column Set 1 and select Display Attribute Forms . When users make selection on grid selector in MicroStrategy Web 9. A normal attribute represents a single hierarchy level (for example, Month). From the Home menu, select Export. 3. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. For now, derived metric based on different datasets is not supported in field group (which would be on the Detail section). On each column set, add at least one attribute. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. Visualizations provide a variety of ways for you to display and interact with the data in a dossier. Finally, just create the report with the attribute (Category) and the third metric. In the list of categories on the left, click Subtotals. Copy cleanup. Although Item Sold is not on the template, since the temporary table containing data for Item Sold is outer-joined to calculate the compound metric, Unit Sales, Year 2001 appears in the final grid view. The key will show up on the screen and will. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. com Click Insert Visualization . This setting has four values:To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. To create a MicroStrategy Environment connection file . In MicroStrategy Web 2019 and above, when running a dossier with row headers centered in the middle (vertically) of the grid, row headers do not appear correctly as you scroll down. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. Visualizations provide a variety of ways for you to display and interact with the data in a dossier. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. This can be in the form of graphs, charts, maps or other graphic depictions that. In MicroStrategy Developer 9. The following options are available: Ø Transaction Mapping options. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. J2EE environment:Year-To-Date Transformation Example. In the example, Year 2001 has value for Item Sold but not for Sales. x, select 'Project Documentation' from the Tools menu to. ApplyOLAP is used to define compound metrics. Create a Modern Grid with Microcharts A modern grid visualization allows you to include microcharts within cells. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Execute the report and view the SQL:Open the document in Design or Editable Mode. Line: Select the style of the grid lines from the drop-down list. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. In the Visualization Gallery, click Combo Chart to create a combination graph. Then, put the "Inbound Costs" into one column set and the "Outbound Costs" into another column set. Right click and "Run as Administrator" to. Microstrategy Dossiers With the release of MicroStrategy 10. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. Learn how to use compound grids in dossier authoring, which allow you to combine multiple lenses of the data in a single view so that they can be analyzed ac. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. Creating Waterfall Charts. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. The partition attribute should allow for near uniform distribution of data across the partitions, so that the workload on each partition is evenly distributed. Click Insert Visualization . MSTR Secure Enterprise. Below are the steps to enable/disable the settings of data blending: 1. Notice that a joint child relationship can be one-to-many or many-to-many. CSS Compound Grids Generator. MicroStrategy Desktop's basic set of 40 colors matches the Excel colors. Custom grids allow you to utilize dynamic text fields in order to create grids that provide mo. To prevent users from navigating out of the document, they might want to hide some sections from the page. You treat one attribute as a child of the other and have a compound key for the lower level attribute. However, o n iPad with MicroStrategy Mobile 9. With a few lines of code, data scientists can extract data from cubes and reports and publish entirely new datasets for consumption by other analysts. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Visit the MicroStrategy download site to download the latest supported version of this product. A custom group is a special filter that can be placed on a template and is comprised of an ordered collection of elements called custom group elements. Micro Strategy also supports mobile BI. 3. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Relationship Tables. In this case, only one form exists for each, as shown below:To pass the prompt answer for an element prompt when the attribute has a compound ID, you separate each ElementID with a colon. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. 4. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. Export server-level settings and import them for use with another server. promptAnswerMode *. 1 and 10. You can use MicroStrategy Web to create a Grid/Graph that contains objects from multiple dataset reports. Compound Grid visualizations.