How to Use Data Spreading in Planning Analytics
Data Spreading is the automatic distribution of a numeric value from a parent to leaf level cells beneath it. When a value is entered at a parent intersection, that value is distributed to all input cells consolidating up to the cell where the data was entered. For example, entering 1200 to a consolidation of all […]
Neglected Functionality – TM1 Data Spreading
Often overlooked and underused, TM1’s Data Spreading Options provide spectacularly advanced features and simple solutions to everyday planning problems. I’ll quickly cover some of the most common uses of spreading functions, but before I do it should be noted that Cube Rules and Data Spreading do not play nice. Rules and even Conditional Rules which evaluate to […]