1. Within the Module 07 database in Analysis Manager, expand the Shared Dimensions folder, right-click Store, and then click Edit.
2. Click the Data pane and then notice the two Mexico members.
The Store dimension does not organize Mexico into states or provinces. Therefore, the member Mexico repeats within the Store State level to ensure that the dimension is balanced.
3. In the dimension tree, click the Store State level, click the Advanced tab of the properties pane, click the Hide Member If property, and then click Parentłs name.
4. Within the Data pane, expand the Store dimension, and then notice the member names at the Store Name level.
Currently, the member names at the Store Name level do not present descriptive information. An analyst may not know that Store 9 was located in Mexico City. You will update the member name to include the city name in addition to the store name.
5. Click the Store Name level, click the Basic tab of the properties pane, and change the Member Name Column to the following expression:
"dbo"."store"."store_city" + ' - ' + "dbo"."store"."store_name"

6. Click the Tools menu, and then click Process Dimension.
7. Save the dimension, rebuild the dimension structure, close the Process dialog box, and then close the Dimension Editor.