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
edited Mar 12, 2019 2:21PM in Reporting and Analytics for HCM 12 comments


Report with snapshots by end of months


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!?


Howdy, Stranger!

Log In

To view full details, sign in.


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