1. User's Guide
  2. Adjusting and Spreading Data
  3. Adjusting Cell Values
  4. Performing 'What If' Analysis

Performing 'What If' Analysis

Before you commit data by saving it, you can perform "what if" calculations and review the changes. By experimenting with data, you can see the impact of various scenarios before saving the data, which is useful for manipulating values to produce desired results.

You can manipulate data values:

  • Enter values (see Entering Data)

  • Lock a value during spreading (see Locking Cells)

  • Change values by typing an operator, followed by a number, described here

  • Use the ad hoc functionality in Oracle Hyperion Planning and Oracle Smart View for Office (see Working with Ad Hoc Grids)

To perform ad hoc calculations on a value:

  1. Select the cell on which to perform a calculation.
  2. Enter an operator (+, +–, *, /, or %), and then enter a value.
  3. Move the cursor from the cell.

    A color change indicates a modified cell.