ALL_CUBES

ALL_CUBES describes the OLAP cubes accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the cube
CUBE_NAME VARCHAR2(128) NOT NULL Name of a cube, such as UNITS_CUBE
CUBE_ID NUMBER NOT NULL ID of a cube
AW_NAME VARCHAR2(128)   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(200)   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(128)   Name of the dimension used to partition the cube, such as TIME
PARTITION_HIERARCHY_NAME VARCHAR2(128)   Name of the dimension hierarchy used to partition the cube, such as CALENDAR
PARTITION_LEVEL_NAME VARCHAR2(128)   Name of the level used to partition the cube, such as QUARTER
REFRESH_MVIEW_NAME VARCHAR2(200)   Name of the refresh materialized view for the OLAP cube
REWRITE_MVIEW_NAME VARCHAR2(200)   Name of the rewrite materialized view for the OLAP cube
DEFAULT_BUILD_SPEC CLOB   The default build specification for the OLAP cube
MEASURE_STORAGE VARCHAR2(200)  

The measure storage for the OLAP cube. Possible values:

  • INDEPENDENT

  • SHARED
SQL_CUBE_STORAGE_TYPE CLOB   The SQL cube storage type for the OLAP cube. This value represents a SQL data type.
CUBE_STORAGE_TYPE VARCHAR2(200)   The cube storage type for the OLAP cube. This value represents a DML data type.

See Also: