Show TOC

Syntax documentation*PROCESS_EACH_MEMBER Locate this document in the navigation structure

Allowed uses: Global, MDX, SQL

*PROCESS_EACH_MEMBER={dimname1}[, {dimname2}, …]

This instruction enforces a commit for each member of the selected dimension in the whole logic file, not just in a specific *COMMIT section. This instruction is similar to *COMMIT_EACH_MEMBER with the following important differences:

  • It applies to the entire rule and not to a specific COMMIT section

  • It is processed separately, before the rule is interpreted. This makes the rules behave exactly as if it had been called multiple times (once for each member in the dimensions listed in the instruction).

  • The member set to process for the named dimensions must be explicitly passed to the rules call, as if such dimension sets were required (see instruction XDIM_REQUIRED).

  • It applies to both MDX logic as well as SQL logics (while currently COMMIT_EACH_MEMBER only works on MDX logic).

Similar to the COMMIT_EACH_MEMBER instruction, this instruction processes the TIME dimension in a special way. It sorts the time members from the oldest to the newest and fills all gaps in the range.

Example Example

For example, if the members passed are:

2001.Mar, 2001.Jan

Then the resulting set whose members are processed individually is:

2001.Jan, 2001.Feb, 2001.Mar

End of the example.