Excluding consolidations from data spreading

You can hold the value of a consolidation constant while you adjust the underlying leaf values.

For example, you might want to hold a value constant while you change the values of the leaves to perform a what-if analysis.

When you apply a consolidation hold and change the value of its leaf elements, TM1® Web applies proportional spreading to the remaining leaf values so that the consolidation value remains unchanged.