TimeByDay: some tasks with duration being zero are not pulled

[Marc Caron]

Hello,
I am trying to create reports with TimeByday (MSP 2007 server). Some of our tasks with duration being zero are not pulled.

Here are examples of VERY SIMPLE queries showing the root cause. In the 1st 2 queries, there is no result but in the 3rd yes...
The 3rd used, made with dbo.MSP_EpmAssignmentByDay_OlapView, is too slow when we pull the report. Moreover, it gives me the baseline TimeByDay and not the current one...

Thanks for your help

MJC


Query 1 :
SELECT TaskUID, TimeByDay, ProjectUID
FROM dbo.MSP_EpmTaskByDay
WHERE (TaskUID = '8da905da-ff08-4510-ab5e-42b440b3d4e3')
Results: Nothing

Query 2:
SELECT TaskUID, TimeByDay, ProjectUID
FROM dbo.MSP_EpmTaskByDay_UserView
GROUP BY TimeByDay, ProjectUID, TaskUID
HAVING (TaskUID = '8da905da-ff08-4510-ab5e-42b440b3d4e3')
Results: Nothing

Query 3:
SELECT TaskUID, TimeByDay, ProjectUID
FROM dbo.MSP_EpmAssignmentByDay_OlapView
GROUP BY TaskUID, TimeByDay, ProjectUID
HAVING (TaskUID = '8da905da-ff08-4510-ab5e-42b440b3d4e3')
Results:
Col 1: TaskUID = '8da905da-ff08-4510-ab5e-42b440b3d4e3'
Col 2: TimeByDay= 06.04.2012 00:00:00
Col 3: ProjectUID= dfb70a1b-8964-4a66-ac0e-cc6ed13e0443