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.