A dimension represents an object for statistical analysis, typically an objectively existing entity. Dataphin adheres to Ralph Kimball's Dimensional Modeling principles to standardize the existence and uniqueness of business entities, or master data, from a top-level perspective. These dimensions, along with their combinations, define the granularity for statistics of derived metrics. For instance, in a transaction procedure analysis, dimensions such as buyer, seller, product, and time describe the transaction environment. This topic provides an overview of logical dimension tables.
Prerequisites
Creating a logical dimension table requires the creation of business entities to be completed. 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 various types of logical dimension tables, which can be created via the configuration page. The types and their descriptions are as follows:
Logical Table Type | Description |
A standard logical dimension table characterizes entity objects by detailing their various attributes. For instance, a member logical dimension table may contain information like member names, IDs, and email addresses. | |
A hierarchical logical dimension table is a type of dimension table that features a hierarchical structure. For instance, a regional hierarchical logical dimension table may contain levels of data ranging from country and province to city and district. | |
An enumeration logical dimension table standardizes enumeration values and lists them to identify enumeration dimension objects. For example, it can be a code table with a key-value structure, like one for gender. | |
A virtual logical dimension table standardizes dimension objects lacking a specific business entity or definable data range logic. Examples include visitor and URL. |