The OLAP row functions extend the syntax of the SQL row functions for use with dimensional objects. If you use the SQL row functions, then this syntax is familiar. You can use these functions on relational data when loading it into cubes and cube dimensions, and with the OLAP functions when creating calculated measures.
This chapter describes the row functions of the OLAP expression syntax. It contains these topics:
A B C D E F G H I L M N O P R S T U V W
The row functions are grouped into the following categories:
These functions accept numeric input and return numeric values:
These functions accept character input and return character values:
These functions return information about a character set:
These functions accept character input and return numeric values:
These functions operate on date, timestamp, or interval values:
These functions determine the greatest or least value in a set of values:
These functions change a value from one data type to another:
These functions return a numeric value for each input value:
These functions facilitate null handling:
These functions provide information about the instance and the session: