Document toolboxDocument toolbox

DefaultMember

Owned by Elvis Kvalbergs
Last updated: Aug 31, 2022 by Gvido
1 min read

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.

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