Open MicroStrategy Web with an English user account. This is a single-value function. Right-click the attribute to create or modify derived elements for, and click Derived Elements. STEPS TO REPRODUCE: 1. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and. Derived Attribute; CSI; Steps to Reproduce. Attribute level locking constrains the element display in system hierarchy, as shown below:. With Architect, you can create and modify multiple attributes in your project quickly from an integrated interface. Click on the attribute. Facts help to link indirectly related attributes. Create the previous Month Filter. 4. Create a new dossier, add new data, use Clipboard and input the same data as below. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. Add the derived attribute into filter. Create a VI grid and create a derived metric. Enter a description of your derived metric in the Description field. Number of Views 222. In a dashboard, create a metric with this formula: Sum (Revenue){~+}<Favorite_Employees_Filter> Important noteThis report shows the sum of sales for each month, for the previous row and the % change between them. Create a copy of Profit with that name 'Copy of Profit. You can add it to a visualization, drag it into a text field to display it as a label, or use it as a filter. An attribute may have attribute elements with descriptions that are identical but the ID forms are unique. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. To manually enter the definition of the derived attribute. To manually enter the definition of the derived attribute. The Metric Editor opens. To create a derived metric. This is a single-value function. This behavior has been logged as a Defect by MicroStrategy Technical Support for version 10. Name the derived metric using the top most text field in the window. The derived metric's value is 12. 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. Create additional visualizations to display the data in multiple ways. A Calculation derived element uses operators and functions to combine attribute elements and derived elements into calculations that define a single derived element. 5. In the Attribute Editor window, give your new attribute a name. Create a derived attribute DA2: Choose project attribute “Day” and project metric “Revenue”. Create a new Derived Element Category (Group) : Right-click Category on the Grid > Create Groups > Select "Books" and "Electronics" to form "Group 1". User without privilege “Web modify the list of report objects” can create derived metric but cannot delete it in MicroStrategy 10. To create a derived attribute with time information, right-click an attribute and choose Create Time Attributes. Supporting data internationalization for attribute elements. Type a new name and press Enter to apply your changes. 6. In the metric editor, go to Tools > Formatting > Values and change the number format to “Date”. 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. Create a new. Apply conditional formatting for the dynamic text. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Create or include a user defined under a security filter on the same attribute or a different attribute in the same hierarchy. using the 'Country' attribute, as shown below: Update the schema. We use MicroStrategy Tutorial objects to reproduce this issue. In MicroStrategy 10. ", Employee@LastName)To Create a Derived Attribute Open the dossier you want to modify. 5. Add, rearrange, or remove data from a visualization in a dossier. The derived attribute can be a string, number, or date. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. Format the text field to show “All” when the value of the derived metric created in step 2 is greater than 1. 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. Derived metrics are not metric objects that can be re-used in other MicroStrategy reports and documents. x. Visit the data visualization and data dashboard galleries for inspiration. Use the ApplySimple pass-through expression to create the HTML tag expression. Create a report with the prompt created in the previous step. It means this scenario cannot be applied if your data is imported from Web. x, Derived Attribute does not display values. Type a name for the metric in the Metric Name field. 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. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. In MicroStrategy Web 9. Go to the report design view, and insert a new metric (a derived metric). 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. These groups provide a new view of report data for analysis and formatting purposes. x-10. Enter the values to use as arguments. ACTION: To remove the derived metric subtotals, follow the steps below: In the Report editor go to Data -> Subtotals. x when joining two datasets together on a document or dashboard data blending is used. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and 'Cost'. Set the qualification type to 'Custom'. For example, if a report contains revenue by year and month, the numbers are calculated to reflect monthly sales data. This procedure is using the MicroStrategy Tutorial warehouse that is shipped with MicroStrategy. Insert one panel stack and add dynamic text with Profit Margin. Attribute lookup tables are joined to other tables only on the basis of the attribute ID. The derived attribute can be developed based on an object. 0:50. Drag attributes or metrics from the Datasets panel to the Filter panel. The syntax for the CaseV. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. For all other valid Intermediate Table Type VLDB settings, the SQL does not reflect the values set for these properties. 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. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. 1. Check one of the available forms for the attribute. You can modify the derived element using the Derived Elements Editor. Tutorial project is used here. The steps to create such an attribute: Make a dataset consisting of the necessary objects. Create a new dossier and click “Existing Objects”. Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. Constituent, Gift, Action) you want to create. You create derived metrics based on objects already present in the report. How to Create a Derived Attribute or Metric. The attribute ID columns included in a fact table represent the level at which the facts in that. ", Employee@LastName) To Create a Derived Attribute Open the dossier you want to modify. Add the dynamic text {Year} to the Detail section. New feature indicates which derived objects are used in visualizations on dossiers. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Run the report and select Quarter when prompted. 4. Expand the document section that contains the Grid/Graph. Create a standard report like the following: 3. Follow the steps below to reproduce this issue in the MicroStrategy Tutorial project: Edit the attribute Call Center and modify the form DESC to define a default sort ascending. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. If the attriubte name has spaces, use the '' symbols to group the name. Select the attribute you want to use to create your derived element. Derived Attribute; Derived Metric; CurrentDate – A function that returns the current date as provided by the database timer. 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. Create a Filter object and save it in an accessible location. Matching objects appear in a drop-down as you type. Open MicroStrategy Developer. 4 Hotfix 4, within the “MicroStrategy Tutorial”, create a new VI. Create a Filter object and save it in an accessible location. Select one of the following Element behavior options: Consolidate items into one element. Steps to reproduce This case is built with the Microstrategy Tutorial project and using the latest version of the Microstrategy 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. 4. While knowing your company’s total sales is useful, knowing when and where the sales took place provides the kind of analytical depth that users require on a daily basis. 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. This video show how to share a filter with other Library users. Add it to the grid as shown below:use the Attribute Forms dialog, see attribute forms in the Report Objects list, see the Attribute Forms context menu options, and pivot attribute forms: WEBCHOOSEATTRFORMDISPLAY: Web create new report: access the Create Report folder and design reports, and to run new reports from the folder where he or she has. Click on the Subtotal drop down list for the. Creating derived facts and fact expressions. Click the Metric Options. Select the Source Table that contains the desired attribute ID, and drag the attribute ID into the Form Expression window. Steps to Reproduce. You need to know the number of regions, so you create a derived metric from the Region attribute. In MicroStrategy 10. 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. To create a derived attribute with time information, right-click an attribute and choose Create Time Attributes. In the Derived Elements Editor, select a derived element. Enter the definition of the derived attribute directly into the right pane. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. A dossier is an interactive display that you can create to showcase and explore business data. Drag table “PRODUCT” and “PRODUCT_DESC” from TABLE node under DHK_SCHEMA. You need to know the number of regions, so you create a derived metric from the Region attribute. Count<Distinct, FactID, UseLookupForAttributes, Null> (Argument) Argument is an attribute, fact, or metric representing a list of values. Enter the definition of the derived attribute directly into the right pane. Select a data type from the drop-down. The Input Metric Formula dialog box. We use MicroStrategy Tutorial objects in the following steps. Finally, just create the report with the attribute (Category) and the third. Every filter contains at least one qualification, while. Number of Views 5. Choose Operator as 'Exactly'. In the Datasets panel, click More to the right of the dataset in which you are creating a derived metric and choose Create Metric. Note that the two metrics with the same definition return different values. Qualify on 'ID'. The main focus of a dossier is the visualizations, which are visual representations of your data. ACTION: See below for steps to create a derived metric that can calculate lag on the whole dataset of the report. e. Description: How to create MicroStrategy OLAP Derived Elements and util. Let’s get started. e. Create a dossier and add subset R from Existing Dataset. KB6458: How to create an outer join between two different attributes in MicroStrategy Developer? Number of Views 13. 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. Add 'Copy of Profit' in the report objects window (OLAP report), as shown below: Create a document based on the saved report. To create a round-down function that produces the following sample results, use the following formula in Metric Editor in MicroStrategy Developer 9. x: 24. a. In later versions of MicroStrategy, you may be shown options for the filter. Starting in MicroStrategy 10. 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. Browse to and select a previously saved Intelligent Cube on which to build your report. Create a derived attribute and reserve it for future use in a visualization. 45 -> 24. Filters can only be created out of schema attributes (in this case: Employee). To create an attribute form with a derived expression using Architect. x and 10. This knowledge base article documents how to use derived metrics to concatenate two attribute forms of the report in MicroStrategy 9. Tutorial project is used here. The Derived Elements Editor opens. Resources; Log In; Join; ×. In this example, we convert years to decades. MicroStrategy Web automatically creates attributes when you import data. x Starting from MicroStrategy 9. From the Insert menu, select New Metric. Create a filter (Previous Month) using attribute qualification. 3. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Assign the Client-Reporter > Web create Derived Metrics and Derived Attributes privilege to the user. To add multiple attribute forms, create a multi-form attribute within the dataset and drag it to the header of the HyperIntelligence card. TOT_DOLLAR_SALES) WJXBFS1. ACTION The issue was addressed in MicroStrategy 11. KB439632: Derived element calculations cause metrics based on day data to display as null. Sometimes you don’t have all the columns that are necessary for creating your visualizations. In the tab Display, add the ID form in the report display form. For information on how to download th. Create a report that uses an object prompt, such as Category or Subcategory. Now this setting is applied to derived metrics in MicroStrategy Web despite the checkbox not being available in the GUI. 3. Note the picture with the definition. To edit an attribute form, click the tab of the attribute form to switch to it, then define the attribute form as described above. A fact has two common characteristics: it is numeric and aggregable. Create a new Intelligent Cube. To edit an attribute form, click the tab of the attribute form to switch to it, then define the attribute form as described above. 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. 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. Navigate to the desired attribute. Users might observe that when an attribute with a compound form is added to a report in MicroStrategy Developer 9. Create the list using the buttons described below: Select Objects dialog box. Additionally, this can slow performance due to the nature of cross joins. This attribute is referred to as a derived attribute. The Input Metric Formula dialog box opens. Matching objects appear in a drop-down as you type. 2. In the Format Definition section, click on Cell Formatting. A derived element is a custom object that can be built in a report or dashboard on the fly. Click OK to apply your changes. Right-click the metric to rank, point to Insert, point to Rank, and then select the break by value from the list. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Select the member attribute as 'Month', as shown below: The "Define a new member attribute expression" window will. In MicroStrategy Developer, log in to a project. Select the check box for any smart attribute that needs to be created. e. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9Derived Elements - grouping of attribute elements; Connect Live - mode of data access that retrieves results directly from the data source; STEPS TO REPRODUCE: Open MicroStrategy Web. This article narrates "Unspecified error" received when try to define derived attribute based on the smart level metric in Dossier in MicroStrategy 2021 Update 5. Users can type certain keywords to specify and create aggregation derived metrics based on an existing attribute/metric. Enter a Form name and Description. The value prompt is designed to return report results based on the data type assigned to the data in your data source. If M1 does not equal any of the values in the list, then it returns a default value. If you want to implement as a true schema object attribute, you can use passthrough SQL in a new attribute to Achieve this. Open MicroStrategy Web. To replace an object (i. Make: Projects. To manually enter the definition of the derived attribute. If you want to create a subtraction or division including more than two attribute elements, you must use the Derived Elements Editor. Simple Implicit Derived Heterogeneous For more information on these types of attribute forms, see the Advanced Reporting Guide. We use MicroStrategy Tutorial objects to reproduce this issue. Open MicroStrategy Web. Add the attribute Category Desc of DS1 to the grid and create new derived elements on Category Desc. In the Datasets panel, right-click the metric to use to create a derived metric and choose Create Metric. Exclude the filter. Add it to the grid. 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. com Format: A MicroStrategy Online Training Video blog. Open the dossier you want to modify. 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 example uses MicroStrategy Tutorial to demonstrate the problem and the fix. In this tutorial, you learn about derived elements and how to create them on the fly. The derived attribute has the following definition: Concat (Leftstr (Employee@FirstName,1),". The attribute ID columns included in a fact table represent the level at which the facts in that. The Duplicate as. Enter the definition of the derived attribute directly into the right pane. The Derived Elements Editor opens. x and add a derived attribute, right clicking an. Create a dossier and add subset R from Existing Dataset. . Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. This behavior has been logged as a Defect by MicroStrategy Technical Support for version 10. Click an object to add it to the definition. 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. The following steps can be used to concatenate two attribute forms. KB483614: Derived metric returns null value if it contains another derived metric which has a derived attribute with curre… Number of Views 1. Both filters and custom groups use qualifications, which are the actual conditions that must be met for data to be included. When a user is authenticated, an authorization token and a session cookie are returned and must be provided in every subsequent request. Open MicroStrategy Developer. Case. The Intelligence Server performs any additional operations requested like subtotals, formatting, derived elements, etc… The data is rendered in the end user browser. From MicroStrategy Education, this lesson teaches you how to. This will be hitting a very large table & will return a lot of rows, so an efficient method is preferable if there are options. 4 Hotfix 4, a cross join occurs when a derived metric created from an attribute on the report is used in conjunction with a date range filter. Filters can only be created out of schema attributes (in this case: Employee). KB5221: How to create metrics based only on constant values in MicroStrategy Desktop 9. This new metric should have the Level (dimensionality) by Category attribute, as shown below. A derived metric performs a calculation on the fly with the data available on a report, without re-executing the report against the data source. Enter the definition of the derived attribute directly into the right pane. This description can be added through MicroStrategy Developer 9. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. When you import data into MicroStrategy Web, the corresponding dataset is stored with the dossier. Steps to reproduce The following example uses MicroStrategy Tutorial attributes and metrics. 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. To create a MicroStrategy Derived Attribute, click the option button (ellipsis. Below is what I tried but it did not work. Click Add Condition in the View Filter section to add your filter. In order to aggregate data at a particular attribute level, that attribute must exist as an attribute. 4. Fact data and levels of aggregation. To create a new Group derived element, from the New drop-down list, select Group. In Web: Choose Data > Insert New Metric. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Create a report with the Category and Subcategory attributes and Revenue metric. This tutorial will guide MSTR users to share dossiers through Web and Library. This can be done by right mouse clicking on an object in the document and choosing the option "Insert New Attribute" In the derived attribute editor define the attribute using the metric whose values the user wishes to use in the grouping. PDF. However, starting in MicroStrategy 2019 Update 5, you are required to have the "Web Create Derived Metric and Derived Attribute" privilege to edit derived metrics. In the MicroStrategy Tutorial, a report with the Subcategory attribute and the Freight and Discount metrics generates the following SQL (using Microsoft SQL Server): select a13. 2, users have the option of removing attributes or metrics from the grid of a Report Services Document executed in Interactive or Editable display mode without losing the. These privileges are part of OLAP Services. There's a reason we're at the top of the list. Open MicroStrategy Web. Double-click the Grid/Graph to edit it. You can easily create a derived attribute that: Changes the data type of an existing attribute. Object descriptions display as tooltips in grid visualizations. You can import business data from many different sources, including local files, databases, Google Drive, etc. The Metric Formula Editor opens. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Create a new column alias for the date attribute ID form with the data type 'date'. Engineering. 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. Type the following for the name: "Total for the #P #0". In MicroStrategy Web, create a Data Import Cube as following: 3. Source: MicroStrategy. 1 – In MicroStrategy Developer, navigate to the folder where you wish. Tutorial project is used here. Define the advance sort on the derived metric and then sort on Gender DESC. 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. Derived elements are grouping of attribute elements on a report that are created on the fly. In terms of join behavior this means the setting applies to metric joins between datasets. Right-click the shortcut metric and choose Edit. Create a new Derived Attribute “Day + 1” based on “Day” by right clicking “Day” Attribute and select “Create Attribute”. Select the attributes, then click to return to the Prompt Generation Wizard. . Description: How to create MicroStrategy OLAP Derived Elements and util. 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. This is an identified defect in MicroStrategy where a derived metric that incorporates a duplicated attribute as a metric in the formula for the derived metric cause the Pie Chart visualization not to display. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. The attribute must have a date type of Date, Time, or DateTime and contain a date attribute form. Right-click the attribute, select formatting>attribute values, and change the attribute value format to 'Date' as shown below. 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. The document grid that has the Category, Subcategory(only ID form) , Revenue, and the. Create a report with the attribute created in step 1, e. blogspot. Examples of facts include sales dollars, units sold, profit, and cost. • Joining dissimilar column names: Heterogeneous. Open up the same document in MicroStrategy Web 10. Check the checkbox 'Apply background color as a graph threshold,' as seen below: Click OK. Double-click the Grid/Graph to edit it. The following procedure illustrates how to retrieve the previous months from a month attribute in MicroStrategy 9. Select the forms you want to see in the card header. Open up the same document in MicroStrategy Web 10. If you include Customer on a report with both Last Name and Address. In this video, I show how to create a derived attribute in MicroStrategy. Click on 'New' to create a new subtotal. 3. Open the dossier you want to modify. Click OK. com . 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. tv. ACTION: This setting can be controlled through the advanced symbols at the end of a conditional derived metric formula. Rather, the totals are displayed for each grouped-by attribute and are shown at the bottom of each separat grid. Execute the report services document. Enter the definition of the derived attribute directly into the right pane. In SQL View look at where the cross join appears, and between which tables the cross join appears. Go to Smart Attribute blade on the Attributes Editor. Select the checkbox that corresponds with each attribute you want to generate. Open MicroStrategy Developer. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. STEPS TO IMPLEMENT. This article notes a workaround to dealing with percent to total derived metrics with custom groups. You can use this method in MicroStrategy Developer and Web. Execute the report either in MicroStrategy Desktop 9. If you need to remove the geographic type later, you can select None. e. 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)To create a derived attribute with time information, right-click an attribute and choose Create Time Attributes. A nested derived attribute is an attribute made from another derived attribute. The following procedure describes how to create a constant date metric (i. All attribute element data is added together to form the metric values for the new group. The derived metric is created, and you can skip the remaining steps of this procedure. To connect a stand-alone. The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. g. 1. Visit the data visualization and data dashboard galleries for inspiration. If you opened the Quick Thresholds Editor, select the Advanced Thresholds Editor link to open the Advanced Thresholds Editor. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. In the drop-down menu, select Create Attribute. 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 SYMPTOM: Derived attributes are attributes that are based on one or more derived form expressions. 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. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. Right click on any of the existing attributes and select Insert Row or scroll down to the bottom of the attributes and place the cursor in the first empty field under Description. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Insert a derived metric 'M01' with expression 'Max(Region@DESC) {~+} '. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. A dossier is an interactive display that you can create to showcase and explore business data. In the metric editor, go to Tools > Formatting > Values and change the number format to “Date”. In the example above, create an attribute.