Metric with an IF Function. Invoke the MicroStrategy Integrity Manager executable MIntMgr. Right-click on a dossier. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. How to Share a Dossier. How to Share a Dossier. Tasks. NOTE: Modifying the key form will trigger required updates when saving. Erstellen einer zusammengesetzten Tabellen-Visualisierung. The Export to Excel option will now appear. MicroStrategy Desktop's basic set of 40 colors matches the Excel colors. ”. The report using in this example has the following structure when executed in Web or Developer: Region,Income Bracket, Metrics, Revenue. 1925 views | September 04, 2020 02:01. promptAnswerMode *. 1, the value range of the metric slider changes accordingly. From the Tools menu, select Report Options . Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. 4 and later. Click Advanced, then New to create a custom subtotal. Then it creates a third metric, a compound metric. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. [データセット] パネルで、アトリビュートとメトリックをダブルクリックし、ビジュアリゼーションに追加し. A compound key attribute is an attribute that has two or more IDs. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis when you need to analyze several KPIs across a common dimension, like investment vehicle or region. How to use the. From the Home menu, select Export, and then select one of the following export formats: PDF: Export the report to an Adobe PDF file. The Grid/Graph is displayed as a grid or as a graph, depending on how the report is displayed. Use the Visualization Gallery to perform the following tasks: Select a visualization's type. How the user answers the question determines what data is displayed on the report when it is returned from your data source. x, non-aggregatable metrics are used for this kind of calculation. Create or edit reports with authoring functionality. Like other visualizations, a Compound Grid can be used as the target of a selector. The report execution is typically a 3 step process process of the below: Query Stage. The same metric exists multiple times on the grid. The following schema shows which setting takes precedence when set at different levels. Because element prompt answers are matched with prompts using the AttributeID, the order of the prompt answers does not determine the order in which prompts are answered. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. x, the series lines do not inherit the color of the series markers and change depending on which metrics are displayed on the graph. Cross-tab Stage: Pivot and display sorting and page-by. 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. Open a new or existing dossier. Choose Grid > Compound Grid . How to use the MicroStrategy 2020 compound grid. Learn to share exact chapter level filter state of the dossier by embedding a filter in the comments. This may make related application objects (reports, filters and. To change how it is displayed, do one of the following: To display it as a grid (a standard MicroStrategy grid report with rows and columns of attributes and metrics), in the Property List: Appearance section, select Grid from the View mode drop-down. 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. In the Datasets panel, double-click attributes and metrics to add them to the visualization. While all metrics have a formula, not all of them have. x-10. Search for users or add users by clicking on the add icon. 97%, and this is true whether Data Engine Version is set to 10 or 11. A compound grid requires at least one attribute and one metric. How to Share a Dossier. Mar 17, 2022 -- 2 Working with data is fun! Recently I found myself obsessed with MicroStrategy’s grid tool. 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. Make two grids with different attributes and metrics in each 3. Create new metric Average (Revenue) via Revenue>New Metric>Average as shown below: Edit Average (Revenue) and change level to Region as shown below: Save the dashboard and create new metric M1. Click Insert Visualization to add a new, blank visualization to the dossier. Create a metric that sums the fact Units Sold. x. See related articleThis video shows how to certify a dossier. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. It is now possible to format column groups differently, freely alternate the placement of metrics and attributes in the column headers for each group of columns, or choose which columns of the Grid should show the subtotal value or all values. In a document, you can display a report by adding a Grid/Graph to the document. You treat one attribute as a child of the other and have a compound key for the lower level attribute. For example, a document contains two Grid/Graphs. Introduction to Grids You can display data in a grid layout. All Grid Fonts: Select font formatting options for all text. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. On the Overview page, click the Comments icon. Metric Expressions. This metric definition is shown below:MicroStrategy recommends using the latest Data Engine Version. 11. x, users may notice that the row headers are not merged, like shown below:Design compound visualizations or add rich text boxes and images. J2EE environment:Year-To-Date Transformation Example. A normal attribute represents a single hierarchy level (for example, Month). Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. In both a Grid and a Compound Grid, checking multiple attribute display forms and displaying attribute form names will cause the enabling or disabling of other attribute's subtotals. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. The compound join saves memory space and processing time on the Intelligence Server executing the document. The Configure Transactions Editor opens. Data from the input objects defined in the Transaction Services report is displayed in the grid, text fields, or cells for users to. Doppelklicken Sie im Abschnitt „Datensätze“ auf Attribute und Metriken, um sie der Visualisierung hinzuzufügen. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. 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. Visualization Options . The Delete unused managed objects option is found under. Like other visualizations, a Compound Grid can be used as the target of a selector. The only solution that I can think of is to create a FreeForm SQL Report. Learn how to build custom grids using MicroStrategy Documents. Export Report Title: Selected by default. Creating a 'Compound Grid' 4104 views | September 04, 2020 02:40. This article describes how to display username on the report grid with MicroStrategy Developer 9. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. A blank visualization appears in the dossier. 678 views 2 years ago MicroStrategy 2020. Metrics are MicroStrategy objects that represent calculations performed on data. The one on the left, which is displayed as a grid, shows revenue by region. 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. Use the links below to create visualizations using the Visualization Gallery:The grid is targeted by a grid selector and a metric slider selector. In the list of categories on the left, click Subtotals. J2EE environment:Year-To-Date Transformation Example. General Settings. 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. 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. 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. There's a reason we're at the top of the list. The key will show up on the screen and will. Create three attributes named A, B, C, and after them added in a report. Lookup Tables. Type the following for the name: "Total for the #P #0". MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Compound Grid visualizations. From the Home menu, select Export. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. This calculation can be aggregated from the Employee level to the Region level. A compound grid requires at least one attribute and one metric. On the I-Server we copy the images to the following folders: - Program Files (x86)MicroStrategyDeveloperImages. Click the vertical eclipse icon (More) on the top right of the visualization. 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. A Grid/Graph can be directly associated with one dataset report. 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. You can also apply a set of color and shading schemes to all the objects on a graph report. Visualize Data Trends: Create intuitive visualizations to present data after it is parsed, structured and analyzed. Create additional visualizations to display the data in multiple ways. Learn how to build custom grids using MicroStrategy Documents. Transformations allow you to apply an attribute-element based offset to compare metric data. Format Panel for Grid Visualizations. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. Share Get link; Facebook; Twitter; Pinterest; Email;. In this case, only one form exists for each, as shown below: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,. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. Check the Merge checkbox under Rows in the Header section. Select the 'Advanced' tab, as shown. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. (Highly recommend for understanding your exported data). The Compound Grid supports similar operations as regular grids, such as: Sorting. That's why it show a static text "{[New Derived. Create a Compound Grid. Required prompts without any default answers remain open while optional prompts without default defaults answers are closed with an empty answer. In Workstation 2020 you can only use attributes in rows. 4 and later. In the top toolbar, click Insert Visualization . Name = [REGION2]. Compound Grid visualizations. Start Power BI Desktop. In general, a user specifies a list of conditions and corresponding return values. Creating Powerful (and Beautiful) Dossiers. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. 1/10. 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. {&GROUPLABEL} Name of the graph item's category. Click Insert Visualization to add a new, blank visualization to the dossier. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. Power BI's dashboards update in real time from all data sources. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. mstrc”. Select 'Export to Excel' to generate a new Excel document. Measure: SLA Status = ISBLANK(SELECTEDVALUE('Alerts'[handledAt])) the results before adding data from dimension: everything works fine until I add data from dimension. A normal attribute represents a single hierarchy level (for example, Month). MicroStrategy AI is here. Create a Report Services Document 2. Ahora, ten en cuenta que corre de nuestra cuenta vigilar que el número de elementos hijos en el grid es el que debería. Connecting Tableau to TDV Using ODBC. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. 1929 views | September 04, 2020 02:01. Introduction to Grids. From the Visualizations panel, select Grid . Create a new report using the Compound metric. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. In the report, the attribute with the compound key is Distribution Center. View the orange Certified ribbon on the dossier. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Compensating Transactions. This may make related application objects (reports, filters. - Program Files (x86)MicroStrategyIntelligenceServerImages. Create 2 panel stacks and put the same grid consisting of 1 attribute and 4 metrics on each panel stack. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Notice that some metrics from the right grid are missing. You can also apply a set of color and shading schemes to all the objects on a graph report. From the Visualizations panel, select Grid . x-10. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis when you need to analyze several KPIs across a common dimension, like investment vehicle or region. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Microstrategy Dossiers With the release of MicroStrategy 10. Independent Transactions. 4. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. A grid is an essential element of data analysis. Graph: Displays the data visually like a standard MicroStrategy graph report. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. The selection bar opens, and the heat map is labeled as the Source. For example, users can have a smart compound metric and a component metric of this compound smart metric on the grid in the document. On the right grid, hide the attribute column by disabling the "Show Rows" option in the Grid properties as shown below: Export the dashboard to Excel. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. 3. Click Switch to Function Editor. Step 1: Figure out how many electrons the molecule must have, based on the number of valence electrons in each atom. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. In the Gallery, click Compound Grid . After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. Copy individual cells from grid visualizations to the clipboard. Steps to Reproduce on a Compound Grid. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. A icon appears in the upper left corner of the source visualization. Then, select the color of the grid lines from the palette. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. The Metric Editor opens in either Function Editor mode or Formula Editor. Portion displayed only (only the displayed page if multiple pages). KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. Enable the Show attribute names parameter. This document provides the steps to accomplish the same. Customers often ask for them, so the visualization seen above is some workaround, that gives possibility to imitate MicroCharts. Step 2. In the relational database, a. Back to the Report. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. I'm working on a dossier and I have a dataset that includes customer types. Learn how to switch to a compound grid, add column sets in this new visualization. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. [グリッド] > [複合グリッド] を選択します 。. Finally, just create the report with the attribute (Category) and the third metric. Access. 4. Microsoft Analysis Services supports it; SAP BW has returned errors in MicroStrategy's testing. To set this option on the user level: Click on the User Preferences within Web Preferences, and then Grid display. In the right corner of the dashboard, change the. MicroStrategy Geospatial Services is automatically enabled in these. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. 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). The add-in introduces the ability to import and refresh reports and datasets from MicroStrategy into Microsoft Excel. mstrc file created before and click Continue. You want to tag the team leader responsible for creating the dossier. Drag and drop the . 3. New workaround Attribute left outer join effect in MicroStrategy Web Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. Select any project that is in the project source that. Color from the Advanced Color Picker will. From the Visualizations panel, select Grid . September 06, 2018. Creating a 'Compound Grid' 4100 views | September 04, 2020 02:40. ドシエを開きます。. Dossiers have two grid visualizations: Grid and Compound Grid. Copy individual cells from grid visualizations to the clipboard. Microstrategy Dossiers With the release of MicroStrategy 10. Select More Options at the bottom of the pane. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. Insert an HTML container (and not an image) and insert the script below. Then, put the "Inbound Costs" into one column set and the "Outbound Costs" into another column set. Select only Configuration Objects for documentation. Create a compound metric "Count Employee" as "Count Employee temp" + "Zero" with the definition: ( + Zero) Under the "Subtotals/Aggregation" tab, enable the setting "Allow Smart Metric", at the bottom of the pane: Use the compound metric "Count Employee" on. xls format. 364 subscribers. We recommend the latest version. The contents of the grid report are displayed, separated by commas. The Export to Excel option will now appear. Subscribe. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Create a report as shown below: When Category=Music, the Cost(1) and C1_R_M will have null values. Export: Choose Whole report vs. MicroStrategy Dossier makes it easy to build insightful and engaging dashboards—and with the free-form canvas, the latest 2020 platform release has introduced new game-changing, design-focused features. Click More in the top right of the heat map and choose Create Contextual Link and select This Dossier. In the Editor panel, right-click the attribute or metric to sort and choose Advanced Sort. However, the SQL used to execute the report can still be viewed and obtained. Tag Users in Microstrategy Dossier. General Settings. Click on Dossiers in the left panel of Workstation. Non-aggregatable metrics are defined using the dimensionality section of the metric editor. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated. See the previous images above to see how the row headers should now appear. x. 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. Finally, just create the report with the attribute (Category) and the third metric. Limit the number of attribute elements displayed in a prompt in MicroStrategy. The smart metric and the component metric are from different datasets. 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. Create. Follow the steps below. CSS Compound Grids Generator. V. Wählen Netz > Zusammengesetztes Gitter . This URL executes a report with one prompt. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. In MicroStrategy Web, edit or execute a report. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. x and 10. 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. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. Template Select template style and color. Click Insert Visualization . Visualizations provide a variety of ways for you to display and interact with the data in a dossier. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. The following steps demonstrate how to do that in MicroStrategy Tutorial project: Import data into project and create dashboard. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. Create a compound metric called B with expression "RunningSum(A)" as shown below. x, select 'Project Documentation' from the Tools menu to start the wizard. 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. In the compound key, calling centers are identified by both Call_Ctr_id and Region_id. Grid Panel. x, select 'Project Documentation' from the Tools menu to start the wizard. From the Tools menu, select Grouping. Create a Compound Grid. Dependiendo del número de elementos hijos que tenga definido el contenedor grid en su HTML, tendremos una cuadrícula de 2x2 elementos (4 ítems), 2x3 elementos (6 ítems), 2x4 elementos (8 ítems) y así sucesivamente. From the 'Edit' menu, choose 'Group'. MicroStrategy Library provides MicroStrategy reporting and analysis capabilities across all of your client interfaces. A heat map visualization requires a minimum of one attribute and one metric to display correctly. Select any project that is in the project source that contains the users and groups and click Next. Information is arranged in rows and columns,. After creating a grid, interact with its data to customize your view, by performing the following tasks: Add and display. When users make selection on grid selector in MicroStrategy Web 9. View the visualization's name and data requirements. New workaround Attribute left outer join effect in MicroStrategy Web Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. Upgrade to MicroStrategy 11. Learn how to switch to a compound grid, add column sets in this new visualization. Why MicroStrategy Why MicroStrategy Why MicroStrategy. This means that every calling center has its own unique ID. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. Add metrics to rows in compound grids. Name, [Measures]. 4. Click Insert Visualization . Follow the steps below: Right-click on the project and select 'Project Configuration. Insert an HTML container (and not an image) and insert the script below. '. Using a combination of filters and metric dimensionality, the same results can be achieved. MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. From the 'Edit' menu, choose 'Group'. [ONAME:Compound Grid]: This is the name of the object. This metric should be used on compound grid (rather than standard one). To export a report while viewing it: Click the name of a report to display it. To enable totals or subtotals for a metric. 5. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. The first pass calculates Sales; the second pass calculates Item Sold. Related articles from the Community: Knowledge Base: Dossier is no longer certified when downloaded as a . What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. 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. of distributed under each attribute element. In the Editor panel, click. Click the Options icon . Export a dossier when viewed in presentation mode. Ø Local Transaction options. Creating metrics on-the-fly: derived metrics, Defining attribute elements on-the-fly: derived elements, Filtering data on the fly: view filters and metric filters, Importing data as an. DAY_DESC. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. Create or edit reports with authoring functionality. x, select 'Project Documentation' from the Tools menu to. Choose Excel-compatible colors for objects as well as grid and graph formatting. compound attributes. 4. Select 'Export to Excel' to generate a new Excel document. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. Custom grids allow you to utilize dynamic text fields in order to create grids that provide more. A visualization is a visual representation of the data in a dossier, such as a grid, line chart, or heat map. Another important observation is not to forget to enable "Smart Metric”. If the document is being displayed on an iOS device, you can link the report to the cells of a transaction table. 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: . Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. View standard reports in MicroStrategy Library to get a simple, grid view of data. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Doppelklicken Sie im Abschnitt „Datensätze“ auf Attribute und Metriken, um sie der Visualisierung hinzuzufügen. The content of the report is displayed. The graph shows revenue by category and region. Method 2: Document with a Grid without the Grid Title Bar. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Selections made while viewing the document are used to determine which slices of data are combined and shown in the Grid/Graph. 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. Note: This fix changes CSI and data. In the Datasets panel, double-click attributes and metrics to add them to the visualization. Click the Options icon . In this brief video tutorial, Jason Hudson from our Customer Education team explains how to create a grid visualization in a dossier. Another important observation is not to forget to enable "Smart Metric”. In MicroStrategy Analytics Enterprise Web 10, 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). Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. This calculation can be aggregated from the Employee level to the Region level.