You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fusion OTBI - Performance Tiles Percentage

edited May 19, 2020 9:34PM in Reporting and Analytics for HCM 2 comments

Summary

Fusion OTBI - Performance Tiles Percentage

Content

Hello

I am actually a bit embarrassed to post this as I should surely have been able to work it out myself...

But, part of the joys of being a co-existence customer without full fusion (we use EBS, Fusion, and Taleo Recruit) is that we are missing a number of columns of data, a fairly key one is that Headcount is not transferred from EBS to Fusion (we do transfer FTE though), so to show headcount we use; COUNT(DISTINCT "Worker"."Person Number") so not to much of an issue.

However to show Part-time headcount I then need to use; CASE WHEN "Worker Assignment"."Full-Time Equivalent" < 1 THEN COUNT(DISTINCT "Worker"."Person Number") END

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!