| 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_VIEWS describes the fact views that can be generated for cubes in analytic workspaces.
Descriptions of the views are created when the cube is refreshed. The view is not instantiated until the DBMS_AWM.CREATE_AWCUBE_ACCESS has executed and the resulting script has been run.
ALL_AW_CUBE_ENABLED_VIEWS shows the descriptions of the views. The views themselves do not necessarily exist.
Metadata about fact views is generated by the DBMS_AWM.REFRESH_AWCUBE procedure. Scripts to create views of workspace cubes are created by 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. | |
system_viewname |
varchar2(4000) |
Default view name created by the DBMS_AWM.REFRESH_AWCUBE procedure. |
|
user_viewname |
varchar2(4000) |
User-defined view name specified by the DBMS_AWM.SET_AWCUBE_VIEWNAME procedure. |
