Overview

Each time you run analysis on a model, PhixFlow creates a new set of data for each table. You can view this data by right-clicking on a table and selecting  Show Recordsets; see Managing Recordsets for more options.

Recordsets remain available until you run an archive task on the table; see Task. 

Rollback Data

For non-transactional tables, which have a Period of Daily, Monthly or Variable, you can back-out the changes to data caused by an analysis run. This resets the data to a previous recordset; see Rollback Window.

To rollback to an earlier recordset, open the rollback window from one of the following places:

• In a model: right-click on a table icon and select  Rollback Table.
• In the repository: right-click on a table name and select    Rollback Table.
• In the repository: use Ctrl+click to select multiple tables, right-click one of the table names and select    Rollback Selected Objects.
• In a list of recordsets: select one or more recordsets, then right-click on one recordset and select  Rollback Recordset. PhixFlow automatically populates the data for the rollback options, as it knows the properties of the selected recordset(s).

Rollback Options

In the Rollback window, select an option and specify the recordsets to rollback.

Option	Description
Rollback a number of Recordsets	Enter the number of recordsets to roll back. PhixFlow removes this number of recordsets, starting with the most recent.
Rollback to a specific run	Enter the run ID of a recordset to which you want to rollback. You can find the run IDs in the Managing Recordsets. PhixFlow removes all the tables from the most recent, up to and including the specified run ID. For a transactional table, PhixFlow removes the specified run ID only. All other recordsets, even more recent ones, are retained.
From Date	Enter a date. PhixFlow removes recordsets whose period start date is more recent than the specified date.
Rollback all data	Phixflow removes all recordsets for this table.
Keep old Recordsets	This box is ticked by default.  Tick to rollback the data but to keep the recordset itself. In the recordset list, the recordset is empty and marked incomplete.  Untick to delete the  recordset. Both the data and the recordset itself are removed from the recordset list. You cannot repopulate deleted recordsets.
	Close the window without running rollback.
	Run the rollback process, then click Yes to confirm.

Details about the rollback process are displayed in the console.

For large data sets, it may take some time to rollback all the data in a recordset.

Example

When testing an analysis model it is likely you will read and clear all the data frequently, in this instance you would use the following configuration:

Repopulating Incomplete Recordsets

If you rollback data due to errors, you can repopulate an incomplete recordset with the correct data. This is because the all recordsets in a model that were created during the same analysis run have the same Run ID. PhixFlow can use the run ID to pull the correct data into an incomplete table.

To repopulate an incomplete recordset:

1. Go to the console.
2. Find the log messages related to rollback.
3. Right-click the log message and select Repeat to reinstate data; see Rollback or Repeat Cycles Window.

For information about rerunning incomplete recordsets in an transactional table; see the Managing Recordsets → Reprocess Recordset option.