Statements Related to Using OLAP _TABLE |
Table: Statements Related to OLAP_TABLE lists the OLAP DML statements that support the use of the OLAP_TABLE function.
Statements Related to OLAP_TABLE
| Statement | Description |
|---|---|
| FETCH
|
Specifies how analytic workspace data is retrieved for use in the relational table created by the OLAP_TABLE function which you use to access analytic workspace data using SQL. |
| GROUPINGID
|
Populates a previously-defined variable with the grouping ids for the values of a hierarchical dimension. |
| HIERHEIGHT command | Populates a previously-defined relation with the values of a specified hierarchical dimension by level. |
| LIMITMAPINFO
|
Returns the analytic workspace expression that a specified limit map uses to map data into a specified column of a relational table. |