| 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_LOAD_DIM_FILTERS lists the filter conditions associated with load specifications for dimensions.
Filter conditions are SQL WHERE clauses that identify a subset of the data to be loaded from the dimension table to the analytic workspace.
Filter conditions are created by the DBMS_AWM.ADD_AWDIMLOAD_SPEC_FILTER procedure.
| Column | Datatype | NULL | Description |
|---|---|---|---|
owner |
varchar2(30) |
Owner of the source dimension in the OLAP Catalog. | |
dimension_name |
varchar2(30) |
Name of the source dimension in the OLAP Catalog. | |
load_name |
varchar2(60) |
Name of the dimension load specification. | |
table_owner |
varchar2(30) |
Owner of the dimension table. | |
table_name |
varchar2(30) |
Name of the dimension table. | |
filter_condition |
varchar2(4000) |
SQL WHERE clause. |
