PURGE_FILTER Procedure

A filter can be removed at anytime by calling the procedure PURGE_FILTER which is described below. You can delete a specific filter or all filters.

Syntax

DBMS_OLAP.PURGE_FILTER (
filter_id    IN NUMBER);

Table 34-12 PURGE_FILTER Procedure Parameters

Parameter	Datatype	Description
filter_id	NUMBER	The parameter DBMS_OLAP.FILTER_ALL indicates all filters should be removed.