By the end of this chapter you will be able to:

• Rollback several tables at once
• Rollback and re-do from the Console
• Rollback a single Recordset (a run)

Rollback several Tables at once

Rollback can be used to back out the changes to data caused by an analysis run. This resets the data to a previous recordset. This method of rollback is generally used when developing and performing a lot of test analysis runs with data that you do not need to keep:

1. Open the model Channel Package Check
2. Keeping your left mouse button pressed down, drag your cursor over all the tables in your model – it doesn't matter if you include other components.
3. All tables and any other components you included should now be highlighted.
4. Right-click anywhere in the model window, but not on any modelling component, to display the context menu.
5. From the menu select Rollback Selected Objects.
6. Roll back the tables using the options:
   1. Rollback all data
   2. Untick Keep Old Recordsets
7. A log entry will be produced telling you what data has been cleared. In this case, all data in all selected components in the model.

Rolling back (and re-running) from the Console

This method of rollback is generally used when testing – in particular, when a run was only partially successful, but you have changed the rules in the parts of the model that were successful (so you want to re-load these).

1. Open the model Channel Package Check
2. Run the table Channel List Reconciliation
3. Open the System Console from the Administrator menu → System → Console
4. Find the log for the analysis run
5. Click on this entry
6. In the bottom section, click on the Recordsets tab.
7. You will find a number of buttons:
8. Rollback.
9.  Rollback data and run the analysis again.

Use the button  Rollback data and run the analysis again to repeat the analysis run from the previous exercise.

Rollback a single table set (a run)

This method of rollback is commonly used when testing a large model. If a single component has been updated and you want to re-run it without causing the rest of the model to re-run, then this approach is suitable.

1. Open the model Channel Package Check
2. Right-click on Latest Package Update
3. Select Rollback.
4. Accept the default options (the Keep Old Recordsets flag is ticked)
5. When the rollback has completed, Show Recordsets for this table – you will see a single Recordset (the most recent one) is yellow
6. Run analysis on this table.
7. The yellow (incomplete) Recordsets will be rebuilt – but this run will not cause any of the table's predecessors to run.