Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Order Management and Fulfillment Analytics Option >

Configuring the Backlog Period Date for Oracle Order Management and Fulfillment Analytics Option

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 SDE_ORA115<ver>_Adaptor 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 W_DATES; to use this calculation you have to extract this data from W_DATES and pass it to the Expression transformation.

5. Validate and save your changes to the repository.