OLAP Catalog Union Views , 10 of 24

ALL_OLAP2_CUBES

ALL_OLAP2_CUBES is a synonym for ALL$OLAP2UCUBES.

Each row represents a cube.

Column	Data Type	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the cube.
`CUBE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the cube.
`INVALID`	`VARCHAR2(1)`	`NOT NULL`	Whether or not this cube is in an invalid state. A cube is valid if it has at least one dimension, all of its dimensions are valid, and all the fact table mappings are valid.
`DISPLAY_NAME`	`VARCHAR2(30)`		Display name for the cube.
`DESCRIPTION`	`VARCHAR2(2000)`		Description of the cube.
`MV_SUMMARYCODE`	`VARCHAR2(2)`		If this cube has a materialized view in the OLAP 2 Catalog, the MV summary code specifies whether it is in `GS` (Grouping Set) or `RU` (Rolled Up) form. `RU` form means that all the dimension key columns are populated, and data may only be accessed when its full lineage is specified. `GS` form means that dimension key columns may contain null values, and data may be accessed simply by specifying one or more levels.