A derived metric is composed of an atomic metric, a period, and one or more modifiers. A derived metric reflects the status of a business activity within a specific period and a specific scope. For example, you can use a derived metric to measure the sales amount of an enterprise in Shanghai within the last week. This topic describes how to create and manage a derived metric.

Prerequisites

  • Atomic metrics are created to define criteria and computing logic for the statistical analysis of business activities. For more information about how to create an atomic metric, see Atomic metric.
  • Modifiers are created to define scopes for the statistical analysis of business activities. For more information about how to create a modifier, see Modifier.
  • Periods are created to define the periods of time for the statistical analysis of business activities. For more information about how to create a period, see Period.
  • Dimension tables are created to define the statistical dimensions of business activities. For more information about how to create a dimension table, see Create a dimension table.
  • Business processes are created. Derived metrics depend on business processes. You must select a business process when you create a derived metric. This way, the derived metric can reflect the status of the business activity that is represented by the business process. For more information about how to create a business process, see Business process.

Background information

A derived metric collects statistics on the status of a business activity of an enterprise. Each derived metric is composed of an atomic metric, a period, and one or more modifiers. A derived metric can reference only one atomic metric and collects statistics on the values of the atomic metric within a specific period based on specific business conditions. You can associate fields in one or more dimension tables with a derived metric. This way, you can perform statistical analysis on a business activity from one or more dimensions. For more information about how to create a dimension table, see Create a dimension table.

Go to the Derived Metric page

  1. Go to the Dimensional Modeling page.
  2. Go to the Derived Metric page.
    1. In the top navigation bar of the Dimensional Modeling page, click Data Metric. The Data Metric page appears.
    2. In the left-side navigation pane of the Data Metric page, click Derived Metric to go to the Derived Metric page.
      Derived metrics depend on business processes. The left-side navigation tree of the Data Metric page displays all of the business processes in your workspace. When you create a derived metric, you must select a business process based on the business activity for which you want to perform statistical analysis. This way, the derived metric can reflect the status of the business activity. Derived Metric
      You can create a single derived metric or create multiple derived metrics at the same time. In most cases, the business activities of an enterprise are complex and diverse, and the status of multiple business activities within different periods and scopes needs to be analyzed at the same time. Therefore, we recommend that you create multiple derived metrics for one type of business activity at the same time. For more information about how to create multiple derived metrics at the same time, see Create multiple derived metrics at the same time. For more information about how to create a single derived metric, see Create a single derived metric.

Create multiple derived metrics at the same time

  1. Select an operation type.
    1. On the Derived Metric page, click the Create icon. In the Select Operation Type dialog box, select Multiple Derived Metrics for Type.
    2. Click OK.
  2. Create a model that is used to generate multiple derived metrics at the same time.
    1. Select atomic metrics, modifiers, and periods and configure the order in which the atomic metrics, modifiers, and periods are displayed in the render tree.
      Generate Derived Metrics
      Section Description
      1 In this section, configure the order in which atomic metrics, modifiers, and periods are displayed in the render tree. The render tree is displayed in section 3.
      2 In this section, select atomic metrics, modifiers, and periods. Then, you can view the derived metrics to be created in section 3.
      Note
      • If the existing atomic metrics, modifiers, or periods do not meet your business requirements, you can click Create on the right side of Atomic Metric, Modifier, or Period to create atomic metrics, modifiers, or periods based on your business requirements.
      • Each derived metric is composed of an atomic metric, a period, and one or more modifiers.
      3 In this section, a render tree is displayed to show all of the derived metrics to be created at the same time. A derived metric that is displayed in the render tree is in one of the following states:
      • Status of a derived metric: indicates that the derived metric does not exist in the current business process.
      • Success: indicates that the derived metric already exists in the current business process. When you generate the derived metrics, the system filters out the existing derived metrics in the current business process.
      4 In this section, you can switch the display mode of the render tree. For example, you can zoom in, zoom out, or center the render tree or present the render tree in full screen.
    2. Click Generate Derived Metrics.
  3. Generate derived metrics at the same time.
    1. Optional:Associate dimension tables with the derived metrics.
      You can select dimension tables and fields in the dimension tables to associate analysis dimensions with the derived metrics.
      Note By default, the selected fields are associated with all of the derived metrics to be created.
      Associate dimension tables with the derived metrics
      1. In the (Optional) Associate Dimension Table step of the Generate Derived Metrics dialog box, select a dimension table that you want to associate with the derived metrics, select the fields in the dimension table, and then click Add. To associate multiple dimension tables with the derived metrics, repeat this step.
      2. Click Next.
    2. Select the derived metrics that you want to generate.
      1. Select derived metrics from the created metric model based on your business requirements. By default, all of the derived metrics in the metric model are selected.
        Note The system filters out the derived metrics that already exist in the current business process.
        Select the derived metrics that you want to generate
      2. Click Create to create the derived metrics.

        After a derived metric is created, the state of the metric in the render tree changes from Status of a derived metric toSuccess.

    3. View the created derived metrics.
      You can view the information about the created derived metrics in the Create Derived Metric step. The information includes metric codes and states. View the created derived metrics

Create a single derived metric

  1. Select an operation type.
    1. On the Derived Metric page, click the Create icon. In the Select Operation Type dialog box, select Derived Metric for Type.
    2. Click OK.
  2. Create a derived metric.
    1. Configure business logic.
      Business Logic
      Parameter Description
      Period The period of time for the statistical analysis of a business activity. Examples: last day and last week.

      Select a period from existing periods. For more information about how to create a period, see Period.

      Modifier The scope for the statistical analysis of a business activity. Examples: online and offline.

      Select modifiers from existing modifiers. For more information about how to create a modifier, see Modifier.

      Atomic Metric The atomic metric that is used to define a criterion and computing logic for the statistical analysis of the business activity. Example: order amount.

      Select an atomic metric from existing atomic metrics. For more information about how to create an atomic metric, see Atomic metric.

    2. Configure basic information.
      Basic Information
      Parameter Description
      Business Process The business process to which the derived metric belongs. This parameter is used to determine the type of the business activity.
      Metric Code The unique identifier that the system generates for the derived metric.
      Display Name The display name of the derived metric. You can click Intelligent Recommendation on the right side of Display Name to generate a display name in the Period_Modifiers_Atomic metric name format. The generated display name helps you understand the statistics of the derived metric in an efficient manner.
      Note The Intelligent Recommendation button appears only after you configure the Period, Modifier, and Atomic Metric parameters in the Business Logic section.

      The display name can contain letters, digits, underscores (_), ampersands (&), and parentheses () and must start with a letter or digit.

      Name The name of the derived metric.

      The name can contain letters, digits, underscores (_), and ampersands (&) and must start with a letter or digit.

      Description The description of the derived metric.
  3. Click Save. The derived metric is created.

Manage a derived metric

In the left-side navigation tree of the Derived Metric page, you can double-click a business process to view all of the derived metrics that belong to the business process and perform the following operations. View derived metrics
  • Edit a derived metric.
    Find the derived metric that you want to edit and click Edit in the Actions column to go to the configuration tab of the derived metric. On the configuration tab, you can modify the information about the derived metric. The information includes Period, Modifier, and Business Process.
    Note If the derived metric is associated with an aggregate table, you cannot modify Period and the fields that are associated with the derived metric and used in the aggregate table. If you want to modify Period and the fields, you must disassociate the fields from the aggregate table first.
  • Delete a derived metric.
    Find the derived metric that you want to delete and click Delete in the Actions column.
    Note If an aggregate table is associated with the derived metric, you must disassociate the aggregate table from the derived metric before you can delete the derived metric.

What to do next

After derived metrics are created, you can organize the statistics of the derived metrics that are of the same period and the same dimensions in the same data domain in an aggregate table. The name of a derived metric and the name of a field that is associated with the derived metric form the name of a field in the aggregate table. This aggregate table can be used in subsequent business queries, OLAP analysis, and data distribution. For more information about how to associate an aggregate table with a derived metric, see Create an aggregate table.