...

Stream Properties

...

Basic Settings

...

Insert excerpt

	_Banners
	_Banners
name	analysis
nopanel	true

Overview

Tables are a key model component. They represent a structured store of data within PhixFlow receiving data from one or more components, processing it then storing it. When you make changes to tables and attributes, PhixFlow automatically publishes them to the database; see Publishing Tables.

Excerpt

name	FileTable

For

Insert excerpt

	_tableFile
	_tableFile
nopanel	true

s, see File Table.

Insert excerpt

	_property_toolbar
	_property_toolbar
nopanel	true

The toolbar has the following additional buttons:

Insert excerpt

	_recordsets_show
	_recordsets_show
nopanel	true

,

Insert excerpt

	_view_show
	_view_show
nopanel	true

,

Insert excerpt

	_run_analysis
	_run_analysis
nopanel	true

.

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Insert excerpt

	_parent
	_parent
nopanel	true

Basic Settings

Field	Description
Name	The name of the table.
Description	We recommend that you always enter a description to explain the purpose of this item.

Attributes

The grid lists the attributes (data columns) in the table data.

Excerpt

name	Attributes

To add a new attribute to the list, click the
Insert excerpt
_add_icon
_add_icon
nopanel true
icon
To edit the properties of an attribute, double-click the attribute name to open the Attribute properties
To remove an attribute from the table, right-click the attribute and select
Insert excerpt
_delete
_delete
nopanel true
To add an attribute from another table, open the table and drag the attributes from one table to the other

Excerpt

name	Views

Views

The grid contains a list of the data views for this table.

To edit the properties of a view, double-click its name. To add a view to the list, click
Insert excerpt
_new
_new
nopanel true
. PhixFlow opens the View properties tab.
To remove a view from the table, select the view and click
Insert excerpt
_delete
_delete
nopanel true
in the toolbar.

Anchor
multipliers
multipliers
Analysis Options

Field

Description

Enabled

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to include the table during analysis runs.

Static Data

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to set the table to hold static data. Static data is reference or "look up" data that is used as part of a table calculation.

Updating a static table

In general, static tables are not updated during an analysis run that is initiated on another table in the model. The exception is when an incoming push pipe is triggered, as this will force the table to update itself.

Instead, to update the data in a static table you must run analysis directly on the table via:

the model
a task plan.

Period

Select the time period for the table:

Excerpt

name	Period

Transactional

This allows multiple users to run independent analysis tasks at the same time.

...

When the period is first set to Transactional the UID stream attribute will be created if it does not already exist.

...

The type of function used to generate this stream. Possible types are:

...

You can select a "loop" pipe - that is, a pipe linking the stream back into itself - in this field. If you do, new records will be compared to existing records, using the selected loop pipe, and if a repeated record is found, the old one will be marked as 'superseded'.

...

Only applies when period is Transactional. If ticked, updates and deletes initiated by stream actions (not those carried out by analysis runs) will automatically mark the existing record as superceded and create a new stream set. The new versions of the updated records will be placed in the new stream set. Inserts will simply create a new stream set, and add the inserted record into that stream set.

When Audit Manual Changes is first set, the attributes UpdateAction, UpdatedByName, UpdatedByID and UpdatedTime will be created if they do not already exist. If you do not require these attributes, delete them.

UpdateAction must be set to the type of action, such as INSERT, UPDATE or DELETE. The other attributes will be populated if they exist on the stream:

UpdatedByName - the name of the user that performed the update,
UpdatedByID - the internal id of the user that performed the update
UpdatedTime - the date and time the update was made

Attributes

A list of the stream attributes in the stream. The toolbar on this section has the options: Image RemovedShow list of File Collectors and Image Removed Shows the list of Streams.

To edit the properties for an attribute, double-click the attribute name. To edit only the expression:

Right-click an attribute name to display the context menu.
Select Edit the expression field.
PhixFlow opens a simple text editor box
Make changes to the attributes expression.
Click Image Removed to save your changes.

...

String
Stream
Integer
Float
Stream
Date
Datetime
Graphic
TrueFalse

...

The order of the attributes in the stream. This is important because the stream attribute expressions are evaluated in this order. If the results of an attribute expression, or a $ variable calculated during its calculation, are required in the expression of a second attribute - the second attribute must come after the first in the attribute list.

...

Advanced

...

When 1 or more output pipes from the stream uses the field to 'Filter' the stream.
When 1 or more output pipes from the stream uses the field in a 'Sort/Group' by action.

...

If ticked, new filter conditions on this field are case-insensitive by default. The filter window → Ignore Case check box inherits this setting; see Filters on Data Views. For case-insensitive filters, there is no difference if the attribute is also indexed.

...

Description

??

...

do ( $aRange = [], addElement($aRange, rng.RangeFrom), addElement($aRange, rng.RangeTo), $bRange = [], addElement($bRange, $aRange), $bRange )

...

ifNull(in.ASSET, [1,10,12] , // else do [5,7] )

...

do( lookup(lkin, $num = in.BNumber), lkin )

will return a list of records which match the lookup on the lkin pipe. In this case the required data can be extracted from the Output Multiplier using the following expression :

do ( $values = _type, $values.account_num )

If the output multiplier expression evaluates to _NULL, an empty list of values or an empty list of records then a single output record will be produced with _type set to _NULL, _NULL or an empty record respectively.

...

Actions

A list of the stream actions on the stream. See Action.

Views

A list of the views on the stream. See Stream View.

Sort Orders

A list of the sort orders on the stream. See Stream View Order.

Filters

A list of the filters on the stream. See Filters on Data Views.

Any filter defined on the stream may appear in the dropdown list of filters accessible from the header of each stream view. To make a filter available in a view, the filter must be added to the list of filters for that view. See Stream View for details.

All filters defined on this tab will be available on the system generated Default View for this Stream.

Inputs

A list of pipes into the stream.

...

Default Data Range

This option affects the following items for which this is the backing table:

views
screens
card components.

Insert excerpt

	_data_range
	_data_range
nopanel	true

If no option is is selected, PhixFlow assumes the default data range is All.

You can override this setting using the options Use Custom Data Range and Data Range available:

on a Screen.
on a card; see Component.

You cannot override this setting for a view.

Table Type

Select the table type; see Types of Table and When to Use Them. The type indicates the function that operates on the data.

Aggregate Table
Calculate Table
CalculateBySet Table
Cartesian Table
Merge Table

Supersede Items on Pipe

Select a loop pipe from the list of those available.

A loop pipe links the table back to itself. It compares new data records to the existing data records. If there is a repeated record PhixFlow uses the new one in the table and marks the old one as superseded.

Input Multiplier

The input multiplier expression should evaluate to a list of one or more values. For each value in the list, the internal variable _inputMultiplier will be set to that value and the whole table processing will be repeated i.e. the pull pipes will be read and the data from those pipes processed to generate output records to be added to the current recordset. For example :

do ( $aRange = [], addElement($aRange, rng.RangeFrom), addElement($aRange, rng.RangeTo), $bRange = [], addElement($bRange, $aRange), $bRange )

Where rng.RangeFrom = 500 and rng.RangeTo = 1000, the above example evaluates to [[500,1000]], which is a list containing 1 element, which is itself a list containing 2 elements. An input multiplier that evaluates to [3,4,7,8] would run the Table 4 times.
Because Input Multipliers are evaluated first in the PhixFlow Timing Cycle they are often used to look up values that can be passed to Database or other Collectors.

See Expressions and PhixScripts.

Log Input Multiplier Messages

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to cause PhixFlow to write a message to the log every time an Input Multiplier value changes during an analysis run.

Output Multiplier

This field is an expression which should evaluate to an array of values. A separate output record will be produced for each value in the array and this value is available as _outputMultiplier in each of the table output attribute expressions (each value in the array is also available through _type, although this is not recommended usage). In effect this will multiply each of the output records by the number of elements from the returned list.
For example :

ifNull(in.ASSET, [1,10,12] , // else do [5,7] )

will create 3 records for every record in the table if in.ASSET contains a value (setting _type = 1, 10 and 12 in each case). Otherwise it will create 2 records for every record in the table (and set _type = 5 and 7). An output multiplier may also evaluate to a record, or a group of records. For example an Output Multiplier with the expression:

do( lookup(lkin, $num = in.BNumber), lkin )

will return a list of records which match the lookup on the lkin pipe. In this case the required data can be extracted from the Output Multiplier using the following expression :

do ( $values = _type, $values.account_num )

If the output multiplier expression evaluates to _NULL, an empty list of values or an empty list of records then a single output record will be produced with _type set to _NULL, _NULL or an empty record respectively.

See Expressions and PhixScripts.

Select Records to Output

(Formerly Output Filter)

You can select a subset of records to output to the next modelling object. You select records using the data in any attribute that is in the table output. Enter an expression that should evaluate to true or false (equivalently 1 or 0).

When the expression evaluates to true or 1, the records found by the expression are selected and output to the next modelling object.

For example:

A table containing data about accounts has an attribute called "active".
You only want to include "active" accounts in the following tables.
Active accounts have the value 1.

To select active accounts, enter the expression _out.active.
All records that have the active attribute set to any other value are ignored.

See Expressions and PhixScripts.

Actions

The grid contains a list of actions that operate on the table.

To edit the properties of an action, double-click its name
To add an action to the list, click
Insert excerpt
_new
_new
nopanel true
and PhixFlow opens the Table-Action properties tab
To remove an action from the table, select the action and click
Insert excerpt
_delete
_delete
nopanel true
in the toolbar

Record-Actions

The grid contains a list of record-actions that can update records in the table.

To edit the properties of a record-action, double-click its name
To add a record-action to the list, click
Insert excerpt
_new
_new
nopanel true
and PhixFlow opens the Record-Action properties tab
To remove a record-action from the table, select the record-action and click
Insert excerpt
_delete
_delete
nopanel true
in the toolbar

Excerpt

name	SortOrders

Sort Orders

The grid contains a list of the sort orders for this table.

To edit the properties of a sort order, double-click its name
To add a sort order to the list, click
Insert excerpt
_new
_new
nopanel true
and PhixFlow opens the Sort Order properties
To remove a sort order from the table, select the sort order and click
Insert excerpt
_delete
_delete
nopanel true
in the toolbar

Excerpt

name	Errors

Errors
Anchor
error
error

Insert excerpt

	_validate
	_validate
name	error
nopanel	true

Excerpt

name	ERDs

ERDs

The grid displays a read-only list of the Entity Relationship Diagrams (ERDs) that this table is part of. Double-click an ERD to open it. See Entity Relationship Diagrams.

Excerpt

name	Relations

Relations

The grid displays a read-only list of the relationships that this table has to attributes in other tables. Double-click a relationship to display it's properties; see Relationship and Entity Relationship Diagrams.

Excerpt

name	Filters

Filters

The grid contains a list of the filters that can be applied to this table. You can add filters to view based on this table.

All filters in this list are available in the default view for this table. For views that you create, in the View properties tab → Filters section, you can add filters. The list of available filters is populated by the filters defined for the table.

To edit the properties of a filter, double-click its name. To add a filter to the list, click

Insert excerpt

	_new
	_new
nopanel	true

. PhixFlow opens the Filter properties tab.

To remove a filter from the table, select the filter and click

Insert excerpt

	_delete
	_delete
nopanel	true

in the toolbar.

Tip
In a view grid, the header row has a drop-down list of filters. The drop-down list is populated by the filters that are selected on the view. The filters must first be defined for the table here.

Inputs

This section lists all pipes that connect into the table. Double-click a pipe to view more details and make changes. See Pipe.

This section has a toolbar with

Insert excerpt

	_detailed_list
	_detailed_list
nopanel	true

and

Insert excerpt

	_refresh
	_refresh
nopanel	true

buttons; see standard buttons, see Menu Options and Toolbar Buttons.

Note
This list can include pipes that have no input. This occurs if the source

...

download_limits
download_limits

The following properties affect the number of data records a user can download from a view, such as a grid, chart or card; see Download CSV or Excel Data.

Field	Description

...

The number of days data to keep in the stream.

When an archive task runs for a stream, all stream data is deleted if it is at least Keep for X Days old or if it is older than the Keep for Y Stream Sets most recent valid stream sets.

If both Keep for X Days and Keep for Y Stream Sets are set, stream data will be deleted only if it meets both conditions. If neither are set, stream data is kept indefinitely.

If Save Archive to File is ticked, deleted items are first saved to archive files.

The age of data in a stream set is its 'to' date relative to the 'to' date of the newest valid stream set in the stream.

See here for how to set up and schedule an Archive Task.

Please see the section below on Archiving Examples to see how this value can be used within Archiving strategies.

...

The number of stream sets data to keep in the stream.

See Keep for X Days for the main description of archiving.

...

The number of days for which to keep superseded data in the stream.

If Track Superseded Data is ticked, then this field will become visible/enabled.

In a stream where the superseded date is tracked, the stream data will contain a mixture of superseded records and "active" records - that is, records that have not been superseded.

When an archive task runs for a stream, records that were marked as superseded more than Keep Superseded for X Days days or more than Keep Superseded for Y Stream Sets stream sets ago are deleted.

If both Keep Superseded for X Days and Keep Superseded for Y Stream Sets are set, superseded records will be deleted only if they meet both conditions. If neither are set, superseded records are not deleted.

This means, for example, that if you have set Keep Superseded for X Days to 4, you will be able to roll back 3 days, making the 4th day the latest valid day.

If Save Archive to File is ticked, deleted items are first saved to archive files.

Please see the section below on Archiving Superceded Examples to see how this value can be used within Archiving strategies.

...

The number of stream sets for which to keep superseded data in the stream.

If Track Superseded Data is ticked, then this field will become visible/enabled.

See Keep Superseded for X Days for the main description of archiving superseded records.

...

Access Permissions

...

If checked, this specifies that all users can view this data by default (provided they have the basic privilege to view streams).

If this field is not checked, then access to the underlying data is controlled by dropping user groups onto the stream's "User Group" tab.

Note that the default setting for this field on streams is controlled by the system parameter allowAccessToDataByDefault.

Analysis Models

A list of the analysis models that this stream appears on.

Advanced

The advanced properties field should only be set by, or under the guidance of, PhixFlow support.

...

All: indexes on the Stream are optimised for selecting from all stream sets (non-historied reads).
Latest: indexes on the Stream are optimised for selecting from the latest stream set (i.e. for historied reads).
Superseded: indexes on the Stream are optimised for self-updating streams which have a moslty superseded records.
None: no indexes are created on the Stream.

...

Database: Store the data in a regular table within the PhixFlow database. This is the most common option
Database (Partitioned): Store the data in a partitioned table within the PhixFlow database. This option provides improved performance for rollback and archiving of very large Streamsets. The option is only available if "partitioning" is available within your database installation.
In Memory: Data for the Stream will not be written to the database. This option can be used (for example) when you want to aggregate large amounts of unsorted data which can then be written to a stored Stream.

...

This field only appears if the Period is set to Transactional. If ticked, it ensures that only a single stream set can be generated at a time even if the stream receives several concurrent requests to generate data.

This can be useful where you want to make sure that two analysis runs don't attempt to update the same records at the same time e.g. as a result of two people selecting the same records in a view and then hitting the same action button at the same time to process those records.

...

If this flag is ticked then whenever the analysis engine needs to generate data for this stream it will first wait for all running tasks to complete before it starts.

Any additional analysis tasks submitted while this stream is waiting to start, or while it is generating data, will wait until this stream has completed its analysis before they start.

...

The table below assumes the stream to be archived currently contains 8 stream sets. Two from the current day and one from each of the previous 6 days.
In the table below the value null refers to the fact that no value has been entered into this field.
Note that archiving will always retain the maximum active stream sets in the data such that no conflicting stream sets will be archived.

...

In the case where only the Keep Superseded for X Days and Keep Superseded for Y StreamSets fields are populated, the same logic in the table above will apply to the superseded records. Note that again archiving will always retain the maximum superseded stream sets in the data such that no conflicting stream sets will be archived.

In the cases where a mixture of the full archive fields Keep for X Days, Keep for Y StreamSets' and the superseded archive fields Keep Superseded for X Days, Keep Superseded for Y StreamSets are populated, then the full archive values will be first applied and the resultant stream item records will be archived and deleted. Only then will the remaining stream sets use the Keep Superseded ... values to apply a further condition to archive and delete any remaining non qualifying superseded records.

Attribute Types

If you load data without specifying a type what happens?

Does PhixFlow make a best guess at what the type is and if it's not sure, assumes string??

What if you want to change a format - e.g set a decimal or date format?

Which fields can have "null"?

String

Apply a string type to sequences of characters (i.e., letters, numerals, symbols and punctuation marks). By default string attribute types have a fixed length of how long?

do we need to tell users about any information-loss if data that is naturally a different type gets loaded as a string?

...

Apply a bigstring type to text strings over 4000 characters long. Bigstring is a different data type to string and has some restrictions on filtering, sorting and aggregation.

For PhixFlow instances that use an Oracle database, bigstrings cannot be sorted or aggregated. On Oracle bigstrings may only be filtered with the conditions:

(not) contains
is (not) null
(not) starts with
(not) ends with.

The maximum bigstring size can be configured in System Configuration → System Tuning → Maximum Bigstring Size.

Integer

Apply an integer type to whole numbers (not a fractions or decimals) that can be positive, negative, or zero.

What happens if you attempt to load a float or decimal number into an integer attribute?

Float

Apply a float type to non-integer numbers with an undefined level of precision. Float numbers have:

significant figures: the total number of digits stored,
decimal places: the number of digits after the decimal place.

...

Apply a decimal type to non-integer numbers with a set level of precision. Decimals have a specific number of:

significant figures: the total number of digits stored,
decimal places: the number of digits after the decimal place.

The maximum number of integer digits is therefore the significant figure minus the decimal places. By default, decimals have 10 significant figures and 2 decimal places, and therefore 8 integer digits.

If the number of integer digits present in a decimal field exceeds the specified format, running analysis will fail and PhixFlow will report an error.

If the number of decimal digits present in a decimal field exceeds the specified format, PhixFlow will discard the excess decimal places. For example, if a data record includes the number 12.3456, but the decimal type can have 4 significant figures and 2 decimal places, PhixFlow records 12.34.

Note
Ensure your decimal type has the number of decimal places you need for yout data. Once the data is loaded into PhixFlow, you will not be able to recover excess decimal places.

Date

Apply a date type to representations of a calendar day.

Are there any specific formats to say are recognised/not recognised?

What about word formats e.g. Tuesday the fourteenth of February?

Datetime

Apply a datetime type to representations of a time, or day and time.

Are there any specific formats to say are recognised/not recognised?

Graphic

Is this still available?

TrueFalse

Apply a TrueFalse type to fields that can have the values true or false.

...

Table Download Limit

Enter the maximum number of records that a user can download from a view on this table. If no value is set, PhixFlow uses the default limit set in System Configuration→ System Tuning → Default Download File Limit.

Allow Unlimited Downloads

Insert excerpt

	_check_box_untick
	_check_box_untick
nopanel	true

to restrict all users to the Table Download Limit.

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to display a User Groups section where you can specify user groups whose members can download unlimited data from a view on this table. For example, members of the Administrators user group may need to download all data.

User Groups

Available when Allow Unlimited Downloads is ticked.

Use this section to select the user groups whose members can download an unlimited number of records.

This section has a toolbar with standard buttons, see Menu Options and Toolbar Buttons, and

Insert excerpt

	_user_group
	_user_group
nopanel	true

.

The grid contains a list of user groups that are exempt from the Table Download Limit. To add a user group to the list:

Click
Insert excerpt
_user_group
_user_group
nopanel true
to list all the user groups in the repository.
Drag user groups into this list to add them to the role.

To remove user groups, use the

Insert excerpt

	_delete
	_delete
nopanel	true

in the toolbar.

Excerpt

name	DataRetentionSettings

Data Retention Settings
Anchor
data-retain
data-retain

Use the following options to specify how PhixFlow manages old data when a table-data-delete task runs.

Warning

We recommend that you always specify the data retention values for every table you create.
PhixFlow checks that a table has:

either data retention settings (recommended)
or Retain All Data selected.

If no data retention option is set, PhixFlow displays an error in the Errors section, above.

Using Tasks and Task Plans for information about tasks.
Deleting Old Data to see how you can use these values in data management strategies.

Field

Description

What Data is Deleted

Retain All Data

Insert excerpt

	_check_box_untick
	_check_box_untick
nopanel	true

to specify the criteria for keeping data in the Keep... properties below (recommended).

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to allow old data to accumulate in PhixFlow.

Warning
Tables with Retain All Data ticked never have their data deleted and the data will accumulate. This can lead to performance issues.

Keep for N Days

Anchor

	keepForXDays
	keepForXDays

Enter the number of days to keep data in the table.

The age of data in a recordset is its 'to' date, relative to the 'to' date of the newest valid recordset in the table .

When a table-data-delete task runs for a table and:

Keep for X Days only is set, PhixFlow deletes table data that is older than N days.
Keep for Y Recordsets only is set, PhixFlow keeps the most recent X recordsets and deletes recordsets that exceed X.
both Keep for X Days and Keep for Y Recordsets are set, PhixFlow deletes the table data that meets both conditions.
neither Keep for N Days nor Keep for X Recordsets are set, PhixFlow keeps table data indefinitely. This can lead to performance issues.

Keep for X Recordsets

The number of recordsets to keep in the table.

Keep Superseded for N Days

Anchor

	keepSupersededForXDays
	keepSupersededForXDays

Available when Track Superseded Data is selected.

Enter the number of days to keep superseded records in the table data.

Tip

Remember to keep superseded records for as long as you want the option to roll back the data.

For example, when Keep Superseded for N Days is set to 4, you can run roll back on data that was superseded up to 4 days ago.

A table-data-delete task removes superseded records older than 4 days, so PhixFlow no longer has the data to be able to roll it back.

In a table where the superseded date is tracked, the table data contains a mixture of active records and records that have been superseded.

When a table-data-delete task runs for a table and:

Keep Superseded for N Days only is set, PhixFlow deletes data records that were superseded more than N days ago.
Keep Superseded for X Recordsets only is set, PhixFlow deletes superseded records from the recordsets that exceed X.
both Keep Superseded for N Days and Keep Superseded for X Recordsets are set, PhixFlow deletes the superseded records that meet both conditions.
neither Keep Superseded for N Days nor Keep Superseded for X Recordsets are set, PhixFlow keeps superseded records indefinitely. This can lead to performance issues.

Keep Superseded for X Tablesets

Available when Track Superseded Data is selected.

Enter the number of recent recordsets that will retain their superseded data records.

Apply Delete Filter

Image Added:

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to open a filter tab where you can set filter conditions; see Filter. PhixFlow applies this filter when it runs a table-data-delete task. Only the records which match the filter are deleted.

Insert excerpt
_model_prop
_model_prop
nopanel true

Excerpt

name	Advanced

Advanced

Only change the advanced properties with advice by PhixFlow support.

Field Description

Advanced Properties Only use this field with advice from PhixFlow support.

Database View

Use this property if your database administrator wants to query table data in the PhixFlow database.

Enter a string in the format v_xxxx. When the table is published to the database, PhixFlow creates a view. If the table is deleted, the next system task that runs will clear the associated view from the database.

By default, this field is blank and no view is created in the database.

Audit Manual Changes

This toggle is available when the Analysis Options → Period is Transactional.

Insert excerpt

	_toggle_on
	_toggle_on
nopanel	true

toggle on to update and delete initiated by actions (not those carried out by analysis runs) will automatically mark the existing record as superseded and create a new recordset. The new versions of the updated records will be placed in the new recordset. Inserts will simply create a new recordset, and add the inserted record into that recordset.

When Audit Manual Changes is first set, the attributes UpdateAction, UpdatedByName, UpdatedByID and UpdatedTime will be created if they do not already exist. If you do not require these attributes, delete them. For the UpdatedByName attribute, PhixFlow creates a field of 250 characters.

UpdateAction must be set to the type of action, such as INSERT, UPDATE or DELETE. The other attributes will be populated if they exist on the table:

UpdatedByName - the name of the user that performed the update,
UpdatedByID - the internal id of the user that performed the update
UpdatedTime - the date and time the update was made

Storage Options

Index Scheme

Anchor

	index_scheme
	index_scheme

Select an option to determine how indexes on the table are organised.

All: indexes on the table are optimised for selecting from all recordsets (non-historied reads).
Latest: indexes on the table are optimised for selecting from the latest recordset (i.e. for historied reads).
Superseded: indexes on the table are optimised for self-updating tables which have a mostly superseded records.
None: no indexes are created on the table.
Partitioned: this index scheme is specific to partitioned tables; see Storage Type below. Partitioned tables must use this index scheme, and only partitioned tables can use it.

Storage Type

Select an option to specify how data for the table should be stored:

Database: Store the data in a regular table within the PhixFlow database. This is the most common option
Database (Partitioned): Store the data in a partitioned table within the PhixFlow database. This option provides improved performance for rollback and retaining very large recordsets. The option is only available if "partitioning" is available within your database installation.
In Memory: Data for the table will not be written to the database. This option can be used (for example) when you want to aggregate large amounts of unsorted data which can then be written to a stored table.

Data Generation Options

Anchor

	data-gen
	data-gen

Start Date

Enter the date on which this table starts or click

Insert excerpt

	_calendar
	_calendar
nopanel	true

to select a date. Data will be populated into the table from this date onwards.

Primary Key Generator

This option relates to an actionflow with a save node that inserts a new record into a table. Each new record requires a unique value for the record's primary key. Use this option to specify how PhixFlow generates the primary key value.

Internal: PhixFlow generates unique primary key values automatically. This is equivalent to setting the attribute expression to _NULL.
Sequence: display the Primary Key Generator Sequence option, in which you can select a sequence of values.

Primary Key Generator Sequence

Available when Primary Key Generator is Sequence.

Select a sequence to assign a new value to the primary key attribute of a new record; see Sequence.

The new record takes the next primary key value in a sequence. This is equivalent to setting the attribute expression to nextValue("sequenceName".

In Memory Cache Size Enter the size of the cache that will be maintained when you are using an in-memory table. See Manage Unsorted Data Using an In-Memory Table.

Allow Partial Set Processing

Insert excerpt

	_check_box_untick
	_check_box_untick
nopanel	true

to restrict all users to the Table Download Limit.

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

so that, when analysis reaches the end of a buffer block, it submits the candidate set for processing, even if the next buffer block has a different key.

Prevent Parallel Processing

Available when Period is Transactional.

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to ensure only a single recordset can be generated at a time even if the table receives several concurrent requests to generate data.

This can be useful where you want to make sure that two analysis runs do not attempt to update the same records at the same time e.g. as a result of two people selecting the same records in a view and then hitting the same action button at the same time to process those records.

Run Alone

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

so that, whenever the analysis engine needs to generate data for this table, it will first wait for all running tasks to complete before it starts.

Any additional analysis tasks submitted while this table is waiting to start, or while it is generating data, will wait until this table has completed its analysis before they start.

Key Tolerances When building a candidate set, data can be grouped together using a specific key value, e.g. Account Number. If the key value is a number, enter a key tolerance to identify numbers within the given tolerance as the same key value.

Default View Select the default view for the table; see Views for details of creating views on tables.

Last Run Date (Read only) PhixFlow displays the date and time that analysis was last run for this table. This date is taken from the "to date" of the most recent recordset for this table.

Last Run By PhixFlow displays the user that last ran analysis on this table.

Insert excerpt

	_access
	_access
nopanel	true

By default, the permissions to access table data is set in System Configuration → Allow access to data by default. You can add specific user groups to restrict access to the table.

Insert excerpt

	_audit
	_audit
nopanel	true

Live Search
spaceKey @self
additional none
placeholder Search all help pages
type page

Panel

borderColor	#00374F
titleColor	white
titleBGColor	#00374F
borderStyle	solid
title	Sections on this page

Table of Contents

maxLevel	3
indent	12px
style	none

Learn More

Version	Old Version 56	New Version Current
Changes made by	Fiona Sargeant (Unlicensed)	Zoe Baldwin
Saved on	Jul 16, 2019	Jan 09, 2025

Content Comparison

Versions Compared

Key

Stream Properties

Basic Settings

Overview

Insert excerpt_property_tabs_property_tabsnamebasic-hnopaneltrue

Basic Settings

Attributes

Views

AnchormultipliersmultipliersAnalysis Options

Updating a static table

Attributes

Advanced

Description

Actions

Views

Sort Orders

Filters

Inputs

Actions

Record-Actions

Sort Orders

Errors Anchorerrorerror

ERDs

Relations

Filters

Inputs

Download Limits Anchor

download_limitsdownload_limits

Access Permissions

Analysis Models

Advanced

Attribute Types

String

Integer

Float

Date

Datetime

Graphic

TrueFalse

Data Retention Settings Anchordata-retaindata-retain

Insert excerpt_model_prop_model_propnopaneltrue

Advanced

Live SearchspaceKey@selfadditionalnoneplaceholderSearch all help pagestypepage

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Anchor
multipliers
multipliers
Analysis Options

Errors
Anchor
error
error

Download Limits
Anchor

download_limits
download_limits

Data Retention Settings
Anchor
data-retain
data-retain

Insert excerpt
_model_prop
_model_prop
nopanel true

Live Search
spaceKey @self
additional none
placeholder Search all help pages
type page