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 , 8 of 25


ALL$OLAP2_CUBE_MEAS_DIM_USES

Each row represents the association of a measure with one of its dimensions, and specifies how the measure's data can be aggregated over that dimension. If no aggregation method is specified, the data is added.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the cube that defines this measure.

CUBE_NAME

VARCHAR2(30)

NOT NULL

Name of the cube that defines this measure.

MEASURE_NAME

VARCHAR2(30)

NOT NULL

Name of the measure.

DIMENSION_OWNER

VARCHAR2(30)

NOT NULL

Owner of a dimension associated with this measure.

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension.

DIMENSION_ALIAS

VARCHAR2(30)

Alias of the dimension.

DEFAULT_AGGR_FUNCTION_USE_ID

NUMBER

ID of the default aggregation method used to aggregate this measure's data over this dimension. If this column is null, the aggregation method is addition.


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