BI report based on HCM extract output
Summary
BI report based on HCM extract outputContent
Hello experts,
I have a requirement of creating a BI report based on ' HCM extract output which is set as Changes Only'.
BI report Input Parameters: From Date and To Date
Required output : All the extract runs data whose run date is with in input dates along with PayrollActionID and extract run date.
| EX: All person and assignment details along with payroll action ID, Date run. | ||||
| Sample HCM Extract output: | ||||
| Run Date 7/1 | Person | Name | Job | |
| 111 | 1_t1 | job1 | ||
| 112 | 1_t2 | job1 | ||
| 113 | 1_t3 | job2 | ||
| Run Date 7/2 | Person | Name | Job | |
| 211 | 2_t1 | job1 | ||
| 212 | 2_t2 | job4 | ||
Tagged:
0