Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
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 WHERE
and 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".OLAP_EXPRESSION_TEXT
returns character data. To return numeric, boolean, or date data, use OLAP_EXPRESSION, OLAP_EXPRESSION_BOOL, or OLAP_EXPRESSION_DATE SQL functions.
Before you use this function, you must specify a ROW2CELL
clause in the limit map used by OLAP_TABLE
. 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_TABLE
function.
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.
Refer to the examples in OLAP_EXPRESSION and OLAP_EXPRESSION_BOOL for examples of OLAP single-row functions.