MAP_AW_ATTRIBUTE Procedure

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

The dimension attribute 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 dimension attribute.

Syntax

MAP_AW_ATTRIBUTE (
          dimension_owner   IN   VARCHAR2  (30),
          dimension_name    IN   VARCHAR2  (30),
          attribute_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-2 MAP_AW_ATTRIBUTE 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.
attribute_name	Name of the logical dimension attribute 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 dimension attribute will be mapped using a property of the object in the analytic workspace. LIMITSET -- The logical dimension attribute 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'