Smart View Undo and Redo behave differently depending on the data source to which you are connected.
In ad hoc analysis with Essbase, Financial Management, or Hyperion Enterprise data sources, Undo undoes Zoom In, Zoom Out, Keep Only, Remove Only, or Refresh and restores the previous database view to the grid. Performing an Undo after modifying member data returns the sheet to its state before the last refresh, not to its state before the data modification.
In forms with Financial Management, Hyperion Enterprise, or Planning data sources, Undo undoes the last user action in a cell.
Note: | You cannot undo operations that are performed on the server rather than in Smart View, such as calculation status. |
To specify the number of permitted undo and redo actions:
From the Smart View ribbon, select Options, then select Advanced in the left panel.
In Number of Undo Actions, specify the number of permissible Undo operations, 0 through 100.
This is also the number of Redo operations permitted.
Click OK. The setting takes effect after you refresh or perform a drill operation.