Dataphin:Step 1: Develop a logical dimension table

Background information

Once you have developed and submitted the product logical dimension table, the next step is to develop and submit the customer logical dimension table. The development process for both tables is identical. This topic will focus on the creation of the product logical dimension table as an illustrative example.

Step 1: Create a logical dimension table

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

2. Follow the steps shown in the figure below to access the Create Logical Dimension Table dialog box.

   

3. In the Create Logical Dimension Table page, set the necessary parameters as follows:

   Parameter	Description
   Business Object	Select the Product business object.
   Data Timeliness	The default setting is Offline T+1.
   Chinese Name	Input Product Logical Dimension Table as the name.
   Description	Provide a concise description of the logical dimension table, such as Product Logical Dimension Table.

4. Single click OK to confirm.

Step 2: Configure logical table fields

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

2. In the Add Fields From Table dialog box, select the dataphin_tutorial.product source table and include fields such as product_name, product_category, and product_price.

   Note

   Note: The primary key and associated dimension foreign key fields are automatically included and need not be manually selected.

3. Single click Add to proceed.

4. 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 as detailed below:

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

3. Single click OK to confirm the selections.

4. Drag the selected data source fields into the computation logic column.

5. Single click Save And Next to continue.

Step 4: Configure logical table field constraints

1. On the constraint configuration page, the system defaults to a Strong Rule for the Rule Strength, which requires no additional setup.

2. Single click Save And Next to proceed.

Step 5: Configure ordinary logical dimension table schedule

1. On the Schedule & Parameter Configuration page, adhere to the system's default settings, as no additional configuration is required.

2. Single click Save And Submit to finalize the setup.

Step 5: Save and submit the logical table

1. Upon selecting Save And Submit, the system will validate the configuration of the Table Structure, Computation Logic, Schedule Dependency, and Runtime Parameter. Should any checks fail, you can examine the Check Results to identify and address configuration issues.

2. Once all checks are passed, single click OK And Submit to complete the submission process.