DataWorks Data Modeling provides the Data Metric feature, which allows you to establish a unified metric system and design and generate aggregate tables.

Metric system

Metrics collect statistics on the business characteristics of an enterprise. A metric reflects the status of a business activity. Metrics are classified into atomic metrics and derived metrics. Derived metrics are related to modifiers and periods. A derived metric is composed of an atomic metric, a period, and one or more modifiers. Derived metric
  • An atomic metric determines a criterion and a computing logic for the statistical analysis of a business activity. For example, you can use the total number of orders as an atomic metric.
  • A modifier defines the scope of a business activity. For example, you can use online fresh shops and offline fresh shops as modifiers.
    Note A derived metric can contain one or more modifiers.
  • A period defines the time range within which you want to collect statistics. For example, you can use a calendar day as a period.
  • A derived metric is composed of an atomic metric, a period, and one or more modifiers. A derived metric is used to collect statistics on the values of an atomic metric within a specific period based on specific dimensions and business conditions. A derived metric reflects the status of a business activity of an enterprise. For example, you can create a derived metric to collect statistics on the total number of orders that are placed in online fresh shops on a calendar day or the total number of orders that are placed in online and offline fresh shops on a calendar day.

Aggregate table

For more information about how to establish a metric system and create an aggregate table, see Data Metric.