Returns the default member of a dimension or hierarchy (which typically is All member).

Syntax

Dimension_Expression.DefaultMember
Hierarchy_Expression.DefaultMember

Arguments

Dimension_Expression

Hierarchy_Expression

MDX expression that returns dimension (default hierarchy)

or specified hierarchy.

Examples

[Invoice].DefaultMember returns All Invoices default member.returns the percentage of current customer's gross profit from all the customer's gross profit.

[Time.Weekly].DefaultMember returns All Times default member from Weekly hierarchy.

([Measures].[Gross profit],[Customer].CurrentMember)/ ([Measures].[Gross profit],[Customer].DefaultMember) returns what percentage from all the customer's gross profit is from the current customer.

See also

CurrentMember

Browser not supported