This page is for data modellers who are new to using PhixFlow. It explains the options in the analysis 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.
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
Insert excerpt |
---|
| _model_display |
---|
| _model_display |
---|
nopanel | true |
---|
|
button.
Tip |
---|
For complex processes the full model of all your data can be split across multiple analysis model diagrams. Model objects, such as tables, can appear in multiple model diagrams. Each diagram represents a view onto the whole data model. |
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.
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
- 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:
- Open the repository → Tables branch and find the table.
- 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
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
button in the model window toolbar.
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 |
- todo |
Insert excerpt |
---|
| _datasource |
---|
| _datasource |
---|
nopanel | true |
---|
|
| A datasource to configure a connection to an external database. |
Image Removed |
Insert excerpt |
---|
| _file_ftp |
---|
| _file_ftp |
---|
nopanel | true |
---|
|
| An FTP site to connect to an external file store. |
Image Removed |
Insert excerpt |
---|
| _http_datasource |
---|
| _http_datasource |
---|
nopanel | true |
---|
|
| A HTTP datasource to configure a connection to an external source. |
Image Removed |
Insert excerpt |
---|
| _database_collector |
---|
| _database_collector |
---|
nopanel | true |
---|
|
| A database collector import data from an external database. |
Image Removed |
Insert excerpt |
---|
| _file_collector |
---|
| _file_collector |
---|
nopanel | true |
---|
|
| A file collector to import a file from an external source. |
Image Removed Insert excerpt |
---|
| _http_collector |
---|
| _http_collector |
---|
nopanel | true |
---|
|
| A HTTP collector to import data from an external source via HTTP. |
Image Removed |
Insert excerpt |
---|
| _database_exporter |
---|
| _database_exporter |
---|
nopanel | true |
---|
|
| A database exporter to export data to an external database. |
Image Removed Insert excerpt |
---|
| _file_exporter |
---|
| _file_exporter |
---|
nopanel | true |
---|
|
| A file exporter to export data in a file. |
Image Removed |
Insert excerpt |
---|
| _http_exporter |
---|
| _http_exporter |
---|
nopanel | true |
---|
|
| A HTTP exporter to export data to an external source via HTTP. |
Image Removed |
Insert excerpt |
---|
| _table_aggregate |
---|
| _table_aggregate |
---|
nopanel | true |
---|
|
| An aggregate table, which combines data. |
Image Removed |
Insert excerpt |
---|
| _table_calculate |
---|
| _table_calculate |
---|
nopanel | true |
---|
|
| A calculate table (the default). |
Image Removed |
Insert excerpt |
---|
| _table_calculateBySet |
---|
| _table_calculateBySet |
---|
nopanel | true |
---|
|
| A Calculate-By-Set table. |
Image Removed |
Insert excerpt |
---|
| _table_cartesian |
---|
| _table_cartesian |
---|
nopanel | true |
---|
|
| A cartesian table. |
Image Removed |
Insert excerpt |
---|
| _table_merge |
---|
| _table_merge |
---|
nopanel | true |
---|
|
| A merge table. |
Image Removed |
Insert excerpt |
---|
| _property_settings |
---|
| _property_settings |
---|
nopanel | true |
---|
|
| Show model |
details 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. |
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 |
---|
Insert excerpt |
---|
| _object_copy |
---|
| _object_copy |
---|
nopanel | true |
---|
|
| Create a copy of the object. |
Insert excerpt |
---|
| _table_new_input |
---|
| _table_new_input |
---|
nopanel | true |
---|
|
| Add a new table with a pipe that connects into the selected object. |
Insert excerpt |
---|
| _object_predecessors |
---|
| _object_predecessors |
---|
nopanel | true |
---|
|
| Add all objects that are used to build this object in the underlying model. |
Insert excerpt |
---|
| _object_successors |
---|
| _object_successors |
---|
nopanel | true |
---|
|
| Add all objects that use this object in the underlying model. |
Insert excerpt |
---|
| _rollback |
---|
| _rollback |
---|
nopanel | true |
---|
| Table | Rollback data in the table. This opens the Rollback Recordsets form. |
Insert excerpt |
---|
| _delete |
---|
| _delete |
---|
nopanel | true |
---|
|
| 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. |
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
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.
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.