*LAST_MEMBER

Allowed uses: By Commit, MDX

*LAST_MEMBER {Dimension name} = {Member}

With this instruction, the rule runs for the indicated dimension from the first passed member to the member specified in the instruction itself. For example, if the instruction says:

*LAST_MEMBER TIME=2002.DEC

…the logic runs from the first modified period up to period 2002.DEC.

The year can be made dynamic using the keyword %PREFIX% as follows:

*LAST_MEMBER TIME=%PREFIX%.DEC

In this case, the year is the year of the last modified period.

The instruction can also interpret some MDX functions in the passed parameters. These can be used, for example, to define an offset from a given period. The following syntax:

*LAST_MEMBER TIME=[%PREFIX%.DEC].LEAD(6)

enables the rules to run from the first selected period until June of the following year.

The member name must be enclosed in brackets ([]) to be recognized as an MDX call. The dimension name must be omitted from the expression.