Databases Reference
In-Depth Information
Figure 5-20
Expand the members of United States to see the member properties of the
States and Cities under United States. The member properties of a member
are also retrieved with the help of an MDX query. For example, when you
want to see all the cities in Alabama, the following MDX query is sent to the
server:
WITH MEMBER [Measures].[-DimBrowseLevelKey 0-] AS
'[Dim
Geography].[Geography].currentmember.properties
("key0", TYPED)'
MEMBER [Measures].[-DimBrowseProp City-] AS '[Dim
Geography].[Geography].currentmember.properties
("City", TYPED)'
MEMBER [Measures].[-DimBrowseProp Country-] AS '[Dim
Geography].[Geography].currentmember.properties
("Country", TYPED)'
MEMBER [Measures].[-DimBrowseProp State-Province-]
AS '[Dim
Search WWH ::
Custom Search