AW_CUBE_FILTER_LOAD Procedure

This procedure creates a SQL WHERE clause to be added to a load definition for a cube. The WHERE clause specifies which rows should be loaded from the fact table to the analytic workspace.

Syntax

AW_CUBE_FILTER_LOAD (
          cube_owner              IN   VARCHAR2,
          cube_name               IN   VARCHAR2,
          load_name               IN   VARCHAR2
          fact_table_owner        IN   VARCHAR2,
          fact_table_name         IN   VARCHAR2,
          where_clause            IN   VARCHAR2);

Parameters

Table 16-10 AW_CUBE_FILTER_LOAD Procedure Parameters

Parameter	Description
cube_owner	Owner of the OLAP Catalog cube.
cube_name	Name of the OLAP Catalog cube.
load_name	Name of a load definition.
fact_table_owner	Owner of the fact table that underlies this OLAP Catalog cube.
fact_table_name	Name of the fact table that underlies this OLAP Catalog cube
where_clause	A SQL WHERE clause that specifies which rows to load from the fact table.