ACoggin
asked on
Help with Data Analysis / Views in Project Server
I need to help with data analysis to extract data from the timesheet component of Project Server 2007.
I have built the cube successfully and I'm pretty confident all the data I'm trying to report on resides within the cube. The main issues are:
1. When I go into data analysis, the system always has a line at the bottom stating - "There are no Data Analysis views available. Contact your administrator to have views defined." (however I am still able to create a report)
2. After connecting to a data source and starting to drag and drop fields to create my report, the options at the top are always greyed out - Expand, Collapse, Show Field List, Save PivotTable as Image, Save PivotChart as Image.
3. [This is my main issue] I am unable to work out how to create a report that displays not only time spent on projects but all time including Administrative time. I can't seem to find a field that includes Admin time. My report consists of resources on the left(all employees), time across the top, and I want time spent on admin tasks to appear in the data field in the middle. I also want to be able to change which admin task I report on, ie holiday, sick for a particular day / week.
I hope you can help.
Thanks Andy.
I have built the cube successfully and I'm pretty confident all the data I'm trying to report on resides within the cube. The main issues are:
1. When I go into data analysis, the system always has a line at the bottom stating - "There are no Data Analysis views available. Contact your administrator to have views defined." (however I am still able to create a report)
2. After connecting to a data source and starting to drag and drop fields to create my report, the options at the top are always greyed out - Expand, Collapse, Show Field List, Save PivotTable as Image, Save PivotChart as Image.
3. [This is my main issue] I am unable to work out how to create a report that displays not only time spent on projects but all time including Administrative time. I can't seem to find a field that includes Admin time. My report consists of resources on the left(all employees), time across the top, and I want time spent on admin tasks to appear in the data field in the middle. I also want to be able to change which admin task I report on, ie holiday, sick for a particular day / week.
I hope you can help.
Thanks Andy.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi Andy,
Are you asking about administrative time in a cube, some other view or some other report?
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
Are you asking about administrative time in a cube, some other view or some other report?
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
ASKER
Ok I'll try to explain...
In Time and Task Management, I clicked on Administrative time and created serveral new categories
admin-holiday
admin-illness
admin-maintenance etc.
The check box "always display" is ticked.
The above categories always appear when users go into their weekly timesheet and they are able to add hours against each of the tasks.
My report consists of employees on the left, time accross the top and work in the data area.
The problem is that I don't see any time being reported against admin tasks. The only time being reported is time spent on actual projects. I want to be able to determine how much holiday time someone has had in a particular month.
Is it possible that the cube is configured incorrectly, or have I just not founf the correct data field to include?
I hope this is clear!
Thanks
Andy.
In Time and Task Management, I clicked on Administrative time and created serveral new categories
admin-holiday
admin-illness
admin-maintenance etc.
The check box "always display" is ticked.
The above categories always appear when users go into their weekly timesheet and they are able to add hours against each of the tasks.
My report consists of employees on the left, time accross the top and work in the data area.
The problem is that I don't see any time being reported against admin tasks. The only time being reported is time spent on actual projects. I want to be able to determine how much holiday time someone has had in a particular month.
Is it possible that the cube is configured incorrectly, or have I just not founf the correct data field to include?
I hope this is clear!
Thanks
Andy.
Hi Andy,
Thank you for the clarification. This gives me the information I need to research the issue.
I have to be out for a few hours this morning and will get on it as soon as I return.
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
Thank you for the clarification. This gives me the information I need to research the issue.
I have to be out for a few hours this morning and will get on it as soon as I return.
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
ASKER
Thanks Bob,
I am away for the next two days now. Ok if we pick this up again on Monday.
Thanks
Andy.
I am away for the next two days now. Ok if we pick this up again on Monday.
Thanks
Andy.
Hi Andy,
The implementation of timesheets and administrative time changed a great deal with the release of Project Server 2007. In the Project Server 2003 world, administrative time was recorded in a special kind of project. This is not the case in the 2007 world.
More significant to this discussion thread, administrative entries are no longer tasks and they don't appear in the MSP_Portfolio_Analyzer cube. Administrative time is visible in the Timesheet cube. [You select the cube you want to use when you create or edit a data analysis view in View Management.]
The good news is that the data can be presented in the format you have described. The bad news is that the administrative time categories are all labeled with the label "Auto-generated". In the attached analysis view example, the Administrative time entries are Administrative, Vacation and Goofing Off (top to bottom respectively). A bit disappointing, but it is what it is. You can always export the table to Excel and relabel things there.
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
Untitled.jpg
The implementation of timesheets and administrative time changed a great deal with the release of Project Server 2007. In the Project Server 2003 world, administrative time was recorded in a special kind of project. This is not the case in the 2007 world.
More significant to this discussion thread, administrative entries are no longer tasks and they don't appear in the MSP_Portfolio_Analyzer cube. Administrative time is visible in the Timesheet cube. [You select the cube you want to use when you create or edit a data analysis view in View Management.]
The good news is that the data can be presented in the format you have described. The bad news is that the administrative time categories are all labeled with the label "Auto-generated". In the attached analysis view example, the Administrative time entries are Administrative, Vacation and Goofing Off (top to bottom respectively). A bit disappointing, but it is what it is. You can always export the table to Excel and relabel things there.
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
Untitled.jpg
ASKER
Thanks Bob, I think I'm nearly there!
I'm am trying to duplicate the data analysis view above.
I have the choice of the following cubes:
EPM Timesheet
MSP_Project_Timesheet
Timesheet
I have tried all three but still can't find the administrative tasks field that I need to add to the data field.
What cube and field did you select for your view?
Shame about the labelling I've got about 50 admin tasks I need to report on!
Regards
Andy.
Data-Analysis.JPG
I'm am trying to duplicate the data analysis view above.
I have the choice of the following cubes:
EPM Timesheet
MSP_Project_Timesheet
Timesheet
I have tried all three but still can't find the administrative tasks field that I need to add to the data field.
What cube and field did you select for your view?
Shame about the labelling I've got about 50 admin tasks I need to report on!
Regards
Andy.
Data-Analysis.JPG
Hi Andy,
I'm sure I used the Timesheet cube in the example.
I'm on my way out the door again, but I will send you more details later today.
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
I'm sure I used the Timesheet cube in the example.
I'm on my way out the door again, but I will send you more details later today.
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bob,
It now works! The main problem was that the cube was restricted by project start and end dates, so some of the timesheet data was missing. I corrected to report 6 months prior to 3 months in advance; rebuilt the cube and the problem was resolved.
I used Timesheet Class instead of Timesheet Task List, and found this provides the correct list of Admin Tasks in the report, as opposed to Auto-generated.
Many thanks for all your help and advice on the case. I have a couple more questions coming up, but I'll post these as new questions, you have done more than enough for the 500 points!
Thanks again
Andy.
It now works! The main problem was that the cube was restricted by project start and end dates, so some of the timesheet data was missing. I corrected to report 6 months prior to 3 months in advance; rebuilt the cube and the problem was resolved.
I used Timesheet Class instead of Timesheet Task List, and found this provides the correct list of Admin Tasks in the report, as opposed to Auto-generated.
Many thanks for all your help and advice on the case. I have a couple more questions coming up, but I'll post these as new questions, you have done more than enough for the 500 points!
Thanks again
Andy.
Hi Andy,
Nice catch on the Timesheet Class! I hadn't taken the time to explore all of the data tables yet.
I'm glad I was able to help...
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
Nice catch on the Timesheet Class! I hadn't taken the time to explore all of the data tables yet.
I'm glad I was able to help...
Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
ASKER
Using your information I have successfully created a data analysis view; so thats solved points 1 and 2 for me. There is hardly any information around in text books or on the internet regarding data analysis views - so thanks for that!
With regard to point 3, I am still unable to find out how to report on any administrative time in the system, any ideas on this one?
Regards
Andy.