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 

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 

  Insert excerpt
  _rollback _rollback nopanel true

   

• Table.
• In the repository: right-click on a

• table name and select   

  Insert excerpt
  _rollback _rollback nopanel true

   

• Table.
• In the repository: use Ctrl+click to select multiple

• tables, right-click one of the

• table names and select   

  Insert excerpt
  _rollback _rollback nopanel true

   Selected Objects.
• In a list of

• recordsets: select one or more

• recordsets, then right-click on one

• recordset and select

  Insert excerpt
  _rollback _rollback nopanel true

   

• Recordset. PhixFlow automatically populates the data for the rollback options, as it knows the properties of the selected

• recordset(s).

Anchor
options options

Rollback Options

In the Rollback window, select an option and specify the

recordsets to rollback.

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:

Image Modified

Anchor
rerun rerun

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.