Dataphin:Step 2: Develop a logical fact table

Step 1: Create a logical fact table

1. Navigate to the Dataphin home page and single click the Develop menu bar at the top.

2. Refer to the instructions in the figure below to access the Create Logical Fact Table dialog box.

   

3. In the Create Logical Fact Table page, set the necessary parameters.

   Parameter	Description
   Business Activity	Choose the Order Purchase business object.
   Data Timeliness	By default, it is set to Offline T+1.
   Chinese Name	Input Order Purchase Logical Fact Table.
   Description	Provide a concise description of the logical fact table, such as Order Purchase Logical Fact Table.

4. Single click OK.

Step 2: Configure logical table fields

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

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

   Note

   Note: Primary keys and associated dimension fields are automatically included and need not be manually selected.

3. Single click Add.

4. Back on the Table Structure page, single click Save And Next.

Step 3: Configure logical table computation logic

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

2. Within the Source Configuration dialog box, single click Add Source Object and set the source parameters.

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

3. Single click OK.

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

5. Single click Save And Next.

Step 5: Configure logical fact table schedule

1. On the Schedule & Parameter Configuration page, retain the system's default settings.

2. Single click Save And Submit.

Step 5: Save and submit logical table

1. Single click Save And Submit. The system will validate the configurations of the Table Structure, Computation Logic, Schedule Dependency, and Runtime Parameter. Review the Check Results for any issues, verify the configuration details, and finalize the setup.

2. Once all checks are successful, single click OK And Submit.