Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Sales Analytics >

Configuring the Backlog Period Date for Siebel Enterprise Sales Analytics

By default, the date is set as the last calendar day of the month; however you may configure this date. You may want to view backlog history at a more detailed level, such as by day or by week, instead of by month.

To configure the backlog period date

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. Open the applicable Sales Backlog Lines mapping.
3. Double-click the Expression transformation to display the BACKLOG_PERIOD_DK port.

   The SQL statement in this port's expression contains the backlog period date.

4. In the Ports tab, modify the default SQL statement for the BACKLOG_PERIOD_DK.

   For example, if you want to store backlog history at the weekly level, replace the existing statement:

   trunc(DATE_DIFF(LAST_DAY(CAL_DAY_DT),to_date('01-JAN-1900','DD-MON-YYYY'),'DD')) + 2415021

   with this new statement:

   trunc(DATE_DIFF(CAL_WEEK_END_DT),to_date('01-JAN-1900','DD-MON-YYYY'),'DD')) + 2415021

   TO_CHAR(CAL_WEEK_END_DT,'J')

   NOTE:  The CAL_WEEK_END_DT is not prepackaged to be extracted from IA_DATES; to use this calculation you have to extract this data from IA_DATES and pass it to the Expression transformation.

5. Validate and save your changes to the repository.