Dimension Design - Professional SQL Server Analysis Services 2005 with MDX - page 189

Assume you want to change the All level of the Geography hierarchy to "All
Countries." The following steps show you how to do this:
1. Go to the Dimension Structure view of the Dimension Designer.
2. Click on the Geography hierarchy in the Hierarchies and Levels
pane.
3. The properties window now shows all the properties of this hierarchy.
The first property is AllMemberName and it displays no value. Add a
value by typing All Countries in the text entry box to the right of
AllMemberName.
4. Deploy the project once again.
5. After the deploy is successful the Dimension Designer automatically
switches to the Browser tab. In the Browser tab BIDS requests you
to reconnect to retrieve the latest data from the Analysis Services in-
stance. Click on the Reconnect link shown in the Browser.
You can now see that the All level of the Geography hierarchy has changed to
All Countries, as shown in Figure 5-19 . You can also see in the figure that the
All Countries level has been expanded to show all members in the next level.
Figure 5-19
When you expand the All Countries level, the following MDX query is sent to
the Analysis Services instance to retrieve the members in the next level:
WITH MEMBER [Measures].[-DimBrowseKey 0-] AS
'[Dim
Geography].[Geography].currentmember.properties ("key0",