Managing Compound Metrics


In Metric Management, you can define compound metrics based on derived metrics and atomic metrics, and perform operations such as editing and publishing.

Prerequisites


Before you start, ensure the following:

  • The current account has been assigned a menu group containing Metric Library. If not assigned, contact the application administrator.
  • The current standard metric library already contains the required atomic metrics, or the required atomic metrics have been created.
  • Dimension attributes used in calculation formulas are published.
  • A query mapping group has been configured for the derived metrics.

Creating a Compound Metric


  1. Select Metric Library in the left navigation bar, which goes to the Atomic Metric tab by default.

  2. Select the Compound Metric tab, select New, and enter the following information on the New Compound Metric page:

    • Associated Atomic Metric: In the drop-down box, select the atomic metric in the built-in Standard Metric library, or select the created atomic metric to define the calculation logic of the metric. If the current atomic metric library does not meet your needs, you can also click Create Atomic Metric. For more information, see Creating a Atomic Metric.
    • Metric ID: Enter the compound metric ID. This cannot be modified after creation.
    • Metric Name: Enter the compound metric name.
    • Description: Enter an additional description for the compound metric.
    • Formula: Enter a calculation formula for the compound metric composed of a function, derived metrics of the same statistical dimension and configured with the query mapping group, and the published dimension attributes. Select Formula Explanation to go to Compound Metrics Calculation Formula Explanation for documents explaining formula syntax. Select Formula Check to verify whether the formula is compliant.
    • Unit: Select the calculation unit for the compound metric.
    • Data Type: Select the data type for the compound metric.
    • Statistical Dimension: The system automatically generates the statistical dimension according to the statistical dimension configured for derived metrics in the calculation formula.
    • Period: The system automatically generates the maximum statistical period configured for the derived metrics in the calculation formula. For example, if derived metric A with a statistical period of Current Week, and derived metric B with a statistical period of Current Month are used, the system will automatically set the Current Month as the statistical period of the compound metric.
    • Business Owner: Select an account as the business owner under the current OU by entering keywords in the drop-down box. In addition, you can also fill in an account that is not registered under this OU.
    • Development Owner: Select an account as the development owner under the current OU by entering keywords in the drop-down box. In addition, you can also fill in an account that is not registered under this OU.
    • Attributes: Select Add Attributes, enter the key-value pair of the metric attribute to add other attributes to marking or differentiation.
  3. Select Publish to automatically trigger verification of the calculation formula. If verification passes, the compound metric will be saved and published.

    If you do not want to publish for the moment, select Save to save it as a draft. To publish later, see Publishing a Compound Metric.


After saving or publishing a derived metric, it can be viewed in the list in the Compound Metric tab.

Editing a Compound Metric


  1. Select Metric Library, then go to the Compound Metric tab.
  2. Select Edit edit_icon at the end of the target derived metric row, and save or publish it after passing the formula check.

Deleting a Compound Metric


  1. Select Metric Library, then go to the Compound Metric tab.
  2. Select Delete delete_icon after hovering over the ellipsis (…) at the end of the target compound metric row.

Publishing a Compound Metric


  1. Select Metric Library, then go to the Compound Metric tab.
  2. Compound metrics can be published in two ways:
    • Select Publish publish_icon at the end of the target compound metric row.
    • Check multiple compound metrics to publish, then select Publish publish_2_icon at the top of the page to publish compound metrics in batches.

After the compound metric is published, you can view its value on the Metric Insights page.

Unpublishing a Compound Metric


  1. Select Metric Library, then go to the Compound Metric tab.
  2. Hover the mouse over the ellipsis (…) at the end of the target compound metric row, and select Unpublish unpublish_icon to unpublish the compound metric.

Viewing an Online Version of a Compound Metric


  1. Select Metric Library, then go to the Compound Metric tab.
  2. Hover the mouse over the ellipsis (…) at the end of the target compound metric row for which the status is Updated for Publish, and then select View Online Version view_version_icon to view the compound metric in its most recently modified version.

Reverting a Derived Metric to an Online Version


  1. Select Metric Library, then go to the Compound Metric tab.
  2. Hover the mouse over the ellipsis (…) at the end of the target compound metric for which the status is Updated for Publish, and then select Revert to Online Version revert_version_icon to republish the previous compound metric.

Exporting/Importing Compound Metrics


You can perform export/import operations to share and migrate compound metrics between different OUs.


  1. Select Metric Library, then go to the Compound Metric tab.
  2. Check the compound metric, select Export, and export a file in JSON format as a template.
  3. Select Import to import the local compound metrics.


After the compound metric are successfully imported, the following situations will occur:

  • If the imported compound metric ID does not exist in the current metric list, the compound metric will be directly added to the metric list and published.
  • If the imported compound metric ID already exists in the current metric list, the field value of the imported compound metric will overwrite the field value of the same ID in the list, and the compound metric will be automatically published.

Insighting a Compound Metric


To view the value of an compound metric on the Metric Insights page, ensure that the compound metric has been published in advance.


  1. Select Metric Library, then go to the Compound Metric tab.

  2. Select Metric Insights insight_icon at the end of the target derived metric row for quickly insight the compound metric value.

Synchronizing Compound Metrics to Common Data Service


You can sync the published compound metrics to EnOS Common Data Service by adding the following attributes to reduct the workload of mapping, debugging, and importing metrics.


Attribute Key Value
Attributes of compound metrics syncToCDA 1
Extra attributes of dimensions businessType The mdm types of the metrics in Common Data Service. For more information, see Business Object Type.

Step 1: Adding Attributes to Compound Metrics


  1. Select Metric Library in the left navigation bar and go to the Compound Metric tab.
  2. Choose one of the following methods to add attributes:
    • Batch Adding:
      1. Select the required compound metrics, click Publish to publish the metrics, and then click Export to export the metrics as a JSON file.
      2. In the attributes field of each line in the file, add the attribute syncToCDA=1 for each metric, for example, "attributes":"[{\"key\": \"syncToCDA\", \"value\": \"1\"}]".
      3. Select Import > JSON File and import the edited file. The existing metrics on the page will be updated if the file is imported successfully.
      4. Select the updated metrics, click Publish to republish the derived metrics.
    • Adding One by One:
      1. Select Edit edit_icon at the end of the target compound metric row to redirect to the Edit Derived Metric page.
      2. Add the syncToCDA=1 attribute in Attributes, where syncToCDA is Key and 1 is Value.
      3. Select Publish to save and publish the compound metric.

Step 2: Adding Extra Attributes to Dimensions


  1. Select Dimensions in the left navigation bar, which goes to the Dimension Definition tab by default.
  2. Select Edit edit_icon at the end of the dimension row associated with the compound metric to redirect to the Edit Dimension page.
  3. Add the businessType = <mdm type> attribute in Extra Attributes, where businessType is Key and <mdm type> is the business object type identifier in Common Data Service.
  4. Select Publish to save and publish the dimension.

Results


Once the compound metrics and dimension are published, you can synchronize the compound metrics to Source Metrics or Biz Metrics in CDS. For more information, see Synchronizing Source Metrics from Metric Management and Synchronizing Business Metrics from Metric Management.