Show TOC

Syntax documentation*FLAG_PERIOD Locate this document in the navigation structure

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 Example

*FLAG_PERIOD = CATEGORY.FLAGPERIOD

End of the example.

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 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 //------------------------------------------------------------------------

-------------------------

End of the example.

Note 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.

End of the note.