Auto spread consolidated inputs

This setting proportionally spreads values entered in a consolidated cell across nested cells.

About this task

If you enable the Auto spread consolidated input option, the values you enter in consolidated cells will be proportionally spread across the nested cells after you commit your data.
Note: Consolidated cells do not accept typed-in input in formulas-based reports, such as Custom Reports or Dynamic Reports.
Figure 1. Auto spread consolidated input. Left: Enabled.Right: Disabled.
The left image shows a consolidated cell being automatically converted into proportional spread options. The right image shows a static consolidated cell.

Procedure

  1. On the IBM® Planning Analytics tab, click Options Options icon.
  2. In the navigation pane, click IBM Planning Analytics.
  3. Under Application settings, select the Auto spread consolidated input check box.
  4. Click OK.