OLAP_EXPRESSION_TEXT is a SQL function that dynamically executes an OLAP DML text expression within the context of an
OLAP_TABLE function. In addition to returning a custom measure, you can use this function in the
ORDER BY clauses to modify the result set of the query of the analytic workspace.
See Also:"Using OLAP DML Expressions in SELECT FROM OLAP_TABLE Statements" and "Adding Calculated Columns to the Relational View".
Before you use this function, you must specify a
ROW2CELL clause in the limit map used by
ROW2CELL identifies a
RAW column that
OLAP_TABLE populates with information used by the OLAP single-row functions.
Note:You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL Worksheet.
An evaluation of text_expression for each row of the table object returned by the
OLAP_EXPRESSION_TEXT( r2c IN RAW(32), text_expression IN VARCHAR2) RETURN NUMBER;
The name of a column specified by a
ROW2CELL clause in the limit map. See "ROW2CELL Clause" of OLAP_TABLE
An OLAP DML expression that returns a text result.