Creating Dimension Attributes

The CWM2_OLAP_DIMENSION_ATTRIBUTE package contains procedures that establish attribute entities for dimensions within the OLAP 2 Catalog.

Note: When you create an OLAP metadata entity, you are simply adding a row to an OLAP Catalog table that identifies all the entities of that type. Creating a dimension attribute does not fully define it, nor does it involve any mapping to warehouse dimension tables.

The parent dimension must already exist in the OLAP 2 Catalog before you can create dimension attributes for it.

Completing the Dimension's Metadata

Creating dimension attributes is one of the first steps in creating the OLAP metadata for a dimension. Once you have created the dimension attributes, you will need to call procedures in the following packages to fully define the dimension's metadata:

• CWM2_OLAP_HIERARCHY to create hierarchical relationships for the dimension's levels (if you have not already done so)
• CWM2_OLAP_LEVEL to create levels and assign them to hierarchies within the dimension
• CWM2_OLAP_LEVEL_ATTRIBUTE to create level attributes and assign them to dimension attributes within the dimension
• CWM2_OLAP_TABLE_MAP to establish the mapping to columns in one or more dimension tables