UDFEntry

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)*

• IdentifierString(1) – Identifies the fact table the UDF is created for.

• IdentifierString(2) – Identifies the fact table the UDF is associated from.

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'

• IdentifierString – Identifies the field the UDF is created from.

• FloatingPoint – Weight value for a field item.

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

• IdentifierString(1) – Identifies a field to be compared.

• IdentifierString(2) – Identifies the field to compare IdentifierString(1) to.

Yes

Yes

Yes

Yes

Yes

TimeUDF

'TIME' FieldName TimeUnits IdentifierString (Time | IdentifierString)

• IdentifierString(1) – Identifies a timespan field.

• IdentifierString(2) – Identifies the timespan field to compare IdentifierString(1) to.

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)* )

• IdentifierString(1) – Quantile field item label format string.

• IdentifierString(2) – Identifies the field to range.

• IdentifierString(3) – Identifies a equal distributions field.

• PositiveInteger – Number of quantiles.

Yes

Yes

Yes

Yes

Yes

UDFEnd

'END UDF'

Yes

Yes

Yes

Yes

Yes