| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
ALL_AW_CUBE_AGG_LEVELS lists the levels in aggregation specifications for cubes.
Aggregation specifications determine how data will be aggregated along the dimensions of a cube in an analytic workspace. Aggregation specifications are created by the DBMS_AWM.CREATE_AWCUBEAGG_SPEC procedure.
| Column | Datatype | NULL | Description |
|---|---|---|---|
owner |
varchar2(240) |
Owner of the cube. | |
cube_name |
varchar2(240) |
Name of the cube. | |
aggregation_name |
varchar2(60) |
Name of the aggregation spec. | |
dimension_owner |
varchar2(30) |
Owner of the dimension to aggregate. | |
dimension_name |
varchar2(240) |
Name of the dimension to aggregate. | |
level_name |
archar2(240) |
Name of the level of aggregation for this dimension. |
