FuturePeriods

EAZYBI Returns a set of future time dimension members starting from the given Time member.

The function is available on the Cloud and since eazyBI version 7.2.

Syntax

FuturePeriods(Time_Member_Expression)

Arguments

Time_Member_Expression	MDX expression that returns a Time dimension member.

Examples

FuturePeriods returns an optimized set of future periods that can be used to aggregate measure values for all existing future time periods in the Time dimension. If necessary, you can add additional Time members to your Time dimension.

For example,

FuturePeriods([Time].[2023].[Q2 2023].[Apr 2023].[Apr 28 2023])

will return this set:

{
  [Time].[2023].[Q2 2023].[Apr 2023].[Apr 29 2023],
  [Time].[2023].[Q2 2023].[Apr 2023].[Apr 30 2023],
  [Time].[2023].[Q2 2023].[May 2023],
  [Time].[2023].[Q2 2023].[Jun 2023],
  [Time].[2023].[Q3 2023],
  [Time].[2023].[Q4 2023],
  [Time].[2024],
  [Time].[2025]
}

This shows all future days in the selected month (Apr 29 2023 and Apr 30 2023), all future months in the selected quarter (May 2023 and Jun 2023), all future quarters in the selected year (Q3 2023 and Q4 2023), and all future years in the Time dimension (2024 and 2025).

The following formula can be used to find the number of issues that have a due date after the selected Time period:

Sum(
  FuturePeriods([Time].CurrentHierarchyMember),
  [Measures].[Issues with due date]
)