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

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 in the model window, but not on any modelling component, to display the context menu.
3. From the menu select Rollback Selected Objects.
4. 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 Administrator

1. menu → System → Console
2. Find the log for the analysis run
3. Click on this entry
4. In the bottom section, click on the Recordsets tab.
5. You will find two buttons:

1. Insert excerpt
   _rollback _rollback nopanel true

    all data...

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

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, look at the

1. table set list 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.