Preparing an Analytic Workspace for Access by OLAP_TABLE

All hierarchies in an analytic workspace are defined by the following analytic workspace objects:

• A dimension whose values are all of the values of the hierarchy.
• A child-parent self-relation for that dimension whose values are the parents of the dimension values.

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:

• A Boolean variable that has a value of TRUE for each dimension value that is in the hierarchy.
• A dimension whose values are integers that represent the levels of the hierarchy.
• A relation that has been populated using the OLAP DML 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)
  
  

• A variable that has been populated using the OLAP DML 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".