DBA_CUBES describes all OLAP cubes in the database. Its columns are the same as those in ALL_CUBES.
· ALL_CUBES describes the OLAP cubes accessible to the current user.
· USER_CUBES describes the OLAP cubes owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|
|
| | Owner of the cube |
|
|
|
| Name of a cube, such as |
|
|
| | 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 |
No comments:
Post a Comment