Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > Configuring Extracts >

Filtering the Data Extract

The Siebel Customer-Centric Enterprise Warehouse prepackages some filters to extract only particular types of records. For example, the Siebel Enterprise Sales Analytics application, by default, extracts only booked orders. Given your unique business needs, you may need to extract nonbooked orders as well. In general, you can manage all extract filters in the same way, and the following procedure describes how to modify an extract. However, for information about application-specific extract filters, see the application-specific configuration chapters.

To modify extract filters

1. In PowerCenter Designer, open the applicable source system configuration folder.
2. Open Mapplet Designer.
3. Drag the Business Component mapplet into Mapplet Designer.
4. Double-click the Source Qualifier to open the Edit Transformations window, and select the Properties tab.
5. In both the User Defined Join field and in the SQL Query field, remove or add a filter statement.

   For example, if you want to change the Accounts Receivable Schedules filter so that it is not restricted to completed schedules only, you would remove the statement, as shown in the following figure.
6. Validate and save your changes to the repository.

NOTE:  If a primary extract exists, you must modify both the regular mapplet and the primary extract mapplet. For information on primary extract mappings, see About Primary Extract and Delete Mappings Process.