Relative Periods

Overview

The Relative period hierarchy is a special hierarchy that is used to make it easier to work with periods in xpna. It is used to create relative period references, such as Current period, Year to date, Year to go, Last 12 periods and so on. When included in a DATA* function, Relative period member modifies the Period functions to return a different result.

To use the Relative period hierarchy, you need to include it in your DATA* function as well as a member from the Period hierarchy. The Relative period member will modify the Period member to return the correct value for the selected period.

Syntax

Relative Period	Definition
Current period (default)	Do not modify the selected period
Year to date	Aggregate the values from the start of the fiscal year to the selected period (or the last period of the selection)
Year to go	Aggregate the values from the period immediatly after the selected period (or the last period of the selection) to the end of the fiscal year
Last 3/6/9/12 periods	Aggregate the values from the last 3/6/9/12 periods

Note:

For Balance measures, the Year to date and Year to go relative periods will return the closing balance for the last period in the selection.\

See Also

DATA

Glossary