ALL_CUBES describes the OLAP cubes accessible to the current user.
DBA_CUBES describes all OLAP cubes in the database.
USER_CUBES describes the OLAP cubes owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the cube | |
CUBE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of a cube, such as UNITS_CUBE |
AW_NAME |
VARCHAR2(30) |
Name of the analytic workspace that contains the cube, such as GLOBAL |
|
CONSISTENT_SOLVE_SPEC |
CLOB |
Default aggregation rules for the cube | |
DESCRIPTION |
NVARCHAR2(300) |
Description of the cube in the session language | |
SPARSE_TYPE |
VARCHAR2(80) |
Text value indicating the type of sparsity for the OLAP cube | |
PRECOMPUTE_CONDITION |
CLOB |
Condition syntax representing the precompute condition of the OLAP cube | |
PRECOMPUTE_PERCENT |
NUMBER |
Percentage of aggregate data values that are calculated and stored during data maintenance. If the cube is partitioned, then this percentage is for the bottom partitions. | |
PRECOMPUTE_PERCENT_TOP |
NUMBER |
Percentage of aggregate data values in the top partition that are calculated and stored during data maintenance | |
PARTITION_DIMENSION_NAME |
VARCHAR2(30) |
Name of the dimension used to partition the cube, such as TIME |
|
PARTITION_HIERARCHY_NAME |
VARCHAR2(30) |
Name of the dimension hierarchy used to partition the cube, such as CALENDAR |
|
PARTITION_LEVEL_NAME |
VARCHAR2(30) |
Name of the level used to partition the cube, such as QUARTER |
See Also: