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 statistical data 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.
An atomic metric determines a criterion and computing logic for the statistical analysis of a business activity. For example, you can use the total number of orders that are placed 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.
NoteA derived metric can contain one or more modifiers.
A period defines the time range within which you want to collect statistical data. 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 statistical data 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 statistical data on
the total number of orders that are placed in online fresh shops on a calendar dayorthe total number of orders that are placed in online and offline fresh shops on a calendar day.