OLAP_DML_EXPRESSION

OLAP_DML_EXPRESSION executes an expression in the OLAP DML language.

Return Value

The data type specified in the syntax

Syntax

OLAP_DML_EXPRESSION (expression, datatype)

Arguments

expression

An expression in the OLAP DML language, such as a call to a function or a program.

datatype

The data type of the return value from expression

Example

In this example, the OLAP_DML_EXPRESSION function executes the OLAP DML RANDOM function to generate a calculated measure with random numbers between 1.05 and 1.10.

OLAP_DML_EXPRESSION('RANDOM(1.05, 1.10)', NUMBER)