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 , 12 of 24


ALL_OLAP2_DIM_ATTRIBUTES

ALL_OLAP2_DIM_ATTRIBUTES is a synonym for ALL$OLAP2UDIM_ATTRIBUTES.

Each row represents a dimension attribute, which is a logical attribute providing a grouping of level attributes within the dimension. The level attributes within the dimension attribute grouping can be determined from the ALL_OLAP2_DIM_ATTR_USES view.

A dimension attribute is only meaningful if it contains level attributes.

Column Data Type NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension.

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension.

ATTRIBUTE_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension attribute.

DISPLAY_NAME

VARCHAR2(30)

Display name for the dimension attribute.

DESCRIPTION

VARCHAR2(2000)

Description of the dimension attribute.

DESC_ID

NUMBER

A classification for the dimension attribute. If a dimension attribute is classified, it may be of type LONG_DESCRIPTION, SHORT_DESCRIPTION, END_DATE, TIME_SPAN, PRIOR_PERIOD, or YEAR_AGO_PERIOD.


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