Non-aggregatable metrics are defined using the dimensionality section of the metric editor. Click Share > Library Access. The smart metric and the component metric are from different datasets. This section helps you choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. Define the advance sort on the derived. To enable a visualization to filter or highlight the data in another visualization. This document provides the steps to accomplish the same. Create a compound metric called B with expression "RunningSum(A)" as shown below. However, the "Report returned no data" message does not necessarily indicate that a null value has been encountered. And leverage the Page-By function to focus your analysis on one element. Explanation. This may make related application objects (reports, filters and. 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: . Learn how to switch to a compound grid, add column sets in this new visualization. Click Certify. 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. 1 and 10. 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. For example: Create a line graph with Revenue,. Query Stage: Retrieve data from the warehouse. Note: This fix changes CSI and data. ApplyOLAP is used to define compound metrics. The name of the source visualization. The "Grouping" property has six possible. Follow these steps to Drill on a Compound metric in Grid mode: Create a compound metric through the Metric Editor. 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. A compound grid requires at least one attribute and one metric. 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. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. 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. The graph legend or axes can be formatted as well. Use the Visualization Gallery to perform the following tasks: Select a visualization's type. Order: The sort order of the row or column. You can import business data from many different sources, including local files, databases, Google Drive, etc. [ONAME:Compound Grid]: This is the name of the object. 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 the Datasets panel, double-click attributes and metrics to add them to the visualization. Metric with an IF Function. 4. 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. This metric definition is shown below:MicroStrategy recommends using the latest Data Engine Version. Click the Options icon . MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. 4 and later. But, this can also be done with this. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. Limit the number of attribute elements displayed in a prompt in MicroStrategy. How to Share a Dossier. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. 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. Learn how to build custom grids using MicroStrategy Documents. This means that every metric is evaluated in separate SQL passes. Visualize Data Trends: Create intuitive visualizations to present data after it is parsed, structured and analyzed. Microstrategy Dossiers With the release of MicroStrategy 10. 5. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. 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. You cannot place the widget in the Detail section of a document. Select or multi-select users as recipients of the dossier. 4 and. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. 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;. 3. 0 or above. 4. Users may want to display MicroStrategy Web 10. cube architecture each other identity. Format the grid. From the Home menu, point to Export. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Set Data Engine Version setting to 11 or. 5. Select 'Export to Excel' to generate a new Excel document. Lookup Tables. x-10. Introduction to Grids You can display data in a grid layout. x-10. You need to compare the number of units sold today to the number of units sold from January 1 through today. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . 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. Create a new report using the Compound metric. ドシエを開きます。. Another important observation is not to forget to enable "Smart Metric”. To enable totals or subtotals for a metric. The following schema shows which setting takes precedence when set at different levels. On each column set, add at least one attribute. 3. Learn how to build custom grids using MicroStrategy Documents. Select the Repeat attribute column checkbox to display the attribute. Metrics are MicroStrategy objects that represent calculations performed on data. MSTR Secure Enterprise. Add subtotals to the grid. Select the desired option for 'Show attribute names'. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. x and 10. For SAP BW, the following syntax may be used. Enable the Show attribute names parameter. Learn more. In the left toolbar, click Format. Introduction to Visualizations. In the drop-down on the selection bar, select. Microstrategy Dossiers With the release of MicroStrategy 10. Start Power BI Desktop. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. In Workstation 2020 you can only use attributes in rows. Creating Histogram Charts. The Profit metric is a simple sum of the Profit fact. 4. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Step 2. 3. promptAnswerMode *. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. Another important observation is not to forget to enable "Smart Metric”. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. 2) Create Metric2 as the RunningSum of Metric1. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Wählen Netz > Zusammengesetztes Gitter . x allows users and administrators to decide if the attribute titles are displayed using the attribute name or the attribute form name: The setting to control the appearance of the attribute title is located under Preferences - Grid Display: Show Attribute Form Names. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Assuming CP1252As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. x and 10. x, follow the steps below:. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Then, select the color of the grid lines from the palette. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. 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. 4. Microstrategy Dossiers With the release of MicroStrategy 10. Excel: This allows the user to export the document to Microsoft Excel in . The contents of the grid report are displayed, separated by commas. 1/10. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Metrics are MicroStrategy objects that represent calculations performed on data. While all metrics have a formula, not all of them have. Join data visualization specialist Len OToole of InfoCepts for this interactive. MicroStrategy is an enterprise BI application software. 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. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. Select only Configuration Objects for documentation. Measure: SLA Status = ISBLANK(SELECTEDVALUE('Alerts'[handledAt])) the results before adding data from dimension: everything works fine until I add data from dimension. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key for. The Configure Transactions Editor opens. From the Visualizations panel, select Grid . Creating Network Visualizations. [ONAME:Compound Grid]: This is the name of the object. The Group Editor opens. . Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. We're sorry. Transformations allow you to apply an attribute-element based offset to compare metric data. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. Tasks. Wählen Netz > Zusammengesetztes Gitter . For the Time hierarchy, the offset can. 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: . Dossiers have two grid visualizations: Grid and Compound Grid. 9, we’ve taken a leap forward in our dashboarding capabilities. HTML: The grid report is exported to an HTML file. Save designs as templates. In the list of categories on the left, click Subtotals. 最上部のツールバーで、 [ビジュアリゼーションを挿入] をクリックします。. Using the Connector. In the Datasets panel, double-click attributes and metrics to add them to the visualization. The Grouping panel is displayed. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. 4 and later. 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. Non-aggregatable metrics are defined using the dimensionality section of the metric editor. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. Shapes and Data Labels. Add data to the report and leverage formatting capabilities in the modern Library interface. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. A Compound Grid stitches multiple simple Grid visualizations together to. How to use the. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. A blank visualization appears in the dossier. In a Compound Grid, checking multiple attribute display forms, displaying attribute form names, and enabling subtotals on a single metric may result in an error when you try to. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. Copy individual cells from grid visualizations to the clipboard. 364 subscribers. This is a filter which contains a prompt on an attribute element list. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. You can tag multiple users or user groups in a comment. However, o n iPad with MicroStrategy Mobile 9. The Profit metric is a simple sum of the Profit fact. To do so, you must link a Transaction Services report to a grid or to text fields in a panel stack. KB298312: Subtotal of a compound metric doesn’t show correctly in Visual Insight in MicroStrategy Web. Eg, total (profit/units Sold). SQL Panel. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. This document provides the steps to accomplish the same. Export a dossier when viewed in presentation mode. Labels: #Creat transaction services photo uploader #transaction. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. 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. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. Incluso, si. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. x and 10. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. Profit is not displayed on the Grid/Graph, nor is it in the data source for the Grid/Graph. 3. The graph shows revenue by category and region. communicate with mapping. The Compound Grid supports similar operations as regular grids, such as: Sorting. mstr file; Knowledge Base: Best Practices for Library from Product; Knowledge Base: Using REST API to find all certified dossiers within a project; Knowledge Base: How to certify. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. From the Visualizations panel, select Grid . 1 - Answers all required prompts and optional prompts with default answers. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. In this brief video tutorial, Jason Hudson from our Customer Education team explains how to create a grid visualization in a dossier. Excel with plain text: Export the report to Microsoft Excel as plain text. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. In the Run Modes area, select the format (s) in which the document can be exported: •. A Grid/Graph is created for the Regional Revenue dataset. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. The third pass combines the results from the first two passes to generate data for Unit Sales and returns the final result to the end user. 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. Right click on the Grid object and select Properties and Formatting to set Photo Uploader as the widget under Widget setting unchecking full screen for android phone as following. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. In MicroStrategy Web, edit or execute a report. Upon making this selection, the row headers will now be merged. Export server-level settings and import them for use with another server. Insert an HTML container (and not an image) and insert the script below. x-10. Continue creating this derived metric by following the steps to create a summary metric in Using a function to create a subtotal: Creating summary metrics. Populate & Evaluate Stage. 4. In the Editor panel, click Add Column Set to create another column set. Follow the steps below: Right-click on the project and select 'Project Configuration. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. Create a filter with an element list or qualification prompt on an attribute. In general, a user specifies a list of conditions and corresponding return values. Theoretically the element qualification is what we are looking for, but as stated before there are certain limitations. Type a name for the metric in the Metric Name field. - Program Files (x86)MicroStrategyIntelligenceServerImages. Click More in the top right of the heat map and choose Create Contextual Link and select This Dossier. Add, rearrange, or remove data from a visualization in a dossier. MSTR Health Center (if it's not uninstalled) MSTR Office (if installed) DHTML Editing Component (if installed) Restart the machine. Begin by choosing a dominant color which will dictate the look and feel of 60% of your dossier, or the majority of the interface. 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. Export: Choose Whole report vs. . In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. Uniquely identifying data in tables with Compound Key. 1 and 10. Microstrategy Dossiers With the release of MicroStrategy 10. 1, the value range of the metric slider changes accordingly. Tasks. The report-related objects placed on the template. The new grouped attribute appears in the Attribute Name field as. A icon appears in the upper left corner of the source visualization. Then, put the "Inbound Costs" into one column set and the "Outbound Costs" into another column set. Go to project configuration by right clicking on specific project (You need admin rights to do this). But, this can also be done with this. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Why MicroStrategy Why MicroStrategy Why MicroStrategy. The MicroStrategy Tutorial project uses aggregate tables by default. Navigate to the first page of the Office Royale Sales dossier. Doppelklicken Sie im Abschnitt „Datensätze“ auf Attribute und Metriken, um sie der Visualisierung hinzuzufügen. Indexes Panel. This is easily done using the &hiddensections URL parameter that can be obtained from the folder browsing. You can define metrics by using the available functions to analyze your data and determine business measures. Create a report with the Region and Month attributes and the Revenue metric in the grid and filter. [01]. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. 09K KB46909: Rows are missing when exporting a grid in outline mode with subtotals enabled in. A heat map visualization requires a minimum of one attribute and one metric to display correctly. We recommend the latest version. The Compound Grid supports similar operations as regular grids, such as: Notice that a joint child relationship can be one-to-many or many-to-many. x-10. KB440511: How to use a HTML image as a button that exports a grid on a document to Excel in MicroStrategy version 10. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. Add data to the report and leverage formatting capabilities in the modern Library interface. 6. Users sometimes encounter the "Report returned no data" message when executing a report and are unable to display the report result as an empty grid instead. Compound Statements. . In the compound key, calling centers are identified by both Call_Ctr_id and Region_id. Creating a. The content of the report is displayed. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. Choose Grid > Compound Grid . MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. The Grid Settings section allows you to select the Fit to page option, which fits the grid's width onto one PDF page width, or you can select the Allow horizontal pagination option, which breaks a wide grid onto numerous pages. View standard reports in MicroStrategy Library to get a simple, grid view of data. For example, users can have a smart compound metric and a component metric of this compound smart metric on the grid in the document. 1929 views | September 04, 2020 02:01. We recommend the latest version. You can use MicroStrategy Web to create a Grid/Graph that contains objects from multiple dataset reports. x, there is an option to select which attribute would act as a selector, like shown below:. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. The following code sample will execute a report using a ReportBean, and output the column headers from the report grid. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. 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. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. NOTE: Modifying the key form will trigger required updates when saving. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. x. Upgrade to MicroStrategy 11. Choose Excel-compatible colors for objects as well as grid and graph formatting. September 06, 2018. In the Datasets panel, double-click attributes and metrics to add them to the visualization. In MicroStrategy SQL Generation Engine 9. The only solution that I can think of is to create a FreeForm SQL Report. exe using the command line. A normal attribute represents a single hierarchy level (for example, Month). For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. 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 10, there is no SQL View execution mode as there is in MicroStrategy Desktop. MicroStrategy Library provides MicroStrategy reporting and analysis capabilities across all of your client interfaces. Double-click the Column Set name to rename the set. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. The Export to Excel option will now appear. 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. September 18, 2018. Custom grids allow you to utilize dynamic text fields in order to create grids that provide mo. 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 is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. You can display data in a grid layout. In the Gallery, click Compound Grid . Create a report with Year on the rows and Revenue on the columns. A Grid/Graph is a container that is placed in a document and which displays a standard MicroStrategy grid or graph report. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. 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. Note the picture with the definition. By default, the MicroStrategy SQL Generation Engine orders the tables in the following way: Fact Tables. Independent Transactions. Each conditional metric contains a copy of employee list (in an IF statement) Employee list filter is moved to a separate metric (Flag metric) Employee list filter is moved to a Filter object. Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. You can use MicroStrategy Web to create a Grid/Graph that contains objects from. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. x and are instead displayed at the bottom of the page as shown in the image below:New Modern Grid now available in MicroStrategy Dossier. The syntax is: FileLocation is the path to the saved test file. ”. The Metric Editor opens in either Function Editor mode or Formula Editor. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. This may make related application objects (reports, filters. This metric should be used on compound grid (rather than standard one). Click the Options icon . Double-click the Column Set name to rename. The one on the left, which is displayed as a grid, shows revenue by region. . Connecting Tableau to TDV Using ODBC. Create or edit reports with authoring functionality. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. A recursive hierarchy or recursive dimension, usually consists of elements that point to other elements pertaining to the same attribute with a parent-child relationship. The following steps demonstrate how to do that in MicroStrategy Tutorial project: Import data into project and create dashboard. In the Grid/Graph, you can use MicroStrategy Web to create a threshold to change the formatting of the revenue amounts when the profit is greater than a specified amount. 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. You can sort data in a grid based on multiple dataset objects at the same time, using the Advanced Sort dialog. Click Advanced, then New to create a custom subtotal. When users make selection on grid selector in MicroStrategy Web 9. 4 and later. Select More Options at the bottom of the pane. In the Editor panel, click Add Column Set to create another column set. 4. Even after following the steps in KB37102: The color of a series in a graph changes depending on the information that is displayed by the graph in MicroStrategy 9. To display a pop-up tooltip, enter the text in Tooltip. Enable Outline: Select this checkbox to enable outline mode. In this tutorial video, we'll show you how to modify Grid visualizations in MicroStrategy to export them to Excel. Creating Combo Charts (Line & Bar Graphs) Creating Smart KPI Visualizations. intelligence platform that adds in-memory delivery applications. Click Continue if the Preview Connector warning message pops up. Continue with the previous Steps 2 and 3 above. Create additional visualizations to display the data in multiple ways. 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. [グリッド] > [複合グリッド] を選択します 。. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Relationship Tables. General Settings. 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. KB483841: Known issues when using a slicing selector to target a. 2987. In this case, the only object in the columns for this grid is the metric "Revenue".