Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to exclude cancelled work relationships from employee headcount?
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?
Answers
-
@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"
0 -
I think this is happening because data is not getting refreshed post WR cancellation as the assignment records are deleted:
@Ravi Guddanti-Oracle , Do you have some inputs here, please?
Fusion HCM Analytics - Frequently Asked Questions — Oracle Analytics
Thanks.
0
