This page is for data modellers who want to view and manage data in tables.

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 run an archive task; 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 indicatd 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.

Learn More

• Managing Models and Data

Opening the

Recordset List

1. To see a list of recordsets:
   either
   1. 1. in a model, right-click a table to display the pop-up toolbar,
   or
   1. 1. in the repository, right-click a table name to display the context menu,
      2. in the table properties, click the more menu
   2. then click 

      Insert excerpt
      _recordsets_show _recordsets_show nopanel true

      .
    
   2. The recordset list shows all recordsets for
   this
   1. the table,
   for example: Image Removed
   1. 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 table
   , details of
   1. the new recordset details are added at the top of the list.
   Using the

   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
   the recordset was created, its Run ID and its Size, which is the number of records it contains. 
   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 to another tablebetween tables:

   1. Select one, several or all recordsets in the list.
   2. Drag 

      Insert excerpt
      _recordset_move _recordset_move nopanel true

       to over another table icon or on the analysis model or into a recordset list. 
   3. PhixFlow asks if you want to copy or move the data;
   4. Select an option. For more information see Copying or Moving Table Data. Select an option.

   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 of the recordset data, indicated by a grey background.

   Rolling Back Recordsets

   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 See Rollback Recordsets.

   Warning

   Do not roll back recordsets in transactional tables. For tables with a Period of Transactional rollback with caution as individual records are updated overtime and can current records can be distributed across multiple record sets. For example, an application users make individual user edits to records record in the table. This means PhixFlow cannot rollback to a recordset in all tables where the data is consistent.  , this can be in a record set that is not the most recent.

   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.