All eazyBI for Jira eazyBI for Confluence Private eazyBI

CurrentDateMember

EAZYBI Returns the Time dimension hierarchy level member which contains current date.

Syntax

Time_Level_Expression.CurrentDateMember

Arguments

Time_Level_Expression

MDX expression that returns Time dimension level.

Examples

[Time].CurrentHierarchy.Levels(‘Day’).CurrentDateMember returns Time dimension current day member for selected Time hierarchy.

[Time].[Year].CurrentDateMember returns Time dimension current year member.

Aggregate({
  [Time].[Year].CurrentDateMember
})

See sample report Created vs resolved issues over time in our Demo account. The calculated member Current year in dimension Time uses the formula above. You can select this calculated member to filter and see the month of a current year on the report instead of Last 12 month. A similar formula is used for Previous year as well. The previous year is calculated as a previous period of the current year.