I have a very simple OTBI Analysis using the Worker Assignment Event Real Time where I show the number of hires using the following columns:
- EXTRACT (MONTH FROM "Assignment Event Details"."Effective Start Date")
- EXTRACT(YEAR FROM "Assignment Event Details"."Effective Start Date")
- COUNT("Worker"."Person Number")
There is a filter on the Action Code = HIRE.
This query returns a count of 36.
HOWEVER, If I remove the COUNT function on the Person Number column, 33 Person Numbers return.
When I write a SQL query against the data base using the same constraints in place for the OTBI query, I get 33 as the aggregate count. 33 is the correct number. 33 Person Numbers will return from the SQL if I remove the aggregates and simply list Person Numbers and those 33 person numbers are the same ones from the OTBI analysis when I remove the aggregate count.
If I redo the OTBI query and simply use the # of Hires measure from Assignment Event facts, I get 36. Anytime I use an aggregate on OTBI, the number is off from SQL or OTBI when I simply list the row data with no aggregate.
Any ideas why this is?
