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 |
