How to exclude cancelled work relationships from employee headcount?

Question

When creating a dashboard using the "HCM-Workforce Core" subject area within FDI, the counts are bringing in cancelled work relationships as if they are active employees. Is there a way to exclude them or correct the data so that it no longer recognizes the employees as active?

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/24535/how-to-exclude-cancelled-work-relationships-from-employee-headcount

I think this is happening because data is not getting refreshed post WR cancellation as the assignment records are deleted:

Frequently Asked Questions

@Ravi Guddanti-Oracle , Do you have some inputs here, please?

Fusion HCM Analytics - Frequently Asked Questions — Oracle Analytics

Thanks.

Sumanth V -Oracle · Answer

@Jacqueline Bigelow - Please check if the below helps:

Try excluding cancelled work relationships in your HCM-Workforce Core subject area within Fusion Data Intelligence (FDI) by applying the correct filters. Here’s how you can do it:

* Try using filter on "Work Relationship Status" and exclude statuses like Cancelled or Terminated.
* Try applying filters on "Assignment status" column  and exclude statuses like Exclude statuses like: "Terminated" and "Inactive – Payroll Ineligible"