All Products
Search
Document Center

Dataphin:Create a virtual dimension logical table

Last Updated:Jun 23, 2026

A virtual dimension logical table standardizes dimension objects that have no specific business entity or definable timestamp range, such as visitors and URLs.

Prerequisites

You must create a virtual business object. For more information, see Create and manage business entities.

Step 1: Create a virtual dimension logical table

  1. On the Dataphin home page, choose Develop > Data Development from the top menu bar.

  2. In the top menu bar, select a Project. If your project uses the Dev-Prod mode, also select an Environment.

  3. In the navigation pane on the left, choose Standard Modeling > Logical Dimension Table.

  4. In the list of logical dimension tables on the right, click the image New icon.

  5. In the Create Dimension Logical Table dialog box, configure the parameters.

    Parameter

    Description

    Business Object

    Select Virtual Object.

    Table Type

    If you select Virtual Object for Business Object, the table type is automatically set to Virtual Dimension Logical Table. This setting cannot be changed.

    Data

    Defaults to the business unit associated with the project and cannot be changed.

    Data Domain

    In the Data section, you can select all subject areas.

    Data Timeliness

    Specifies the scheduling type for the logical table node in the production environment. Defaults to T+1 (daily node) for virtual dimension logical tables.

    Logical Table Name

    Automatically populated and cannot be changed. The naming convention is {Business unit name}.dim_virtual_Custom name.

    The custom name must follow these rules:

    • It can contain letters, digits, and underscores (_).

    • It cannot exceed 64 characters in length.

    Chinese Name

    The name must follow these rules:

    • It cannot exceed 128 characters in length.

    • It can contain any characters.

    Description

    Enter a brief description of the logical dimension table.

  6. Click OK.

Step 2: Save and submit the virtual dimension logical table

Follow the instructions in the figure to submit the virtual dimension logical table.

image

What to do next

If your project uses the Dev-Prod mode, you must publish the logical table to the production environment. For more information, see Manage publish tasks.

After the logical table is published to the production environment, you can view and manage the corresponding node in the Operation Center. For more information, see Operation Center.