You need to know the number of regions, so you create a derived metric from the Region attribute. The value prompt is designed to return report results based on the data type assigned to the data in your data source. 3. STEPS TO REPRODUCE: 1. The derived metric is created, and you can skip the remaining steps of this procedure. Optimize the performance of derived objects: Skip the evaluation of unused derived attributes and derived elements in a dossier to improve performance during execution. . e. Rename the metric in dataset object panel. 4 Hotfix 4, within the “MicroStrategy Tutorial”, create a new VI. You can easily create a derived attribute that: Changes the data type of an existing attribute. Open the dossier you want to modify. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. . Open the dossier you want to modify. x and add a derived attribute, right clicking an attribute and. x-10. x: 24. Create a new metric with the following format: Max(‘DD/MM/YYY') {~}. Create a filter (Previous Month) using attribute qualification. Create a new dossier. Below is what I tried but it did not work. View the report as a graph and notice that the. For the example scenario, right-click the Region attribute, and click Derived Elements. Also practical examples are used in this document in order to illustrate the. Create a standard report like the following: 3. To rename the attribute form, double-click its name on the tab. A dataset can come from a variety of sources, including an Excel spreadsheet imported from your computer or downloaded from an URL, a database imported by building a SQL query or picking relational tables, a MicroStrategy project, etc. The attribute must have a date type of Date, Time, or DateTime and contain a date attribute form. Create a report that uses an object prompt, such as Category or Subcategory. Open the dossier you want to modify. The ID form should be based on multiple attributes, some of which come from different hierarchies. Notice that the above expression for the ID to calculate the customer's age does so by taking the current year found by Year() and then subtracts it by the year that is extracted from the CUST_BIRTHDATE by Year(CUST_BIRTHDATE). Distinct is a TRUE / FALSE parameter that allows you to count all elements in a list or only the unique elements. 4. Save the report. Select the checkbox that corresponds with each attribute you want to generate. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. The value chosen by the user is compared to metric or attribute element values. x. 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. The attribute ID columns included in a fact table represent the level at which the facts in that. Simple Implicit Derived Heterogeneous For more information on these types of attribute forms, see the Advanced Reporting Guide. Note that if the selected attribute is on the grid, the attribute will be moved. Create a new derived metric called MovingDifference with the formula below: MovingDifference<BreakBy = {Country}, SortBy = (Year)>(Revenue,2) It is recommended to build the derived metric using function wizard (the “fx” button in new metric editor) as show below: 2. Apply conditional formatting for the dynamic text. I will first show how to build this derived attribute in sections, and in the end we will combine all the sections together. Click OK. The Metric Formula Editor opens. These are the steps to reproduce in MicroStrategy Tutorial: Create an object prompt on Quarter attribute. Define the advance sort on the derived metric and then sort on Gender DESC. In the Datasets panel, click More. Modify the attribute from which the metric is based or base it on a numeric field. 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. Before MicroStrategy 2019, users cannot specify the Derived Attribute type in the Attribute Editor. The following procedure describes how to achieve this: Create the highest level filter. Create or include a user defined under a security filter on the same attribute or a different attribute in the same hierarchy. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Symptom 02 . 97K subscribers Subscribe 1. Insert a derived metric 'M01' with expression 'Max(Region@DESC) {~+} '. To manually enter the definition of the derived attribute. The following procedure describes how to create a constant date metric (i. Facts are one of the essential elements within the business data model and basis for almost all metrics. Follow the steps below to change the column alias to data type 'date':This technical note provides an example of how to calculate the number of days between the current date and a date attribute. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year) MicroStrategy Workstation automatically creates attributes when you import data. If you are editing the Case function, use the values in step 8. 1. Select Display Attribute Forms. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. If you need to remove the geographic type later, you can select None. HTCMS (Programmer) (OP) 19 Feb 04 20:41. You have the following options: Break by None: No break by is used and the rank is calculated accounting for each separate item on a report. Use the definition below by using "RunningCount" function:. The calculation is created as a derived element and displayed on the report. x? Knowledge Base: How to concatenate two attribute forms by using derived attributes in MicroStrategy 10. This can help the end user more easily distinguish between elements when browsing or. Add, rearrange, or remove data from a visualization in a dossier. The following two business cases, which use the Today derived attribute fails when the VLDB Property “Cartesian Join Governing" is set to Cancel Execution. x SYMPTOM: Derived attributes are attributes that are based on one or more derived form expressions. Fact data and levels of aggregation. In MicroStrategy Desktop, create a Transformation schema object. Depending on your MicroStrategy product and licensing. Create the previous Month Filter. 2. 1 - 10. Select the heat map visualization. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. ACTION: To remove the derived metric subtotals, follow the steps below: In the Report editor go to Data -> Subtotals. Loading × Sorry to interruptA derived attribute works the same as any other attribute. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. 4. . x with any number of attributes. This article notes a workaround to dealing with percent to total derived metrics with custom groups. In the Functions pane, search for the If or Case functions. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. TOT_DOLLAR_SALES) WJXBFS1. Open MicroStrategy Web. 2. x. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. 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. This allows attribute element data to be displayed. Learn how to switch to a compound grid, add column sets in this new visualization. When editing the name of a derived metric (or any other such object), in a Visual Insight document, the name changes on the visualization itself, and the grid panel, but not in the "Dataset Objects" panel: STEPS TO REPRODUCE: 1. Create a report with the prompt created in the previous step. The attribute ID columns included in a fact table represent the level at which the facts in that. Another important observation is not to forget to enable "Smart Metric”. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. 2. Select the member attribute as 'Month', as shown below: The "Define a new member attribute expression" window will. The steps below use objects from the MicroStrategy Tutorial project as an example. But, it will calculate at the lowest Data level if that is your intention. Run the report and select Quarter when prompted. 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. Cleaning up unused objects is still useful for easier troubleshooting, improving performance and better organization of the dossier content down the line. This article describes a behavior observed with derived attributes and metrics, where their values show as null depending on the user language. The derived attribute has the following definition: Concat (Leftstr (Employee@FirstName,1),". To Create a Derived Attribute. a. Enter a name for the metric in the Metric Name field. Glossary. Right-click the attribute to create or modify derived elements for, and click Derived Elements. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. Attributes give users context for reporting on and analyzing data. 2. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. Matching objects appear in a drop-down as you type. )To display more attribute forms on report template, login MicroStrategy Web with Web Analyst privilege "Web choose attribute form display", right click the attribute on report, click Attribute Forms -> More. Shared attributes are outer joined while relationships control other related attributes. Right-click the attribute to unlink and select Unmap. SUBCAT_ID SUBCAT_ID,Step 4) Click on data foundation node. Double-click the Grid/Graph to edit it. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 1, and it is currently being evaluated for a potential fix in a future version. 6. The count function parameters used in the metric should be changed to Distinct Count and a suitable FactID should be selected in order to use the correct fact to calculate the customers. Create a new metric with the following format: Max(‘DD/MM/YYY') {~}. 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. The location of each property in the CREATE TABLE statement is given below. Go to Smart Attribute blade on the Attributes Editor. This change is being made as the property is to help move the product towards future deprecation of this setting. The document grid that has the Category, Subcategory(only ID form) , Revenue, and the. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. 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. 2. Introduction to Attributes, Metrics, and Groups. Drag and drop the objects into the report grid. Revenue + Profit. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. Click the magnifier icon on the top right page: In the pop out search window, choose "Refine": In Object Type drop down, select "Metric", this will include metrics in search result: In Search result, click the folder path: The hidden folder contain the metric will be shown in list view, and right click metrics will show Edit option in context menu: KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. Sometimes you don’t have all the columns that are necessary for creating your visualizations. To quickly create a derived metric based on an attribute, right-click the attribute, point to Insert Metric, and select the function. Add the derived attribute into filter. Facts help to link indirectly related attributes. Action Enable Data Blend VLDB property through Analytical Engine>Document Grids from Multiple Datasets as shown below:Synopsis: Figure 1 describes different scenarios that are described later in greater detail. Create derived elements for the Region attribute; Create a New Dossier using the base report as a dataset. Attributes appear with an attribute icon on the Datasets and Editor panels. In the New Metric Editor, manually add the metric definition using this expression: max (<attribute>@<form>) {~} The new metric below will display the DESC column of the Country attribute and was created using the metric. Tutorial project is used here. This Community article gives instructions on how to force the MicroStrategy SQL Engine to ignore a report filter during the metric calculation when the attributes in the report filter and the metric condition. Double-click the Grid/Graph to edit it. Go to the MicroStrategy Web and create a new dossier using this cube 7. In MicroStrategy Web 10. The condition is based on either an attribute or metric. Both filters and custom groups use qualifications, which are the actual conditions that must be met for data to be included. These groups provide a new view of report data for analysis and formatting purposes. Input the metric formula. You need to know the number of regions, so you create a derived metric from the Region attribute. Create a derived attribute "Time" in the first dataset using "Case" function with the following formula. 3. microstrategy. You can use this method in MicroStrategy Developer and Web. All attribute element data is added together to form the metric values for the new group. For a more detailed description, see About the report level of a metric. Create attribute 'Date' with three forms: ID, DESC, NONE and their data type are numeric, text and date-time accordingly. Browsers automatically handle cookies, but if you are using your own client, you need to. To manually enter the definition of the derived attribute. The metric, 'Prompt answer' will display the prompt answer on the report, as shown below: NOTE: If the metric 'Prompt answer' returns as blank, remove and re-add the metric, 'Prompt answer' onto the report in design mode. 4. Open MicroStrategy Web. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. 4. 24. Qualify on 'ID'. For example, add Electronics to Group 1. To access the Derived Elements Editor for a Grid/Graph in a Report Services document, expand the document section that contains the Grid/Graph. Add "Products" user hierarchy to the metric level and set the grouping option to "None", as shown below: Create a new report, add item attribute in the row and the metric in step 1 in the column, as shown below:Unlike Value prompts with type of Numeric, in a Text prompt, it is not possible to drag and drop to the Metric Definition pane. We use MicroStrategy Tutorial objects to reproduce this issue. Create a Base Report in MicroStrategy Tutorial project. Page percent-to-totals affect all attributes on a page. 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, log in to a project. The complicated DA will have both an ID form and a description form. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. 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. Sometimes you don’t have all the columns that are necessary for creating your visualizations. Trending Articles. Insert a derived metric 'M01' with expression 'Max(Region@DESC) {~+} '. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. g. com Format: A MicroStrategy Online Training Video blog. If all conditions are false, a default value is returned. If a dialog appears, click OK Hover over a function in the Functions panel and click Edit. 4. To replace an object (i. They relate numeric data values from the data warehouse to the MicroStrategy reporting environment. The following steps describes how to create such derived metric. Right-click the attribute to create or modify derived elements for, and click Derived Elements. Supporting data internationalization for attribute elements. Open the dossier you want to modify. When the same expression “Week(CurrentDate()-x)” is used into definition of attribute and derived metric, for some particular date, the values are different. Run the document. A fact has two common characteristics: it is numeric and aggregable. com Format: A MicroStrategy Online Training Video blog. Enter the definition of the derived attribute directly into the right pane. 2. Create new Report, Document or Dashboard with some Attributes and Metrics. MicroStrategy will. In this example, we convert years to decades. Create a dossier and add DS1 and DS2 as datasets. Click the name of the dashboard to run it. Key in 'Category' between braces after the formula, as shown in the screenshot below. Double-click the Grid/Graph to edit it. Create a Base Report in MicroStrategy Tutorial project. Place the new metric in the desired location, as shown in the screen shot below:MicroStrategy Developer 9. Select the check box for any smart attribute that needs to be created. Click on the "Validate" button to validate the formula. Matching objects appear in a drop-down as you type. STEPS TO REPRODUCE: 1. This tutorial will guide MSTR users to share dossiers through Web and Library. 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. To create a Group derived element. In the Datasets panel, right-click the metric to use to create a derived metric and choose Create Metric. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. Derived attribute: an attribute that is created using other attributes; when the component attribute is also a derived attribute, it is called a nested derive attribute. Define Attribute Forms “Day@ID+1”. Source: MicroStrategy. Click on 'New' to create a new subtotal. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. ' Create a report with Region, Profit in the template. 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. Navigate to the desired attribute. 3. Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. To locate a function, enter its name in Search . Enter a description of your derived metric in the Description field. 0. For the Time hierarchy, the offset can. . Learn how to create and use a derived attribute with MicroStrategy Workstation 2019, MicroStrategy’s powerful tool that lets you administer and control. Additionally, this can slow performance due to the nature of cross joins. x In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. Attribute forms contain additional descriptive information about a given attribute. x 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 value in MicroStrategy Developer 9. Visit the data visualization and data dashboard galleries for inspiration. Enter the definition of the derived attribute directly into the right pane. 11K. This feature supports more Big Data scenarios where moving large amounts of data to memory is not practical. Add the derived metric to the report and hide it by setting the column width to 0. In the Datasets panel, right-click the metric to use to create a derived metric and choose Create Metric. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Link the attribute Category Id from DS1 to Category Id in DS2. Select the Attribute Forms option. If you are editing the If function, use the values in step 7. DESCRIPTION: Starting MicroStrategy 10. Step 1. Create a new derived attribute by right mouse clicking an object in the dashboard and selecting the option to Create Attribute In the derived attribute editor,. Make sure the Report has Month, Region, and Revenue. You need the Create Derived Metrics (Developer) and/or the Web Create Derived Metrics and Derived Attributes (Web) privileges. Create derived metric M01 in C01 with level set as attribute Call Ctr Id in C02. Select the attribute form to be displayed with a link. Select a data type from the drop-down. Assign the Client-Reporter > Web create Derived Metrics and Derived Attributes privilege to the user. MicroStrategy Web automatically creates attributes when you import data. MicroStrategy REST. Select a main attribute form for the title and choose other forms for subtitles. Create a new derived metric in a VI Dashboard with the formula below: Sum(IF((Year@ID=2014),Cost,0)){} 2. In the Format Definition section, click on Cell Formatting. Select the Grid visualization as its. Type a name for the metric in the Metric Name field. Click OK. Phoenixier. Choose All in Check boxes style of filter. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. Custom Banding: This will provide some functionality, but will not allow you to dynamically change the banding style based on the attribute element. Create a Filter object and save it in an accessible location. The Insert Function dialog box opens. 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. it looks like MicroStrategy doesn't support it, please advise. Drag it back to all. Choose New List to created a single derived element that is a combination of only attribute elements. If you want to create a subtraction or division including more than two attribute elements, you must use the Derived Elements Editor. 2. A workaround is available in the current document. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges. 11 a change is being made to the default value of the use lookup for attributes function parameter when making metrics. You can create a Year derived attribute from a Date attribute in MMDDYYYY format. FactID is a parameter that forces a calculation to take place on a fact table that. Check one of the available forms for the attribute. 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. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so on. Create a report with the following attributes and metrics: Attributes: Brand; Metrics: 'Revenue' , 'Rank Revenue', 'Max of 1' and 'Rank times Max of 1' Change the Metric join type of the Revenue metric to Outer join in the Report Data Options, as shown below:Create attribute or metric visualization selectors. If the attribute is modeled as an attribute form instead, it is possible to aggregate only at the level of the attribute containing the form. The end results still reflect null values and does not display "0" for empty rows as shown aboveIn MicroStrategy Developer, the user could see Insert-> Transformations on a report for a metric, however, it’s not able to see it on MicroStrategy Web for the same metric inside the same report. Count<Distinct, FactID, UseLookupForAttributes, Null> (Argument) Argument is an attribute, fact, or metric representing a list of values. Click an object to add it to the definition. Click Add New Element. PDF. If you include Customer on a report with both Last Name and Address. Select the checkbox that corresponds with each attribute you want to generate. Add a dataset to a VI that contains a metric that is a string (“Metric Number” in this. I want to create a new Metric, using MicroStrategy Metric Editor, to check two conditions: 1 is progress_days > complete_date 2 is Status column is = In Progress. For example, if a report contains revenue by year and month, the numbers are calculated to reflect monthly sales data. Create an Intelligent Cube with the following tables and relationships: Create a new dossier. Open the dossier you want to modify. 2. From the Data menu, select Insert New Metric. Related TopicsUnable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. Create two count distinct derived metrics and places them on the report template. STEPS TO IMPLEMENT. . In this example, we convert years to decades. Open the Workstation window. 1 derived Metric shows NULL values when the Metric definition contains a reference to an Attribute form which is not shown on the corresponding grid on a report services document. The steps to create such an attribute: Make a dataset consisting of the necessary objects. In this Data in the Wild episode, you'll learn how to create derived metrics and attributes in MicroStrategy. Choose Operator as 'Exactly'. When you import data into MicroStrategy Web, the corresponding dataset is stored with the dossier. For example, if attribute Region is 'Central' then derived metric value should be 'Profit + Cost'. Login MicroStrategy Web, create Subset Report SubR01 based on Intelligent Cube C01; Create Derived Smart Metric DM with expression: Sum (Cost) {~ +} Add into template: Attribute Quarter, Region and Metric DM; Create Subset Report SubR02 based on Intelligent Cube C02, add into template: Attribute Country, Year, Quarter and Metric. Now, perform the following steps to create the actual transformation: Go to File Menu > New > Transformation, as illustrated below: The new transformation window will open, followed by the "Select a member attribute" window. The derived attribute can be a string, number, or date. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. In the Attribute Editor, create a new form expression. Expand the document section that contains the Grid/Graph. In MicroStrategy Tutorial, construct a level metric with a definition like Function(Fact) {~+, [Attribute]%} which includes the report level and an attribute with filtering set to ignore. Symptom MicroStrategy 10. MicroStrategy Web automatically creates attributes when you import data. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. To create a new Group derived element, from the New drop-down list, select Group. Tutorial project is used here. Tutorial project is used here. :. x using an Oracle warehouse. 3. Create a derived attribute based on existing objects; Combine data from multiple attribute values into a single item. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. You can import business data from many different sources, including local files, databases, Google Drive, etc. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. ). Right-click the attribute to create or modify derived elements for, and click Derived Elements. To create a new Filter derived element, from the File drop-down list, point to Newand then select Filter. This new metric should have the Level (dimensionality) by Category attribute, as shown below. 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. Add the new derived element Category Desc(Group) to the filter panel. 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. To edit an attribute form, click the tab of the attribute form to switch to it, then define the attribute form as described above. There are two work arounds available to create similar functionality. Select "Element/Value Filter". Open the dossier you want to modify. Click Switch to Function Editor. Create a derived metric in the report whose definition is Max(@DESC){~} 3. 1 or MicroStrategy Web 9. Drag table “PRODUCT” and “PRODUCT_DESC” from TABLE node under DHK_SCHEMA. The new form should immediately be included in the attribute's column. Open MicroStrategy Developer. You can add multiple datasets. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. The Metric Editor opens. Open the dossier you want to modify. In MicroStrategy Developer, configure the null display option in Report Data options setting of the report. The user is able to see the. To edit the desired attribute so it sorts in the report, view filter, and report filter, follow the steps below. Exclude the filter. If M1 does not equal any of the values in the list, then it returns a default value. This video shows you how to add a MicroStrategy dossier to your MicroStrategy Library by using both the Add to Library and Share options. The Duplicate as Metric. We use MicroStrategy Tutorial objects to reproduce this issue. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. 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. x by modifying the object's properties, as shown below: However, when creating a derived metric, no Description field exists, as shown below:. Right-click a derived metric and choose Edit. Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. When creating reports in MicroStrategy Web 9. x. STEPS TO REPRODUCE: Create an object prompt, using the pre-defined list of objects and adding the following attributes. Click Advanced.