LevelDepth

The LevelDepth parameter specifies the number of levels below a selected hierarchical dimension member at which to start a consolidation. Unlike a currency consolidation, which consolidates all descendants of a selected member, a level depth consolidation does not consolidate (1) any member below the specified level or (2) any parent member at the starting level of the consolidation (these members, called virtual leaf members, are required to have been previously consolidated).

LevelDepth is used in conjunction with the SuppressLeafProcessing parameter when running a level depth consolidation and is also required when running an incremental consolidation.

An incremental consolidation is a type of level depth consolidation that does not re-evaluate formulas but only rolls up pre-consolidated data, automatically re-executing itself for each common ancestor of selected starting members.

Leaf members included in the scope of the consolidation (that is, on the levels to be consolidated) are called in-scope leaf members. Unlike virtual leaf members, a currency consolidation is run for in-scope leaf members by default. Consolidations of in-scope leaf members can optionally be suppressed through the SuppressLeafProcessing parameter.

Type: Scripting parameter, Page option (Level Depth)

Related parameters: SuppressLeafProcessing, IncrementalConsolidationTarget