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 

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 

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 

Model Window Toolbar Icons

Image Removed

Insert excerpt _drag_type _drag_type nopanel true	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.
Image Modified	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.

Image Removed

Insert excerpt _align_grid _align_grid nopanel true	Organise selected objects in a grid.

Image Removed

Insert excerpt _align_left _align_left nopanel true	Align all selected objects left.

Image Removed

Insert excerpt _align_right _align_right nopanel true	Align all selected objects right.

Image Removed

Insert excerpt _align_top _align_top nopanel true	Align all selected objects to top.

Image Removed

Insert excerpt _align_bottom _align_bottom nopanel true	Align all selected objects to bottom.

Image Removed

Insert excerpt _align_horizontal _align_horizontal nopanel true	Distribute all selected objects horizontally.

Image Removed

Insert excerpt _align_vertical _align_vertical nopanel true	Distribute all selected objects vertically.
Object Types that you can add to an analysis model
Insert excerpt _datasource _datasource nopanel true	A datasource to configure a connection to an external database.
Insert excerpt _file_ftp _file_ftp nopanel true	An  FTP site to connect to an external file store.
Insert excerpt _http_datasource _http_datasource nopanel true	A HTTP datasource to configure a connection to an external source.
Insert excerpt _database_collector _database_collector nopanel true	A database collector import data from an external database.
Insert excerpt _file_collector _file_collector nopanel true	A file collector to import a file from an external source.
Insert excerpt _http_collector _http_collector nopanel true	A HTTP collector to import data from an external source via HTTP.
Insert excerpt _database_exporter _database_exporter nopanel true	A database exporter to export data to an external database.
Insert excerpt _file_exporter _file_exporter nopanel true	A file exporter to export data in a file.
Insert excerpt _http_exporter _http_exporter nopanel true	A HTTP exporter to export data to an external source via HTTP.
Insert excerpt _table_aggregate _table_aggregate nopanel true	An aggregate table, which combines data.
Insert excerpt _table_calculate _table_calculate nopanel true	A calculate table (the default).
Insert excerpt _table_calculateBySet _table_calculateBySet nopanel true	A Calculate-By-Set table.
Insert excerpt _table_cartesian _table_cartesian nopanel true	A cartesian table.
Insert excerpt _table_merge _table_merge nopanel true	A merge table.
Insert excerpt _property_settings _property_settings nopanel true	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:

Insert excerpt _static _static nopanel true	Make this object static. When you run analysis, this object and any data it carries are not changed.
Image Modified   Image Modified	Disable or enable this object.
Insert excerpt _attributes_show _attributes_show nopanel true	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.
Insert excerpt _view_show _view_show nopanel true	Show the list of views configured on this object.
Insert excerpt _recordsets_show _recordsets_show nopanel true	Show the list of recordsets for this object; see Managing Recordsets.
Image Modified Show Inputs	Add to the model all objects that are inputs to this object.
Image Modified Show Outputs	Add to the model all objects that are outputs of this object.
Insert excerpt _run_analysis _run_analysis nopanel true	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.
Insert excerpt _remove _remove nopanel true	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:

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.