Use data spreading in Universal Reports,Exploration Views, and Quick Reports

You can use data spreading to enter or edit numeric data in Universal Reports, Exploration Views, or Quick Reports by using a predefined distribution method, called a data spread method. For example, you can evenly distribute a value across a range of cells or increment all values in a range of cells by a percentage.

Procedure

  1. Select a cell or range from which you want to initiate data spreading.
    You can initiate spreading from a single cell or a single linear range of cells. You cannot initiate spreading from a non-contiguous range of cells, nor can you spread data across multiple individually selected cells or ranges in a worksheet.
  2. Right-click the cell or range and click IBM® Planning Analytics > Spread.
    Note: If the Spread command is not available, data spreading might be restricted on the server. Ask your administrator to check the capability assignments configured in the data model.
  3. Select a data spreading method.
    The methods that are available in the Spreading dialog box depend on the cells that you selected for data spreading. For example, some methods, such as Equal Across Leaves, are applicable to consolidated cells only.
  4. Specify the required values.
    For example, if you selected the Growth % method, enter the growth percentage.
  5. Select an Update action.
  6. If required, specify a Direction for the data spread.
  7. Click OK.
    Note: You can also apply data spreading by typing data spreading syntax in a cell.