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.
For information about how to create an atomic metric, see Atomic metric.
For information about how to create a modifier, see Modifier.
For information about how to create a period, see Period.
For information about how to create a derived metric, see Derived metric.
FAQ
Why am I unable to select a custom common layer when I create a metric?
Metrics belong to the data warehouse summary (DWS) layer or the application data service (ADS) layer. You cannot select another layer when you create a metric.
In which scenario I can associate metrics with data in a table?
When you create an aggregate table or application table, you can import metrics to create fields for the table based on the metrics.
Why can I select an atomic metric when I create a derived metric at the application layer even if I can create an atomic metric only at the common layer?
An atomic metric is generated based an actual business activity and is an abstract metric concept from a business process. For example, amount of an order is an atomic metric.
A derived metric is composed of an atomic metric, a period, and one or more modifiers. Derived metrics at the application layer are derived from atomic metrics at the common layer.