4.5.5 Executing the Time Dimension Population Process

You can execute the function from the Operations Framework module of OFSAAI.

Define a new Batch and an underlying Task definition from the Batch Maintenance window of OFSAAI. For more information on defining a new Batch, see the How to Define a Batch.

To define a new task for a Batch definition:

1. Select the checkbox adjacent to the newly created Batch Name in the Batch Maintenance window.
2. Click Add (+) from the Task Details grid. The Task Definition window is displayed.
3. Enter the Task ID and Description.
4. Select Transform Data from the Transform Data drop-down list.
5. Select the following from the Dynamic Parameters drop-down list:
   • Rule Name: Select Dim_Dates_Population from the list of all available transformations. (This is a seeded Data Transformation which is installed as part of the ALM BI application, if you don't see this in the drop-down list, contact Oracle Support).
   • Parameter List: Enter the Start Date and End Date in 'yyyymmdd' format. This is a mandatory parameter.

     For example: 19000101','20120101'

   • Start Date: This is the date from which the Transformation will populate the DIM_DATES table.
   • End Date: This is the date up to which the Transformation will populate the DIM_DATES table.
6. Click Save. Execute the Batch.
7. You can execute a Batch definition from the Batch Execution window of the OFSAAI Operations module.
8. You can execute this process from the Simplified Batch window. For more details, see Simplified Batch Execution.
9. The function can also be executed directly on the database through SQLPLUS by providing the following details:
   • Function Name: FN_DIM_DATES
   • Parameters: P_BATCH_RUN_ID, P_AS_OF_DATE, P_ST_DT, and P_ED_DT

     Sample Parameter Values: 'Batch1', '20091231', '19000101', and '19050101'