MAP_AW_LEVEL Procedure

This procedure associates a logical level in the OLAP Catalog with level information in an analytic workspace.

The level entity in the OLAP Catalog must have been created by procedures in the CWM2_OLAP_AW_OBJECT package.

Note: Whereas dimensions and variables (measures) are native to the analytic workspace, there is no single native workspace object for a level.

Syntax

MAP_AW_LEVEL (
          dimension_owner   IN   VARCHAR2  (30),
          dimension_name    IN   VARCHAR2  (30),
          level_name        IN   VARCHAR2  (30),
          aw_owner          IN   VARCHAR2  (30),
          aw_name           IN   VARCHAR2  (30),
          aw_object_name    IN   VARCHAR2  (30),
          aw_limit_type     IN   VARCHAR2  (30),
          aw_limit_value    IN   VARCHAR2  (255));

Parameters

Table 26-5 MAP_AW_LEVEL Procedure Parameters

Parameter	Description
dimension_owner	Owner of the logical dimension in the OLAP Catalog.
dimension_name	Name of the logical dimension in the OLAP Catalog.
level_name	Name of the logical level in the OLAP Catalog.
aw_owner	Owner of analytic workspace.
aw_name	Name of analytic workspace.
aw_object_name	Name of the object in the analytic workspace.
aw_limit_type	One of the following values: PROPERTY -- The logical level will be mapped using a property of the object in the analytic workspace. LIMITSET -- The logical level will be mapped using an expression that limits one or more dimensions.
aw_limit_value	When aw_limit_type is PROPERTY, the limit value is the property name. When aw_limit_type is LIMITSET, the limit value is a string that specifies how to limit one or more dimensions in the analytic workspace. Each dimension is limited to one of its members. The string should be enclosed in single quotes, and each dimension name and dimension member pair should be separated by a forward slash. There should be a space between the dimension name and the dimension member, but there should be no space before or after the forward slash. The format of the limit expression is as follows. 'dim1name dim1member/dim2name dim2member'