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
- Open the parameterfileDW.txt file using Microsoft WordPad or Notepad in the \OracleBI\DAC\Informatica\parameters\input.
- 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
- 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".
- Save and close the file.
|