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.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.