Period and Year Keywords

To create dynamic rules, you can use the keywords in Table 11-21 instead of member names to represent members of the destination Year or Period dimensions:

Table 11-21 Period and Year Keywords and Descriptions

Keyword	Description
CUR	The current period or year.
FIRST	The first period or year that is valid for the application.
LAST	The last period or year that is valid for the application.
NEXT	The period or year that follows the current period or year.
PRIOR	The period or year that precedes the current period or year.

Note:

Period and Year keywords are case-sensitive and must be in all uppercase letters.

You can use the plus (+) and minus (-) signs with the Period and Year keywords. This example sets the MiscPast account to the amount in the Misc account two years before the current year.

HS.Exp "A#MiscPast = A#Misc.Y#CUR-2"

If you use the keywords Prior, First, Last, Current, or Next, immediately followed by the plus (+) and minus (-) signs and a digit, you must be careful to use the correct syntax for the order of the equation. In these cases, you can use one of these methods to write the rule:

Always use parentheses to correctly separate the variable. For example:

HS.Exp "A#9001_Group.C4#[None] = A#9001_Group.P#Prior" & "+(" & VAR & "*A#9001_Group.V#[ParentTotal])"

Or

HS.Exp "A#9001_Group.C4#[None] = (A#9001_Group.P#Prior" & "+" & VAR & ") *A#9001_Group.V#[Parent Total])"