Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
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
PDF · Mobi · ePub

ALL_CUBES

ALL_CUBES describes the OLAP cubes accessible to the current user.

Related Views

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(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(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