| 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_DIM_ENABLED_VIEWS describes the dimension views that can be generated for dimensions in analytic workspaces.
Descriptions of the views are created when the dimension is refreshed. The view is not instantiated until the DBMS_AWM.CREATE_AWDIMENSION_ACCESS has executed and the resulting script has been run.
ALL_AW_DIM_ENABLED_VIEWS shows the descriptions of the views. The views themselves do not necessarily exist.
Metadata about dimension views is generated by the DBMS_AWM.REFRESH_AWDIMENSION procedure. Scripts to create views of workspace dimensions are created by the DBMS_AWM.CREATE_AWDIMENSION_ACCESS procedure.
| Column | Datatype | NULL | Description |
|---|---|---|---|
aw_owner |
varchar2(30) |
Owner of the analytic workspace. | |
aw_name |
varchar2(30) |
Name of the analytic workspace. | |
dimension_name |
varchar2(4000) |
Name of the dimension in the analytic workspace. | |
hierarchy_name |
varchar2(4000) |
Name of the hierarchy in the analytic workspace. | |
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_AWDIMENSION_VIEWNAME procedure. |
