Create a unique metric definition name

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • Specify the value formula in the sn_grc_metric_definition in the required record table to create unique metric definition names to import data from an external source such as Watershed spreadsheets.

    Before you begin

    Role required: sn_grc_metric.admin

    About this task

    Any external source that contains data must be imported into the metric definitions and each metric definition must have a unique name. The metric definition name can either use a single column from the spreadsheet or it can be a combination of multiple columns. This procedure uses the Operational Sustainability Integration with Watershed and the sn_grc_metric_definition table as an example. You can specify the formulae in the sn_grc_metric_definition table to create the unique metric definition names. The same procedure can be repeated for the other tables as well. The following tables are installed by default.
    • sn_grc_profile
    • sn_grc_profile_type
    • sn_grc_metric_definition
    The following image shows the string and value columns from a sample spreadsheet.
    Figure 1. Value formula combinations
    Sample strings and values from a spreadsheet.

    Procedure

    1. Navigate to All > Metrics > Metric Integrations.
    2. Select Watershed Integration.
    3. In the Data Mappings section, select the data mapping for which you want to specify the formula.
    4. On the Required Records form, in the Value Formulas section select New.
    5. On the form, fill in the fields.
      Table 1. Value Formula form
      Field Description
      Source table. Name of the source table. This field is automatically set to Watershed Data [sn_esg_watershed_data].
      Required record Name of the table being modified.
      Note:
      In this procedure, the example used is the sn_grc_metric_definition table.
      Column Column containing GHG protocol category.
      Format Format of the name. The choices are as follows
      • String: Use this option to specify a text string.
      • Value: Use this option to use any value of the column.
      • String+Value: Use this option prepend text to beginning of column value.
      • Value+String: Use this option to append text to end of column value. Specify the text in the String field.
      String Text to use in the format.
      Sequence Specify the sequence of the formula. Multiple value formula under same required record will be concatenated following the sequence specified.
    6. Select Submit.