All eazyBI for Jira eazyBI for Confluence Private eazyBI

DefaultMember

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

Syntax

Dimension_Expression.DefaultMember

or

Hierarchy_Expression.DefaultMember

Arguments

Dimension_Expression

Hierarchy_Expression

MDX expression that returns a dimension (default hierarchy)

or a specified hierarchy.

Examples

[Issue].DefaultMember returns All Issues default member.

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

Any default measure in eazyBI is related to Time dimension. Some scenarios requires ignoring this default mapping by Time dimension to get needed results. The following example will count total days an issue spent in any status from status category Done. eazyBI by default will split Days in transition status by any period when an issue moved from a status. If the issue was open for a longer period and had several status changes over time, the formula should ignore Time to get a total time the issue spent in those statuses. The example uses a tuple with time default member [Time].CurrentHierarchy.DefaultMember to pull in total time no matter when any status change was done. 

([Measures].[Days in transition status],
[Transition Status.Category].[In Progress],
[Status.Category].[Done],
[Time].CurrentHierarchy.DefaultMember)

See example report Control chart (cycle time) in our demo account. Calculated measure Rolling average cycle time uses the formula above as a part of the calculation to get a total time an issue spent in any status from status category In Progress.