2.109 ALL_CUBES
ALL_CUBES describes the OLAP cubes accessible to the current user.
Related Views
-
DBA_CUBESdescribes all OLAP cubes in the database. -
USER_CUBESdescribes the OLAP cubes owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the cube |
|
|
|
|
Name of a cube, such as |
|
|
|
|
ID of a cube |
|
|
|
|
Name of the analytic workspace that contains the cube, such as |
|
|
|
|
Default aggregation rules for the cube |
|
|
|
|
Description of the cube in the session language |
|
|
|
|
Text value indicating the type of sparsity for the OLAP cube |
|
|
|
|
Condition syntax representing the precompute condition of the OLAP cube |
|
|
|
|
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. |
|
|
|
|
Percentage of aggregate data values in the top partition that are calculated and stored during data maintenance |
|
|
|
|
Name of the dimension used to partition the cube, such as |
|
|
|
|
Name of the dimension hierarchy used to partition the cube, such as |
|
|
|
|
Name of the level used to partition the cube, such as |
|
|
|
|
Name of the refresh materialized view for the OLAP cube |
|
|
|
|
Name of the rewrite materialized view for the OLAP cube |
|
|
|
|
The default build specification for the OLAP cube |
|
|
|
|
The measure storage for the OLAP cube. Possible values:
|
|
|
|
|
The SQL cube storage type for the OLAP cube. This value represents a SQL data type. |
|
|
|
|
The cube storage type for the OLAP cube. This value represents a DML data type. |
See Also: