MicroStrategy Geospatial Services is automatically enabled in these. View the visualization's name and data requirements. Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. To export a report while viewing it, click the name of a grid report to display it. Connecting Tableau to TDV Using ODBC. This prompt is used in a filter. 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. Hover over the visualization to use as the source and click More in the top right and choose Select Target. Make two grids with different attributes and metrics in each 3. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. The compound join saves memory space and processing time on the Intelligence Server executing the document. The following options are available: Ø Transaction Mapping options. Add data to the report and leverage formatting capabilities in the modern Library interface. Slicing means that the data for each available item in the selector is calculated in advance when the document is first displayed. Compound Statements. Note the next figure. You need to compare the number of units sold today to the number of units sold from January 1 through today. To enable a visualization to filter or highlight the data in another visualization. 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,. This calculation can be aggregated from the Employee level to the Region level. Note: If a user enters more than 15 digits for a. The spreadsheet retains the formatting of the report as displayed in MicroStrategy Web, such as colors, fonts, and structure. After creating a grid, interact with its data to customize your view, by performing the following tasks: Add and display dynamic links in the grid. This article describes how to merge the row headers in Visual Insight MicroStrategy Web 9. 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. E2open - MicroStrategy Training. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. com Click Insert Visualization . 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. Generally, you build a compound attribute when your logical data model reflects that a compound key relationship is present. Super Cubes in MicroStrategy 2019 Beginning in MicroStrategy 11. Copy individual cells from grid visualizations to the clipboard. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. But, this can also be done with this. 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. MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. Use the links below to create visualizations using the Visualization Gallery:The grid is targeted by a grid selector and a metric slider selector. This URL executes a report with one prompt. Then it creates a third metric, a compound metric. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Learn more. The Metric Editor opens in either Function Editor mode or Formula Editor. This article outlines an issue when using a Compound Grid there is a missing row after exporting to Excel. A icon appears in the upper left corner of the source visualization. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. "IIf([REGION2]. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. But, this can also be done with this work around, here are three tables in warehouse. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. x-10. This design may look strange, but in most cases there are. The graph shows revenue by category and region. Insert an HTML container (and not an image) and insert the script below. Here the many-to-many relationship is converted into a compound attribute relationship. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. A visualization is a visual representation of the data in a dossier, such as a grid, line chart, or heat map. In the list of categories on the left, click Subtotals. This means that every metric is evaluated in separate SQL passes. 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. 2. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. Creating a 'Compound Grid' 4104 views | September 04, 2020 02:40. 最上部のツールバーで、 [ビジュアリゼーションを挿入] をクリックします。. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. [ONAME:Compound Grid]: This is the name of the object. CSS Compound Grids Generator. The following procedure describes how to achieve this: Create the highest level filter. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). MicroStrategy Desktop's basic set of 40 colors matches the Excel colors. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. The graph legend or axes can be formatted as well. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Export Report Title: Selected by default. 最上部のツールバーで、 [ビジュアリゼーションを挿入] をクリックします。. 0 and 2019, users will notice objects referred to as "Super Cubes". Microstrategy Dossiers With the release of MicroStrategy 10. Portion displayed only (only the displayed page if multiple pages). If the document is being displayed on an iOS device, you can link the report to the cells of a transaction table. Click Switch to Function Editor. You can display data in a grid layout. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. ApplyOLAP is used to define compound metrics. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Click on Dossiers in the left panel of Workstation. Dossiers have two grid visualizations: Grid and Compound Grid. A heat map visualization requires a minimum of one attribute and one metric to display correctly. 3. 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. This may make related application objects (reports, filters. 1. Live 360-Degree View of Data: Stay in the loop about crucial business insights. For SAP BW, the following syntax may be used. Click Insert Visualization . . A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. There's a reason we're at the top of the list. How to use the. Add data to the report and leverage formatting capabilities in the modern Library interface. Access. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. 678 views 2 years ago MicroStrategy 2020. Double-click a column set name to rename it. The Profit metric is a simple sum of the Profit fact. Start Power BI Desktop. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Using a combination of filters and metric dimensionality, the same results can be achieved. Do not forget to enable Subtotal (F11). 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. 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. Subscribe. Symptom After setting up a dossier with a compound grid that has more than one column set there are situations in which after exporting to excel the file generated is missing the first row of information. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. In the Editor panel, click Add Column Set to create another column set. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Using the Connector. Select the entire visualization or just the area you want to format. 4. [グリッド] > [複合グリッド] を選択します 。. MicroStrategy recommends that when choosing your colors, to keep the 60-30-10 rule in mind. 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. The Grid/Graph (referred to simply as a report) can be directly associated with one dataset or with multiple datasets. NOTE: Modifying the key form will trigger required updates when saving. Click Insert Visualization to add a new, blank visualization to the dossier. Compound grid export via Office add-in Hi there @Cheng Guo (Inactive) (Microstrategy, Inc. x. 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. 11. Create an empty MD shell in Microsoft Access. 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. 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. HTML: The grid report is exported to an HTML file. 1925 views | September 04, 2020 02:01. DAY_DESC. KB440511: How to use a HTML image as a button that exports a grid on a document to Excel in MicroStrategy version 10. ) Unfortunately I have a limitation/bug to report and ask about. The Shapes and Data Labels options are available to format the graph items, such as graph markers and data labels, in. 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. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. 1925 views | September 04, 2020 02:01. Share Get link; Facebook; Twitter; Pinterest; Email;. Fit to grid contents, to display all of the data on the Grid/Graph. Create or edit reports with authoring functionality. 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. The following schema shows which setting takes precedence when set at different levels. Export Report Title: Selected by default. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. A heat map visualization requires a minimum of one attribute and one metric to display correctly. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. By default, the MicroStrategy SQL Generation Engine orders the tables in the following way: Fact Tables. 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. Learn how to build custom grids using MicroStrategy Documents. Add, rearrange, or remove data from a visualization in a dossier. 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. This metric should be used on compound grid (rather than standard one). Assuming CP1252As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. 2. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. This will enable the option to use ApplyComparison’s in Filters. Color from the Advanced Color Picker will. Each custom format can have up to four. In the Gallery, click Compound Grid . This metric definition is shown below:MicroStrategy recommends using the latest Data Engine Version. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. A classic example is an organization chart: This information can be stored in a recursive fashion using only one table with two ID columns: Problem. Make two grids with different attributes and metrics in each 3. 364 subscribers. Method 2: Document with a Grid without the Grid Title Bar. 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. Insert an HTML container (and not an image) and insert the script below. The report-related objects placed on the template. 3. Export: Choose Whole report vs. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. That's why it show a static text "{[New Derived. Open the dossier you want to modify. Compound grids offer enormous flexibility and a lot of room for creativity. In the list of categories on the left, click Subtotals. MicroStrategy recommends that when choosing your colors, to keep the 60-30-10 rule in mind. 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 format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. Formula and dimensionality are the two important components in a metric. 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. Go to Web Preferences and select Project Default -> Grid Display. Explanation. From the Visualizations panel, select Grid . This article provides a list of new enhancements and default settings available to users exporting a dossier to a PDF in MicroStrategy version 2020 of Workstation, Web, or Desktop. For example, a document contains two Grid/Graphs. A ragged hierarchy is the one in which the parent attribute element of one or more. Using images in Microstrategy reports. Then it creates a third metric, a compound metric. And leverage the Page-By function to focus your analysis on one element. Create or edit reports with authoring functionality. Metric with an IF Function. In the Editor panel, click Add Column Set to create another column set. Enable Outline: Select this checkbox to enable outline mode. Select one of the following export formats: To export the report to an Adobe PDF file, select PDF. To enable totals or subtotals for a metric. Create a Report Services Document 2. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. To do so, you must link a Transaction Services report to a grid or to text fields in a panel stack. Enable the Source Visualization to Update the Target Visualization. You can define metrics by using the available functions to analyze your data and determine business measures. 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. The selection bar opens, and the heat map is labeled as the Source. Microstrategy Dossiers With the release of MicroStrategy 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. From the Tools menu, select Report Options . 09K KB46909: Rows are missing when exporting a grid in outline mode with subtotals enabled in. In the Datasets panel, double-click attributes and metrics to add them to the visualization. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. Tasks. 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. If projects are distributed asymmetrically across the cluster, when you assign an event-triggered schedule to a project, make sure you trigger the event on all nodes on which that project is loaded. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. 2987. 4. Open the dossier you want to modify. Check the Merge checkbox under Rows in the Header section. Create 2 panel stacks and put the same grid consisting of 1 attribute and 4 metrics on each panel stack. An input box will be displayed with a list of recommended questions based. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. In the compound key, calling centers are identified by both Call_Ctr_id and Region_id. Compound Grid visualizations. This section shows the effects of different element settings on a single metric when used in the same report. Use compound. 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. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. promptAnswerMode *. Select More Options at the bottom of the pane. Insert an HTML container (and not an image) and insert the script below. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. The only solution that I can think of is to create a FreeForm SQL Report. See related articleThis video shows how to certify a dossier. 4. You can tag multiple users or user groups in a comment. This document provides the steps to accomplish the same. exe using the command line. E2open - MicroStrategy Training. Like other visualizations, a Compound Grid can be used as the target of a selector. But, this can also be done with this. Create a Report Services Document 2. Transformations allow you to apply an attribute-element based offset to compare metric data. compound attributes. To determine how null and zero metric values are displayed or hidden in a grid report Open the report in Edit mode. 3. Creating Box Plots. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. Select the 'Advanced' tab, as shown. Format the grid. Navigate to and select a Transaction Services report, then click OK. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. Name, [Measures]. Create a second metric identical to the first, but add the predefined Year to Date transformation. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. 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. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. Community & Support Search Discussions Open A Case View My CasesExample 1: Compound key with Effective Date and End Date. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Click the Options icon . View standard reports in MicroStrategy Library to get a simple, grid view of data. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. To pass the prompt answer for an element prompt when the attribute has a compound ID, you separate each ElementID with a colon. MicroStrategy Community 4. How the user answers the question determines what data is displayed on the report when it is returned from your data source. In the Run Modes area, select the format (s) in which the document can be exported: •. 3K views 3 years ago What's new in MicroStrategy 2020 Learn how to use compound grids in dossier. Compound Grid Generator (Large preview)A prompt is a question the system presents to a user when a report is executed. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. of data from digital manage digital identity. (Does it sound like multisourcing for all the users without admin help?)MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. 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. Exceptions. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. Why MicroStrategy Why MicroStrategy Why MicroStrategy. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. x, non-aggregatable metrics are used for this kind of calculation. Click Share > Library Access. 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. Click the vertical eclipse icon (More) on the top right of the visualization. After the attribute form names are enabled, the grid will display. In general, a user specifies a list of conditions and corresponding return values. See the previous images above to see how the row headers should now appear. Click Advanced, then New to create a custom subtotal. For example, there. Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. However, o n iPad with MicroStrategy Mobile 9. The Export to Excel option will now appear. x and 10. Step 1: Figure out how many electrons the molecule must have, based on the number of valence electrons in each atom. To set this option on the user level: Click on the User Preferences within Web Preferences, and then Grid display. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. Compound metrics are the ones that are derived by some specific expression involving the different simple metrics. 5. Visualization Options . Populate & Evaluate Stage: Fill report data for display. Finally, just create the report with the attribute (Category) and the third metric. 3. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. This document provides the steps to accomplish the same. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. Create a report with the Region and Month attributes and the Revenue metric in the grid and filter. Select any project that is in the project source that. Create a filter with an element list or qualification prompt on an attribute. Required prompts without any default answers remain open while optional prompts without default defaults answers are closed with an empty answer. 9, we’ve taken a leap forward in our dashboarding capabilities. mstrc file created before and click Continue. - Program Files (x86)Common FilesMicroStrategyimages. In the Datasets panel, double-click attributes and metrics to add them to the visualization. 4. Turning on totals returns a row for the total, even though there are not rows of data to show. 364 subscribers. Select 'Export to Excel' to generate a new Excel document. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. 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. The following errors were encountered while parsing the POD: Around line 3444: Non-ASCII character seen before =encoding in '·'. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Enable the Show attribute names parameter. Relate tables contain the ID columns of two or more attributes, which will define associations between them. In the Editor Panel, right-click the attribute in Column Set 1 and select Display Attribute Forms . To enable this row display, change the Join type to “Join 92” and disable “null check” for metric in report VLDB properties. promptAnswerMode *. A heat map visualization requires a minimum of one attribute and one metric to display correctly. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. Input connection parameters for the connector:MicroCharts are visualizations that MicroStrategy has in Document, but not in Dossier. Export server-level settings and import them for use with another server. 5. Create a metric that sums the fact Units Sold. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. The color is displayed in Presentation Mode in MicroStrategy Web. . You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Visualizations provide a variety of ways for you to display and interact with the data in a dossier. How to Share a Dossier. In MicroStrategy Web 10, there is no SQL View execution mode as there is in MicroStrategy Desktop. Click Insert Visualization to add a new, blank visualization to the dossier. x and 10. Compound grid export via Office add-in. Introduction to Grids. Excel with formatting: The report is exported and displayed as a Microsoft Excel spreadsheet. This video show how to share a filter with other MicroStrategy Library users. Check the Merge checkbox under Rows in the Header section. 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. 11?; Knowledge Base: Annotate. A blank visualization appears in the dossier. 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. I'm showing on a grid visual unique IDs from the fact table and a measure that checks if there is value in a specific column in the fact table for the selected id. Learn how to build custom grids using MicroStrategy Documents. Use the Visualization Gallery to perform the following tasks: Select a visualization's type. Click the location on your document in which to place the widget. 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. x, follow the steps below:. MicroStrategy AI is here. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Add an attribute and a metric to both Column Set 1 and Column Set 2. Add the derived metric to the report and hide it by setting the column width to 0. Learn how to switch to a compound grid, add column sets in this new visualization. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. A blank visualization appears in the dossier. Creating Powerful (and Beautiful) Dossiers.