Skip to main content
Skip table of contents

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

  • 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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.