Missing Actual Work in Cube

[David]

I am attempting to create an external report that queries the MSP_ASSN_FACT
Cube. The Cube generates fine and has all the projects and resources
available but when I query it for Actual Work some work is missing. Does
anyone have any ideas why some work is being left out of the cube? If I “View
resource assignments†all the information is there. I have tried expanding
the date range for the cube generation and that did not help.

Thanks for any ideas or suggestions.

David

 

[David]

I have discovered that with some resources if I change them from Proposed to
Committed they show up with data in the cube. This still doesn't solve my
problem but hopefully it is a step in the right direction.

Again thanks for any ideas or suggestions.

David

 

[Vadim Bogdanov]

David,

and what sort of report are you trying to develop?

Also check that you have SP1 applied.

Regards,
Vadim

 

[David]

Yes SP1 is applied. The report is to get the resources total weekly actuals
by project for billing purpose's. Most of my problems have been cleaned up
already, it appears that the missing data was being caused by a lot of small
problems.

Thanks
David