DateMembersBetween

Function DateMembersBetween is available for eazyBI in Cloud and starting from the eazyBI version 5.1 for Jira Server.


EAZYBI Returns Time dimension hierarchy level members between two specified dates.

Syntax

Time_Level_Expression.DateMembersBetween(from_date, to_date)

Arguments

Time_Level_Expression

MDX expression that returns Time dimension hierarchy level.

from_date

Expression that returns the period start date (included)

to_date

Expression that returns the period end date (included)

For from_date and to_date you can use also a string expression, that can be parsed with DateParse or relative dates.

Examples

Aggregate(
  [Time].[Day].DateMembersBetween('30 days ago', 'today')
)

returns all Time dimension day level members that represent last 30 days, including today.

Note: To retrieve all date members between two given dates, they should be imported in the Time dimension. For future periods, it is advised to add missing Time dimension members.

See also