You can register metric fields from physical tables to logical aggregate tables for data analysis. This topic describes how to create registered metrics for a logical aggregate table.
Prerequisites
You have created derived metrics. For more information, see Create derived metrics.
Procedure
On the Dataphin homepage, click Develop in the top navigation bar. The Development page appears by default.
In the top navigation bar, select a project (In Dev-Prod mode, you need to select an environment).
In the left-side navigation pane, choose Standardized Modeling > Logical Summary Table.
In the logical aggregate table list, click the target logical aggregate table. On the Logical Summary Table page, click the Registered Metric tab.
On the Registered Metric tab, click Create Registered Metric.
On the Create Registered Metric configuration wizard page, complete the following operations.
On the Select Data Source page, configure the following parameters.
Section
Parameter
Description
Select Source Data
Source Table
Select the data source for the registered metric.
We recommend that you select production data (data that is not generated by a Dev project or data domain). This prevents operation failures when you update to production scheduling and O&M because the object does not exist in the production environment, or failures in automatic dependency parsing. If you select production data, we recommend that you specify the project or data domain prefix in your code to ensure that the fact table without a primary key passes the standardization check when submitted.
Statistical Granularity
The time validity of the statistical granularity is consistent with that of the logical aggregate table and cannot be modified.
You need to map the primary key fields of the statistical granularity to the fields of the source table.
Subject Area And Aggregate Table
Data Domain
Select the subject area to which the registered metric belongs.
Aggregate Table
The aggregate table to which the metric is added is selected by default and cannot be modified.
You need to select fields from the source table to register to the logical aggregate table. You also need to configure the English name, Chinese name, metric definition, atomic metric, statistical period, and business filter parameters for the metric.
English Name: Only English letters, digits, and underscores (_) are supported. The name must start with a letter and cannot exceed 64 characters.
Chinese Name: All characters are supported. The name cannot exceed 128 characters.
Metric Definition: Enter the metric definition, which describes the definition and processing logic of the metric in natural language to help business personnel understand the metric processing logic. For example:
Average customer transaction value in the last month = Total sales in the last month / Total number of orders in the last month. The metric definition cannot exceed 1,000 characters.
Click Next. On the Complete Metric Information page, configure the parameters.
Parameter
Description
Data Type
Select the data type of the registered metric.
Measurement Unit
Select the measurement unit of the registered metric.
Business Owner
Select the business owner of the registered metric.
Description
Enter a brief description of the registered metric.
After you complete the configuration, click OK.