Overview

Each time you run analysis on a model, PhixFlow creates a new set of data in each

table; see Table

. A

recordset is a collection of data in a

table for a given period. 

Recordsets, and the data they contain, remain in the

table until you

archive the data (see Task) or manually remove it (see rolling back record sets below). 

If there is a problem during the analysis run, you may find that a

recordset has incorrect or missing data, usually indicated by a yellow highlight in the recordset list. To fix

recordsets, you can undo the analysis by running rollback

or if you fix the issue and re-run analysis PhixFlow will attempt to repair the recordset.

Opening the Recordset List

1. To see a list of

1. recordsets:

1. 1. in a model, right-click a

1. 1. table to display the

1. 1. popup toolbar,

1. 1. in the repository, right-click a

1. 1. table name to display the context menu,
   2. in the table properties, click the more menu
2. then click 

   Insert excerpt
   _

1. recordsets_show _

1. recordsets_

1. show nopanel true

   .

2. The

1. recordset list shows all

1. recordsets for the table, as illustrated below:Image Added
2. To view the content of a recordset double click on any row.
3. Each time you run analysis on a

1. table the new

1. recordset details are added at the top of the list.

The Recordset List Details

The

recordset list includes details about:

1. Run ID, a unique identifier for the analysis that has been run It can be used when

1. roiling back.
2. From Date,
   
   1. For Transactional Tables this is when the analysis was started.
   2. For Variable Tables this is when the analysis last ran.
3. To Date, when analysis finished.
4. Created Date, the date the record set was created.
5. Size, the number of records in the recordset.
6. Status,
   1. OK, is a complete record set with no issues.
   2. Incomplete, is a recordset that is incomplete due to an error in analysis.
7. Owner, provides the name or the user, or system, that initiated the analysis.
8. Archive Time, when it was archived.
9. Parent, location of the recordset.
10. Cycle, list the cycle of the analysis run when run multiple times.  
11. Instance ID, an internal id for locating the recordset.

The toolbar has the standard icons and Image Modified Move

Recordsets. 

Moving Recordsets

To move

recordsets between tables:

1. Select one, several or all

1. recordsets in the list.
2. Drag 

   Insert excerpt
   _

1. recordset_move _

1. recordset_move nopanel true

    

1. over another table on the analysis model or into a recordset list. 
2. PhixFlow asks if you want to copy or move the data

2. Select an option. For more information see Copying or Moving

1. Table Data.

Viewing Recordset Data

To view the

recordset data, double-click on a

recordset. PhixFlow opens the default view of the data that the

recordset contains. If the

recordset contains superseded records they will be included in this view, indicated by a grey background.

Rolling Back Recordsets

See Rollback Recordsets.

Context Menu

In the

recordset list, right-click on a

recordset to display the context menu. The options are:

• Show Log File: display the log file for the analysis run that generated this

• recordset.
• Rollback

• Recordset: rollback this

• recordset, and all

• recordsets that come after it; see Rollback

• Recordsets.
• Show

• Recordset Data: display a table showing the data in the

• recordset.
• Reprocess

• Recordset: this option is available for incomplete

• recordsets in an transactional

• table. Rerun the current

• recordset.

Learn More

• Managing Models and Data