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