The boolean datatype should be seen as "Unknown"; it is not natively supported by MicroStrategy 9. It returns the base attribute that contains this form. Each of these compound metric types is described with examples below. Heterogeneous mapping allows the engine to perform joins on unlike column names. DATE and DIM_DATE. The formula of a compound metric is based on arithmetic operators and non-group functions. Modify the Address form so that it has a descending report sort order. MicroStrategy recommends to have only one child at the lowest level. 4 Basic Functions are supported by the MicroStrategy Analytical Engine: First. Generally, you build a compound attribute when your logical model reflects that a compound key relationship is present. . If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. The Metric Editor opens. Transformations allow you to apply an attribute-element based offset to compare metric data. Update:1 Answer. Incident update and uptime reporting. Attributes are the business concepts reflected in your data. I have a metric A = Avg(0. Attributes give users context for reporting on and analyzing data. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. performance and data integrity=2E. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. When naming a MicroStrategy object, you must follow the naming convention rules for your particular database platform. Temporary policy. This article notes a limitation of mapping MDX attributes to schema mapped attributes For example: Simple or Compound Metrics . The new grouped attribute appears in the Attribute Name field as. This section focuses on the VLDB properties that are set at the metric and report level. An implicit expression is required for creating such an attribute. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. In Desktop 2020 you can only use attributes in rows. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges to create derived metrics. A compound attribute is an attribute with multiple columns specified as the ID column. A metric is a compound metric if it uses a non-group function, which includes OLAP functions and scalar functions. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. Attribute_ID2= “,B1,”)”). This implies that more than one ID column is needed to uniquely identify the elements of that attribute. Unique identifiers denote the key that maps an attribute to its source data in the source system, when applicable. it is the same as the Attribute property). This article notes a limitation of mapping MDX attributes to schema mapped attributesA compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. Attribute forms are identifiers or descriptors of an attribute, such as ID, Name, and Address. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the formatting will not show correctly when viewed. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. However it. The Promotion attribute is related to a particular Item-Quarter pair, as opposed to it being related to Item and Quarter separately. A compound key attribute is an attribute that has two or more IDs. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Use "Access External Data" feature in MicroStrategy Web 10 to import data. The Transformations definition pane displays below the Metric component pane. x: Create a metric called A with expression "Min(1){~}" as shown below. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. Mapping is required only if you want to display areas on your map on a local server. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. Count Compound Attribute is an advanced property that is hidden by default. Attribute form: contains an identifier or descriptor of an attribute. To create a compound key (composite key), users must create multiple attribute forms, group them together, and set the form group as the key for the attribute. This visualization allows you to create a grid that analyzes different aspects of data. 13. Split Hierarchy with M-M relationships: Explanation. Set qualifications. During our 10+ years of work with MicroStrategy we often encountered overlapping cube and cache questions and what are the best practices in order to manage them. g. Metrics used to define the calculated metric can come from different datasets. 2, the selector will not work if using the Include option for the selector. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In both a Grid and a Compound Grid, checking multiple attribute display forms and displaying attribute form names will cause the enabling or disabling of other attribute's subtotals. The Compound Grid supports similar operations as regular grids, such as:Relationship tables in Microstrategy. When the attribute used as a selector has a compound key, i. To create a last year transformation based on an expression. A compound attribute is an attribute with multiple columns specified as the ID column. The Attribute Creation Wizard opens,. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. If you include Customer on a report with both Last Name and Address. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the exporting does not format correctly when exported to. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. e. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Passing prompt answers for an element prompt when the attribute has a compound ID. If the user defines more than one expression for a given form, heterogeneous mapping will automatically take place when tables and column names require it. NOTE: The 'Refresh' option assists in frequent updates to the interface for end user objects such as metrics, filters, prompts, etc. Create 2 datasets. It's. The only solution that I can think of is to create a FreeForm SQL Report. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. 0 if there are multiple join paths between two or more One-to-Many relationship tables in a multi-table data import cube, rather than using the first available table join path, the analytical engine will look for the path with the least number of tables and the smallest table base on the following order/criteria:Beginning in MicroStrategy 11. 2. As you type, matching objects, such as attributes. Attribute_ID2= “,B1,”)”). 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. From within a blank report in MicroStrategy Tutorial, double-click inside the Report Filter pane. Each attribute form must have at least one expression. In the list of categories on the left, click Subtotals. Document with no element attributes in the group by section. The attributes and metrics appear as filters. intermediate object}. Click the Add icon to the right of the Element list. Might need to play with formatting to make sure. This article describes how to create derived metrics to show previous row data in MicroStrategy. Click User Manager . The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. Attribute T contains an element t1. For each form listed, select or clear the corresponding checkbox in the Show on Grid column. With Architect, rather than defining parent and child. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. On the Attribute Forms editor, click the Current Attribute drop-down and select an attribute. MSTR uses lots of components like attribute, metric, facts, Logical Tables etc to build a report. Setting a join specification allows you to place conditions on the data selected for display in a report. The Results Preview dialog box opens. Foreign Key. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the exporting does not format correctly when exported to a Flash MHT file. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Add an attribute and a metric to both Column Set 1 and Column Set 2. What is compound and smart metrics?. Syntax . You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. A compound key attribute is an attribute whose primary key is made up by the combination of two or. Compound attributes are usually counted by concatenating the keys of all the attributes that form the key. Create the statistics database instance. HyperWeb surfaces cards on a web browser based on a keyword that matches the underlying criteria set by the card author. Click Create on any page, and select New Metric. Drag at least one attribute to the top of the Vertical area. Last. x? Number of Views 6. In MicroStrategy Analytics Enterprise Web 10, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI). Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Open the dossier you want to modify. 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). Double-click the Column Set name to rename the set. A compound attribute is an attribute with multiple columns specified as the ID column. WORKAROUND: Instead of using the formula editor, type in the formula expression manually and it will validate. II. b. Open attribute editor (right-click on attribute and. Create an Attribute Open the Workstation. This name change is visible in. SYMPTOM: In Visual Insight in. Set the qualification type to 'Custom'. 4. Configuration Objects:. Ambiguity in filters, metrics, security filters, facts, and attribute expressions can be avoided by. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. MicroStrategy builds the rules that MicroStrategy SQL Engine uses to generate SQL when a report request is made. If the attriubte name has spaces, use the '' symbols to group the name. member_terminal. ACTION: Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled MicroStrategy release. This feature is only implemented for element list prompts. The use of compound attributes in a non-aggregatable metric is not supported in MicroStrategy Developer 9. Mapping geo attributes. Usually this is the attribute to which the form belongs (i. x where all hyperlinks based on Applysimple no longer work when exporting to Flash, generating a MHT file. Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. . A dataset is a MicroStrategy report that is used on a document and all of the report's elements–attributes, custom groups, consolidations, and metrics. You can also access the Attribute Creation Wizard at any time in the development of a project from the Schema menu in MicroStrategy Developer. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. For example, in the MicroStrategy Tutorial project, the Time hierarchy includes relationships between the attributes Year, Quarter, Month of Year, Month, and Day. n this brief video tutorial, Stephen Goodson, a senior instructor from our Customer Education team explains what compound attributes are and demonstrates how. Enter a Form name and Description. Metrics: Component Objects. A compound attribute is an attribute that consists of more than one atomic attribute through an object join or member terminals that use dot notation. 4. 4. The types of attribute form expressions are as follows: Simple. Creating calculated expressions. Recommendation. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. 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. 78K. x doesn't have mapping between boolean type and MicroStrategy internal datatype. 0 and 2019, users will notice objects referred to as "Super Cubes". On each column set, add at least one attribute. Syntax . The compound join saves memory space and processing time on the Intelligence Server executing the document. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. 1. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. Click the Options icon . Form groups in Microstrategy - Form groups in Microstrategy courses with reference manuals and examples pdf. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. 1 and 10. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. 4. MicroStrategy interfaces include desktop (for developers), web, Microsoft Office integration as well as Mobile Applications. MicroStrategy's default technique is to write description form expressions into the SQL Max() function. The column with boolean datatype can be mapped as integer by using a. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Attribute Editor in edit mode so that you can make changes to the attribute. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. In order to have a derived metric that can source from the join of multiple datasets a simple compound metric can be. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Example:. Some formulas expect related attributes to exist on the template, and they will return incorrect results (or an error) if the attributes are omitted; other. Attribute ID form expressions will always appear in the group by clause, because this is necessary to define the aggregation level for the query. You treat one attribute as a child of the other and have a compound key for the lower level attribute. 1 and 10. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Steps to Create Smart Attributes. Under 'Source tables', select a table and click 'Set as Lookup'. While knowing your company’s total sales is useful, knowing when and where the sales took place provides the kind of analytical depth that users require on a daily basis. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. Go through this MicroStrategy Tutorial to get a clear understanding of MicroStrategy. 939 views 3 years ago. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. Each attribute form must have at least one expression. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. 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. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE(“OR (a11. Currently the DIM_DATE. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. When the attribute used as a selector has a compound key, i. There are three basic logical operators: Union behaves as the inclusive term OR does in grammar. Open a report in MicroStrategy Developer. You are returned to MicroStrategy Developer. In this article, we clarify your questions regarding Pattern Matching and how it is different from the standard Keyword Matching. This calculation can be aggregated from the Employee level to the Region level. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. J2EE environment:Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformEven though a metric qualification depends on the result of an aggregation, it still must apply before template metrics, or metrics used in compound metrics. This technote describes a current defect in MicroStrategy Distribution Services 9. CONTENTS 1. Each graph appears in a separate row, one for each element in the attribute. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. Attributes can have multiple attribute forms. This is a single-value function. In some business scenarios, it is required to apply threshold on rows without specific characters in attribute element names in a report with compound metrics in MicroStrategy Developer. Select a Form category, Display type and Default sort from the lists. 0. In both a Grid and a Compound Grid, checking multiple attribute display forms and displaying attribute form names will cause the enabling or disabling of other attribute's subtotals. In MicroStrategy Developer, from the File menu, point to New, and select Transformation. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. Transformations allow you to apply an attribute-element based offset to compare metric data. Each type is described below: . To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. Important: Parts of a compound attribute cannot be omitted. Therefore, its ID form maps to a combination of columns. If a user maps a Data Import column to an attribute that has compound ID formsIn MicroStrategy Workstation, architects can create and edit attribute objects. MicroStrategy needs to be explicitly told that there is a Many-1 relationship between Location and Airport, which can only be done by creating them as two separate attributes. 71K subscribers Subscribe 2. Click OK. Metrics: Component Objects. Dataset DS1 with attribute 'Year' and metric 'Profit'. Option A 1. To toggle smart metrics on and off, use the checkbox (Allow Smart Metric) at the bottom of the Subtotals/Aggregation tab in the Metric Editor. The formula of a compound metric is based on arithmetic operators and non-group functions. Several non-group functions that are. 4. We decided to gather them in one placing using our experience and MicroStrategy materials. Make two grids with different attributes and metrics in each 3. In the Query Detail, the Engine is guided by the metric guide and pick the correct table. An attribute-to-attribute qualification can compare the City form of both attributes to display only the Call Centers and Customer Cities that are in the same city. Create a new attribute form without the undesired source table. MicroStrategy is an enterprise BI application software. Example: Creating compound attributes. To enable totals or subtotals for a metric. For. Answer / nadia sheikh. desired view using MicroStrategy, without DBA involvement. In MicroStrategy Developer, open the folder that contains the attribute to modify. This calculation can be aggregated from the Employee level to the Region level. How to create a conditional attribute in MicroStrategy Desktop A user may want to create an attribute with an alternating expression depending on a certain condition, a. Metrics made up of metrics: Compound metrics. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. x, the Report Objects window shows the same attribute form multiple times, as shown: In the above example, the 'Store ID' form shows up twice. In MicroStrategy Developer, go to File > New > Metric. Create a. Surrogate Key. In the MicroStrategy Tutorial project, for instance, such a report could include the Year attribute, Customer Geography Ratio consolidation, the Profit and Revenue metrics, and a compound metric dividing Profit by Revenue. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. 0:50. The smart metric property of a compound metric allows the user to change the default evaluation order of the metric. To Create a Metric Using the Formula Editor. You can use derived metrics to. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Learn how to switch to a compound grid, add column sets in this new visualization. ". It uses Business Scenarios to provide examples of each concept. Only two leading objects are defined in the query language. Compound attributes are usually counted by concatenating the keys of all of the attributes that form the key. Four types of direct relationships can exist between related attributes, and these relationships are defined by the attribute elements that exist in the related attributes. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. Compound Key. The attributes Customer City and Call Center are enclosed in brackets. Compound Metrics. There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form. Quite often these attributes have automatic mapping for one ID and manual. Sometimes you don’t have all the columns that are necessary for creating your visualizations. Click the Metric Options. If the Region attribute is removed from the grid, the metric value is dynamically aggregated to the Day level. VLDB Properties. The report-related objects placed on the template. xml, contains the information used to map ESRI geo attributes to the corresponding attributes in the MicroStrategy metadata. Use the Object Browser on the left to locate the prompt to add to the metric's definition. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the formatting will not show correctly. The time required for dependency checking varies based on a customer's metadata size and schema complexity. Today, we are covering how to create derived attributes and metrics in MicroStrategy. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. One advantage of compound metrics compared to simple metrics is that compound metrics can use smart totals. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. Using a combination of filters and metric dimensionality, the same results can be achieved. Drag the Metric Names attribute to the Rows or Columns areas to display metrics on the rows or columns of the grid. The Limit dialog box opens. From there, put the elements into one group that is labeled "Inbound Costs" and make another that is labeled "Outbound Costs". In the report, the attribute with the compound key is Distribution Center. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9Consider the following scenerio: A user wants to create a metric which ranks the Regions according to Revenue at a company-wide level. In the top toolbar, click Insert Visualization . When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. To specify a transformation, double-click it in the Object Browser to add it to the Transformations definition pane. A compound attribute is an attribute that consists of more than one atomic attribute through an object join or member terminals that use dot notation. compound attributes. Workaround / Solution. x and 10. (The compound metric also enables the "Allow Smart Metric" option in the Subtotals/Aggregation tab of the metric editor. To create a compound key (composite key), users. Depending on your MicroStrategy product and licensing, this function may not be available. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. 1 - 10. Micro Strategy also supports mobile BI. xA connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Click Insert Visualization . Following examples uses MicroStrategy Tutorial project to demonstrate the problem and solution. This has been identified as a defect in MicroStrategy Web 10. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. The examples below describe how to drill on these compound metrics on both grid and graph reports. Add data to the report and leverage formatting capabilities. 4. Published: Sep 19, 2019Report will display result as below. Create Dossier and Chapter Filters. In MicroStrategy Workstation, architects can create and edit attribute objects. The formula of a compound metric is based on arithmetic operators and non-group functions. 1, users can map attributes during Data Import to existing attributes. Calculated expressions are created directly in text fields on the document, which makes them. These privileges are part of OLAP Services. A compound attribute is an attribute with multiple columns specified as the ID column. In this case, enter 'Date@ID'. In summary, when Metric Join type or Formula Join Type for a compound metric is set as Outer, a full outer join would happen between temporary tables for base metrics. Select the check box for any smart attribute that needs to be created. An attribute form is a descriptive aspect of an attribute. In this case, Promotion has a many-to-many relationship to both Item and. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. MicroStrategy Object Manager makes a list of all object dependencies before copying an object to prevent metadata inconsistency. This information can help define primary keys in the physical warehouse schema (see Uniquely identifying data in tables. microstrategy; or ask your own question. For information on training metrics and creating predictive. Separate attribute forms should be created for latitude and longitude, and should also support the numeric data of these values. This tutorial shows how to create derived attributes and metrics in a dossier. The only solution that I can think of is to create a FreeForm SQL Report. It is derived based on a count against the fact_object_component table. x and 10. The User Editor opens. 10869 views | September 04, 2020 01:10. 2. Select Joint Element List from the Option pull-down list. In the list of categories on the left, click Subtotals. On the template, the month attribute, A - NORMAL SUM, C - DATA PREVIOUS ROW (B - A) and D - % CHANGE ((A-C)/C) are. The Transformation Editor opens with the Select a Member Attribute dialog box displayed. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. On the Security Filter tab, select a project under which you want to assign a security filter to the user or group. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE(“OR (a11. This article notes a limitation of MDX data sources for filters on different levelsStarting in MicroStrategy 10. A set qualification first produces a set of attribute elements. Double-click the Column Set name to rename the set. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. 1. DATE@ID) My. 4. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. 0: Profit/Revenue. xattributes (list or None, optional): ID numbers of attributes to be included in the filter. 0-10. Create a Report Services Document 2. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. If you know of better/faster ways, please share. , Attributes, Facts, Hierarchies, partition mappings, Tables or Transformation). This implies that more than one ID column is needed to uniquely identify the elements of that attribute. For example:By adding simple dummy attributes you are able to arrange the columns in a much more tidy form without even touching the original data. Types of filters in Microstrategy Below are the types of filters: 1. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. The ApplyOLAP function is used to define compound metrics. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. Select Manual from the Aggregation and Subtotal Behavior drop-down. This is a compound metric that calculates the percentage change between the previous row and the current row. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. The targeted grid will show no value no matter the attribute and the metric in the grid is related to the group by attribute or not. 4.