instantOLAP Online documentation 2.2.7 - Functions

Functions

Contents of this chapter:

ABC
ABS
ADD
ALL
ANCESTORS
AND
ATTRIBUTENAMES
ATTRIBUTENV
ATTRIBUTES
AVG
AVGKEY
BEAUTIFY
BELONGSTO
CASE
CEIL
CHILDREN
CLUSTER
COLSPAN
CONCAT
CONTAINS
CONTAINSTEXT
COUNT
COUNTRY
CUBE
DEBUG
DEFAULTTEXT
DEVIATION
DEPTH
DIMENSIONATTRIBUTENAMES
DIMENSIONNAME
DIMENSIONNAMES
DISTINCT
DIV
DLOOKUP
DRILLKEY
DRILLLEVEL
DSORT
ELEMENT_AT
EMPTY
ENDSWITH
EQUAL
ERROR
EVAL
EXISTS
EXP
FACTROOT
FAMILY
FILTER
FILTERKEYS
FIND
FIRST
FLOOR
FOREACH
FORECAST
FPOP
FPUSH
GREATER
GREATER_OR_EQUAL
HASACCESS
HASCHILDREN
HASKEYS
HASLEVEL
HASPOSITION
HASROLES
HASUSER
IIF
IN
INTERSECT
ISCHILDOF
ISNULL
ISPARENTOF
ITERATIONKEY
JOIN
LANGUAGE
LAST
LEAFS
LEFT
LESS
LESS_OR_EQUAL
LEVEL
LEVELNAMES
LEVELOF
LIMIT
LOCALE
LOOKUP
LTRIM
MATCH
MATRIX
MAX
MAXKEY
MAX_X
MAX_Y
MIN
MINKEY
MIN_X
MIN_Y
MOD
MUL
NEIGHBOURS
NEXT
NONFACTROOTS
NONLEAFS
NOT
NOW
OR
PARENT
PEDIGREE
PERCENTILE
POSITIONOF
POW
PRED
PREV
RANGE
REGRESSION
REPLACE
RETURNTYPE
REVERSE
RIGHT
ROUND
ROWNUM
ROWSPAN
RTRIM
SORT
SPLINE
SPLIT
STARTSWITH
STRLEN
SUCC
SUBSTR
SUBSTRINGBEHIND
SUBTOTALS
SUB
SUM
TEXTPOSITION
TIMESTAMP
TODATE
TOINTEGER
TOKEY
TOLOWER
TONUMBER
TOSTRING
TOUPPER
TRIM
TYPE
UNEQUAL
UNIT
UPPERNEXT
UPPERPREV
USER
VARIANCE
WITHOUT
X
XHEADER
Y
YHEADER
YTD
ZERO

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Query properties
Chart properties
Configuration properties
Expressions
The Type-system
Syntax
Constants
Functions
ABC
ABS
ADD
ALL
ANCESTORS
AND
ATTRIBUTENAMES
ATTRIBUTENV
ATTRIBUTES
AVG
AVGKEY
BEAUTIFY
BELONGSTO
CASE
CEIL
CHILDREN
CLUSTER
COLSPAN
CONCAT
CONTAINS
CONTAINSTEXT
COUNT
COUNTRY
CUBE
DEBUG
DEFAULTTEXT
DEVIATION
DEPTH
DIMENSIONATTRIBUTENAMES
DIMENSIONNAME
DIMENSIONNAMES
DISTINCT
DIV
DLOOKUP
DRILLKEY
DRILLLEVEL
DSORT
ELEMENT_AT
EMPTY
ENDSWITH
EQUAL
ERROR
EVAL
EXISTS
EXP
FACTROOT
FAMILY
FILTER
FILTERKEYS
FIND
FIRST
FLOOR
FOREACH
FORECAST
FPOP
FPUSH
GREATER
GREATER_OR_EQUAL
HASACCESS
HASCHILDREN
HASKEYS
HASLEVEL
HASPOSITION
HASROLES
HASUSER
IIF
IN
INTERSECT
ISCHILDOF
ISNULL
ISPARENTOF
ITERATIONKEY
JOIN
LANGUAGE
LAST
LEAFS
LEFT
LESS
LESS_OR_EQUAL
LEVEL
LEVELNAMES
LEVELOF
LIMIT
LOCALE
LOOKUP
LTRIM
MATCH
MATRIX
MAX
MAXKEY
MAX_X
MAX_Y
MIN
MINKEY
MIN_X
MIN_Y
MOD
MUL
NEIGHBOURS
NEXT
NONFACTROOTS
NONLEAFS
NOT
NOW
OR
PARENT
PEDIGREE
PERCENTILE
POSITIONOF
POW
PRED
PREV
RANGE
REGRESSION
REPLACE
RETURNTYPE
REVERSE
RIGHT
ROUND
ROWNUM
ROWSPAN
RTRIM
SORT
SPLINE
SPLIT
STARTSWITH
STRLEN
SUCC
SUBSTR
SUBSTRINGBEHIND
SUBTOTALS
SUB
SUM
TEXTPOSITION
TIMESTAMP
TODATE
TOINTEGER
TOKEY
TOLOWER
TONUMBER
TOSTRING
TOUPPER
TRIM
TYPE
UNEQUAL
UNIT
UPPERNEXT
UPPERPREV
USER
VARIANCE
WITHOUT
X
XHEADER
Y
YHEADER
YTD
ZERO
Formats
SQL-Expressions