Export (0) Print
Expand All

DefaultMember

SQL Server 2000

DefaultMember

Returns the default member of a dimension or hierarchy.

Syntax
Dimension

«Dimension».DefaultMember

Hierarchy

«Hierarchy».DefaultMember

Remarks

The default member is specified in the Default Member property of the dimension or hierarchy (DefaultMember in the Decision Support Objects library.) If this property is empty and the dimension contains an (All) level, the default member is the All member. If this property is empty and the dimension or hierarchy does not contain an (All) level, the default member is an arbitrary member of the highest level. In this last case, the DefaultMember function is ambiguous.

Example
Dimension

If the Time dimension has levels (All), Year, Quarter, and Month, and member All-Time, the following expression returns All-Time:

Time.DefaultMember
Hierarchy

If the [Fiscal Year] hierarchy has levels Quarter, and Month, and member [Month 1], the following expression returns [Month 1]:

[Fiscal Year].DefaultMember
Show:
© 2015 Microsoft