Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How Time Dimension works? — Cloud Customer Connect
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

How Time Dimension works?

Accepted answer
45
Views
12
Comments
edited Mar 12, 2019 2:21PM in Reporting and Analytics for HCM 12 comments

Summary

Report with snapshots by end of months

Content

Hi Everyone,

I am struggling to build an OTBI analysis that creates a monthly Head Count report.

I am using "Workforce Management - Worker Assignment Event Real Time" subject area.

For Head Count, which is working correctly we are using: COUNT(DISTINCT "Worker"."Person Number").

However, when I try to add either Calendar Month, Calendar Month End Date or Month fields from Time dimension to create the HC by end of each month, the analysis is not bringing the correct numbers. Number are much smaller than expected and it seems the HC was split through the months!?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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