Show TOC

Syntax documentation*COMMIT_EACH_MEMBER Locate this document in the navigation structure

Allowed uses: By Commit, MDX, SQL

*COMMIT_EACH_MEMBER={dimname}

This instruction enforces a commit for each member of the selected dimension. If the dimension is of type TIME, the members are also sorted in ascending sequence, so that older periods are processed first. In addition, the rule is executed for all periods between the oldest and the youngest, filling any gaps existing in the range of selected periods. This can be useful for formulas performing a carry-forward of prior periods values as in this example.

Example Example

#ClosingBalance= (ClosingBalance, lag([TIME].currentmember,1)) + Changes

End of the example.

Note Note

The lag() function is an MDX function. See your Microsoft MDX reference documentation for more information.

End of the note.