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

This formula returns the Time dimension current day member for the selected Time hierarchy:

[Time].CurrentHierarchy.Levels(‘Day’).CurrentDateMember

This formula returns Time dimension current year member:

[Time].[Year].CurrentDateMember

See the sample report Created vs resolved issues over time in our Demo account. The calculated member Current year in dimension Time uses the formula below. 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.

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