instantOLAP Online documentation 2.6.1 - REVERSE

REVERSE

Syntax

<reverse-expression> := 'REVERSE(' <Any> ')'

Since

1.2

Return-type

The type of the argument.

Description

This function returns all values from the argument in their reverse order.

Examples

REVERSE( 1 | 2 | 3 )

= 3 | 2 |1

REVERSE( LEVEL( Time, 3 ) )

E.g. returns Time:'Dec/2003' + ... + Time:'Jan/2003'

See also

INTERSECT, JOIN, WITHOUT

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