x, follow the steps below:. Create a report with Year on the rows and Revenue on the columns. You can quickly create multiple element groups at the same time. In this brief video tutorial, Jason Hudson from our Customer Education team explains how to create a grid visualization in a dossier. From the Visualizations panel, select Grid . mstrc, please open something similar to Notepad. To enable totals or subtotals for a metric. x and 10. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Dossiers have two grid visualizations: Grid and Compound Grid. If installed over previous versions of the product, the folder remains the same. This case is also explained with an example based on the MicroStrategy Tutorial project. Or create and edit content. This section shows the effects of different element settings on a single metric when used in the same report. Compound grid export via Office add-in. Compound metrics are the ones that are derived by some specific expression involving the different simple metrics. Filter data in a second visualization by selecting attribute elements or metric values in. Selections made while viewing the document are used to determine which slices of data are combined and shown in the Grid/Graph. [データセット] パネルで、アトリビュートとメトリックをダブルクリックし、ビジュアリゼーションに追加し. Access. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. Select any project that is in the project source that contains the users and groups and click Next. To create a MicroStrategy Environment connection file . Select or multi-select users as recipients of the dossier. 4. Solution. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. . For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. For steps and information on how the datasets are joined, see the. Panel Stacks. Method 2: Document with a Grid without the Grid Title Bar. Format Panel for Grid Visualizations. 0 and 2019, users will notice objects referred to as "Super Cubes". Learn more. 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. But, this can also be done with this. In MicroStrategy Analytics Enterprise Web 10 onewards, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI) which has been renamed as Super Cubes in MSTR 2019. Click Share > Library Access. Learn more. Then, put the "Inbound Costs" into one column set and the "Outbound Costs" into another column set. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. And leverage the Page-By function to focus your analysis on one element. Access. Double-click a column set name to rename it. Metric Expressions. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. 1, the value range of the metric slider changes accordingly. Note the picture with the definition. Turning on totals returns a row for the total, even though there are not rows of data to show. 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. 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. It can connect to data warehouses, relational systems, flat files, web. 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. On the I-Server we copy the images to the following folders: - Program Files (x86)MicroStrategyDeveloperImages. NOTE: Modifying the key form will trigger required updates when saving. Use compound. 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. Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. Make two grids with different attributes and metrics in each 3. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Incluso, si. Creating a grid report. The following schema shows which setting takes precedence when set at different levels. Customers often ask for them, so the visualization seen above is some workaround, that gives possibility to imitate MicroCharts. 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. We recommend the latest version. Columns Panel. You need to compare the number of units sold today to the number of units sold from January 1 through today. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Export: Choose Whole report vs. MicroStrategy is an enterprise BI application software. Microstrategy Dossiers With the release of MicroStrategy 10. In the list of categories on the left, click Subtotals. Follow the steps below to create a prompt-in-prompt. The only solution that I can think of is to create a FreeForm SQL Report. Select any project that is in the project source that contains the users and groups and click Next. Custom grids allow you to utilize dynamic text fields in order to create grids that provide mo. The same metric exists multiple times on the grid. 3K views 3 years ago What's new in MicroStrategy 2020 Learn how to use compound grids in dossier. 4 and later. Save the dashboard. 09K KB46909: Rows are missing when exporting a grid in outline mode with subtotals enabled in. This groups them, but doesn't label them quite yet. How to use the MicroStrategy 2020 compound grid. But this behavior can be changed by using the 'From Clause Order' VLDB property under the 'Joins' folder. Creating Combo Charts (Line & Bar Graphs) Creating Smart KPI Visualizations. That's why it show a static text "{[New Derived. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. A compound key attribute is an attribute that has two or more IDs. Graph: Displays the data visually like a standard MicroStrategy graph report. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. The compound join saves memory space and processing time on the Intelligence Server executing the document. 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. is not running the latest Microstrategy for office so I'd like to ask if this issue is A)known. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Enable the Source Visualization to Update the Target Visualization. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. Click here to view help for the latest version of this product or search MicroStrategy Community. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. 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. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. MicroStrategy recommends that when choosing your colors, to keep the 60-30-10 rule in mind. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. 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. Subscribe. DAY_DESC. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. See the previous images above to see how the row headers should now appear. This means that two calling centers from different regions can share the same Call_Ctr_id. Formula and dimensionality are the two important components in a metric. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Compound Grid visualizations. What's New;This video shows you how to add a MicroStrategy dossier to your MicroStrategy Library by using both the Add to Library and Share options. In MicroStrategy SQL Generation Engine 9. Foreign Keys Panel. x, users can define a custom subtotal for a metric that returns a value that a compound level metric would return. Set Data Engine Version setting to 11 or. Export Page. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. 97%, and this is true whether Data Engine Version is set to 10 or 11. September 06, 2018. x. In the Datasets panel, double-click attributes and metrics to add them to the visualization. All Grid Fonts: Select font formatting options for all text. Click More in the top right of the heat map and choose Create Contextual Link and select This Dossier. Invoke the MicroStrategy Integrity Manager executable MIntMgr. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. With MicroStrategy 2020 Patch Installer, our customers get centralized solution for applying critical fixes to any version of the. In the list of categories on the left, click Subtotals. [グリッド] > [複合グリッド] を選択します 。. Create a report as shown below: When Category=Music, the Cost(1) and C1_R_M will have null values. Copy individual cells from grid visualizations to the clipboard. Notice that a joint child relationship can be one-to-many or many-to-many. The same metric exists multiple times on the grid. in Microstrategy Dossier, is it possible to create 2 rows of header, such that the first row is the grouping information and spans to number of columns to identify as a. This means that every calling center has its own unique ID. The Profit metric is a simple sum of the Profit fact. The one on the left, which is displayed as a grid, shows revenue by region. A compound attribute is an attribute with multiple columns specified as the ID column. Limit the number of attribute elements displayed in a prompt in MicroStrategy. 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. However, o n iPad with MicroStrategy Mobile 9. The contents of the grid report are displayed, separated by commas. 1919 views | September 04, 2020. From the 'Edit' menu, choose 'Group'. x SYMPTOM When users create a Grid visualization in Visual Insight using MicroStrategy Web 9. And leverage the Page-By function to focus your analysis on one element. Open an existing dossier that contains a grid visualization. Exceptions. Click Switch to Function Editor. - Program Files (x86)MicroStrategyIntelligenceServerImages. Copy individual cells from grid visualizations to the clipboard. In the Datasets panel, double-click attributes and metrics to add them to the visualization. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. My org. This case is also explained with an example based on the MicroStrategy Tutorial project. In Workstation 2020 you can only use attributes in rows. The report execution is typically a 3 step process process of the below: Query Stage. 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. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. Export: Choose Whole report vs. 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. compound attributes. Create a Report Services Document 2. A blank visualization appears in the dossier. First, do "Change Visualization" on your grid and set it to "Compound Grid". NOTE: Modifying the key form will trigger required updates when saving. 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. This means you can have multiple. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. mstrc”. To export the report to Microsoft Excel as plain text, select Excel with plain text. A heat map visualization requires a minimum of one attribute and one metric to display correctly. In certain reports, users may notice that subtotals defined across level are not broken by attribute element in a grid report in MicroStrategy Developer 9. 4. Example 1: Compound key with Effective Date and End Date. Cross-tab Stage: Pivot and display sorting and page-by. 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. Click Insert Visualization to add a new, blank visualization to the dossier. Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. Relate tables contain the ID columns of two or more attributes, which will define associations between them. ドシエを開きます。. 4. Select one of the following export formats: To export the report to an Adobe PDF file, select PDF. Open a new or existing dossier. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . J2EE environment:Year-To-Date Transformation Example. 1, the value range of the metric slider keeps the same when the grid selector answer is changed, as. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. This metric should be used on compound grid (rather than standard one). Note the picture with the definition. Select only Configuration Objects for documentation. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. Create a Compound Grid. To access the Advanced Sort dialog: Select a grid visualization. x-10. 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. 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. x and 10. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. 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. Click Insert Visualization . The Grouping Properties dialog box opens. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis. You can use MicroStrategy Web to create a Grid/Graph that contains objects from multiple dataset reports. This is easily done using the &hiddensections URL parameter that can be obtained from the folder browsing. Create or edit reports with authoring functionality. Insert an HTML container (and not an image) and insert the script below. 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. The Profit metric is a simple sum of the Profit fact. To prevent users from navigating out of the document, they might want to hide some sections from the page. Tasks. Select the Repeat attribute column checkbox to display the attribute. このチュートリアルでは、複合グリッドへの切り替え方法、複合グリッド内の列セットの追加方法、およびこの新しいビジュアリゼーション タイプを活用する簡単な使用例について、順を追って説明します。. Relate tables are often used to create relationships between attributes. Export server-level settings and import them for use with another server. From the Home menu, select Export, and then select one of the following export formats: PDF: Export the report to an Adobe PDF file. Assuming CP1252As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. 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. Data from the input objects defined in the Transaction Services report is displayed in the grid, text fields, or cells for users to. Click Insert Visualization . This article describes how to display username on the report grid with MicroStrategy Developer 9. In the report, the attribute with the compound key is Distribution Center. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. Grouping. communicate with mapping. 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. For example, users can have a smart compound metric and a component metric of this compound smart metric on the grid in the document. 2 - Closes all optional prompts with an empty answer. 4074 views · September 04, 2020. x, select 'Project Documentation' from the Tools menu to start the wizard. The compound join saves memory space and processing time on the Intelligence Server executing the document. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. Make two grids with different attributes and metrics in each 3. Create a Modern Grid with Microcharts A modern grid visualization allows you to include microcharts within cells. Creating a 'Compound Grid' 4100 views | September 04, 2020 02:40. 1, the value range of the metric slider keeps the same when the grid selector answer is changed, as. In the example, Year 2001 has value for Item Sold but not for Sales. 1 documents inside an iframe. MicroStrategy Geospatial Services is automatically enabled in these. 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 MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Continue with the previous Steps 2 and 3 above. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Once you add a grid visualization to a dossier, you can format it. Line: Select the style of the grid lines from the drop-down list. View data in simple grid format and leverage page-by options. Creating a 'Compound Grid' 4104 views | September 04, 2020 02:40. How to Share a Dossier. 4 and later. Step 2. The Export to Excel option will now appear. Like other visualizations, a Compound Grid can be used as the target of a selector. Enter 'Year' as the attribute and click 'Prompt' as shown below. Custom number formatting symbols. Follow the steps below. 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. This metric definition is shown below:MicroStrategy recommends using the latest Data Engine Version. 4. You can import business data from many different sources, including local files, databases, Google Drive, etc. Creating Box Plots. Non-aggregatable metrics are defined using the dimensionality section of the metric editor. ) Unfortunately I have a limitation/bug to report and ask about. This metric definition is shown below:MicroStrategy recommends using the latest Data Engine Version. 3. Click the visualization to add the group to. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Excel: This allows the user to export the document to Microsoft Excel in . Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. Notice that a joint child relationship can be one-to-many or many-to-many. Create a metric that sums the fact Units Sold. Why MicroStrategy Why MicroStrategy Why MicroStrategy. 364 subscribers. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. '. You can tag multiple users or user groups in a comment. A blog on Microstrategy development and issues faced during development, deployment and maintenance. 2. Compound Grid visualizations. The first pass calculates Sales; the second pass calculates Item Sold. You treat one attribute as a child of the other and have a compound key for the lower level attribute. Do not forget to enable Subtotal (F11). The color is displayed in Presentation Mode in MicroStrategy Web. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Query Stage: Retrieve data from the warehouse. Formula and dimensionality are the two important components in a metric. In MicroStrategy Developer 9. View the visualization's name and data requirements. 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 MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. On the Overview page, click the Comments icon. 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. Open a dossier. The partition attribute should allow for near uniform distribution of data across the partitions, so that the workload on each partition is evenly distributed. 5. Choose Grid > Compound Grid . 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. of distributed under each attribute element. The graph legend or axes can be formatted as well. When you upgrade your MicroStrategy software version, you may not want any changes in your data or in the look and feel of your application objects. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. Follow these steps to Drill on a Compound metric in Grid mode: Create a compound metric through the Metric Editor. Insert an HTML container (and not an image) and insert the script below. Open the dossier you want to modify. How to use the. For example, given a report with Revenue and Cost, the custom subtotal will return total Profit, as shown below:A compound key attribute is an attribute that has two or more IDs. KB440511: How to use a HTML image as a button that exports a grid on a document to Excel in MicroStrategy version 10. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Metrics are MicroStrategy objects that represent calculations performed on data. In the top toolbar, click Insert Visualization . In the list of categories on the left, click Subtotals. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. There's a reason we're at the top of the list. 1925 views | September 04, 2020 02:01. A grid is an essential element of data analysis. 4. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. 5. Labels: #Prompts in URL API #mstr urlapi. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. The following schema shows which setting takes precedence when set at different levels. . This design may look strange, but in most cases there are. Then it creates a third metric, a compound metric. Consider the following MicroStrategy Tutorial project. Micro Strategy also supports mobile BI. The Export to Excel option will now appear. The report-related objects placed on the template. Make two grids with different attributes and metrics in each 3. View the visualization's name and data requirements. Insert an HTML container (and not an image) and insert the script below. From the Visualizations panel, select Grid . When you upgrade your MicroStrategy software version, you may not want any changes in your data or in the look and feel of your application objects. ドシエを開きます。. Slicing means that the data for each available item in the selector is calculated in advance when the document is first displayed. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Users may want to display MicroStrategy Web 10. As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. Type the following for the name: "Total for the #P #0". Introduction to Visualizations. Excel: This allows the user to export the document to Microsoft Excel in . MicroStrategy Internal Reference number for this technical note is KB483542 and. Made up of two or more grids of any type (column, modular, symmetrical, and asymmetrical) on one page, they can occupy separate areas or overlap. For SAP BW, the following syntax may be used. Compound Statements. How the user answers the question determines what data is displayed on the report when it is returned from your data source. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. This means that every calling center has its own unique ID. Click the vertical eclipse icon (More) on the top right of the visualization. Color from the Advanced Color Picker will. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. MicroStrategy Community 4. Ø Local Transaction options. While all metrics have a formula, not all of them have. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. The following code sample will execute a report using a ReportBean, and output the column headers from the report grid. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. The graph shows revenue by category and region. A normal attribute represents a single hierarchy level (for example, Month). A compound grid requires at least one attribute and one metric. First, do "Change Visualization" on your grid and set it to "Compound Grid". Open a new or existing dossier. Microcharts are small versions of visualizations shown without. Create an empty MD shell in Microsoft Access. 4. x When a security filter is used, different users get different report results when the same report is being executed, hence there might be a need to include the name of the user who generated the report in the grid to differentiate the. 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. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. All Grid Fonts: Select font formatting options for all text. 4. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. In MicroStrategy SQL Generation Engine 9. The MicroStrategy for Office add-in enables you to use Microsoft Excel to connect to data in MicroStrategy. Save and assign a name to the file like “My_first_connection_file. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. An inner join between pass 1 and 2 is performed in pass 3. Metrics are MicroStrategy objects that represent calculations performed on data. compound attributes. A Grid/Graph can be directly associated with one dataset report. Step 2.