Create registered metrics

Procedure

1. On the Dataphin homepage, click Develop in the top navigation bar. The Development page appears by default.

2. In the top navigation bar, select a project (In Dev-Prod mode, you need to select an environment).

3. In the left-side navigation pane, choose Standardized Modeling > Logical Summary Table.

4. In the logical aggregate table list, click the target logical aggregate table. On the Logical Summary Table page, click the Registered Metric tab.

5. On the Registered Metric tab, click Create Registered Metric.

6. On the Create Registered Metric wizard page, complete the following configurations.

   1. 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 not generated by a Dev project or data domain) to avoid operation failures during production scheduling and O&M caused by missing objects, or failures in automatic dependency parsing. If you select production data, specify the project or data domain prefix in your code to ensure the fact table without a primary key passes the standardization check upon submission.
      	Statistical Granularity	The statistical granularity shares the same time validity as the logical aggregate table and cannot be modified. Map the primary key fields of the statistical granularity to the corresponding fields in the source table.
      Subject Area And Aggregate Table	Data Domain	Select the subject area for the registered metric.
      	Aggregate Table	The aggregate table is selected by default and cannot be modified. Select fields from the source table to register to the logical aggregate table, and configure the English name, Chinese name, metric definition, atomic metric, statistical period, and business filter 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: A natural-language description of the metric's definition and processing logic, to help business users understand how the metric is calculated. 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.

   2. 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.

7. After you complete the configuration, click OK.