Skip Headers
Oracle® OLAP Reference
10g Release 2 (10.2.0.3)

Part Number B14350-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_OLAP2_AW_CUBE_MEASURES

ALL_OLAP2_AW_CUBE_MEASURES lists the measures of cubes in standard form analytic workspaces.

Column Datatype NULL Description
AW_OWNER VARCHAR2(30)
Owner of the analytic workspace.
AW_NAME VARCHAR2(30)
Name of the analytic workspace.
AW_CUBE_NAME VARCHAR2(90)
Name of a cube in the analytic workspace.
AW_MEASURE_NAME VARCHAR2(4000)
Logical name of a measure of the cube.
AW_PHYSICAL_OBJECT VARCHAR2(4000)
Standard form name of the measure.
MEASURE_SOURCE_NAME VARCHAR2(4000)
Name of the source measure in the OLAP Catalog (Oracle9i metadata).
DISPLAY_NAME VARCHAR2(4000)
Display name for the measure in the analytic workspace.
DESCRIPTION VARCHAR2(4000)
Description of the measure in the analytic workspace.
IS_AGGREGATEABLE VARCHAR2(4000)
Whether or not this measure can be aggregated with the OLAP DML AGGREGATE command. The value is YES if the measure is implemented as an OLAP variable or if its underlying storage is a variable. For example, the measure could be implemented as a formula whose value is stored in a variable.