I typically style the
lowest level in the Date hierarchy as Date; calendar, fiscal, and
perhaps other date hierarchies would typically share Date as a common
lowest level, and thus I give it a name that will serve all equally well.

Having handled the Calendar.Time
member properties that will be created in our cube, let's do something
similar for the Store dimension. The Store dimension consists of
member naming that makes intuitive sense, as we will see upon our initial cube
generation, so we will simply swap the name for the id number that previously
occupied the Store member level.

34.
Right-click the store_id
dimension.

35.
Select Rename from the
context menu, and type in Store.

36.
Click the Advanced tab
in the Properties pane.

37.
Select the All Caption
property.

38.
Change the All Caption
property to read "All Stores."

39.
Drag the store_id field
from the store table over to drop onto the Store dimension in the
cube tree.

40.
Right-click the store_id
level that appears.

41.
Select Rename from the
context menu, and type in Store.

42.
Click the Basic tab in
the Properties pane.

43.
Select the Member Name
Column property.

44.
Click the ellipses button ("..").

The Select Column
dialog appears.

45.
Select the store_name
column by clicking.

46.
Click OK.

47.
Press the Enter key.

The Properties
pane for the new Store level, with the modification we have put into
place, should appear as shown below:

Illustration 40:
The Modified Properties, Store Level Member of the Store Dimension