Drag it back to all. x-10. ", Employee@LastName) To Create a Derived Attribute Open the dossier you want to modify. This change applies to metric creation in either Developer or Web. In this example, we convert years to decades. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. Drag and drop the objects into the report grid. 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. Attribute lookup tables are joined to other tables only on the basis of the attribute ID. A dataset enables you to dynamically manipulate the data that appears on a dossier, without having to import a new dataset. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. A derived fact has its value determined by an expression that contains more than just a column in a table. An attribute may have attribute elements with descriptions that are identical but the ID forms are unique. Open MicroStrategy Developer. 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. You can create a derived attribute by changing an existing attribute's data type. 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. Case. In this example, we convert years to decades. Create the following objects in the MicroStrategy Tutorial project: Prompts: Enter Month ID: Value prompt of type numeric, default value: 200601. A dossier is an interactive display that you can create to showcase and explore business data. 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. x SYMPTOM: Derived attributes are attributes that are based on one or more derived form expressions. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. ) next to your dataset. This feature supports big data scenarios where moving large amounts of data to memory is not practical. To manually enter the definition of the derived attribute. Create a derived metric in the report whose definition is Max(@DESC){~} 3. There's a reason we're at the top of the list. Open a report in MicroStrategy Developer or Web. Create a filter (Previous Month) using attribute qualification. Case can be used for categorizing data based on multiple conditions. Make your changes, save the metric, and then save and re-execute the report to see the changes in the metric. Select the attributes, then click to return to the Prompt Generation Wizard. 2. I've an Excel file for dataset input. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. The following two business cases, which use the Today derived attribute fails when the VLDB Property “Cartesian Join Governing" is set to Cancel Execution. Create a metric based on the freight fact which is extended to Item attribute with fact extension. Type a new name and press Enter to apply your changes. This tutorial will guide MSTR users to share dossiers through Web and Library. The attribute acts like a column header and the. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. Tutorial project is used here. This video shows you how to add a MicroStrategy dossier to your MicroStrategy Library by using both the Add to Library and Share options. Drop “PRODUCT” and “PRODUCT_DESC” to data foundation node. Loading × Sorry to interruptA derived attribute works the same as any other attribute. Today, we are covering how to create derived attributes and metrics in MicroStrategy. Open MicroStrategy Developer. When creating reports in MicroStrategy Web 9. Open the Workstation window. Add the dynamic text {Year} to the Detail section. Refer to Product Manual for more detailed information. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so. Go to Menu -> Insert -> New Metric, and enter the formula as shown below: Max (Region@DESC) {~ } NOTE: Use Max () function to transfer an attribute form into a. Create a dossier and add subset R from Existing Dataset. Create a derived attribute DA2: Choose project attribute “Day” and project metric “Revenue”. But, it will calculate at the lowest Data level if that is your intention. Drag attributes or metrics from the Datasets panel to the Filter panel. Rename the metric in dataset object panel. g. To connect a stand-alone. Select the checkbox that corresponds with each attribute you want to generate. Save and close the metric and add it to the report, it should contain the same values as the attribute as shown below: Create a new metric that calculates the max date at. Editor Pane: If desired, you can enter the definition of the derived attribute directly into the. Add Region to the Color By. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. 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. The derived attribute can be a string, number, or date. x using an Oracle warehouse. Add DM. blogspot. 2. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. This tech note describes what each of these count parameters controls. Select the forms you want to see in the card header. Simple Implicit Derived Heterogeneous For more information on these types of attribute forms, see the Advanced Reporting Guide. In SQL View look at where the cross join appears, and between which tables the cross join appears. This example uses MicroStrategy Tutorial to demonstrate the problem and the fix. 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. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. How to create an attribute in MicroStrategy What are attributes? Attributes are groups of related data, such as table columns. Add External Data. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. Browse to and select a previously saved Intelligent Cube on which to build your report. Enter a description of your derived metric in the Description field. Create two count distinct derived metrics and places them on the report template. 2. com . This feature supports more Big Data scenarios where moving large amounts of data to memory is not practical. 3. ). 4. Open up the same document in MicroStrategy Web 10. When FactID is set to something other than (Nothing), the count. Click the Metric Options. Select the Grid visualization as its. In the tab Display, add the ID form in the report display form. Then it creates a third metric, a compound metric. STEPS TO REPRODUCE: Follow the steps below to reproduce the issue in. 2. Creating Derived Metrics. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges. addTransformationMetric (WebTransformationMetric) WebReportManipulation. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. Once in the report editor, select an attribute and right-click on the attribute header. If M1 does not equal any of the values in the list, then it returns a default value. Refer to the procedure below for steps to create a rank shortcut metric. Open the dossier you want to modify. 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:In MicroStrategy Web 10. Attributes appear with an attribute icon on the Datasets and Editor panels. 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. There are two work arounds available to create similar functionality. Create the previous Month Filter. Enter a name for the metric in the Metric Name field. g. A fact has two common characteristics: it is numeric and aggregable. Define the advance sort on the derived. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. To see more. Select the appropriate checkboxes to create additional attributes. 4. You can use the Find box to search for an object in the current list of objects. When selecting some geographic types, such as zip codes, checkboxes appear for new attributes you can create (for example, County, State, Zip, etc. . Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. This is a filter which contains a prompt on an attribute element list. Enter the definition of the derived attribute directly into the right pane. Matching objects appear in a drop-down as you type. Attribute form expressions must be rendered into SQL and cannot use any MicroStrategy functions specific to the Analytical Engine. 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. e. 5. When Distinct is set to True, the Count function counts only distinct values. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. The Input Metric Formula dialog. Format the text field to show “All” when the value of the derived metric created in step 2 is greater than 1. 41 -> 24. Modify the Address form so that it has a descending report sort order. Click OK. 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. Break byObject: A break by on Object is used to. Add attribute Center Name from C02 and metric Tot Cost from C01 to the grid visualization. 5. Attributes appear with an attribute icon on the Datasets and Editor panels. 3. Prerequisite. To Create a Derived Attribute. In the Functions pane, search for the If or Case functions. Create a derived attribute and reserve it for future use in a visualization. Create Derived Attributes and Derived Metrics in the first dataset as below: Derived Attribute Today: CurrentDate Derived Attribute Week: Week ([Today@ID])The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. This is a single-value function. 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. Related TopicsUnable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. Create a derived element on Quarter (this option is only available in MicroStrategy Web, after executing the report). To manually enter the definition of the derived attribute. Case. 4. Report filters based on attributes unrelated to the attribute in the metric condition are still kept and included in the WHERE clause. 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. Go to Smart Attribute blade on the Attributes Editor. Create a new report. 11?; Knowledge Base: Annotate. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Click Add New Element. This is a known issue in MicroStrategy 10. This can help the end user more easily distinguish between elements when browsing or. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. ‘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. To change the order of the transformations, select a transformation and use the directional arrows to re-position it. Create a new derived metric in a VI Dashboard with the formula below: Sum(IF((Year@ID=2014),Cost,0)){} 2. Select the attribute you want to use to create your derived element. 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. This attribute is referred to as a derived attribute. There's a reason we're at the top of the list. 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. x and 10. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. Define Attribute Forms “Day@ID+1”. Select Display Attribute Forms. When creating new derived metric in a Report, Document or Dashboard in MicroStrategy Web, it is not displayed in a list of available metrics when creating another derived metric as in the screenshot below: STEPS TO REPRODUCE: 1. In the Based On list, select the object to base the threshold on. In the Attribute Editor window, give your new attribute a name. Click Advanced. )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. The Metric Editor opens. Editor Pane: If desired, you can enter the definition of the derived attribute directly into the. 4 Hotfix 4, within the “MicroStrategy Tutorial”, create a new VI. To edit the desired attribute so it sorts in the report, view filter, and report filter, follow the steps below. Enter a name for the metric in the Metric Name field. Keep individual items separate. 4. 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}". Creating derived facts and fact expressions. Save the cube, and run it to publish. a dossier with derived attributes based on multiple attributes fails with "Unspecified error". x, Derived Attribute does not display values. Steps to reproduce The following example uses MicroStrategy Tutorial attributes and metrics. Finally, just create the report with the attribute (Category) and the third. To create a derived attribute with time information, right-click an attribute and choose Create Time Attributes. You can import business data from many different sources, including local files, databases, Google Drive, etc. For example, using the MicroStrategy Tutorial project, users may want to calculate the number of. The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. Open the dossier you want to modify. In the Based On list, select the object to base the threshold on. Select the checkbox that corresponds with each attribute you want to generate. To manually. Click Switch to Function Editor. Enter the definition of the derived. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. They are metrics that are saved and displayed only on the specific report on which they are created. MicroStrategy RESTOAS3. To create a new attribute: In Configuration, click Attributes. Open the dossier you want to modify. This tutorial shows you how and is just one example of. You create derived metrics based on objects already present in the report. Create a copy of Profit with that name 'Copy of Profit. SUBCAT_ID SUBCAT_ID,Step 4) Click on data foundation node. You can create derived elements with the following methods, which are all described in this section: Depending on the type of report you are creating a derived element on, you can use either MicroStrategy Developer or Web. By adding simple dummy attributes you are able to arrange the columns in a much more tidy form without even touching the original data. The following procedure describes how to create a constant date metric (i. Attribute element display locking can be performed at the attribute level and hierarchy level in MicroStrategy Developer 10. If the attriubte name has spaces, use the '' symbols to group the name. Double-click the Grid/Graph to edit it. Make: Projects. Steps to Reproduce. If you want to create a subtraction or division including more than two attribute elements, you must use the Derived Elements Editor. Run the report. a. We use MicroStrategy Tutorial objects to reproduce this issue. There are two methods with to create a stand-alone derived element: Create a derived element from within a report or Grid/Graph and then save it as a stand-alone object. Create a derived attribute as shown below with multiple attributes. In the Attribute Editor, create a new form expression. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. To rename the attribute form, double-click its name on the tab. 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. x with any number of attributes. The main focus of a dossier is the visualizations, which are visual representations of your data. 1. Phoenixier. 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. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. Enter a name for the metric in the Metric Name field. Enter the definition of the derived attribute directly into the right pane. To Create Derived Metrics. Open the dossier you want to modify. KB483243: Derived Attribute data type cannot be specified by the user. Click an object to add it to the definition. x: 24. In the Dataset Objects panel, right click a dateset and select Insert New Attribute. Derived Attribute; CSI; Steps to Reproduce. x Starting from MicroStrategy 9. The derived attribute has the following definition: Concat (Leftstr (Employee@FirstName,1),". Add the new derived metric to the grid as shown below:1. Click on the attribute. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. The Duplicate as Metric. Click New Data > Databases. 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). MONTH_DATE) MONTH_DATE, sum (a11. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. 1 and wants to use derived elements to display to display the attribute elements in a specific order. 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. Create a new bar chart. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. Introduction to Attributes, Metrics, and Groups. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. Case can be used for categorizing data based on multiple conditions. Another important observation is not to forget to enable "Smart Metric”. To quickly create a derived metric based on an attribute, right-click the attribute, point to Insert Metric, and select the function. x. Learn how to create and use a derived attribute with MicroStrategy Workstation 2019, MicroStrategy’s powerful tool that lets you administer and control. x and add a derived attribute, right clicking an attribute and. Assign the Client-Reporter > Web create Derived Metrics and Derived Attributes privilege to the user. A dataset can come from a variety of sources, including an Excel spreadsheet imported from your computer or downloaded from an URL, a database imported by building a SQL query or picking relational tables, a MicroStrategy project, etc. Click OK to apply your changes. Modify the attribute from which the metric is based or base it on a numeric field. Create a new report 'Dataset' with Attribute 'Category' in row. Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. MicroStrategy Web automatically creates attributes when you import data. Sometimes you don’t have all the columns that are necessary for creating your visualizations. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. 4. In such situations, it may be beneficial to display all the same descriptions together and sort the ID in a particular manner, ascending or descending. The 2 attributes should not come from the same hierarchy (e. Click Switch to Function Editor. Count<Distinct, FactID, UseLookupForAttributes, Null> (Argument) Argument is an attribute, fact, or metric representing a list of values. 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. Create a standard report like the following: 3. These privileges are part of OLAP Services. Learn how to switch to a compound grid, add column sets in this new visualization. Create a report with the attribute created in step 1, e. The ID form should be based on multiple attributes, some of which come from different hierarchies. Tutorial project is used here. Create a new bar chart. Here is the issue: We have an attribute qualification filter that uses . New feature indicates which derived objects are used in visualizations on dossiers. To accomplish this, use the following methods: WebReportManipulation. Open MicroStrategy Web. The report looks as follows. We use MicroStrategy Tutorial objects in the following steps. 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. Add the new derived element Category Desc(Group) to the filter panel. 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. Create another derived attribute with following expression: 5. If removed, server doesn’t spend time calculating unused Derived Attributes anymore. tv. CONTENTS 1. . Since attributes provide context for fact values, both fact columns and attribute ID columns are included in fact tables. 2. 1. The value prompt is designed to return report results based on the data type assigned to the data in your data source. In later versions of MicroStrategy, you may be shown options for the filter. Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. 2. x? Knowledge Base: How to concatenate two attribute forms by using derived attributes in MicroStrategy 10. Enter the definition of the derived attribute directly into the right pane. WORKAROUND: Creating an attribute to replace the custom group can resolve this issue. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. In the example above, create an attribute. STEPS TO REPRODUCE: Create an object prompt, using the pre-defined list of objects and adding the following attributes. To manually enter the definition of the derived attribute. Add the attribute Category Desc of DS1 to the grid and create new derived elements on Category Desc. Visit the data visualization and data dashboard galleries for inspiration. x. In the Datasets panel, right-click the metric to use to create a derived metric and choose Create Metric. Provide details and share your research! But avoid. They are able to achieve this in the grid report,. 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. 0:50. Add Category attribute to the grid template. If the selected metric is a transformation shortcut metric, the Metric Editor opens. The location of each property in the CREATE TABLE statement is given below. This tutorial shows how to create derived attributes and metrics in a dossier. In DS2, create derived attribute called DA with this expression: concat ([Quarter Id@ID] in DS2, [Category Id@ID]. Unrelated and nonshared attributes will be cartesian joined. If you need to remove the geographic type later, you can select None. In this Data in the Wild episode, you'll learn how to create derived metrics and attributes in MicroStrategy. If you opened the Quick Thresholds Editor, select the Advanced Thresholds Editor link to open the Advanced Thresholds Editor. 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. ACTION: To remove the derived metric subtotals, follow the steps below: In the Report editor go to Data -> Subtotals. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. Create a new Custom Group with the attribute Call Center as shown below:I'm newbie on Microstrategy. However, on editing the attribute, this form appears only once as. Derived Attribute; CSI; Steps to Reproduce. To create a derived metric. The derived attribute can be a string, number, or date. If a dialog appears, click OK Hover over a function in the Functions panel and click Edit. Click on 'New' to create a new subtotal. Add, rearrange, or remove data from a visualization in a dossier. x. Use the ApplySimple pass-through expression to create the HTML tag expression. 3. Each element of the Customer attribute represents a different customer, and in the data, you store the following information. Create a new. To add multiple attribute forms, create a multi-form attribute within the dataset and drag it to the header of the HyperIntelligence card. 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. 4. Note that if the selected attribute is on the grid, the attribute will be moved. This tutorial shows how to create derived attributes and metrics in a dossier. These key attributes denote. x when joining two datasets together on a document or dashboard data blending is used. Create a new Derived Attribute “Day + 1” based on “Day” by right clicking “Day” Attribute and select “Create Attribute”. KB34980: Removing an attribute or a metric from a grid in a Report Services Document preserves runtime information in MicroStrategy 9. Create a new Derived Element Category (Group) : Right-click Category on the Grid > Create Groups > Select "Books" and "Electronics" to form "Group 1". if both conditions are met, then Red, else Green. Trending Articles. KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. Filters can only be created out of schema attributes (in this case: Employee). Steps to reproduce This case is built with the Microstrategy Tutorial project and using the latest version of the Microstrategy Web. Source: MicroStrategy. , attribute, derived attribute, metric, or derived metric) with an existing object from the new dataset, select the object to use as a replacement. The following steps describes how to create such derived metric. Before MicroStrategy 2019, users cannot specify the Derived Attribute type in the Attribute Editor. In this case, only one form exists for each, as shown below: All the metrics on the report are listed. The Select Attribute window opens. Count[Employee ID]) are calculated at the grand total level, and not the correct level. STEPS TO REPRODUCE: 1. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. In MicroStrategy Web 10. from ITEM_MNTH_SLS a11. Put the attributes Business line, Category in the grid along with the metric sales. The MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. Check the checkbox 'Apply background color as a graph threshold,' as seen below: Click OK. x and add a derived attribute, right clicking an. See Modifying existing metrics for more detailed instructions. You can easily create a derived attribute that: Changes the data type of an existing attribute. KB483614: Derived metric returns null value if it contains another derived metric which has a derived attribute with curre… Number of Views 1. You can use the Derived Elements Editor to create and save the derived element as a stand-alone derived element. The Input Metric Formula dialog box. On the Custom Subtotal Properties window, write a name for the new subtotal. In Web: Choose Data > Insert New Metric. Distinct is a TRUE / FALSE parameter that allows you to count all elements in a list or only the unique elements. 1 to see the results as shown below: Right click on Attribute Region in the grid view of the report and click on Derived Elements as seen below: Create a derived element group called DE with elements "Central" and Mid-Atlantic" as seen below:They will be created on-the-fly as derived attributes. x-10. Published: Jun 9, 2017. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type.