I am attempting to create a report of projects, resources assigned and Actual hours by Timesheet Manager. Is it possible to do this using OLAP? We had a consultant do something similar using SSRS, however I want to use Task Tracking and Time sheets. Any ideas?
Thanks
thinkordi wrote:
Finally I can see the actual time on MSP_Portfolio_Analyser cube!
05-Nov-07
I finally can see the actual time. I found out that we need the following
steps to see the actual time on MSP_Portfolio_Analyser cube
(1) User01 inputs the actual time on her Timesheet and submits it
(2) Timesheet manager of User01 approves the Timesheet
(3) User01 imports her Timesheet into 'My Tasks' and updates the progress
percentage of assigned tasks
(4) User01 submits the updated progress to Project Manager
(5) Project Manager approves the updated progress
(6) In addition, Project Manager publishes the approved progress
(7) Finally the actual time of User01 appears on MSP_Portfolio_Analyser cube
I forgot Step (6) written above
Thank you for your help, Ben
:
Previous Posts In This Thread:
Which field of OLAP cube represents actual work hours on Time Shee
Here is my simple question
Which field of Project Web Access OLAP cube represents the actual worked
hours on each project member's Timesheet
I tried to put all fields of OLAP cube on the pivot table. But I couldn't
find any field which has the same amout of hours with the actual worked hours
Please suppose that team members have already input their worked hours in
Timesheet, submitted it, got approved, imported it to task status, updated
task progress and submitted the updated task progress
Thank you in advance,
So you either need EPM Timesheet or Timesheet cube, and you need to sum all of
So you either need EPM Timesheet or Timesheet cube, and you need to sum all of
Actual Work Billable, Actual Work Non Billable, Actual Overtime Work
Billable, Actual Overtime Work Non Billable. That will tell you the work the
resource put on their timesheet.
--
Thanks, Ben
http://appleparkltd.spaces.live.com
:
Ben, thank you for your response. But your response didn't get to the point.
Ben, thank you for your response. But your response didn't get to the point
I'm afraid my descriptioin was not so clear
We created a new project file and publish it to project server
In the project file, User01 is assigned a task, let's say, with 8 work hours
Our PWA is configured to permit users to update their task progress only
through Timesheet, not by directly inputting progress percentage on 'Edit
Task' form
If User01 creates her EPM Timesheet of correspoinding period of the assigned
task, inputs her actual worked hours, for example, 4 hours and imports the
Timesheet to 'My Task' page, then the progress percentage of this task will
become 50%
My question is how we can see this '4 hours' on PWA analysis cube at this
stage
:
Okay.
Okay. Assuming the PM approves the time, use the MSP_Portfolio_Analyser cube
and select Actual Time.
Remember timesheets and task updates are different entities
--
Thanks, Ben
http://appleparkltd.spaces.live.com
:
Ben, I really appreciate your quick response!
Ben, I really appreciate your quick response! I checked the name of the cube
and noticed the name is exactly 'MSP_Portfolio_Analyser'
I displayed all the fields of 'MSP_Portfolio_Analyser' but I couldn't find
any fields with '4.0' value when I select 'User01' as resource
Some fields have '8.0' value which means the total hours of assigned tasks
and some other fields have '168' value which means the total workable hours
of User01 and the other fields have '0' value
Can you see why all these strange things happen
:
Finally I can see the actual time on MSP_Portfolio_Analyser cube!
I finally can see the actual time. I found out that we need the following
steps to see the actual time on MSP_Portfolio_Analyser cube.
(1) User01 inputs the actual time on her Timesheet and submits it.
(2) Timesheet manager of User01 approves the Timesheet.
(3) User01 imports her Timesheet into 'My Tasks' and updates the progress
percentage of assigned tasks.
(4) User01 submits the updated progress to Project Manager.
(5) Project Manager approves the updated progress.
(6) In addition, Project Manager publishes the approved progress.
(7) Finally the actual time of User01 appears on MSP_Portfolio_Analyser cube.
I forgot Step (6) written above.
Thank you for your help, Ben!
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .Net Tips and Tricks No. 26
http://www.eggheadcafe.com/tutorial...be30-cde5d852348d/dr-dotnetskys-cool-net.aspx