Using the expression editor

An expression is any combination of operators, constants, functions, and other components that evaluates to a single value. You build expressions to create calculation and filter definitions. A calculation is an expression that you use to create a new value from existing values that are contained within a data item. A filter is an expression that you use to retrieve a specific subset of records.

Build expressions that use the following components.

Operators
Operators specify what happens to the values on either side of the operator. Operators are similar to functions, in that they manipulate data items and return a result.
Summaries
This list contains predefined functions that return either a single summary value for a group of related values or a different summary value for each instance of a group of related values.
Member Summaries
This list contains predefined functions that return either a single summary value for a set of members or a different summary value for each member of a set of members.
Constants
A constant is a fixed value that you can use in an expression.
Constructs
This list contains constructs and templates that can be used to create an expression. Templates combine multiple functions into a group. For example, the search case template includes the case, when, else, and end functions.
Business Date/Time Functions
This list contains business functions for performing date and time calculations.
Block Functions
This list contains functions used to access members of a set, usually in the context of Analysis Studio.
Aster Data
DB2
Greenplum
Informix
MS Access
MySQL
Netezza
Oracle
Paraccel
Postgres
Red Brick
SAP BW
Salesforce.com
SQL Server
Sybase
Teradata
Vectorwise
Vertica
Macro Functions
This list contains functions that can be used within a macro. A macro may contain one or more macro functions. A macro is delimited by a number sign (#) at the beginning and at the end. Everything between the number signs is treated as a macro expression and is executed at run time. For macro functions that accept expressions of datatype timestamp with time zone as arguments, the accepted format is 'yyyy-mm-dd hh:mm:ss[.ff]+hh:mm' where fractional seconds are optional and can be represented by 1 to 9 digits. In lieu of a space separating the date portion to the time portion, the character 'T' is also accepted. Also, in lieu of the time zone '+hh:mm', the character 'Z' is accepted and will be processed internally as '+00:00'. The macro functions that return expressions of datatype timestamp with time zone return 9 digits by default for their fractional seconds. The macro function timestampMask () can be used to trim the output if required.
Common Functions
Dimensional Functions
Report Functions
Data Type Casting Functions