Logical Dimension Table-Dataphin(Dataphin)-阿里云帮助中心

A dimension represents an object for statistical analysis, typically an objectively existing entity. Dataphin follows Ralph Kimball's dimensional modeling principles to standardize the existence and uniqueness of business entities (master data) from a top-level perspective. Dimensions and their combinations define the statistical granularity for derived metrics. For example, in transaction analysis, dimensions such as buyer, seller, product, and time describe the transaction environment.

Prerequisites

Before you create a logical dimension table, you must create business entities. For more information, see Create and manage business entities.

Logical Dimension Table Configuration Entry

On the Dataphin home page, click Development on the top menu bar.
Use the operation guide shown below to navigate to the Logical Dimension Table configuration page.

Configure Logical Dimension Table

Dataphin supports the following types of logical dimension tables:

Logical Table Type	Description
Create a General Logical Dimension Table.	A standard logical dimension table describes entity objects by listing their attributes. For example, a member dimension table may include member names, IDs, and email addresses.
Create a hierarchy dimension logical table.	A hierarchical logical dimension table organizes dimensions into a multi-level hierarchy. For example, a regional hierarchy table may include levels such as country, province, city, and district.
Create an enumeration logical dimension table.	An enumeration logical dimension table standardizes and lists enumeration values to identify enumeration dimension objects. For example, a gender code table with a key-value structure.
Create a virtual dimension logical table.	A virtual logical dimension table standardizes dimension objects that lack a specific business entity or definable data range logic. Examples include visitor and URL.