|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
OLAP_TABLE Function, 3 of 6
All hierarchies in an analytic workspace are defined by the following analytic workspace objects:
When you want to define a complete limit map for
OLAP_TABLE for a hierarchy or for data that is dimensioned by a hierarchy, you must also define the following analytic workspace objects:
TRUEfor each dimension value that is in the hierarchy.
HIERHEIGHTcommand. This relation represents the values of the hierarchy by level.
Tip: When the hierarchical dimension is defined as a concat dimension, the values of this relation are the values of the concat dimension. If you want the base dimension values in the relational view, define a variable with the same dimensions as this relation. and populate that variable using the following syntax:
GROUPINGIDcommand. The values of this variable, which is dimensioned by the hierarchy, are the grouping ids for each value of the hierarchy.
For an example of preparing an analytic workspace for access by OLAP_TABLE see, "Example: Using the OLAP_TABLE Function". For more information on the analytic workspace objects that support the use of hierarchies, see "Hierarchies".