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 Analytic Workspace Views , 10 of 11


ALL$OLAP2_AW_MAP_LVL_USE

Each row represents the mapping between a dimension level entity within the OLAP Catalog and dimension level information within an analytic workspace.

Column Datatype NULL Description

DIMENSION_OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension entity within the OLAP Catalog.

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension entity within the OLAP Catalog.

LEVEL_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension level entity within the OLAP Catalog.

AW_OWNER

VARCHAR2(30)

NOT NULL

Owner of the analytic workspace.

AW_NAME

VARCHAR2(30)

NOT NULL

Name of the analytic workspace.

AW_OBJECT_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension object within the analytic workspace, as defined by the OLAP DML.

AW_LIMIT_TYPE

VARCHAR2(30)

One of the following values:

  • PROPERTY -- The logical level will be mapped using a property of the object in the analytic workspace.
  • LIMITSET -- The logical level will be mapped using an expression that limits one or more dimensions.
  • NULL -- Not applicable.

AW_LIMIT_OBJ_NAME

VARCHAR2

For a limit type of LIMITSET, the names of the dimensions that are limited to a single value.

AW_LIMIT_OBJ_VALUE

VARCHAR2

For a limit type of LIMITSET, the values of the limited dimensions.


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