Databases Reference
In-Depth Information
Geography].[Geography].currentmember.properties
("State-Province", TYPED)'
SELECT { [Measures].[-DimBrowseLevelKey 0-],
[Measures].[-DimBrowseProp City-],
[Measures].[-DimBrowseProp Country-],
[Measures].[-DimBrowseProp State-Province-] }
ON 0,
Head ( [Dim
Geography].[Geography].[City].&[Huntsville].Children,
1000) ON 1
FROM [$Dim Geography]
CELL PROPERTIES VALUE
Member Property Icon Similar to the MDX query you analyzed earlier to re-
trieve all the members of the All level, this query retrieves all the Alabama
City members. The member properties City, State-Province, and Country are
retrieved with the same query as calculated members using the WITH
MEMBER clause as seen in the above query.
Search WWH ::
Custom Search