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 (CWM2-Specific) Views , 7 of 25


ALL$OLAP2_CUBE_DIM_USES

Each row represents an association between a cube and a dimension. A dimension may be associated more than once with the same cube, but each association is specified in a separate row, under its own unique dimension alias.

Column Datatype NULL Description

CUBE_DIMENSION_USE_ID

NUMBER

NOT NULL

ID of the association between a cube and a dimension.

OWNER

VARCHAR2(30)

NOT NULL

Owner of the cube.

CUBE_NAME

VARCHAR2(30)

NOT NULL

Name of the cube.

DIMENSION_OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension.

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension.

DIMENSION_ALIAS

VARCHAR2(30)

Alias of the dimension, to provide unique identity of dimension use within the cube.

DEFAULT_CALC_HIERARCHY_NAME

VARCHAR2(30)

The default hierarchy to be used for drilling up or down within the dimension.

DEPENDENT_ON_DIM_USE_ID

NUMBER

ID of the cube/dimension association that this association depends on.


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