| 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_ENABLED_HIERCOMBO lists the hierarchy combinations associated with cubes in analytic workspaces.
Each hierarchy combination is identified by a unique number. The OLAP API Enabler creates a separate fact view for each hierarchy combination.
The information in this view is available for all standard form cubes that have been refreshed. See the DBMS_AWM.REFRESH_AWCUBE procedure and the DBMS_AWM.CREATE_AWCUBE_ACCESS procedure.
| Column | Datatype | NULL | Description |
|---|---|---|---|
aw_owner |
varchar2(30) |
Owner of the analytic workspace. | |
aw_name |
varchar2(30) |
Name of the analytic workspace. | |
cube_name |
varchar2(4000) |
Name of the cube in the analytic workspace. | |
hiercombo_num |
number |
Unique number that identifies the hierarchy combination. | |
hiercombo_str |
varchar2(4000) |
List of hierarchies that define the dimensionality of a fact view of the enabled cube. |
