Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Count vacant positions in FDI using Position Managment Subject Area
We need to get vacant positions through Position Management subject area. The business need is that : the position is considered as vacant if there is no incumbent or if it's occupied only by Pending Workers and or Contingent Workers.
Could you please share any formula or expression that may help in FAW ? or if you faced the same cases or business requirements.
Kind regards,
Ayoub
Answers
-
The HCM - Position subject area has a few facts related to incumbent which you can use to find the vacant positions. You can subtract the number of positions with an incumbent from the number of all positions. Something like this:
"HCM - Positions"."Facts - Positions"."Position Count" - "HCM - Positions"."Facts - Positions"."Position Incumbent Count"
I don't believe that will meet the full requirement that you have outlined because I believe Contingent Workers who are assigned to a position will lead to that positions having an incumbent. What is the reason that your organization considers those positions vacant?
0 -
Hi @Ayoub Afrass_1 Your requirement needs the support of Core subject area as well, Check this attached dv
Raghu
0
