About Specifying the Filter to Be Applied on Activity

You can configure the ETL parameter ACTIVITYFILTER for Customer Data Management Analytics. This filter is used to customize Filter on Activity. The default value is '(1=1) AND', which does not affect the data that is loaded.

Change the default value if you want to adjust the number of records that are loaded. For example, to load only the Activity created this month or this quarter, use the following syntax:

(ACT.CREATED_ON_DT > <Date>) AND

Where <Date> is in the format YYYY-MM-DD, for example, 2014-12-31.