An enumeration logical dimension table lists and standardizes enumeration values to identify enumeration dimension objects, such as a key-value lookup table for gender.
Prerequisites
An enumeration business object is created. Create and manage business entities.
Procedure
Step 1: Create an enumeration logical dimension table
-
On the Dataphin home page, in the top menu bar, choose Develop > Data Development.
-
In the top menu bar, select a Project. If you are in Dev-Prod mode, also select an Environment.
-
In the navigation pane on the left, choose Standardized Modeling > Logical Dimension Table.
-
In the logical dimension table list on the right, click the
New icon. -
In the Create Logical Dimension Table dialog box, configure the parameters.
Parameter
Description
Business Object
Select Enumerable Object.
Table Type
When Enumerable Object is selected, the table type defaults to Enumeration Logical Dimension Table and cannot be modified.
Data Section
Defaults to the business unit of the project. Not modifiable.
Data Domain
Select any subject area within the business unit.
Data Recency
Defines the scheduling type for the logical dimension table task in production. Defaults to T+1 (daily task).
Logical Table Name
Auto-populated by Dataphin. Naming convention:
{business unit name}.dim_enum_custom_name.Custom name rules:
-
Must contain only letters, digits, and underscores (_).
-
Cannot exceed 100 characters.
Display Name
Naming rules:
-
Cannot exceed 128 characters.
-
Can contain any characters.
Description
Brief description of the table. Maximum 1,000 characters.
-
-
Click Next.
Step 2: Configure enumeration values
-
In the Enumeration Logical Dimension Table - Calculation Logic dialog box, configure the enumeration values.
Enumeration values: Key-value lookup table pairs separated by commas. Example:
F,Female M,Male -
Click OK.
Step 4: Save and submit the logical table
On the logical dimension table tab, click Submit, enter remarks, and click OK And Submit.
What to do next
In Dev-Prod mode, publish the logical table to production. Manage publish tasks.
After publishing to production, view and manage the logical table task in the Operation Center. For more information, see Operation Center.