UDFEntry
SuperCROSS | Production System | SuperWEB2 | |||||
---|---|---|---|---|---|---|---|
Element | Format | Description | Save | Load | Load | Save | Load |
UDFEntry | 'UDF' IdentifierString (MultiUDF | SingleUDF | RangeUDF | WeightUDF | MathUDF | ComparisonUDF | TimeUDF | QuantileUDF) UDFEnd | IdentifierString – Display name of the UDF. | Yes | Yes | Yes | Yes | Yes |
MultiUDF | 'MULTI' IdentifierString IdentifierString (MultiCount | MultiCopy | MultiSum) (MultiConditions)* |
| Yes | Yes | Yes | Yes | Yes |
MultiCount | 'COUNT' PositiveInteger | PositiveInteger – Maximum number of field items within the UDF. | Yes | Yes | Yes | Yes | Yes |
MultiCopy | 'COPY' IdentifierString MultiNoMatchName MultiManyMatchName | IdentifierString – Identifies the name of field to copy. | Yes | Yes | Yes | Yes | Yes doesn't show hierarchy field |
MultiNoMatchName | (IdentifierString | 'No Matches') | IdentifierString – Identifies the field item to add the value to if no matches occur. | Yes | Yes | Yes | Yes | Yes |
MultiManyMatchName | (IdentifierString | 'Multiple Matches') | IdentifierString – Identifies the field item to add the value to if many matches occur. | Yes | Yes | Yes | Yes | Yes |
MultiSum | 'SUM' IdentifierString | IdentifierString – Identifies the field the summation is based on. | Yes | Yes | Yes | Yes | Yes |
MultiConditions | (InCondition | MinCondition | MaxCondition) {'OR' MultiConditions} | Yes | Yes | Yes | Yes | Yes | |
InCondition | 'IN' ItemMap | Yes | Yes | Yes | Yes | Yes | |
ItemMap | IdentifierString 'MAP' (FieldItem)+ 'END MAP' | IdentifierString – Identifies a field the condition is based on. | Yes | Yes | Yes | Yes | Yes |
MinCondition | 'MINIMUM' IdentifierString | IdentifierString – Identifies a field the maximum is based on. | Yes | Yes | Yes | Yes | Yes |
MaxCondition | 'MAXIMUM' IdentifierString | IdentifierString – Identifies a field the minimum is based on. | Yes | Yes | Yes | Yes | Yes |
SingleUDF | 'SINGLE' IdentifierString (SingleResultName)+ | IdentifierString – Identifies the fact table the UDF is created for. | Yes | Yes | Yes | Yes | Yes |
SingleResultName | 'RESULT' IdentifierString WS (ItemMap) 'END RESULT' | IdentifierString – Indicates the name of a field item for the UDF. | Yes | Yes | Yes | Yes | Yes |
RangeUDF | 'RANGE' IdentifierString 'VALUES' (RangeValue)+ 'END VALUES' | IdentifierString – Identifies the field the UDF is created from. | Yes | Yes | Yes | Yes | Yes |
RangeValue | (LT | LTE) WS (FloatingPoint) | FloatingPoint – Range value boundary. | Yes | Yes | Yes | Yes | Yes |
WeightUDF | 'WEIGHT' IdentifierString 'VALUES' (FloatingPoint)+ 'END VALUES' |
| Yes | Yes | Yes | Yes | Yes |
MathUDF | 'MATH' IdentifierString MathFormula | IdentifierString – Identifies the fact table the UDF is created for. | Yes | Yes | Yes | Yes | Yes |
MathFormula | UnaryOp '(' MathFormula ')' | UniqueOp | MathFormula | FloatingPoint {BinaryOp (UnaryOp '(' MathFormula ')' | MathFormula | FloatingPoint)} | Yes | Yes | Yes | Yes | Yes | |
UniqueOp | 'UNIQUE(' IdentifierString { ', ' IdentifierString}* ')' | IdentifierString - Identifies a field to be combinated | Yes | Yes | |||
ComparisonUDF | 'COMPARISON' IdentifierString IdentifierString |
| Yes | Yes | Yes | Yes | Yes |
TimeUDF | 'TIME' FieldName TimeUnits IdentifierString (Time | IdentifierString) |
| Yes | Yes | Yes | Yes | Yes |
TimeUnits | 'DAYS' | 'MONTHS' | 'YEARS' | Yes | Yes | Yes | Yes | Yes | |
Time | 'DATE' PositiveInteger | PositiveInteger – date in the format YYYYMMDDHHNNSS | Yes | Yes | Yes | Yes | Yes |
QuantileUDF | 'QUANTILE' IdentifierString IdentifierString IdentifierString PositiveInteger (InCondition ('OR' InCondition)* ) |
| Yes | Yes | Yes | Yes | Yes |
UDFEnd | 'END UDF' | Yes | Yes | Yes | Yes | Yes |