Performing Calc on the Fly

While performing ad hoc analysis, you can insert member formulas to get quickly calculated values.

To perform calc on the fly:

1. Connect to your database and perform an ad hoc analysis.
2. In the Planning Ad Hoc ribbon, click Insert Member Formula.

   The grid is refreshed and green triangle indicators appear on cells containing member formulas.

3. Click the cells with formulas to view the formula in the tooltip, along with the members and mathematical operators involved in the formula.

   For more information, see Viewing Inserted Member Formulas.

4. Enter a value or modify an existing value in the data cells.

   Note:

   Entering or modifying values manually in cells containing formula is not supported in Smart View. If you do so, the formula gets overwritten with your entered value and you may lose the formula.
5. Tab out of the modified cells to see the values in the cells with formula refresh immediately, without saving or submitting. The calculations also roll up to parent dimensions of members, if any, and their values are also updated.

   The modified cells become dirty, that is they are indicated with a color change. You can click Refresh to return the dirty cells to their original values from the database.

6. Continue to perform calc on the fly and see the calculated values refresh in the cells instantaneously.
7. Once satisfied with the calculations, submit the data by clicking Submit Data in the Planning Ad Hoc ribbon.
   Alternatively, you can close the grid without submitting to discard your changes.