After spreading is complete

Internally, TM1® performs a series of checks to determine if a spreading function was performed properly.

• The values are checked to test whether the leaf cells contain zero values. TM1® applies an equal spread to the empty cells when the ProportionSpreadToZeroCells parameter is enabled. This functionality is enabled by default.
• The values after the spreading of all consolidated cells that participated in the spreading are compared to their desired values.
• The values before and after the spreading are compared for all cells with consolidate holds. If any of the comparisons failed to be within the predefined relative accuracy, the spreading is deemed failed and all changes are rolled back. The default for the predefined relative accuracy is 1e-8, but this value is configurable for the server through the tm1s.cfg parameter SpreadingPrecision.