g. The location of each property in the CREATE TABLE statement is given below. You can import business data from many different sources, including local files, databases, Google Drive, etc. MicroStrategy RESTOAS3. The following steps can be used to concatenate two attribute forms. orYou can create an attribute based on an existing object. Create a Filter object and save it in an accessible location. You can use the Derived Elements Editor to create and save the derived element as a stand-alone derived element. The Metric Editor opens. To rename the attribute form, double-click its name on the tab. 3. KB6458: How to create an outer join between two different attributes in MicroStrategy Developer? Number of Views 13. Create a New Dossier. You link directly related attributes to each other by defining parent-child relationships. Select the Logical View Tab of both tables to see all the logical objects mapped to the table. Create a derived attribute DA2: Choose project attribute “Day” and project metric “Revenue”. Once an attribute has been selected, the button is replaced by the. 11 a change is being made to the default value of the use lookup for attributes function parameter when making metrics. In the Operator list, select a comparison operator (Greater Than, Less Than. By default, a metric is calculated at the report level, meaning that the lowest attributes on the report dictate how the metric is aggregated. Define Attribute Forms “Day@ID+1”. Create a new dossier and click “Existing Objects”. The 2 attributes should not come from the same hierarchy (e. 8K views 1 year ago Data in the Wild Short Videos In this Data in the Wild episode, you'll learn how to create derived metrics and. Execute the report services document. The complicated DA will have both an ID form and a description form. Now Edit the "Revenue for Books metric and Replace Category@ID with this new Books metric formula would looks like this Case ( (Books = 1), Revenue, 0. STEPS TO REPRODUCE: 1. Now the report execution will return the date in the desired format. The Select Objects dialog box opens. Click an object to add it to the definition. Create a report with the Category and Subcategory attributes and Revenue metric. This attribute is referred to as a derived attribute. Open a report in MicroStrategy Developer. Schema abstraction of the database columns (into MicroStrategy attributes and facts) provides the flexibility necessary to allow applications to be created quickly without having to change the structure of the data model. This feature also supports multiple attribute forms. . Right-click the metric to rank, point to Insert, point to Rank, and then select the break by value from the list. Right-click and select New > Attribute. You can easily create a derived attribute that: Changes the data type of an existing attribute. Create a new document with the sample file, "Airline Sample Data," in MicroStrategy Web. Open MicroStrategy Web. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). Create another derived attribute with following expression: 5. To edit an attribute form, click the tab of the attribute form to switch to it, then define the attribute form as described above. Begin to create the derived metric: Using Developer, from the Insert menu in the Report Editor, select New Metric. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so on. Select the checkbox that corresponds with each attribute you want to generate. Case. 4. 2. In the context of MicroStrategy functions,. Select a data type from the drop-down. Browse to and select a previously saved Intelligent Cube on which to build your report. Note that if the selected attribute is on the grid, the attribute will be moved. Select the member attribute as 'Month', as shown below: The "Define a new member attribute expression" window will. addTransformationMetric (WebTransformationMetric) WebReportManipulation. Right-click the attribute to create or modify derived elements for, and click Derived Elements. For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. Editor Pane: If desired, you can enter the definition of the derived attribute directly into the. 4. The Derived Elements Editor opens. New feature indicates which derived objects are used in visualizations on dossiers. In this Data in the Wild episode, you'll learn how to create derived metrics and attributes in MicroStrategy. For information on how to download th. This can help the end user more easily distinguish between elements when browsing or. You can create them in a report, document and. From the 'Edit' menu, choose 'Group'. MONTH_DATE) MONTH_DATE, sum (a11. These groups provide a new view of report data for analysis and formatting purposes. xCreate a custom subtotal object which is defined with the expression: Count<Distinct=True>(x) {@}, as shown below Create a metric object which is defined as: Max(Customer@ID){~+}, as shown below: Go to the subtotals/aggregation tab of the above created metric and make the subtotal created in Step 1 as the dynamic aggregation. 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. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. Asking for help, clarification, or responding to other answers. 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. Why is this happening?[-] When creating a visualization dashboard within MicroStrategy Web 10. Related TopicsUnable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. Enter the definition of the derived attribute directly into the right pane. Right-click the attribute to unlink and select Unmap. This article notes a workaround to dealing with percent to total derived metrics with custom groups. use the function "Remove Duplicate Rows". These are the steps to reproduce the issue in MicroStrategy Tutorial: Max(){Category} -1 . KB483614: Derived metric returns null value if it contains another derived metric which has a derived attribute with curre… Number of Views 1. x-10. . Select a data type from the drop-down. 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. On the same right mouse click context menu under the attribute header, users will see an. To ungroup the object elements: The Create Group feature is only available through document view mode. Open the dossier you want to modify. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges. ApplySimple. The Insert Function dialog box opens. . Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. To manually enter the definition of the derived attribute. Follow the next steps to create this type of metric. To create a MicroStrategy Derived Attribute, click the option button (ellipsis. Choose 'Month' as the attribute. 11?; Knowledge Base: Annotate. For a more detailed description, see About the report level of a metric. When building a derived metric with a condition in Web the formula will look like the below. In the metric editor, go to Tools > Formatting > Values and change the number format to “Date”. Then it creates a third metric, a compound metric. Resources; Log In; Join; ×. In the Datasets panel, click More next to. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. This tutorial shows how to create derived attributes and metrics in a dossier. Select the attribute form to be displayed with a link. Each attribute form must have at least one expression. Drag table “PRODUCT” and “PRODUCT_DESC” from TABLE node under DHK_SCHEMA. Derived elements are grouping of attribute elements on a report that are created on the fly. In some business scenarios, it is required to use derived metrics to concatenate two attribute forms of the report. Sometimes you don’t have all the columns that are necessary for creating your visualizations. By adding simple dummy attributes you are able to arrange the columns in a much more tidy form without even touching the original data. Derived Attribute; CSI; Steps to Reproduce. 4. A derived fact has its value determined by an expression that contains more than just a column in a table. KB483243: Derived Attribute data type cannot be specified by the user. Depending on the type of object you are filtering on, a different set of choices appears. If you include Customer on a report with both Last Name and Address. Let’s get started. To create a Filter derived element. Select the object (s) from the Available objects list and click > to move them to the Selected objects list. Create a dossier and add subset R from Existing Dataset. x? Based on the ID column in the LU table to calculate the previous ID:In MicroStrategy Agent, go to Schema Objects > Attributes. To create a new Group derived element, from the New drop-down list, select Group. The new form should immediately be included in the attribute's column. Create a dossier and add DS1 and DS2 as datasets. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. July 27, 2022 | In Business Intelligence, Analytics, MicroStrategy | By Data Meaning How To Create Derived Metrics and Attributes in MicroStrategy Watch on View. These are the steps to reproduce in MicroStrategy Tutorial: Create an object prompt on Quarter attribute. Create a metric based on the freight fact which is extended to Item attribute with fact extension. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so on. x-10. Be aware that linking actually replaces the source attribute. In the Attribute Editor window, give your new attribute a name. x? Knowledge Base: How to concatenate two attribute forms by using derived attributes in MicroStrategy 10. Sometimes you don’t have all the columns that are necessary for creating your visualizations. You need the Create Derived Metrics (Developer) and/or the Web Create Derived Metrics and Derived Attributes (Web) privileges. x. 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. If you want to implement as a true schema object attribute, you can use passthrough SQL in a new attribute to Achieve this. In a document in MicroStrategy Web, create a new derived attribute. Execute the report either in MicroStrategy Desktop 9. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Break byObject: A break by on Object is used to. The Input Metric Formula dialog box. To connect a stand-alone. Open up the same document in MicroStrategy Web 10. Select the member attribute as 'Month', as shown below: The "Define a new member attribute expression" window will. Derived metrics are not metric objects that can be re-used in other MicroStrategy reports and documents. Right-click the attribute, select formatting>attribute values, and change the attribute value format to 'Date' as shown below. many derived tables seem to be “too complex” and not perform as well when using derived tables. Open the dossier you want to modify. Select the checkbox that corresponds with each attribute you want to generate. KB442371: "Unspecified error" is displayed for a dossier with at least two dataset with attributes linked, derived attribute and conditional metric When using more than one datasets with attributes linking, derived attribute and conditional metric, Dossier fails with "In-Memory query execution failed against Intelligent Cube due to duplicate. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. To create a derived attribute with time information, right-click an attribute and choose Create Time Attributes. Create a VI grid and create a derived metric. Create an Intelligent Cube with the following tables and relationships: Create a new dossier. Create a new column alias for the date attribute ID form with the data type 'date'. Viewed 13k times. In MicroStrategy 10. From the Functions list on the left, browse to and select the function to use to. In the Format Definition section, click on Cell Formatting. Go to Smart Attribute blade on the Attributes Editor. When creating reports in MicroStrategy Web 9. ) next to your dataset. Select the Source Table that contains the desired attribute ID, and drag the attribute ID into the Form Expression window. Make your changes, save the metric, and then save and re-execute the report to see the changes in the metric. How to create a derived attribute in MicroStrategy? A derived attribute in Microstrategy has a value that is decided by the combination of two or more columns. Make: Projects. See below Image for Reference, I made an assumption that all the values of the column is same and replaced it with column value. Additionally, this can slow performance due to the nature of cross joins. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. STEPS TO REPRODUCE: 1. Create new Report, Document or Dashboard with some Attributes and Metrics. com Format: A MicroStrategy Online Training Video blog. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type. For the example scenario, right-click the Region attribute, and click Derived Elements. The attribute ID columns included in a fact table represent the level at which the facts in that. 2. You can also browse for a function by selecting a function category. In MicroStrategy Web 10. Today, we are covering how to create derived attributes and metrics in MicroStrategy. Note that the two metrics with the same definition return different values. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type. Each element of the Customer attribute represents a different customer, and in the data, you store the following information. This video shows you how to add a MicroStrategy dossier to your MicroStrategy Library by using both the Add to Library and Share options. Add it to the grid. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. 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). 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. Starting in MicroStrategy 10. Create a new metric with the following format: Max(‘DD/MM/YYY') {~}. Examples of facts include sales dollars, units sold, profit, and cost. e. g. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. 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. 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. A derived element is a grouping of attribute elements on a report. In this example, we convert years to decades. Tutorial project is used here. Define the advance sort on the derived. Introduction to Attributes, Metrics, and Groups. In the Functions pane, search for the If or Case functions. To manually enter the definition of the derived attribute. 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. This change applies to metric creation in either Developer or Web. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. Create a derived attribute and reserve it for future use in a visualization. 3/7 videos | 14M 39S total runtime. When creating a count metric within the Metric Editor, users are able to highlight Count, right-click, and select "Count Parameters". e. This pairs rows from each dataset together. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. . Add the derived attribute into filter. ). In this file, I have attributes like products, months (YYYYMM), and some measures. Add the attribute Category Desc of DS1 to the grid and create new derived elements on Category Desc. Support for custom shapes in Mapbox visualizations. 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. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. Source: MicroStrategy. 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. You can use the Find box to search for an object in the current list of objects. Enter the definition of the derived. Create a report with the prompt created in the previous step. 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. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Login to MicroStrategy Web, go to Add External Data -> Databases -> Pick Tables and pick the following tables and columnsClick Create on any folder page, point to New Report, and select Intelligent Cube Report. If all conditions are false, a default value is returned. From the Data menu, select Insert New Metric. Create Microstrategy Metrics without using gui. If removed, server doesn’t spend time calculating unused Derived Attributes anymore. x. For example, add Electronics to Group 1. Open the dossier you want to modify. 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. x-10. ACTION The issue was addressed in MicroStrategy 11. A fact has two common characteristics: it is numeric and aggregable. This tutorial shows how to create derived attributes and metrics in a dossier. Report will display result as below. 2. In the Dataset Objects panel, right click a dateset and select Insert New Attribute. Case can be used for categorizing data based on multiple conditions. In MicroStrategy Desktop, create a Transformation schema object. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. To create an attribute form with a derived expression using Architect. To create a rank shortcut metric. In MicroStrategy Web 10. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. The attribute must have a date type of Date, Time, or DateTime and contain a date attribute form. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. The procedure below describes how to create and format this derived metric for the report shown above. Continue creating the metric (for example, adding levels or conditionality) . For example, if attribute Region is 'Central' then derived metric value should be 'Profit + Cost'. 2. 9/10. Number of Views 9. Check other tables and select/deselect correct tables. To do this: a. Run the report. Open MicroStrategy Web. When selecting some geographic types, such as zip codes, checkboxes appear for new attributes you can create (for example, County, State, Zip, etc. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. Click on the attribute. The main focus of a dossier is the visualizations, which are visual representations of your data. This feature supports more Big Data scenarios where moving large amounts of data to memory is not practical. Format the text field to show “All” when the value of the derived metric created in step 2 is greater than 1. 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. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Custom groups are not treated in the same way as attributes by the MicroStrategy SQL Generation Engine. Click Switch to Function Editor. If the elements of an object being replaced appear as choices in a filter, the filter updates to contain elements of the new object. Create derived metric M01 in C01 with level set as attribute Call Ctr Id in C02. Result for new metric is blank. Value prompts are useful when the result desired on the report is a single value, such as a specific date, a number, or a specific word or phrase. Create a new report. Create a derived attribute and reserve it for future use in a visualization. 3. A nested derived attribute is an attribute made from another derived attribute. 2. The ID form should be based on multiple attributes, some of which come from different hierarchies. 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. The derived attribute can be a string, number, or date. Now this setting is applied to derived metrics in MicroStrategy Web despite the checkbox not being available in the GUI. 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. To add multiple attribute forms, create a multi-form attribute within the dataset and drag it to the header of the HyperIntelligence card. For example, using the MicroStrategy Tutorial project, users may want to calculate the number of. . Apply conditional formatting for the dynamic text. 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. You can modify the derived element using the Derived Elements Editor. g. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Derived Attribute called "Today" is defined as: CurrentDate() Case 1: Derived attribute "Today" is used in the template DescriptionSelect the geographic type from the drop-down list. 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. Drag attributes or metrics from the Datasets panel to the Filter panel. Select the forms you want to see in the card header. Any operation on a column such as adding a constant, adding another column's values, or setting the expression to be an absolute value creates a derived fact. In a dashboard, create a metric with this formula: Sum (Revenue){~+}<Favorite_Employees_Filter> Important note This report shows the sum of sales for each month, for the previous row and the % change between them. 06K. With related attributes however the amount of. 3. If the selected metric is a transformation shortcut metric, the Metric Editor opens. 4 Hotfix 4, within the “MicroStrategy Tutorial”, create a new VI. Expand the document section that contains the Grid/Graph. The Intelligence Server performs any additional operations requested like subtotals, formatting, derived elements, etc… The data is rendered in the end user browser. x - 10. ACTION: See below for steps to create a derived metric that can calculate lag on the whole dataset of the report. 4. Action If the CASE expression has only one branch -- i. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Open a report in MicroStrategy Developer. This new metric should have the Level (dimensionality) by Category attribute, as shown below. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges. To select specific attribute elements: Choose Use a pre-defined list of elements, then click Add. If you opened the Quick Thresholds Editor, select the Advanced Thresholds Editor link to open the Advanced Thresholds Editor. It means this scenario cannot be applied if your data is imported from Web. Click an object to add it to the definition. Click an object to add it to the definition. These privileges are part of OLAP Services. I will first show how to build this derived attribute in sections, and in the end we will combine all the sections together. Derived expressions: Derived form expressions perform some type of mathematical calculation on columns in the data warehouse to create an attribute form. Select the appropriate checkboxes to create additional attributes. Click OK to apply your changes. Today, we are covering how to create derived attributes and metrics in MicroStrategy. x users can hover over certain objects in the object browser for a description. In this video, I show how to create a derived attribute in MicroStrategy. Derived element groups are defined by a list, filter, or calculation. 4. MicroStrategy can help you with that, with the creation of derived attributes and metrics. 2. Qualify on 'ID'. Create a derived attribute DA2:Choose project attribute “Day” and project metric “Revenue”. In the Functions pane, hover over the If or Case function and click Edit. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Click Switch to Function Editor. 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. To quickly create a derived metric based on an attribute, right-click the attribute, point to Insert Metric, and select the function. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. Select the Attribute Forms option. Transformations allow you to apply an attribute-element based offset to compare metric data. 1. In the example above note that:Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe following rules apply to percent-to-total shortcut metrics: Row and column percent-to-totals refer to the topmost and extreme-left positions, respectively. Enter a Form name and Description. Even if you unmap the linked attributes later, you cannot recover information for the source attribute. Type a new name and press Enter to apply your changes. 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. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. If you need to remove the geographic type later, you can select None. With Architect, you can create and modify multiple attributes in your project quickly from an integrated interface. The Create New Attribute Form dialog box now appears. . To edit the desired attribute so it sorts in the report, view filter, and report filter, follow the steps below. In order to display and sort an attribute by Description and in alphabetical order, an example based on the attribute 'Month of the Year' from the MicroStrategy Tutorial project has been shown. ", Employee@LastName) To Create a Derived Attribute Open the dossier you want to modify. Time-derived columns such as “Month of timestamp” or “Day of timestamp” and other out of the box time-based derived attributes are now calculated at the source. In this Data in the Wild episode, you'll learn how to create derived metrics and attributes in MicroStrategy. Fact tables are used to store fact data. For all other valid Intermediate Table Type VLDB settings, the SQL does not reflect the values set for these properties. The attributes and metrics appear as filters. 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. A Calculation derived element uses operators and functions to combine attribute elements and derived elements into calculations that define a single derived element. 1/1/2010) that can be used to perform date time functions. Symptom MicroStrategy 10. A dossier is an interactive display that you can create to showcase and explore business data. 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. Create a derived attribute "Time" in the first dataset using "Case" function with the following formula. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. 4. Select one of the following Element behavior options: Consolidate items into one element. The derived metric's value is 12. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. Simple Implicit Derived Heterogeneous For more information on these types of attribute forms, see the Advanced Reporting Guide. This procedure is using the MicroStrategy Tutorial warehouse that is shipped with MicroStrategy. A dossier is an interactive display that you can create to showcase and explore business data. Open a report in MicroStrategy Developer or Web. For example, the Customer attribute in the MicroStrategy Tutorial project has the five attribute forms shown below: Of these five attribute forms, only Last Name has a default report sort order defined. Create a derived metric with definition: Sum([Tot Cost]){~+, [Month Id]%} and choose Aggregate from Base in the metric option.