Excluding consolidations from data spreading
You can hold the value of a consolidation constant while adjusting
the underlying leaf values. For example, when performing a what-if
analysis you might want to hold a value constant while changing
the values of the leaves.
When you apply a consolidation hold and change the value of its leaf elements, proportional spreading is applied to the remaining leaf values so that the consolidation value remains unchanged.