Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2)

Part Number A95295-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

OLAP Catalog Union Views , 16 of 24


ALL_OLAP2_DIM_LEVEL_ATTRIBUTES

ALL_OLAP2_DIM_LEVEL_ATTRIBUTES is a synonym for ALL$OLAP2UDIM_LEVEL_ATTRIBUTES.

Each row represents a level attribute. Each level attribute is a column in a dimension table. The column stores descriptive information about a level defined within the same dimension table. If the level attribute is not named, the column name is used.

The mapping of the level attribute column to its associated level columns is represented in ALL_OLAP2_DIM_LEVEL_ATTR_MAPS.

Column Data Type NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension containing the level attribute.

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension containing the level attribute.

ATTRIBUTE_NAME

VARCHAR2(30)

Name of the level attribute. If no attribute name is specified, the column name is used.

DISPLAY_NAME

VARCHAR2(30)

Display name for the level attribute.

DESCRIPTION

VARCHAR2(2000)

Description of the level attribute.

DETERMINED_BY_LEVEL_NAME

VARCHAR2(30)

NOT NULL

Name of the level to which this level attribute is mapped.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback