Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for Oracle 11i >

Filtering Extracts Based on Set of Books ID for Siebel General Ledger Analytics

This task is a step in the Process of Configuring Siebel Financial Analytics for Oracle 11i.

If you have multiple sets of books and want to use only some of them as sources for the extract, then you have to modify the Source Qualifier. For example, assume that you have four sets of books for your enterprise—a set of books for your U.S. organization (SOB_ID = 1), a set of books for your Japan organization (SOB_ID = 2), a set of books for your German organization (SOB_ID = 3), and a set of books for your enterprise as a whole (SOB_ID = 4). If you want to extract only the enterprise level information, you extract only transactions where the SOB_ID = 4. Therefore, in the Source Qualifier's SQL Query and User Defined Join fields, you must add the following filter statement:

AND SET_OF_BOOKS_ID IN (4)

To filter extracts based on Set of Books ID

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In Mapplet Designer, open the MPLT_BCI_GL_ACCOUNTS.
3. Double-click the Source Qualifier to open the Edit Transformations window, and click the Properties tab.
4. Insert the filter condition in the SQL Query field and in the User Defined Join field.

   For example, if you want to use only the Set of Books whose ID is 4, then you insert the following filter:

   AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID IN (4)

   in the WHERE clause in the SQL Query field, and at the end of the statement in the User Defined Join field.

5. Validate and save changes to the repository.