Allowed uses: By Commit, MDX, SQL
*FLAG_PERIOD= {period}
where period must be a valid value of the PERIOD property of the TIME dimension. (For example the date 2005.MAR would typically have PERIOD=
”MAR”).
The value of {period} can also be retrieved from a property with the following alternative syntax:
*FLAG_PERIOD= {dimension }.{property}
Example
*FLAG_PERIOD = CATEGORY.FLAGPERIOD
This instruction creates a value for the reserved keyword %FLAG_PERIOD%, which can be used as a replacement string inside the POS( ) keyword as follows:
*WHEN POS(TIME)
*IS >=POS(%PREFIX%.%FLAG_PERIOD%)
Example
//------------------------------------------------------------------------
-------------------------
*FLAG_PERIOD=CATEGORY.FIRSTPERIOD
*WHEN POS(TIME)
*IS >= POS(%PREFIX%.%FLAG_PERIOD%)
*WHEN ACCOUNT
*IS UNITS
*REC(FACTOR=GET(ACCOUNT=”PRICE”), ACCOUNT= “REVENUE”)
*ENDWHEN
*ELSE
*REC // this may be needed if clear_destination is used
*ENDWHEN
//------------------------------------------------------------------------
-------------------------
Note
Similar to the *PRIOR instruction, the *FLAG_PERIOD instruction works dynamically only if just one member of the selected dimension (in this example CATEGORY again) is being processed by the logic.
On the other hand, this instruction can also be used in a logic definition where *CALC_EACH_PERIOD is not required.