AW_DIM_FILTER_LOAD Procedure

This procedure creates a SQL WHERE clause to be added to a load definition for a dimension. The WHERE clause specifies which members of a hierarchy should be loaded from the dimension table to the analytic workspace.

Syntax

AW_DIM_FILTER_LOAD (
          dimension_owner       IN   VARCHAR2,
          dimension_name        IN   VARCHAR2,
          load_name             IN   VARCHAR2
          dim_table_owner       IN   VARCHAR2,
          dim_table_name        IN   VARCHAR2,
          where_clause          IN   VARCHAR2);

Parameters

Table 16-5  AW_DIM_FILTER_LOAD Procedure Parameters

Parameter	Description
dimension_owner	Owner of the OLAP Catalog dimension.
dimension_name	Name of the OLAP Catalog dimension.
load_name	Name of a load definition.
dim_table_owner	Owner of the dimension table that underlies this OLAP Catalog dimension.
dim_table_name	Name of the dimension table that underlies this OLAP Catalog dimension.
where_clause	A SQL WHERE clause that specifies which rows to load from the dimension table.