Dataphin:Step 2: Develop a logical fact table

Step 1: Create a logical fact table

1. On the Dataphin home page, click Develop in the top menu bar.

2. Follow the figure below to open the Create Logical Fact Table dialog box.

   

3. On the Create Logical Fact Table page, configure the following parameters.

   Parameter	Description
   Business Activity	Select the Order Purchase business object.
   Data Timeliness	Defaults to Offline T+1.
   Chinese Name	Enter Order Purchase Logical Fact Table.
   Description	Enter a brief description, such as Order Purchase Logical Fact Table.

4. Click OK.

Step 2: Configure logical table fields

1. On the Table Structure page, click Import From Table.

2. In the Add Field From Table dialog box, select the dataphin_tutorial.orders table, and add the order_time and payment_amount fields.

   Note

   Primary keys and associated dimension fields are included automatically.

3. Click Add.

4. On the Table Structure page, click Save And Next.

Step 3: Configure logical table computation logic

1. On the computation logic page, click Source Configuration to open the Source Configuration dialog box.

2. In the Source Configuration dialog box, click Add Source Object and configure the following parameters.

   Parameter	Description
   Source Table Name	Select the dataphin_tutorial.orders source table.
   Associated Primary Key Field	Select the order_id field.

3. Click OK.

4. Drag the configured data source column to a logical computed column.

5. Click Save And Next.

Step 5: Configure logical fact table schedule

1. On the Schedule & Parameter Configuration page, keep the default settings.

2. Click Save And Submit.

Step 5: Save and submit logical table

1. Click Save And Submit. The system validates Table Structure, Computation Logic, Schedule Dependency, and Runtime Parameter configurations. Review the Check Results and verify your settings.

2. After all checks pass, click OK And Submit.