BI report based on HCM extract output

Summary

BI report based on HCM extract output

Content

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