ALL_OLAP2_AW_CUBE_MEASURES

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

The ALL_OLAP2_AW_CUBE_MEASURES view uses the direct analytic workspace metadata access process to rapidly return information about standard form metadata. It does not use a caching mechanism and is unaffected by CWM2_OLAP_METADATA_REFRESH. See Chapter 19 for more information.

Column	Datatype	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(1000)`	Logical name of a measure of the cube.
`AW_PHYSICAL_OBJECT`	`VARCHAR2(4000)`	Standard form name of the measure.
`MEASURE_SOURCE_NAME`	`VARCHAR2(1000)`	Name of the source measure in the OLAP Catalog.
`DISPLAY_NAME`	`VARCHAR2(1000)`	Display name for the measure in the analytic workspace.
`DESCRIPTION`	`VARCHAR2(1000)`	Description of the measure in the analytic workspace.
`IS_AGGREGATEABLE`	`VARCHAR2(1000)`	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.