In this exercise, you will learn to create Attributes. Take the following steps:

1. Open your new MicroStrategy Essentials project and go to the Schema Objects | Attributes folder.

2. Right-click New | Attribute.
3. The Attribute Editor will open the three nested windows. In the innermost, the For Expression must be defined. Select the LU_COUNTRY table.
4. Double-click on the COUNTRY_ID column. Leave Automatic mapping | OK.
5. You should now be on the second window, the Form Editor. Verify that the lookup (in bold) table is LU_COUNTRY. Which other table is selected? If you had selected the Manual method, none of the tables would have been selected and you must manually check which should be used.
6. As shown in the following screenshot, verify that the form category is ID and the data type is Number | OK:

7. You should now be on the outermost window. So far only the ID form has been created. You will now add a description for this Attribute. Click on New to add a new Attribute form, shown as follows:

8. Using the same source, the (LU_COUNTRY) table, define an expression for COUNTRY_NAME. Repeat steps 4 to 6, but this time for the text field that will be used as a description for Country. Your Attribute Editor window should show both ID and DESC forms created, shown as follows:

9. Save and Close. Leave the default object name as Country | Save.
10. Repeat the process to create a Region Attribute with the following information:
    • Source table / lookup table: LU_REGION
    • Attribute forms: ID (REGION_ID) and DESC (REGION_NAME)
    • Parent: Country

11. To assign the region parent go to the Parents tab | Add | select Country Attribute | OK. The relationship type and table should look like the following:

12. Save and Close. Leave the default object name as Region | Save.
13. Repeat the process to create a Call Center Attribute with the following information:
    • Source table / lookup table: LU_CALL_CTR
    • Attribute forms: ID (CALL_CTR_ID) and DESC (CENTER_NAME)
    • Parent: Region

14. Save and Close. Leave the default object name as Call Ctr | Save.
15. Update Schema. This finalizes the exercise.