trying not to reinvent the wheel....?

[Shawn Everingham]

Fellow Admins:

I need to report the following items out to a spread sheet:
Employee ID, Timesheet Project List Level 02, Timesheet Resource List Level
2, Timesheet Class, Time

I have this view already created in Data Analysis using the Timesheet Cube.
However, it does not include employee id as a reportable field. How do/can I
get this included in my cube?

Also, along those same lines, we have differing categories of ADMINISTRATIVE
time ie berevement, FMLA, Vacation, Personal Time, and then true
administrative time (emails, misc meetings, etc...at work activities as
opposed to out of work activities).

Is there a way for me to filter out these sub custom-categories we have
created?

thanks in advance. Shawn

 

[Marc Soester [MVP]]

Hi Shwan,

the information you are after is not available in the cubes ( as you
discovered already). Check out the Reporting Datatbase of Project Server. I
have forwarded you the DB schema in your last post. I believe you will be
able to find this info in the Report DB
Hope this helps