Approved Time Reporting

[Willard Grayson]

We have created the Project OLAP cube database and built the cubes in Office
Project Server 2007.

We do not use timesheets in our Office Project Server 2007 implementation.
We enter and approve time on a project through the MyTask feature in EPM.

We would like to create a report that shows the following:
• Resource Name
• Project Name
• Task Name
• Date Time Entered
• Amount of Time Entered
• Total Time Entered for Task

Is it possible to create this report using Cubes without having timesheets
enabled?

If so, what Cube and what attributes can be used to report on the time data?

We are new to reporting from the Cubes so any help would be greatly
appreciated.

 

[Ben Howard]

Hi Willard,
You'll need to write an SSRS report or similiar, this is not available
directly via the cubes. However, you could create an OLAP cube that
displays Actual work and you could show actual work by resource/project/task
and then show this by the time dimension. It would potentially be a very
big report....

 

[Willard Grayson]

Hi Ben,

Thank you for your response. That was very helpful.
--
Willard Grayson
Project Coordinator
Technology Resources
Texas State University-San Marcos