Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Workforce Analytics >

Aggregating the Payroll Table for Oracle Workforce Analytics

To load the Payroll aggregate table (W_PAYROLL_A), you need to configure the post-load processing parameter file, parameterfileDW.csv, and run the initial workflow and then the incremental workflow.

To configure the parameterfileDW.txt parameters file

1. Open the parameterfileDW.txt file using Microsoft WordPad or Notepad in the \OracleBI\DAC\Informatica\parameters\input.
2. Locate the sections [PLP_PayrollAggregate_Extract] and [PLP_PayrollAggregate_Load_Full].

   For example:

   [PLP_PayrollAggregate_Extract]

   $$ETL_PROC_WID=1

   $$GRAIN=MONTH

   $DBConnection_OLAP=PARAM_OLAP

   [PLP_PayrollAggregate_Load_Full]

   $$GRAIN='MONTH'

   $$Hint_Tera_Post_Cast= as decimal(18,3))

   $$Hint_Tera_Pre_Cast= cast (

   $DBConnection_OLAP=PARAM_OLAP

   MPLT_GET_ETL_PROC_WID.$$ETL_PROC_WID=1

3. Change the value of the aggregation time grains, as required (highlighted in bold above).

   NOTE:  You need to use single quotes for the GRAIN parameter for the section "PLP_PayrollAggregate_Load_Full".

4. Save and close the file.