ParallelPeriods (PQL)

Returns member for a time period that derived from the specified date-time member.

  • Returned Output: Member
  • Library: PQL \ Semantic \ Date-Time
  • Version: 2018.00.000
  • Compatibility: Pyramid Query Language (PQL) data sources

Syntax

ParallelPeriods( <Member> , <Periods Integer> , OPTIONAL <Period Type> , OPTIONAL <Range Type> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The member needs to be an existing member from a date-time flagged attribute in the model.
  • The 'periods' integer specifies how many periods to go backward (positive integer), or forward (negative integer) from the specified member.
  • The optional 'period type' describes the type of time period by which to count backward or forward:
    • 0 or YEARS (default)
    • 1 or QUARTERS
    • 2 or MONTHS
    • 3 or WEEKS
    • 4 or DAYS
  • The optional 'period range' describes the range of members to return. If this is not included, the day will be returned.
    • 0 or FULL_YEAR
    • 1 or FULL_QUARTER
    • 2 or FULL_MONTH
    • 3 or FULL_WEEK
  • For details on how to employ and use this function see the semantic calculation overview.
Different Function types
  • This function is similar the MDX "ParallelPeriod" function.

Examples

Taking the date 2016-02-05, this formula will return the date for 2014-02-05:

ParallelPeriod( [data].[dateKey].[1454630400000], 2, 0 )

Taking the date 2016-02-05, this formula will return the full week of dates for 2018-02-05:

ParallelPeriod( [data].[dateKey].[1454630400000], -2, 0, 3 )

Taking the date 2016-02-05, this formula will return the full month of dates for 2016-04-05:

ParallelPeriod( [data].[dateKey].[1454630400000], -2, "MONTHS", "FULL_MONTH" )