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:
TRUE
for each dimension value that is in the hierarchy.HIERHEIGHT
command. 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:
variable
= BASEVAL(relation)
GROUPINGID
command. 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".
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|