Manage logical dimension/fact tables - Dataphin - Alibaba Cloud Documentation Center

The logical dimension/fact table list is a collection of the logical dimension and fact tables that you create in Dataphin. This list displays basic information about the tables and provides options for you to view and manage them. This topic describes the management features available on the logical dimension/fact table list.

Managing dimensions and logical fact tables

In the top menu bar of the Dataphin home page, choose Development > Data Development.
In the navigation pane on the left, choose Standardized Modeling > Logical Dimension Table/Logical Fact Table.

At the bottom of the logical dimension table or logical fact table list, click Logical Dimension/Fact Table List. On the list tab that opens, you can perform table management operations.

Section	Description
①Search and filter area	Enter the Chinese or English name of a logical table to search for it. You can also select My Development to quickly filter the list. Click Filter to expand the filter area. The following filter options are available. Logical Table Type: Select one or more table types. Options include regular dimension logical table, hierarchical dimension logical table, enumeration dimension logical table, virtual dimension logical table, event fact logical table, process fact logical table, and snapshot fact logical table. Data Domain: Filter tables by subject area. You can select one or more subject areas. The list contains all subject areas in the current module. Schedule Type: Select one or more schedule types. Options include normal scheduling, dry-run, and skip execution. Published: Filter tables based on whether they are published. Development Owner: Filter tables by developer. You can select one or more users and search by username keyword. If you select My Development, this filter includes your account. Created By: Filter tables by creator. You can select one or more users. Data Timeliness: Filter tables by data timeliness. You can select daily (T+1), hourly (T+h), or minute (T+m). Development Status: Select one or more development statuses. Options include Submitting, Submission Successful, and Submission Failed. Last Submission Status: Select one or more recent submission statuses. Options include Submitting, Submission Successful, and Submission Failed. Conditional Scheduling: Filter tables based on whether conditional scheduling is enabled. Operation Owner: Filter tables by O&M owner. You can select one or more users and search by username keyword. If you select My O&M, this filter includes your account. Tag: Select one or more tag values to filter by.
②Function area	View Batch Operation Records: Click View Batch Operation Records to open the Batch Operation Records panel. Click the Submit or Other Operations tab to view the corresponding batch operation records. Create Logical Table: Click Create Logical Table and select Logical Dimension Table or Logical Fact Table. For more information, see Logical dimension table and Create a logical fact table. Select list display content: Click the icon to select the fields to display in the list. Refresh: Click the icon to refresh the list based on the selected filter conditions.
③Dimension/real-time logical table list	The dimension/real-time logical table list displays information such as logical table name, subject area/business entity, data timeliness, development status, last submission status, current lock holder, and developer. You can perform management operations on the tables in the Actions column. For more information, see Operations supported by the logical dimension/fact table list.
④Batch operations	In the batch operations area, perform batch operations on multiple tables. For more information, see Batch operations supported by the logical dimension/fact table list.

Operations supported by the logical dimension/fact table list

The following operations are supported in the Actions column of the logical dimension/fact table list:

Operation	Description
Open logical table	Click the icon in the Actions column of the target logical table to open the tab for that logical table. On the current logical table tab, you can perform operations such as editing and configuration.
Get lock	Click the icon in the Actions column of the target logical table to obtain the edit lock and lock the logical table. Note After you enable the exclusive edit lock in System Settings > Platform Settings > Development Platform, you can go to the editing area to manually release the edit lock for the current table.
Transfer Developer Ownership	Change the developer of the current logical dimension or fact table. Click the icon in the Actions column of the target logical table to open the Change Owner To Developer dialog box. In the Change Owner To Developer dialog box, select the target user and click OK.
Go to publish	In the Actions column of the target logical table, click the icon and select Go To Publish. You are redirected to the Publish Center, where you can publish the logical table. For more information, see Manage publish nodes.
Go to O&M	In the Actions column of the target logical table, click the icon and select Go To O&M. You are redirected to the Operation Center, where you can perform O&M on the logical table. For more information, see Operation Center. Note You can perform O&M only on published logical tables.
Unpublish	Unpublish a published logical table. In the Actions column of the target logical table, click the icon and select Unpublish. In the Unpublish dialog box, enter a Remark of up to 128 characters. Click OK And Submit.
Delete	Delete a logical table that is in a draft state. In the Actions column of the target logical table, click the icon and select Delete. In the Delete dialog box, enter a Remark and click Confirm and submit. Note If the Development environment can delete published objects option in Development Platform Settings > Unpublish and Delete is disabled for the current tenant, you cannot delete a draft object in a Dev-prod project if a corresponding production object exists.
Unpublish and delete	Unpublish and delete a published logical table. In the Actions column of the target logical table, click the icon and select Unpublish And Delete. In the Unpublish And Delete dialog box, enter a Remark of up to 128 characters. Click OK And Submit. Note If the logical table has downstream dependency nodes, the unpublish and delete operation fails. Nodes that are published to the production environment are only unpublished, not deleted. After the unpublish and delete operation is submitted, go to the to-be-published list to publish the object to the production environment. If the Development environment can delete published objects option in Development Platform Settings > Unpublish and Delete is disabled for the current tenant, you cannot unpublish and delete a published object in a Dev-prod project.

Batch operations supported by the logical dimension/fact table list

Operation	Description
Lock	Select multiple logical tables and click Lock at the bottom of the list to obtain edit locks for the selected logical tables in a batch. Note After you enable the exclusive edit lock in System Settings > Platform Settings > Development Platform, you can go to the editing area to manually release the edit lock for the current table.
Submit	Select multiple logical tables and click Submit at the bottom of the list to submit the selected logical tables in a batch. You can view the submission status and details in the Last Submission Status column of the list. You can also click View Batch Operation Records and view the details on the Submit tab of the Batch Operation Records panel.
Unpublish	Select multiple logical tables and click Unpublish at the bottom of the list. In the Batch Unpublish dialog box, enter a Remark and click OK And Submit. Note After the operation is submitted, go to the to-be-published list to publish the object to the production environment. If the selected logical tables have downstream dependency nodes, the unpublish operation fails.
Unpublish and delete	Select multiple logical tables, click the icon at the bottom of the list, and select Unpublish And Delete. In the Batch Unpublish And Delete dialog box, enter a Remark and click OK And Submit. Note If the logical tables have downstream dependency nodes, the unpublish and delete operation fails. Nodes that are published to the production environment are only unpublished, not deleted. After the unpublish and delete operation is submitted, go to the to-be-published list to publish the object to the production environment. If the Development environment can delete published objects option in Development Platform Settings > Unpublish and Delete is disabled for the current tenant, you cannot unpublish and delete published objects in a Dev-prod project.
Batch modify tags	Replace or append tags for multiple dimension or fact tables. You can select tasks individually in the offline computing task list, or select the check box next to Select at the bottom of the page to select all tasks. Click the icon at the bottom of the page and select Batch Modify Tags. In the Batch Modify Tags dialog box, select a Modification Type and a Tag. If you select Replace, the system clears the existing tags from the selected tables and applies the tags that you select. If you select Append, the system keeps the existing tags on the selected tables and adds the tags that you select. Click OK to update the tag.
Change development owner	Select multiple logical tables, click the icon at the bottom of the list, and select Change Development Owner. In the Batch Change Development Owner dialog box, select the target user and click OK.
Run configuration	Select multiple logical tables, click the icon at the bottom of the list, and select Run Configuration. In the Batch Run Configuration dialog box, configure the settings. For more information, see Logical table run configuration.
Parameter configuration	Select multiple logical tables, click the icon at the bottom of the list, and select Parameter Checking. In the Batch Parameter Configuration dialog box, configure the settings. For more information, see Logical table run parameter configuration.
Dependency configuration	Select multiple logical tables, click the icon at the bottom of the list, and select Dependency Configuration. In the Batch Dependency Configuration dialog box, configure the settings. For more information, see Configure upstream dependencies for logical tables.