Task 1. Create a Reference Table
In this task, you will create the Reftab_CustomerTier_Codes reference table to standardize the valid values for the customer tier data.
1. Click New > Reference Table.
The New Reference Table wizard appears.
2. Select Use the reference table editor.
3. Click Next.
4. For each column you want to include in the reference table, click the Add New Column icon and configure the column properties for each column.
Add the following column names: CustomerID, CustomerTier, and Status. You can reorder the columns or delete columns.
5. Enter an optional description and set the default value to 0.
The Analyst tool uses the default value for any table record that does not contain a value.
6. Click Next.
7. In the Name field, enter Reftab_CustomerTier_Codes.
8. In the Folders section, select the Customers folder in the tutorial project.
9. Click Finish.
The reference table appears in the Design workspace.
10. From the Actions menu, select Add Row to populate each reference table column with the following four values:
CustomerID = LA1, LA2, LA3, LA4
CustomerTier = 1, 2, 3, 4.
Status= Active, Inactive