Understanding Level Attributes

A level attribute is an OLAP metadata entity. This means that it is a logical object, identified by name and owner, within the OLAP 2 Catalog.

A level attribute is a child entity of a level, and it may be a child entity of one or more dimension attributes.

A level attribute stores descriptive information about its related level. For example, a level containing product identifiers might have an associated level attribute that contains color information for each product.

Each level attribute maps to a column in a dimension table. The level attribute column must be in the same table as the column (or columns) for its associated level. If the dimension is stored in a parent/child table instead of a level-based table, level attributes map to columns in the view you can generate via the CWM2_OLAP_PC_TRANSFORM package. Similarly, if the dimension is stored in an analytic workspace, level attributes map to columns in the view you can generate via the AWCONVERT package.