instantOLAP Online documentation 2.2.7 - ISCHILDOF

ISCHILDOF

Syntax

<ischildof-expression> := 'ISCHILDOF(' <Key> ',' <Key> { ',' <Key> } ')'

Since

1.2

Return-type

Boolean

Description

This function checks whether all keys from the first argument are equal to or children of at least one of the keys from the second argument.

A key A is child of a key B, if:

If more than two arguments are passed, all keys of the first arguments must be a child of at least one key of all following arguments

If one of the arguments is NULL, the function returns NULL. If the first argument is empty and contains no key, the function returns TRUE.

Examples

ISCHILDOF( Time:'Jan/2003', Time:'2003' )

= TRUE

ISCHILDOF( Time:'2003', Time:'Jan/2003' )

= FALSE

ISCHILDOF( Time:'2003', NULL )

= NULL

ISCHILDOF( NULL, Time:'Jan/2003' )

= NULL

See also

ISPARENTOF

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