Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 22 Next »

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; see Task. If there is a problem during the analysis run, you may find that a recordset has incorrect or missing data. To fix recordsets, you can undo the analysis by running rollback.

Learn More

Opening the Reocrdset List

To see a list of recordsets:

  • either in a model, right-click a table to display the pop-up toolbar
  • or in the repository, right-click a table name to display the context menu

then click  Show Recordsets. 

The recordset list shows all recordsets for this table, for example: 

Each time you run analysis on a table, details of the new recordset are added at the top of the list.

Using the Recordset List

The recordset list includes details about when the recordset was created, its Run ID and its Size, which is the number of records it contains. 

The toolbar has the standard icons and  Move Recordsets. 

To move recordsets to another table:

  1. Select one, several or all recordsets in the list.
  2. Drag  Move Recordsets  to another table icon or recordset list. 
  3. PhixFlow asks if you want to copy or move the data; see Copying or Moving Table Data. Select an option.

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.

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

Do not roll back recordsets in transactional tables.
For tables with a Period of Transactional individual records are updated overtime. For example, application users make individual edits to records in the table. This means PhixFlow cannot rollback to a recordset in all tables where the data is consistent.  

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.
  • No labels