...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
This setting is not available from the repository browser. It opens from:
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
To improve performance, index an attribute when the stream has a large data set and an output pipe from the stream uses this attribute to:
- filter the stream data
- sort or group the stream data.
...
...
...
...
...
...
...
...
...
...
Access Permissions
...
...
...
...
This grid is available if All Users Can View Data is not ticked.
...
Apply aAll stream attributes have a type. The default is string.
Once the stream has data, the attribute type can only be changed if the database allows the change. this is database dependent. You will see an error if your change is not allowed. If the stream has no data then any change in attribute type is possible.
String
Apply a string type to sequences of characters, such as letters, numerals, symbols and punctuation marks. By default string attribute types have a default length of 50. However you can configure a minimum length of 1 and a maximum length of 4000.
...
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) containsis (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. The number of digits in an integer indicates its precision.
- The default precision is 10 digits
- The minimum precision is 1 digit
- The maximum precision is 38
If you store a number with decimal places as an integer it will be truncated.
Float
Apply a float type to non-integer numbers with an undefined level of precision.
...
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 round to the required precision. 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.35.
| Note |
|---|
Ensure your decimal type has the number of decimal places you need for your 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. Word formats, such as Tuesday the fourteenth of February are not recognised. However, three letter month abbreviations are recognised, for example: 14 Feb 2019.
The following date formats, have:
- y represents year digits
- M represents month digits or MMM represents three letters
- d represents day digits
- separators can be forward slash / hyphen - or a space.
Recognised Date Formats
- the international standard format has not separators and is yyyyMMdd, for example 20190214.
- the following variations (examples shown with space separators).
...
Datetime
Apply a datetime type to representations of a day and a time. It cannot be used to represent a time alone.
Datetimes can have any of the above date formats followed by a space separator and HH:mm:ss. for example MM/dd/yy HH:mm:ss represents a datetime such as 02/14/19 15:35:06.
- H represents hour digits (24 hour)
- m represents minute digits
- s represents second digits
- time separators are colons :
The international datetime uses a full stop/period as a separator between the date and time, yyyyMMdd.HHmmss, for example 20190214.15:35:06.
| Note |
|---|
PhixFlow recognises date and datetime formats, but does not recognise time-only formats, for example HH:mm:ss. When a database collector loads TIME data, it therefore sets the string data-type. |
Graphic
Is this still available?
TrueFalse
Apply a TrueFalse type to fields that can have the values true or false.
The values that are saved as true are:
- any number other than 0
- for a list: all items in the list are true
- the following case-insensitive strings
- true
- t
- yes
- y.
The values that are saved as false are:
...