Run the report. from ITEM_MNTH_SLS a11. Insert attribute element selector which uses derived element Category as source and targets on the panel stack as shown below:In Microstrategy I am trying to create a new fact that returns a specific name depending on the type of text contained in the field NAME. The location of each property in the CREATE TABLE statement is given below. 10, when the "Defect fixes may impact Data, SQL, MDX, CSI" is turned to "On" under Web preferences > Project Default, thresholds for derived metric cannot be properly applied if the condition is based on a cube base attribute. Description: How to create MicroStrategy OLAP Derived Elements and util. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. Fact tables are used to store fact data. 2. Make your changes, save the metric, and then save and re-execute the report to see the changes in the metric. In the Attribute Editor window, give your new attribute a name. STEPS TO REPRODUCE: 1. The Create New Attribute Form dialog box now appears. x. Create a derived attribute DA2: With the Data Engine version set to 11 in MicroStrategy 2019, you may notice that metrics defined by attributes (e. On the same right mouse click context menu under the attribute header, users will see an. Derived elements are grouping of attribute elements on a report that are created on the fly. x-10. When you run this report, null values are displayed for the metric because the metric's. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so on. 4. To access the Derived Elements Editor for a Grid/Graph in a Report Services document, expand the document section that contains the Grid/Graph. A dossier is an interactive display that you can create to showcase and explore business data. Published: Feb 4, 2020; Last. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Click New Data > Databases. The nested derived metric shows missing data (null value) Glossary. This behavior has been logged as a Defect by MicroStrategy Technical Support for version 10. Show more 104 views 3:23With MicroStrategy 10, you can create document-level derived attributes with the click of a button, with no IT involvement. From the Tools menu, make sure that View Filter section is enabled. They are able to achieve this in the grid report,. The derived metric's value is 12. Before MicroStrategy 2019, users cannot specify the Derived Attribute type in the Attribute Editor. 2. ‘year’ cannot be linked to ‘month’ because they have parent-child relation) The object to be linked should not be a Consolidation, Custom Group, New Derived Element, or DESC form of old Derived Element; Data types of linked form should be compatible. Matching objects appear in a drop-down as you type. x and 10. For example, the report below contains Region, Category, and Profit. Open up the same document in MicroStrategy Web 10. Click an object to add it to the definition. In this example, we convert years to decades. 2. There are two work arounds available to create similar functionality. Right click on the attribute, and click edit. Go to the report design view, and insert a new metric (a derived metric). In the Derived Elements Editor, select a derived element. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. x. When creating reports in MicroStrategy Web 9. In this video, I show how to create a derived attribute in MicroStrategy. Select a main attribute form for the title and choose other forms for subtitles. Enter the definition of the derived attribute directly into the right pane. The following procedure describes how to create a constant date metric (i. After you have created attributes for your project, you can define attribute relationships to determine how the engine generates SQL, how tables and columns are joined and used, and which tables are related to other tables. 17K KB16868: How to use an attribute with more than one word in the name in an apply statement in MicroStrategy Developer 10. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. In the metric editor, go to Tools > Formatting > Values and change the number format to “Date”. Create another derived attribute with following expression: 5. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Matching objects appear in a drop-down as you type. This article describes how to create a metric with an attribute as a filter using a Case statement in a Visual Insight dashboard in MicroStrategy Web. The syntax for the CaseV. Enter the definition of the derived attribute directly into the right pane. When searching for the dependants of 'Copy of profit', the document just created will appear, as shown below:If added attributes from multiple datasets into template, two dashes '--' display on the derived metric total after doing custom sort on attribute. x. x. Customizing a CREATE TABLE statement is only possible for a permanent table. The following steps are based on the MicroStrategy Tutorial project Using the out-of-the-box VI Dashboard Casino Analysis, create a new derived attribute called “New attribute 1” with the formula of “Lower ([Slot Location]@ID) ” as shown below: It is noticed there is no option to define a translation for it as shown below:In MicroStrategy Desktop, double-click on the attribute to be modified. For example, if a report contains revenue by year and month, the numbers are calculated to reflect monthly sales data. The. Open the dossier you want to modify. If M1 equals V1, then a specified value can be returned. Open the Input Metric Formula dialog box to create a new metric by performing one of the following steps: In Developer: Choose Insert > New Metric. Enter a Form name and Description. A blank page displays and the dynamic text does not show in the document. Create a Filter object and save it in an accessible location. Steps to reproduce This case is built with the Microstrategy Tutorial project and using the latest version of the Microstrategy Web. Related articles from the Community: Knowledge Base: Is it possible to pass filter panel values from one chapter to another using Microstrategy Dossier version 10. Visit the data visualization and data dashboard galleries for inspiration. Create a metric based on the freight fact which is extended to Item attribute with fact extension. Select File, point to New, and then Derived Element. x. If M1 equals V1, then a specified value can be returned. The following is a procedure that will modify the default setting to create Outer Joins for metrics at the Project level: Procedure: Right-click on the Project name and select Project Configuration. A workaround is available in the current document. MicroStrategy AI is here. You create derived metrics based on objects already present in the report. in pop-up menu, as shown below: NOTE: Refer to the following technical note for more details of attribute form display. 4. In the Datasets panel, click More next to. To manually enter the definition of the derived attribute. Create a derived attribute based on existing objects; Combine data from multiple attribute values into a single item. Create the following objects in the MicroStrategy Tutorial project: Prompts: Enter Month ID: Value prompt of type numeric, default value: 200601. HTCMS (Programmer) (OP) 19 Feb 04 20:41. Tutorial project is used here. To do this: a. We use MicroStrategy Tutorial objects in the following steps. Click New Threshold. Create attribute 'Date' with three forms: ID, DESC, NONE and their data type are numeric, text and date-time accordingly. This new metric should have the Level (dimensionality) by Category attribute, as shown below. Finally, just create the report with the attribute (Category) and the third. 2. Make sure the Category attribute has the Image form as a Display form. You can create a derived attribute by changing an existing attribute's data type. Go to the MicroStrategy Web and create a new dossier using this cube 7. Linked attributes appear with a Link icon in the top pane of the Preview dialog. Create a derived attribute DA2: Choose project attribute “Day” and project metric “Revenue”. The following steps describes how to create such derived metric. Calculation should be done only on metrics based from a numeric source. See below for the definition of the metric: The image below describes the difference between normal metric and round-down metric. x-10. Follow below steps to reproduce the issue: Create a web user without privilege of Web modify the list of report objects ; This user can create Derive metric within a report but he could not delete it. x does not provide ability to add row numbers in grid reports. MONTH_DATE) MONTH_DATE, sum (a11. The Input Metric Formula dialog box opens. In a document in MicroStrategy Web, create a new derived attribute. Drag table “PRODUCT” and “PRODUCT_DESC” from TABLE node under DHK_SCHEMA. Attributes appear with an attribute icon on the Datasets and Editor panels. Datasets contain the data that appears on a dossier. customize analyses and attribute groups Prompting users Stand-alone and derived metrics Sharing reports Improving performance with and dossiers Developing enterprise metrics Customizing data by grouping attributes Creating attributes on dossiers Filtering dossiers Getting started with MicroStrategy SDKs Leveraging the REST API forBy default, when an attribute is added to the 'Grouping' section of a Report Services document containing a grid in the document body, the display of a Grand Total will not be shown for the metric over the entire document. This will be hitting a very large table & will return a lot of rows, so an efficient method is preferable if there are options. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. x In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. Right-click the attribute to create or modify derived elements for, and click Derived Elements. Number of Views 222. The value prompt is designed to return report results based on the data type assigned to the data in your data source. Click New Threshold. In Web: Choose Data > Insert New Metric. Create derived elements for the Region attribute; Create a New Dossier using the base report as a dataset. If the attriubte name has spaces, use the '' symbols to group the name. Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. You can easily create a derived attribute that: Changes the data type of an existing attribute. Enter a name for the metric in the Metric Name field. Filters can only be created out of schema attributes (in this case: Employee). Exclude the filter. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges. Save and close the metric and add it to the report, it should contain the same values as the attribute as shown below: Create a new metric that calculates the max date at. A Calculation derived element uses operators and functions to combine attribute elements and derived elements into calculations that define a single derived element. Create a derived attribute and reserve it for future use in a visualization. Select the checkbox that corresponds with each attribute you want to generate. Select one of the following Element behavior options: Consolidate items into one element. The new form should immediately be included in the attribute's column. Create a new report 'Dataset' with Attribute 'Category' in row. When selecting some geographic types, such as zip codes, checkboxes appear for new attributes you can create (for example, County, State, Zip, etc. KB34980: Removing an attribute or a metric from a grid in a Report Services Document preserves runtime information in MicroStrategy 9. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. Select a data type from the drop-down. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. This feature supports big data scenarios where moving large amounts of data to memory is not practical. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. This Knowledge Base article describes how to create a derived metric that can use the whole dataset of the report, rather than the default functionality of using the grid dataset using the Lag function as an example. Article Reference Number: KB39231. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below:In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. Select the checkbox that corresponds with each attribute you want to generate. Create a new document with the sample file, "Airline Sample Data," in MicroStrategy Web. The following procedure describes how to create a constant date metric (i. Case. Create or include a user defined under a security filter on the same attribute or a different attribute in the same hierarchy. As you can see the Live Connected workflow takes 8 steps while the In-Memory Intelligent Cube takes 4 steps, clearly the In-Memory workflow is faster. Sometimes you don’t have all the columns that are necessary for creating your visualizations. Derived Attribute; CSI; Steps to Reproduce. 5. e. x: 24. Create a new metric with the following format: Max(‘DD/MM/YYY') {~}. x, derived attribute returns only filtered row from one of the blended dataset, or in some cases returns NULL rows when it's defined with two linked attributes which exists in multiple datasets in the dossier/VI dashboard with different filtering conditions. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. From MicroStrategy Education, this lesson teaches you how to. 1 and wants to use derived elements to display to display the attribute elements in a specific order. Check the checkbox 'Apply background color as a graph threshold,' as seen below: Click OK. The calculation is created as a derived element and displayed on the report. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. For the example scenario, right-click the Region attribute, and click Derived Elements. Max (1) The metric definition is shown in the image below: Create a second metric with an apply simple statement and using the dummy metric on its definition, as shown below. Users may want to create a report with a metric that has the current date of execution as a column on a report in MicroStrategy Developer 9. Learn how to switch to a compound grid, add column sets in this new visualization. 4. Open MicroStrategy Web with an English user account. 2. Create an Intelligent Cube with the following tables and relationships: Create a new dossier. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type. Open MicroStrategy Developer. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. The derived metric is now set to the level of Category: Published: Apr 4, 2017. In the Format Definition section, click on Cell Formatting. Both filters and custom groups use qualifications, which are the actual conditions that must be met for data to be included. Run the report and select Quarter when prompted. Define the advance sort on the derived. MicroStrategy Web automatically creates attributes when you import data. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type. In MicroStrategy, how to create a report that will dynamically show the distinct count of an attribute at different levels. KB6458: How to create an outer join between two different attributes in MicroStrategy Developer? Number of Views 13. To manually. To do this, follow the steps below: Apply a numeric column alias to the attribute form, as shown below: Change the table column being used to a numeric one for the attribute form. Create a derived metric with definition: Sum([Tot Cost]){~+, [Month Id]%} and choose Aggregate from Base in the metric option. You can create a Year derived attribute from a Date attribute in MMDDYYYY format. 4. Create a new derived attribute by. Glossary. Put the attributes Business line, Category in the grid along with the metric sales. On the Background tab in the Format Cells editor and select 'Solid' as background style and choose black as the color for the 'Fill' drop-down. e. Open MicroStrategy Web. To edit the desired attribute so it sorts in the report, view filter, and report filter, follow the steps below. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. Note that for the first row, the data from the previous row is 0 since the analysis is limited to the data retrieved by the report. A derived fact has its value determined by an expression that contains more than just a column in a table. To manually enter the definition of the derived attribute. e. Create a new derived metric in a VI Dashboard with the formula below: Sum(IF((Year@ID=2014),Cost,0)){} 2. In SQL View look at where the cross join appears, and between which tables the cross join appears. For example, August 4th, 2014, the attribute will show value “31”, while, in derived metric, the value is “32”, as shown below:KB325774: How to concatenate two attribute forms by using derived attributes in MicroStrategy 10. e. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Create a new bar chart. When Distinct is set to True, the Count function counts only distinct values. In MicroStrategy Web, create a dossier with C01 and C02 as the datasets. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Below is what I tried but it did not work. The empty derived attribute is created of project schema object; Glossary Derived Attribute Steps to Reproduce The following example uses MicroStrategy Tutorial Project. the 'Country' attribute and a metric, e. Choose 'Month' as the attribute. Check other tables and select/deselect correct tables. Click the Metric Options. When FactID is set to something other than (Nothing), the count. Fill out the required fields in the dialog and click Add. Open MicroStrategy Web. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below: In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. x. To create a MicroStrategy Derived Attribute, click the option button (ellipsis. Click an object to add it to the definition. x with any number of attributes. 2. Click on the attribute. Open a report in MicroStrategy Developer. 06K. Enter a name for the metric in the Metric Name field. When a derived attribute is built off of data from a single live data import cube, then the calculation of the derived attribute will be pushed down into the query against the data. There's a reason we're at the top of the list. After running a report with an object prompt, selecting an attribute and then creating a derived element based on said attribute, the next time the report is run, the derived element will not show in MicroStrategy Web. This attribute is referred to as a derived attribute. Add Country Id, Year Id, and the derived metric to the grid, define visualization filter on Month and set the attribute Join Type to be Outer Join - Ignore Filter 5. Create a filter (Previous Month) using attribute qualification. To rename the attribute form, double-click its name on the tab. Select the Attribute Forms option. Facts are one of the essential elements within the business data model and basis for almost all metrics. Select the object (s) from the Available objects list and click > to move them to the Selected objects list. A nested derived attribute is an attribute made from another derived attribute. This Knowledge Base article describes how to create a derived metric that can use the whole dataset of the report, rather than the default functionality of using the grid dataset using the Lag function as an example. 10869. ApplySimple. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. The derived metric aggregates at the level of the attributes on the visualization by default. Revenue + Profit. x. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web. These groups provide a new view of report data for analysis and formatting purposes. The ID form should be based on multiple attributes, some of which come from different hierarchies. The Select Attribute window opens. The derived attribute can be a string, number, or date. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Enter a description of your derived metric in the Description field. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. This tech note describes what each of these count parameters controls. The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. Click OK. The ApplySimple function is used with simple operators and functions. ", Employee@LastName) To Create a Derived Attribute Open the dossier you want to modify. To rename the attribute form, double-click its name on the tab. Click Advanced, then New to create a custom subtotal. ApplySimple (" 'Text goes. Step 1. These are the steps to reproduce the issue in MicroStrategy Tutorial: Max(){Category} -1 . 4. 4. Set the qualification type to 'Custom'. For example, in a report with Region and Category attributes and a Profit metric, you can combine the regions on the report into various groups for profit analysis, as shown below. Tutorial project is used here. KB483614: Derived metric returns null value if it contains another derived metric which has a derived attribute with curre… Number of Views 1. Clear the Filter setting: uncheck to exclude attributes absent in report or level (dimensionality) check box. com . Press and hold the Ctrl key to select multiple attributes or metrics. com Format: A MicroStrategy Online Training Video blog. Create a second metric, "Zero" as SUM(0), as shown below: 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 the report. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so on. Attributes appear with an attribute icon on the Datasets and Editor panels. x SYMPTOM: Derived attributes are attributes that are based on one or more derived form expressions. Run the report and select both attributes in the object prompt. Click OK. x and add a derived attribute, right clicking an attribute and. To create a Group derived element. Create a report named Year Revenue Report with Year attribute on the row and Revenue, Last Year's Revenue & Percentage Change in Revenue metrics on the column and run it as shown below: Notice that the percentage sign (%) is displayed with the values under the Percentage Change in Revenue metric. You can create a derived attribute based on Employee, using the Concatenation function to combine the first letter of the first name and the last name. For all other valid Intermediate Table Type VLDB settings, the SQL does not reflect the values set for these properties. All attribute element data is added together to form the metric values for the new group. For general instructions to create a derived metric, see Creating derived metrics. Expand the document section that contains the Grid/Graph. If M1 does not equal any of the values in the list, then it returns a default value. use the function "Remove Duplicate Rows". x users can hover over certain objects in the object browser for a description. The Derived Elements Editor opens. Right-click the attribute to create or modify derived elements for, and click Derived Elements. This tutorial shows how to create derived attributes and metrics in a dossier. Since attributes provide context for fact values, both fact columns and attribute ID columns are included in fact tables. Create a new Custom Group with the attribute Call Center as shown below:I'm newbie on Microstrategy. To be more specific the product creates a metric dataset for the join between datasets and then outer joins that to the. In MicroStrategy Web, create a Data Import Cube as following: 3. 45 -> 24. Enter the definition of the derived. For example, if sales data is stored in the data warehouse at the day level, a month attribute allows users to. The syntax for the CaseV. In MicroStrategy Developer, configure the null display option in Report Data options setting of the report. Create a derived attribute DA2:Choose project attribute “Day” and project metric “Revenue”. Click on 'New' to create a new subtotal. Select the attribute you want to use to create your derived element. Result for new metric is blank. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. This article notes a workaround to dealing with percent to total derived metrics with custom groups. You can get to exactly the same result using "regular" MicroStrategy Objects _and_ this is a lot easier to tune (and sometimes, the MicroStrategy SQL engine will do. To create an attribute form with a derived expression using Architect. The complicated DA will have both an ID form and a description form. Right-click and select New > Attribute. Attribute element display locking can be performed at the attribute level and hierarchy level in MicroStrategy Developer 10. An attribute may have attribute elements with descriptions that are identical but the ID forms are unique. To locate a function, enter its name in Search . Insert one panel stack and add dynamic text with Profit Margin. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. To add multiple attribute forms, create a multi-form attribute within the dataset and drag it to the header of the HyperIntelligence card. Create a standard report like the following: 3. Resources; Log In; Join; ×. Create a dossier using the above report and create following derived metrics:In the popup dialog box, enter the formula: Count(attribute){} Make sure “Apply selections as a filter” is enabled for the selector. Create a derived attribute and reserve it for future use in a visualization. This article describes a situation where using a derived attribute based on an existing metric as a filter on a Visual Insight dashboard causes the Intelligence Server to crash. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. The attribute ID columns included in a fact table represent the level at which the facts in that. I've an Excel file for dataset input. 5. using the 'Country' attribute, as shown below: Update the schema. If a dialog appears, click OK Hover over a function in the Functions panel and click Edit. Before MicroStrategy 2019, users cannot specify the Derived Attribute type in the Attribute Editor. Click on the "Validate" button to validate the formula. Attribute level locking constrains the element display in system hierarchy, as shown below:. Click Advanced. The syntax of the ApplySimple expression is as follows: ApplySimple ("expression using #0",ATTRIBUTE_NAME)Open a metric editor and create the metric with the following structure: AggregationFunction(case((attribute@AttributeForm="attribute element"), ReturnValue, DefaultValue)) {dimensionality} Users should be sure to specify the attribute form of the attribute that should be used in the calculation. You can also browse for a function by selecting a function category. To create a new attribute: In Configuration, click Attributes. Transformations allow you to apply an attribute-element based offset to compare metric data. To create a Group derived element. Create additional visualizations to display the data in multiple ways. You can create a Year derived attribute from a Date attribute in MMDDYYYY format. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Optimize the performance of derived objects: Skip the evaluation of unused derived attributes and derived elements in a dossier to improve performance during execution. Select the forms you want to see in the card header. To Create a Derived Attribute. Add new data -> Clipboard and create a "Time Filter" table by typing in: 8. Open MicroStrategy Web. MicroStrategy platform capabilities exposed in a RESTful web service. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). Derived Attributes Steps to Reproduce 1. In this video, I show how to create a derived attribute in MicroStrategy. Define the advance sort on the derived metric and then sort on Gender DESC. Browse to and select a previously saved Intelligent Cube on which to build your report. Create a report that uses an object prompt, such as Category or Subcategory. Open MicroStrategy Developer. Custom Banding: This will provide some functionality, but will not allow you to dynamically change the banding style based on the attribute element. To include database table for creating attribute view, click on data foundation node and follow the instruction step by step as below –. 0:50. Input the metric formula. Click on the Subtotal drop down list for the. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;The following scenario describes how to create a distinct count subtotal from base report: 1 Create a report A with only “year” in row and ”category” in column; add customer in report object window only. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. These privileges are part of OLAP Services. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Schema objects are building block objects; they are. Create a derived metric in the report whose definition is Max(@DESC){~} 3. . Create a derived attribute and reserve it for future use in a visualization. x. Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. Create Derived Attributes and Derived Metrics in the first dataset as below: Derived Attribute Today: CurrentDate Derived Attribute Week: Week ([Today@ID])The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. In the Based On list, select the object to base the threshold on. They are metrics that are saved and displayed only on the specific report on which they are created. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. 2 is due to a known issue. 3. In some business scenarios, it is required to use derived metrics to concatenate two attribute forms of the report. under the "Insert" menu. addTransformationMetric (WebTransformationMetric) WebReportManipulation. You can import business data from many different sources, including local files, databases, Google Drive, etc.