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

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 two buttons:
8.  Rollback all data...
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, look at the table set list 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.