How Time Dimension works?
SummaryReport with snapshots by end of months
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!?