Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

MAP_DIMTBL_HIERLEVELATTR Procedure

This procedure maps a level attribute to a column in a dimension table.

The attribute being mapped is associated with a level in the context of a hierarchy.

Syntax

MAP_DIMTBL_HIERLEVELATTR (
          dimension_owner            IN   VARCHAR2,
          dimension_name             IN   VARCHAR2,
          dimension_attribute_name    IN   VARCHAR2,
          hierarchy_name             IN   VARCHAR2,
          level_name                 IN   VARCHAR2,
          level_attribute_name        IN   VARCHAR2,
          table_owner                IN   VARCHAR2,
          table_name                 IN   VARCHAR2,
          attrcol                     IN   VARCHAR2);

Parameters

Table 26-2  MAP_DIMTBL_HIERLEVELATTR Procedure Parameters
Parameter Description

dimension_owner

Owner of the dimension.

dimension_name

Name of the dimension.

dimension_attribute_name

Name of the dimension attribute.

hierarchy_name

Name of the hierarchy.

level_name

Name of the level.

level_attribute_name

Name of the level attribute associated with this level.

table_owner

Owner of the dimension table.

table_name

Name of the dimension table.

attrcol

Column in the dimension table to which this level attribute should be mapped.

Exceptions

Table 26-3  MAP_DIMTBL_HIERLEVELATTR Procedure Exceptions
Exception Description

no_access_privileges

User does not have the necessary privileges. User must be the dimension owner and have the OLAP_DBA role.

dimension_not_found

Dimension not found.

hierarchy_not_found

Hierarchy not found.

level_not_found

Level not found.

attribute_not_found

Level attribute not found.

table_not_found

Dimension table not found.

column_not_found

Dimension table column not found.