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

1. tables in your model – it doesn't matter if you include other components.
2. All

1. tables and any other components you included should now be

1. highlighted.
2. Right-click anywhere

1. in the model

1. window, but not on any modelling component, to display the context menu.
2. From the menu select Rollback Selected Objects.
3. Roll back the

1. tables using the options:
   1. Rollback all data
   2. Untick Keep Old

1. 1. Recordsets
2. A log entry will be produced telling you what data has been cleared

1. . 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

1. table Channel List Reconciliation
2. Open the System Console from the

1. Administrator menu → System → Console
2. Find the log for the analysis run

1. Click on this entry

1. In the bottom section, click on the Recordsets tab.
2. You will find

1. a number of buttons:

1. Insert excerpt
   _rollback _rollback nopanel true

   .

2. Insert excerpt
   _rollback_run_analysis _rollback_run_analysis nopanel true

   .

Use the button

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

2. Select 

   Insert excerpt
   _rollback _rollback nopanel true

   .
3. Accept the default options (the Keep Old

1. Recordsets flag is ticked)
2. When the rollback has completed,

1. Show Recordsets for this

1. table – you will see a single

1. Recordset (the most recent one) is yellow
2. Run analysis on this

1. table.
2. The yellow (incomplete)

1. Recordsets will be rebuilt – but this run will not cause any of the

1. table's predecessors to run.