All eazyBI for Jira eazyBI for Confluence Private eazyBI

CurrentDateMember

EAZYBI Returns the Time dimension member that matches today's date at the specified level. eazyBI dynamically creates Time dimension members based on the imported data. If no member exists for today's date yet, the function will return the most recent member that exists at that level rather than today's.

Syntax

Time_Level_Expression.CurrentDateMember

Arguments

Time_Level_Expression

MDX expression that returns Time dimension level.

Examples

This formula returns the Time dimension 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
})


See also