Click Insert Visualization . Click OK. Use "Access External Data" feature in MicroStrategy Web 10 to import data. You can also access the Attribute Creation Wizard at any time in the development of a project from the Schema menu in MicroStrategy Developer. Create Dossier and Chapter Filters. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. If the user defines more than one expression for a given form, heterogeneous mapping will automatically take place when tables and column names require it. Open MicroStrategy Web. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. x. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. In Fiddler, users can use the Inspectors > WebForms > params feature to view the body of the request. A compound attribute in Microstrategy is where more than one column is. Compound Metrics. In Desktop 2020 you can only use attributes in rows. Once you create. In some cases, it may be preferable to define multi-level calculations as cube objects, rather than as metrics in MicroStrategy. Heterogeneous mapping allows the engine to perform joins on unlike column names. The key attributes are determined solely by attribute mappings to the table and attribute relationships, where the logical table keys. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Create a filter on the attribute "Year. Open MicroStrategy Web. It can be set at the project and. 2. End_date. The following procedure describes how to achieve this: Create the highest level filter. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become. 'Create Individual Index' VLDB setting is an advanced setting that is hidden by default. Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. The multiple columns are joined with other attributes, typically in a many-to-many relationship. This optimizes the SQL generated considerably:Visualizations that can be used in a dossier appear in the Gallery panel. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. In MicroStrategy Developer, choose File > New > Report. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. Article Reference Number: KB39231. 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. Do not set any additioThe Profit metric is a simple sum of the Profit fact. Advanced Metrics, explains level metrics, conditional metrics, transformation. • For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. Then, click 'OK'. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformCreate a report with attribute "Quarter", metric "Revenue" and "Rank Test". In Visual Insight in MicroStrategy Web 9. The examples below describe how to drill on these compound metrics on both grid and graph reports. Definition : Max(Day) Condition : nothing; Level : Remove report level and add Day (standard, standard) Create a. Select the function to use to calculate data in the metric. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Consider the sales figures of your company. Create a filter on the attribute "Year. when you define attributes you set a lookup table. x, the hyperlinks base on attribute form with Applysimple no longer work in the exported MHT file. To add a parent attributes, drag the appropriate attributes from the Candidates list into the Parent drop zone under Directly Related Attributes. The attribute acts like a column header and the. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched. Ans: A Compound key attribute is a primary key that is made up of two or more columns and these columns are joined with other attributes. Place the 'max month' metric created in step 4 in the Report objects window. ACTION: Ensure that there is another attribute that has a common column in their lookup table with the attribute you are working with. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Do not set any additioA list of security roles in the project source opens in the main Developer pane. In this case, from the Table Editor's Layout tab, you. This is one of the. In the MicroStrategy Tutorial project, Distribution. The only solution that I can think of is to create a FreeForm SQL Report. Select the data set and click Prepare Data. Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute keys. Use fictional primary key (i. 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)Here the many-to-many relationship is converted into a compound attribute relationship. To create an attribute using Architect 1 In MicroStrategy Developer, log in to a project. The primary key should be dataless (a primary key should not be. e. The following procedure describes how to achieve this: Create the highest level filter. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. The first step of the cycle is to quantify the performance by measuring the time spent in each of the components that are part of a Document Execution Request, as described in the preceding sections. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (to Create Smart Attributes. ApplyAgg. Select an operator, such as Equals or Less Than, from the next drop-down. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE(“OR (a11. Place the attribute 'Category' on the Page-by. In the Gallery, click to add a new visualization and choose. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. To manually enter the definition of the derived attribute. Create the relationships and hierarchies. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Get the instant response experience with new features unique to the app such as Smart Download and Automatic Refresh that predict and proactively download the content you need both online and offline. An empty filter appears in the dossier. If the document is already open in Design Mode, click the Editable Mode icon . Name this filter "Greater than 3,000,000". Choose your environment and project. The forms you create must have a reference to a lookup table and can include multiple expressions. For information on training metrics and creating predictive. 0. View the report as a graph and notice that the. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Continue creating the metric (for example, adding levels or conditionality) . 3. The new grouped attribute appears in the. Open a report in MicroStrategy Developer. The table below summarizes a few key modules that commonly consume the most amount of time during a dashboard execution:In the MicroStrategy 9. Derived Attributes A derived attribute has its value determined by an expression which combines two or more columns in a database to create a new column. When the attribute used as a selector has a compound key, i. 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'. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Click 'Browsing Options' and check the 'Display hidden objects' checkbox and click OK twice. (in my example: table_id, start_date) 2) create a 2nd metric for your date value at your desired=. Compound metric C is made up of two metrics A and B with expression (A+B). Use a percent-to-total shortcut metric to show cell-level values as percents of an accumulated row or column total. A compound attribute is an attribute with multiple columns specified as the ID column. The resulting SQL will contain just the Metric Alias. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key for the. To enable or disable Smart Totals in MicroStrategy Developer, follow the steps below: Open the compound metric in the metric editor. Choose one of the following options: To display all of the attribute's elements to the user when they are answering the prompt, select List all elements (no restriction). Create a filter on the attribute "Year. To create a logical table alias, right-click the logical table name and select Create Table Alias. In MicroStrategy Developer, go to File > New > Metric. insufficient. The derived attribute can be developed based on an object. Creating smart metrics. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). Now Edit the "Revenue for Books metric and Replace Category@ID with this new Books metric formula would looks like this Case ( (Books = 1), Revenue, 0. The key points are: 1) create the Contribution (%) derived metric in the report instead of in the dashboard; 2) use filtering selector instead of slicing selector. 0. Microstrategy follows an algorithm to calculate the logical size of a table, which depends on the no of attributes and facts based on the table and also the position of those attributes in the system hierarchy. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. Note: The two IDs must come from multiple source tables, and one of them should have the format type of Text. If you were informed that your company had sales of $100,000, you can gather. You treat one attribute as a child of the other and have a compound key for the lower level attribute. After loading, MicroStrategy will present a window like this. In short, an inner join includes only the data common to all the elements in the join, whether that data is tables or metrics. The derived metric's value is 12. Type RunningAvg in the Definition pane. Click on the 'Subtotals' tab. primary key or a composite primary key. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the. Open the dossier you want to modify. This is a filter which contains a prompt on an attribute element list. Follow the steps below. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. Click Save and Update Schema. Attributes appear with an attribute icon on the Datasets and Editor panels. A compound attribute is an attribute with multiple columns specified as the ID column. Open up the same document in MicroStrategy Web 10. For information on defining the primary key for tables included in a MicroStrategy project, see Defining the primary key for a table. xThe following procedure describes how to achieve this: Create the highest level filter. Ultimately, it was. x allows users and administrators to decide if the attribute titles are displayed using the attribute name or the attribute form name: The setting to control the appearance of the attribute title is located under Preferences - Grid Display: Show Attribute Form Names. In the attributes list, right-click the Commute Distance attribute and then select New Attribute Relationship. Open any folder page. 'Create Individual Index' VLDB setting is an advanced setting that is hidden by default. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In the Gallery, click Compound Grid . Create a duplicate of the Month attribute and name it 'AliasMonth' Create a filter that will prompt users to select the Month attribute. To allow the user to choose attributes from a list of attributes that you specify, select . We use MicroStrategy Tutorial tables that have the Month Id attribute and. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. Do not set any additioThis article describes an issue in MicroStrategy where SQL will not be generated correctly when using an attribute with a compound ID in a metric without specifying a form. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. Do not set any additioMicrostrategy Dossiers With the release of MicroStrategy 10. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. To select the attribute from which the user can create the filter. Hierarchy 2: 4. Double-click the Column Set name to rename the set. mstrc, please open something similar to Notepad. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and 'Cost'. it seems like a small gap to breach to finalize this API endpoint. The key icons are not intended to reflect the warehouse table's physical keys, but rather which logical attributes in the MicroStrategy schema should function as lowest-level join attributes for this table. Create a new derived attribute by. This article describes best practices to be taken when using a Teradata database in MicroStrategy. You can use the Custom Visualization API to create tooltip functionality using third-party plotting libraries like D3. For information on compound attributes, see Attributes with multiple. To create an attribute filter Open the dossier you want to modify. How to create attributes in MicroStrategy? Create an Attribute. In general, ApplySimple can be used to create the following objects: •. J2EE environment:To create a derived metric. The cursor is positioned between the parentheses in the Definition pane. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. database to create a new column. How to apply threshold on rows without specific characters in attribute element. . Use the Ctrl key to select multiple attributes and metrics. If you know of better/faster ways, please share. ; On the Freeform Sources tab, select Create Query Builder report. An empty filter appears in the dossier. In-line M-M Relationships: Explanation. In Data Preview page, use ctrl or shift key to select multiple columns, and right mouse click, choose "Create Multiform Attribute" function, as shown below: In the Create Multi-form Attribute window, assign Form. Compound Key attribute; How to create a derived attribute in MicroStrategy? A derived attribute in Microstrategy has a value that is decided by the combination of two or more columns. Select the Relationships tab. It helps to merge or concat two columns in the same group. To add a derived element to a document, open the document in Editable Mode. Click "Prepare data" to enter Data Preview page. Drag the attributes and metrics for filtering from the Datasets panel to the empty filter. Select "DESC" from the 'Qualify On' drop down options and change the operator to "Contains", as shown below:In MicroStrategy Developer, to create a list of the individual fact entries for an attribute in a scenario where the attribute has a fact table as its lookup table Very Large Database (VLDB) 'Distinct/Group By option (when no aggregation and not table key)', users can create an attribute 'Year' that uses the YR_CATEGORY_SLS fact table in. You can easily create a derived attribute that: Changes the data type of an existing attribute. There are no restrictions on the names for the columns used in the expressions of a given attribute. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Click the visualization to add the group to. Select the heat map visualization. mstrc file created before and click Continue. Enter the definition of the derived attribute directly into the right pane. the attribute definition window. In Workstation 2020 you can only use attributes in rows. The following procedure describes how to achieve this: Create the highest level filter. Beginning in MicroStrategy 11. Create a metric with the formula Max(Month Duration) {~} (metric max month) called 'max month'. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. By ManishaGupta that reached out to. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. From the Visualizations panel, select Grid . In the Gallery, click Compound Grid . From the 'Edit' menu, choose 'Group'. SUBCAT_ID. The primary key should be compact (avoid the use of long data types). From the MicroStrategy home page, click New Metric . This implies that more than one ID column is needed to uniquely identify the elements of that attribute. An empty filter appears in the dossier. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. Attribute form. 2. Simple key requires only one column to identify a record uniquely within a table. A setting in MicroStrategy Web 9. A compound key attribute is an attribute that has two or more IDs. There is a Filter Editor, Template Editor, Attribute Editor, Metric Editor, Report Editor, and so on. In Name, enter a descriptive name for the attribute. Here's what you would need to do in your code: public class MyTable { [Key, Column (Order = 0)] public string SomeId { get; set; } [Key, Column (Order = 1)] public int OtherId { get; set; } } You can also look at this SO question. Click on 'Yes' to continue, when prompted, in a dialog box, to confirm this action. In the Attribute Editor, create a new form expression. For example, a warehouse table's primary key is defined using the columns CUSTOMER_ID, PRODUCT_ID, and ORDER_ID. Ans: In Microstrategy, facts are the numeric data and attributes are contextual data for the facts which. x, the hyperlinks base on attribute form with Applysimple no longer work in the exported MHT file. Therefore, if a metric is specified to calculate to an explicit attribute level and the attribute is not on the report template or in the Report Objects window, it will not calculate to that level, but. Metric A has corresponding value for element t1 while B does not. Microstrategy follows an algorithm to calculate the logical size of a table, which depends on the no of attributes and facts based on the table and also the position of those attributes in the system hierarchy. STEPS TO REPRODUCE: 1 - In the MicroStrategy Tutorial project create a new attribute form in the Category attribute with the following expression:Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. Creating Compound Attributes MicroStrategy Community 3. For any Apply function, the attribute form in the arguments should be a single form—not a form. This is a filter which contains a prompt on an attribute element list. For detailed information on attribute roles, refer to Attributes that use the same lookup table: Attribute roles. Open a report in MicroStrategy Developer. Click Filter and choose Element/Value Filter. Open attribute editor (right-click on attribute and select. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. This is a list of the available auto text macros that the Report Services Document engine recognizes. For example, if sales data is stored in the data warehouse at the day level, a month attribute allows users to. This article notes a limitation of mapping MDX attributes to schema mapped attributesLet’s say you need to create a new table that should contain the compound key attribute and a new fact. To create an attribute relationship. Do not set any additioHow to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. In MicroStrategy Developer, open Architect. Drag attributes or metrics from the Datasets panel to the Filter panel. For example, given a report with Revenue and Cost, the custom subtotal will return total Profit, as shown below:The Profit metric is a simple sum of the Profit fact. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. To show data valuable for any analysis, the map visualization requires at least one Attribute (including Geo Attribute) and at least one Metric. Compound attributes are usually counted by concatenating the keys of all of the attributes that form the key. I want to be able to make one graph that shows only customer types A, B and C, and a second graph on the same page that shows only customer type D. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE(“OR (a11. Press and hold the Ctrl key to select multiple attribute elements. Creating attribute form expressions • Creating and modifying attribute data types: Column aliases • Creating attributes with multiple ID columns: Compound attributes • Modifying how to use attributes to browse and report on data • Specifying attribute roles: Attributes that use the same lookup • Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute keys. This issue is being investigated by the MicroStrategy Technology team. Select the heat map visualization. All Files. Update:To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Use the same. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. After choosing the attribute, choose to qualify on the ID, as in shown below: The user will now be able to access the. Double-click Time to open the folder, then double-click Year. Metrics are completely reusable - they can be added to different reports or even other metrics. In a relational database, each row in a table must have a unique identifier, which is used for indexing and searching the table efficiently. Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. Double-click the security role you want to assign to the user or group. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Click Filter . Video Tutorials. In the relational database. In the relational database. This is a filter which contains a prompt on an attribute element list. Add 'AliasMonth' to the report template as shown in the image below: Create a. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. As you type, matching objects, such as attributes. A derived attribute works the same as any other attribute. Create a new metric based on the OLAP function RunningCount: 3. P12 certificate and key file into a . This article explains how to create a metric which counts only a single key of a compound key attribute n this brief video tutorial, Stephen Goodson, a senior instructor from our Customer Education team explains what compound attributes are and demonstrates how. Click the Create Filter icon . Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. create 2 similar region prompt ( call it region 1 & region 2) now create 2 revenue metric , region1 revenue ( with region 1 prompt in filter) and region 2 revenue ( with region 2 prompt in filter) in custom group band could be like following YY - region1 revenue > 0 AND region 2 revenue > 0. In MicroStrategy Developer, from the File menu, point to New, and select Transformation. The following procedure describes how to achieve this: Create the highest level filter. Right-click in an empty area on the right side of. How to create an attribute in MicroStrategy What are attributes? Attributes are groups of related data, such as table columns. In the report, the attribute with the compound key is Distribution Center. However, it is recommended that you use the provided tooltip API that is capable of creating the same style tooltips as out-of-the-box widgets. To create attributes with the Attribute Creation Wizard, follow the steps outlined in Simultaneously creating multiple attributes. The derived attribute can be developed based on an object. After migrating to MicroStrategy 9. The Attribute Editor opens, with the Create New Form Expression dialog box displayed on top of it. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. This example uses 'AliasMonth' to build the filter as shown in the image below: Build a report using the filter created above. Create Multiple Element Groups. We decided to gather them in one placing using our experience and MicroStrategy materials. You can also create multiple attributes using Architect, which is described in Adding and modifying attributes. In the Object Browser, locate and double-click the metric Cost. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). Create a filter on the attribute "Year. This is a filter which contains a prompt on an attribute element list. g. (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. Do not set any additio 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. Set the qualification type to 'Custom'. x and 10. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated below: Create a report with the above created consolidation and three metrics - 'Revenue',. 1. The following steps can be used to concatenate two attribute forms. 2 From the Schema menu, select Architect. The steps below use objects from the MicroStrategy Tutorial project as an example. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. All articles. Set "Join Type" to "Join 92" in menu: Data -> VLDB Properties -> Joins -> Join Type, as shown below:. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. From the Select a Project drop-down list, select the project for which to assign the security role. Click on 'OK' and save the. 3 If a message is displayed asking if you want. Create an attribute with a compound key In the metric editor, drag the attribute to the metric definition Consider the following: if the attribute you created is. Shorter data types are faster to join than longer. This approach gives project architects direct control over the specific attributes to be treated as different roles, as well as their mappings to logical tables. Simultaneously creating multiple attributes. On the Background tab in the Format Cells editor and select 'Solid' as background style and choose black as the color for the 'Fill' drop-down. Apply Filter Changes. Count Compound Attribute. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. Filters in MicroStrategy are built from Attributes. Save and assign a name to the file like “My_first_connection_file. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Attribute_ID1 = “,A1,”. e. The following procedure describes how to achieve this: Create the highest level filter. In MicroStrategy Developer, go to the Tools menu and select Desktop Preferences. The only solution that I can think of is to create a FreeForm SQL Report. attribute with a compound key of the table id and my date value=. 4. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. The Count function in MicroStrategy does have a parameter to include or exclude nulls, but including nulls can only count rows that exist in the result set. 1. For information on connecting to databases, see Connect to Databases. How to force non-key template attributes to appear in the SELECT and GROUP BY statements in intermediate passes of MicroStrategy SQL Generation EngineUse the Selections pane (the bottom pane on the right) in the Query Builder Editor to map the columns in your SQL query to attributes and metrics that appear in the Query Builder report. If you are on a folder page, click Create on the icon bar on the left, then select New Metric. Do not set any additio In the relational database, a compound key is a primary key that consists of more than one database column. Drag from the middle of the attribute to an. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. To enable or disable Smart Totals in MicroStrategy Developer, follow the steps below: Open the compound metric in the metric editor. Create and schedule incremental reports when the cube can be partially. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Attributes give users context for reporting on and analyzing data. Launch MicroStrategy Desktop and open a local dossier. Double-click the Column Set name to rename the set. 4. Right-click the group and choose Set as key. Visit the data visualization and data dashboard galleries for inspiration. Click the “Select File” option. Ensure that the project schema for your new attribute is available for editing. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. long_description is the long description of the attribute, of type string, between double quotes ("). Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. From the Insert menu, select New Training Metric to use derived metrics as part of Data Mining Services to create training metrics.