Roll back transactions in the transaction log

You can now roll back one or more transactions from the database transaction log in Planning Analytics Workspace.

Procedure

  1. Open the transaction log from the Databases tree on a modeling workbench.
    1. To open the transaction log at the database level, right-click a database, then click Logs > Transaction log.
    2. To open the transaction log for an individual cube, right-click the cube, then click Logs > Transaction log.
  2. Set filtering options if desired, then click Search. You can also click any column heading to sort transactions.
  3. Select the transactions you want to roll back.
  4. Click Roll back to roll back a single selected transaction or click Roll back all to roll back multiple selected transactions..
  5. Click OK to confirm the action.

    The current cell value is reverted to the value indicated by the Prior value column. If multiple selections target the same cell, the most recent transaction takes precedence.