Create a logical dimension table for enumeration

An enumeration logical dimension table lists and standardizes enumeration values to identify enumeration dimension objects, such as a key-value lookup table for gender. This topic describes how to create and configure an enumeration logical dimension table.

Prerequisites

An enumeration business object must be created. For more information, see Create and manage business entities.

Procedure

Step 1: Create an enumeration logical dimension table

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

2. In the top menu bar, select a Project. If you are in Dev-Prod mode, also select an Environment.

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

4. In the logical dimension table list on the right, click the New icon.

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

   Parameter	Description
   Business Object	Select Enumerable Object.
   Table Type	For the business object, Enumerable Object is selected. The table type is Enumeration Logical Dimension Table. This cannot be modified.
   Data Section	The business unit associated with the project is used by default. This cannot be modified.
   Data Domain	You can select any subject area within the business unit.
   Data Recency	Data recency defines the scheduling type for the logical dimension table task in the production environment. The default data recency for an enumeration logical dimension table is T+1 (daily task).
   Logical Table Name	Dataphin automatically populates the logical table name. The naming convention is {business unit name}.dim_enum_custom_name. The naming rules for the custom name are as follows: Must contain only letters, digits, and underscores (_). Cannot exceed 100 characters.
   Display Name	The naming rules are as follows: Cannot exceed 128 characters. Can contain any characters.
   Description	Enter a brief description of the enumeration logical dimension table. The description must be 1,000 characters or less.

6. Click Next.

Step 2: Configure enumeration values

1. In the Enumeration Logical Dimension Table - Calculation Logic dialog box, configure the enumeration values.

   Enumeration values: The enumeration values use a key-value lookup table structure. Use a comma (,) to separate the key and the value. For example:

   F,Female
   M,Male

2. Click OK.

Step 4: Save and submit the logical table

On the current logical dimension table tab, click Submit. Enter remarks, and then click OK And Submit.