This page is for data modellers who are new to using PhixFlow. It explains the options in the analysis model window.

Opening a Model Window

For an introduction to using analysis models, see Analysis Models for Batch Processing Data.

PhixFlow opens a model in the workspace when you:

• create a new model from the home screen.
• display an existing model.

Model Properties

In the repository, double-click on an analysis model's name to open its properties.

To open a model, in it's properties toolbar, click the  Display button.

In addition to the Common Properties, analysis models have a Name; see Analysis Model Properties. They do not have any other properties, as all their content is in the model itself.

Modelling Objects

The toolbar at the top of a model window includes icons for the different objects that you can add to the model. The types of modelling object are:

• data connectors, to load or export data
  • Datasource
  • Database Collector
  • Database Exporter
  • FTP Site
  • File Collector
  • File Exporter
  • HTTP Datasource
  • HTTP Collector
  • HTTP Exporter
• Table to process the data
• Pipe to connect the objects

Drag an object from the toolbar into the model to add new object of this type. For information about the object icons, see Modelling Window Toolbar Icons, below.

You can also drag in existing modelling objects from the repository. For example, to add an existing table:

1. Open the repository → Tables branch and find the table.
2. Drag the table into the model.

Objects in models must be connected by pipes. Hover your mouse pointer over an object to display the popup toolbar and add a  Connector to connect two objects.

Usually you add modelling objects that belong to the same application. However, PhixFlow can share modelling objects between applications. When you drag in a modelling object from a different application, PhixFlow adds a small application icon to the top left of the object's icon.

When you make changes to a model, remember to save your changes by clicking the   Save button in the model window toolbar. 

Model Window Toolbar Icons

Drag Type	The default mode for the cursor in the model window is select. Pressing this button sets the mode to drag. Alternatively, while in select mode, keep the Ctrl key pressed on your keyboard, and with the left mouse button pressed move the pointer.
	If you are in drag mode, pressing this button puts you back into select mode (the default mode when you open a new model window). While in select mode, keeping the left mouse button pressed and dragging over an area of the window, you can select several items in the model. Press the Alt key on your keyboard to include Pipes in the selection.
Align to Grid	Organise selected objects in a grid.
Align Objects to Left	Align all selected objects left.
Align Objects to Right	Align all selected objects right.
Align Objects to Top	Align all selected objects to top.
Align to base	Align all selected objects to bottom.
Distribute Objects Horizontally	Distribute all selected objects horizontally.
Distribute Objects Vertically	Distribute all selected objects vertically.
Object Types that you can add to an analysis model
Datasource	A datasource to configure a connection to an external database.
Server Address/FTP Site	An  FTP site to connect to an external file store.
HTTP Datasource	A HTTP datasource to configure a connection to an external source.
Database Collector	A database collector import data from an external database.
File Collector	A file collector to import a file from an external source.
HTTP Collector	A HTTP collector to import data from an external source via HTTP.
Database Exporter	A database exporter to export data to an external database.
File Exporter	A file exporter to export data in a file.
HTTP Exporter	A HTTP exporter to export data to an external source via HTTP.
Aggregate Table	An aggregate table, which combines data.
Calculate Table	A calculate table (the default).
Calculate by Set Table	A Calculate-By-Set table.
Cartesian Table	A cartesian table.
Merge Table	A merge table.
Properties	Show model properties.

Modelling Object Popup Toolbar

In the model, hover your mouse pointer over any object to display a popup toolbar. The popup toolbar some of the same buttons that appear in the menu bar, described above. It also provides the following buttons:

Static	Make this object static. When you run analysis, this object and any data it carries are not changed.
	Disable or enable this object.
Show Attributes	Bring up a list of attributes for the object. Attributes can be selected from this list and dragged into an attribute list window for another object, so this is useful when building new objects in the model.
Show view	Show the list of views configured on this object.
Show Recordsets	Show the list of recordsets for this object; see Managing Recordsets.
Show Inputs	Add to the model all objects that are inputs to this object.
Show Outputs	Add to the model all objects that are outputs of this object.
Run Analysis	Run the analysis process on this object. All objects required to build the object selected will be run, but only these objects. This means PhixFlow may: run analysis on objects that are not in the model not run analysis on some of the objects that are in the model.
Remove	Erase this object from the model. This object still exists in the repository, and it's data is available to any other object that refers to it.

Modelling Object Popup Menu

Right-click on a modelling object to display its popup menu. This includes many of the same options as in the menu bar or the popup toolbar. Some addition options are also available:

Popup Menu Option	Description
Copy Object	Create a copy of the object.
Create new input table	Add a new table with a pipe that connects into the selected object.
Show all Predecessors	Add all objects that are used to build this object in the underlying model.
Show All Successors	Add all objects that use this object in the underlying model.
Rollback Table	Rollback data in the table. This opens the Rollback Recordsets form.
Delete	Permanently delete the object from the underlying model in PhixFlow. This removes the object from PhixFlow completely. Only do this if you are certain that you never want to use this object again.

Model Window Popup Menu

Right-click anywhere on the model window to display the popup menu:

• Rollback Selected Objects: Rollback the data in the currently selected recordsets in the table
• Copy Selected Objects: Create copies of the currently selected objects
• Delete Selected Objects: Delete selected objects
• Enable Selected Objects: Enable selected objects
• Disable Selected Objects: Disable selected objects
• Switch The Static Flag On In The Selected Objects: Switch the 'static' flag on in the currently selected tables and pipes
• Switch The Static Flag Off In The Selected Objects: Switch the 'static' flag off in the currently selected tables and pipes

Moving a Model Window

As models get bigger, you may find that model window only shows part of the model. If part of the model is off-screen, PhixFlow will display arrows:

Use the arrows to move the model window to show different parts of the model. Alternatively, you can drag the model around in the model window.

Keyboard Support

If you are in select mode , there are keyboard commands available:

• Ctrl:
  • either switch to drag mode (move the pointer with the left mouse button pressed)
  • or select multiple items (click left mouse button on items).
• Alt: Include pipes in selection.