Use of relative periods in a Calculation rule

This allows line items in the rule to reference either:

• Previous Periods 
• Previous Closing Periods

This is done by creating system date members. 

The two system date members have been created:

• PrevClosing: it's with respect to the current date and retrieves the previous year's 12th month. 
  1. Set Tags to #OPENING#.
  2. Type -1 for the Year property.
  3. Type 12 for the Month property.
• PrevMonth: It's with respect to the current date and retrieves the previous month.
  1. Set Tags to #PREVMONTH#
  2. Type -1 for the Month property.

For example:

These relative dates can then be used in the Multi Dimensional Calculation.