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