Database Reference
In-Depth Information
Members and Levels
Each dimension consists of members. These members can be grouped into user-defined hierarchies. Each user-
defined hierarchy consists of two or more levels, with the highest level being the All level. (The only exception to
this rule is the Measures dimension, which is completely flat and has no hierarchical structure of this type).
To display every member of the hierarchy or level, specify its name and use the
AllMembers
function. To
specify the members of a level, include the dimension, hierarchy, and level. The Analysis Server will implicitly use
the
AllMembers
function for you. Listing 14-21 outlines these concepts. Figure
14-16
displays the query results.
Figure 14-16.
The results of the examples from Listing 14-21
Listing 14-21.
Specifying the Hierarchy and a Level Implicitly Returns All Members
Select
{ [Measures].[SalesQuantity] } On Columns,
{ −- Dimension - Hierarchy - Level
- Property or Function
[DimTitles].[TitlesByType].[Title]
.AllMembers
} On Rows
From [CubePubsSales];
Select
{ [Measures].[SalesQuantity] } On Columns,
{ −- Dimension - Hierarchy - Level
[DimTitles].[TitlesByType].[Title]
} On Rows
From [CubePubsSales];
