Overview of Data Spreading

IBM® Cognos® TM1® provides a variety of pre-defined data spreading functions that you can use to distribute numeric data to cells in a cube view. For example, you can use data spreading to evenly distribute a value across a range of cells or to increment all values in a range of cells by a desired percentage.

Data spreading functionality is available in the Cube Viewer, In-Spreadsheet Browser, and in slice worksheets. When you right-click a cell in any of these places, the shortcut menu includes a Data Spread option, from which you can select a data spread method.

The Data Spread menu option selected to display the list of Data Spreading options.

You cannot use data spreading functionality when you work in batch update mode. If you attempt to spread data in the Cube Viewer or In-Spreadsheet Browser while in batch update mode, an error displays. If you attempt to spread data in a slice while in batch update mode, the spreading operation is not executed.

Batch updates are described in Using Batch Updates.