Select a data type from the drop-down. Right-click the attribute to create or modify derived elements for, and click Derived Elements. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. Use the ApplySimple pass-through expression to create the HTML tag expression. Click OK. In the Datasets panel, click More. 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'. In this case, only one form exists for each, as shown below: All the metrics on the report are listed. (15-minute smart attribute is always required by default, if any smart attribute is checked) You can rename the time attributes or apply default sorting for each smart attribute. The option for Thresholds on attribute elements is not currently available. x by modifying the object's properties, as shown below: However, when creating a derived metric, no Description field exists, as shown below:. Click Advanced, then New to create a custom subtotal. 41 -> 24. 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. x with any number of attributes. 1 or MicroStrategy Web 9. x. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. In the Functions pane, hover over the If or Case function and click Edit. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. To create a derived metric. The syntax for the CaseV. Attribute element display locking can be performed at the attribute level and hierarchy level in MicroStrategy Developer 10. Select the Source Table that contains the desired attribute ID, and drag the attribute ID into the Form Expression window. KB6458: How to create an outer join between two different attributes in MicroStrategy Developer? Number of Views 13. Create another derived attribute with following expression: 5. This is a single-value function. 1 - 10. Follow below steps to reproduce the issue: Create a web user without privilege of Web modify the list of report objects ; This user can create Derive metric within a report but he could not delete it. 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. In this case, you would create a dummy derived attribute. MicroStrategy can help you with that, with the creation of derived attributes and metrics. 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. If M1 does not equal any of the values in the list, then it returns a default value. When building a derived metric with a condition in Web the formula will look like the below. In this video, I show how to create a derived attribute in MicroStrategy. Right-click the attribute to create or modify derived elements for, and click Derived Elements. g. If all conditions are false, a default value is returned. A nested derived attribute is an attribute made from another derived attribute. 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. Article Reference Number: KB39231. 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. Since attributes provide context for fact values, both fact columns and attribute ID columns are included in fact tables. The 2 attributes should not come from the same hierarchy (e. Object descriptions display as tooltips in grid visualizations. A window with all of the attribute forms available for that attribute appears. 1. A workaround is available in the current document. In some business scenarios, it is required to use derived metrics to concatenate two attribute forms of the report. To create a new Group derived element, from the New drop-down list, select Group. It might not be the solution that you are looking for, I just want to show other things that you can do with derived attributes. xlsx as an example data set. 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. Create a Base Report in MicroStrategy Tutorial project. ACTION: See below for steps to create a derived metric that can calculate lag on the whole dataset of the report. 3. Define the advance sort on the derived metric and then sort on Gender DESC. Keep individual items separate. To do this: a. Percent to All -> A1, where A1 is an attribute, indicates that the calculation is performed across all elements of that attribute. In this tutorial, you learn about derived elements and how to create them on the fly. 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. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. Select one of the following Element behavior options: Consolidate items into one element. Let’s get started. Create a derived attribute DA2: Choose project attribute “Day” and project metric “Revenue”. Clear the Filter setting: uncheck to exclude attributes absent in report or level (dimensionality) check box. Open the dossier you want to modify. KB483243: Derived Attribute data type cannot be specified by the user. Create a derived metric with the following definition: Run the report: no data will be displayed for the derived metric created in Step 3. 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. Fact tables are used to store fact data. In this Data in the Wild episode, you'll learn how to create derived metrics and attributes in MicroStrategy. All attribute element data is added together to form the metric values for the new group. Add Month to the horizontal axis. Click the name of the dashboard to run it. 24. from ITEM_MNTH_SLS a11. x - 10. The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. To create a rank shortcut metric. 11?; Knowledge Base: Annotate. 11K. 2. The Metric Editor opens. x, Derived Attribute does not display values. Click New Data > Databases. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. ‘year’ cannot be linked to ‘month’ because they have parent-child relation) The object to be linked should not be a Consolidation, Custom Group, New Derived Element, or DESC form of old Derived Element; Data types of linked form should be compatible. If the elements of an object being replaced appear as choices in a filter, the filter updates to contain elements of the new object. 3. ACTION The issue was addressed in MicroStrategy 11. The value chosen by the user is compared to metric or attribute element values. 2. Make your changes, save the metric, and then save and re-execute the report to see the changes in the metric. A derived element is a custom object that can be built in a report or dashboard on the fly. The Intelligence Server performs any additional operations requested like subtotals, formatting, derived elements, etc… The data is rendered in the end user browser. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. For the example scenario, right-click the Region attribute, and click Derived Elements. Type a name for the metric in the Metric Name field. This tutorial will guide MSTR users to share dossiers through Web and Library. The Derived Elements Editor opens. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. Finally, just create the report with the attribute (Category) and the third. Format the text field to show “All” when the value of the derived metric created in step 2 is greater than 1. Next, add Revenue to the Vertical Axis. In this example, we convert years to decades. 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. The following steps can be used to concatenate two attribute forms. The following procedure illustrates how to retrieve the previous months from a month attribute in MicroStrategy 9. Matching objects appear in a drop-down as you type. The Create New Attribute Form dialog box now appears. 5. Open MicroStrategy Web. The derived attribute can be a string, number, or date. Note that if the selected attribute is on the grid, the attribute will be moved. New feature indicates which derived objects are used in visualizations on dossiers. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. This change is being made as the property is to help move the product towards future deprecation of this setting. Drag attributes or metrics from the Datasets panel to the Filter panel. Put the attributes Business line, Category in the grid along with the metric sales. Choose Operator as 'Exactly'. Now this setting is applied to derived metrics in MicroStrategy Web despite the checkbox not being available in the GUI. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and 'Cost'. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). Loading × Sorry to interruptA derived attribute works the same as any other attribute. 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. TOT_DOLLAR_SALES) WJXBFS1. Add the new derived metric to the grid as shown below:1. KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. )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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. a dossier with derived attributes based on multiple attributes fails with "Unspecified error". On the same right mouse click context menu under the attribute header, users will see an. To manually enter the definition of the derived attribute. Open MicroStrategy Developer. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. g. Add DM. 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. To create a derived attribute with time information, right-click an attribute and choose Create Time Attributes. . Enter a description of your derived metric in the Description field. The Level advanced options dialog box opens. 2. Select the forms you want to see in the card header. Creating derived facts and fact expressions. A dossier is an interactive display that you can create to showcase and explore business data. 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. In this example, we convert years to decades. 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. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and. Select the Grid visualization as its. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web. The report displays derived elements defined using. x. You can create a Year derived attribute from a Date attribute in MMDDYYYY format. For all other valid Intermediate Table Type VLDB settings, the SQL does not reflect the values set for these properties. Check other tables and select/deselect correct tables. The steps below give a detailed explanation on how to create a report that contains a metric based on another metric that will return a static string of data from the warehouse. The condition is based on either an attribute or metric. Then it creates a third metric, a compound metric. Attribute level locking constrains the element display in system hierarchy, as shown below:. Type a new name and press Enter to apply your changes. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. The Select Objects dialog box opens. 4. This article notes a workaround to dealing with percent to total derived metrics with custom groups. You can easily create a derived attribute that: Changes the data type of an existing attribute. Provide details and share your research! But avoid. Filter definition prompts qualify on attribute elements and metrics in qualifications. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. Create a dossier using the above report and create following derived metrics:In the popup dialog box, enter the formula: Count(attribute){} Make sure “Apply selections as a filter” is enabled for the selector. Create a new derived attribute by right mouse clicking an object in the dashboard and selecting the option to Create Attribute In the derived attribute editor,. Examples of facts include sales dollars, units sold, profit, and cost. Create a new dossier and click “Existing Objects”. This new metric should have the Level (dimensionality) by Category attribute, as shown below. Once the report has run, right click the Category attribute. See below for the definition of the metric: The image below describes the difference between normal metric and round-down metric. 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. The filter within the report is created by selecting from an element list as follows: With the report created to filter on a specific Month of Date element selected from a list of elements, the following SQL is generated: select DATEPART (MONTH, a12. This feature supports more Big Data scenarios where moving large amounts of data to memory is not practical. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type. MicroStrategy will. 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. In the example above, create an attribute. Editor Pane: If desired, you can enter the definition of the derived attribute directly into the. For example, add Electronics to Group 1. 2. In the metric editor, go to Tools > Formatting > Values and change the number format to “Date”. By default, a metric is calculated at the report level, meaning that the lowest attributes on the report dictate how the metric is aggregated. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. 3/7 videos | 14M 39S total runtime. The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. Right-click the attribute, select formatting>attribute values, and change the attribute value format to 'Date' as shown below. Create a dossier based on the cube. 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. Begin to create the derived metric: Using Developer, from the Insert menu in the Report Editor, select New Metric. Add the derived attribute into filter. Right-click the attribute to create or modify derived elements for, and click Derived Elements. A code fix for this issue is not available in current releases but is being reviewed for a future MicroStrategy release. To be more specific the product creates a metric dataset for the join between datasets and then outer joins that to the. With related attributes however the amount of. Create a document using the above report. x-10. Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. To change the order of the transformations, select a transformation and use the directional arrows to re-position it. The MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. 1 – In MicroStrategy Developer, navigate to the folder where you wish. 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. To quickly create a derived metric based on an attribute, right-click the attribute, point to Insert Metric, and select the function. x. Here is the issue: We have an attribute qualification filter that uses . e. Right-click the metric to rank, point to Insert, point to Rank, and then select the break by value from the list. Right-click the attribute to create or modify derived elements for, and click Derived Elements. Count<Distinct, FactID, UseLookupForAttributes, Null> (Argument) Argument is an attribute, fact, or metric representing a list of values. x SYMPTOM: Derived attributes are attributes that are based on one or more derived form expressions. This article describes a behavior observed with derived attributes and metrics, where their values show as null depending on the user language. Create a dossier and add DS1 and DS2 as datasets. Continue creating the metric (for example, adding levels or conditionality) . 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. For conceptual information on attributes as well as detailed examples, see The Context of Your Business Data: Attributes. When a user is authenticated, an authorization token and a session cookie are returned and must be provided in every subsequent request. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. Open a report in MicroStrategy Developer. The attribute must have a date type of Date, Time, or DateTime and contain a date attribute form. This knowledge base article documents how to use derived metrics to concatenate two attribute forms of the report in MicroStrategy 9. Note: Filters can only be created out of metrics and schema attributes. Drag and drop the objects into the report grid. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. The Input Metric Formula dialog box opens. In MicroStrategy Web, create a Data Import Cube as following: 3. 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. Create a metric "count day" with definition "Count(Day) {~, Month}", as shown below: Create a report with attributes Month and Day, metrics "count day" created at Step #1 and a derived metric with the same metric definition "Count(Day) {~, Month}". STEPS TO REPRODUCE: 1. Make sure the Report has Month, Region, and Revenue. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. If M1 equals V1, then a specified value can be returned. Modify the Address form so that it has a descending report sort order. 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. 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. Click Switch to Function Editor. ). Break byObject: A break by on Object is used to. The Duplicate as Metric option is not available for a derived attribute. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x? Knowledge Base: How to concatenate two attribute forms by using derived attributes in MicroStrategy 10. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Go to the report design view, and insert a new metric (a derived metric). Prerequisite. 2. To create a new Group derived element, from the New drop-down list, select Group. Derived Attribute; CSI; Steps to Reproduce. Right-click the shortcut metric and choose Edit. Browsers automatically handle cookies, but if you are using your own client, you need to. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. To manually enter the definition of the derived attribute. To Create Derived Metrics. In terms of join behavior this means the setting applies to metric joins between datasets. Enter the definition of the derived attribute directly into the right pane. To add multiple attribute forms, create a multi-form attribute within the dataset and drag it to the header of the HyperIntelligence card. Since attributes provide context for fact values, both fact columns and attribute ID columns are included in fact tables. x, derived attribute returns only filtered row from one of the blended dataset, or in some cases returns NULL rows when it's defined with two linked attributes which exists in multiple datasets in the dossier/VI dashboard with different filtering conditions. . Create a Base Report in MicroStrategy Tutorial project. Create derived elements for the Region attribute; Create a New Dossier using the base report as a dataset. Create the previous Month Filter. Custom groups are not treated in the same way as attributes by the MicroStrategy SQL Generation Engine. Choose one of the following: Save the metric. It creates a derived element whose definition can be edited by right mouse clicking on the attribute header to bring up the Derived Elements editor. Create a report with the attribute created in step 1, e. Create a Derived Attribute Open an existing document. Support for custom shapes in Mapbox visualizations. Create a filter (Previous Month) using attribute qualification. . In the Operator list, select a comparison operator (Greater Than, Less Than. 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. Create a new Derived Attribute “Day + 1” based on “Day” by right clicking “Day” Attribute and select “Create Attribute”. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. Facts help to link indirectly related attributes. 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). Click OK to apply your changes. 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. You can use the Derived Elements Editor to create and save the derived element as a stand-alone derived element. . Create an Intelligent Cube with the following tables and relationships: Create a new dossier. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. But, it will calculate at the lowest Data level if that is your intention. On the Datasets panel, right-click the metric to use to create the derived metric, and select New Metric. KB5221: How to create metrics based only on constant values in MicroStrategy Desktop 9. Type a name for the derived element, and click OK. Modify the attribute from which the metric is based or base it on a numeric field. 10?; Knowledge Base: How can I filter a visualization on a dossier that users can’t view or manipulate?;. The Metric Formula Editor opens. Select the heat map visualization. Create Microstrategy Metrics without using gui. This tech note describes what each of these count parameters controls. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so on. If you have any questions or suggestions for a f. These privileges are part of OLAP Services. You can import business data from many different sources, including local files, databases, Google Drive, etc. The following two business cases, which use the Today derived attribute fails when the VLDB Property “Cartesian Join Governing" is set to Cancel Execution. The attribute must have a date type of Date, Time, or DateTime and contain a date attribute form. Create a derived metric (“New Metric”) with the following syntax: Sum([Metric String]){~+, [Attribute 2]+} Add that metric in a grid visualization, you will notice the cells are blank: Setting a threshold on a derived metric using the max function. For example, in a report with Region and Category attributes and a Profit metric, you can combine the regions on the report into various groups for profit analysis, as shown below. 4. Select the appropriate checkboxes to create additional attributes. To manually enter the definition of the derived attribute. The attribute Month of the Year, as with many other attributes, does not have a preferred sort order either in the ID or in the DESC field, therefore. The Derived Elements Editor opens. The Select Attribute window opens. There's a reason we're at the top of the list. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. In MicroStrategy Developer, log in to a project. Create a derived attribute and reserve it for future use in a visualization. You can create a derived attribute by changing an existing attribute's data type. How to Create a Derived Attribute or Metric. Create an Intelligent Cube with the following tables and relationships: Create a new dossier. ApplySimple (" 'Text goes. the 'Unit Cost' metric. , attribute, derived attribute, metric, or derived metric) with an existing object from the new dataset, select the object to use as a replacement. The syntax for the If function is IF (Condition, TrueResult, FalseResult) where: In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Name the derived metric using the top most text field in the window. Add External Data. You can create a Year derived attribute from a Date attribute in MMDDYYYY format. A dossier is an interactive display that you can create to showcase and explore business data. The nested derived metric shows missing data (null value) Glossary. 0. MicroStrategy Web automatically creates attributes when you import data. Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. Customizing a CREATE TABLE statement is only possible for a permanent table. These are the steps to reproduce the issue in MicroStrategy Tutorial: Max(){Category} -1 . GetNewTransformationMetric (WebMetric, WebObjectInfo) Use. Enter the definition of the derived attribute directly into the right pane. Max (1) The metric definition is shown in the image below: Create a second metric with an apply simple statement and using the dummy metric on its definition, as shown below. From the 'Edit' menu, choose 'Group'. In Web: Choose Data > Insert New Metric. The Duplicate as Metric. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. If a dialog appears, click OK Hover over a function in the Functions panel and click Edit. Glossary. Number of Views 5. The MicroStrategy product has been built from the ground up to focus on metrics and analysis of aggregated and calculated values. Open the dossier you want to modify. Double-click the Grid/Graph to edit it. Go to Smart Attribute blade on the Attributes Editor. In this example, we convert years to decades. Rather, the totals are displayed for each grouped-by attribute and are shown at the bottom of each separat grid. KB237469. 2. 3. Create a Derived Attribute Open an existing document. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. If you are editing the Case function, use the values in step 8. 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. Enter the definition of the derived attribute directly into the right pane. Select Manual from the Aggregation and Subtotal Behavior drop-down. Click New Threshold. 1, and it is currently being evaluated for a potential fix in a future version. This tutorial shows how to create derived attributes and metrics in a dossier. To create a Filter derived element. These are the steps to reproduce in MicroStrategy Tutorial: Create an object prompt on Quarter attribute. e. PDF. You can use this method in MicroStrategy Developer and Web. Create new Report, Document or Dashboard with some Attributes and Metrics. Under 'Source tables', select a table and click 'Set as Lookup'. Under 'Source tables', select a table and click 'Set as Lookup'. Select the Logical View Tab of both tables to see all the logical objects mapped to the table. For general instructions to create a derived metric, see Creating derived metrics. Open MicroStrategy Developer. Depending on your MicroStrategy product and licensing. To create a MicroStrategy Derived Attribute, click the option button (ellipsis. x. Steps to reproduce The following example uses MicroStrategy Tutorial attributes and metrics. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. Navigate to the desired attribute. From the Data menu, select Insert New Metric. Use the definition below by using "RunningCount" function:. To manually enter the definition of the derived attribute. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. KB34980: Removing an attribute or a metric from a grid in a Report Services Document preserves runtime information in MicroStrategy 9. g. . Add new data -> Clipboard and create a "Time Filter" table by typing in: 8. This may make related application objects (reports, filters. Define Attribute Forms “Day@ID+1”. Add Category attribute to the grid template. Create a dossier and add subset R from Existing Dataset. Schema objects are building block objects; they are. On the left, select the attribute type (Ex. Move all the attributes and metrics to the Report Objects pane except for the attribute Region and the metric Standard Deviation of Revenue. User without privilege “Web modify the list of report objects” can create derived metric but cannot delete it in MicroStrategy 10. Add a filter visualization, and drag Brand to it.