Classification of work in report

[Kuzmenko Alexander]

Hello, All
I'm researching and trying to implement MS Project Server in my
Organization. I have problems with reporting of work by resources. I need
table report with hours filling and rows:resource list, columns:work
type(Administrative, Sick, Vacation, Project work). What is the cube name to
use? And what fields I will need to make report.
Thanks

 

[Marc Soester [MVP]]

Hi ALex,

try the EPM timesheet cube. You should be able to use this one for your
request. also you can create your own reports using the reporting database
from project server.
hope this helps

 

[Kuzmenko Alexander]

I can't receive information from any OLAP cube. Can you tell me cube name
and field names to report. I need a report about resources work per month
with qualification(Project Work, Sick, Vacation, Adminstrative).
"Marc Soester [MVP]" <[email protected]>
ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:

 

[Marc Soester [MVP]]

Alex, I would recommend that you get Analysis Services working, since most of
the analysis you whish to do can be done in the cube. If this is not enough
you will need to retrieve that data from the proejct server reporting
database. You will be able to find a data cataloge in the Project Server SDK
with a full explanation of all reporting tables etc.
Hope this helps
Marc
--
Marc Soester [MVP]
National Manager: EPM
http://marcsoester.blogspot.com

 

[Kuzmenko Alexander]

Thanks. I'll try to use this information.

"Marc Soester [MVP]" <[email protected]>
ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: