Solved

Help with Data Analysis / Views in Project Server

Posted on 2008-06-24
12
4,016 Views
Last Modified: 2013-11-15
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.

0
Comment
Question by:ACoggin
  • 7
  • 5
12 Comments
 
LVL 13

Accepted Solution

by:
bobsegrest earned 500 total points
Comment Utility
Hello Andy,

When you install Project Server there are no data analysis views.  I suspect that this is because the Project Server has no way to know which SQL server you are using for analysis services during the initial deployment process.

After you create your cube you need to connect to PWA as a project server administrator and select the Server Settings on the quick launch menu.  Next select the Manage Views option under the look and feel heading.  Click New View on the manage views page.  Pull down the View Type drop down field and select Data Analysis.  After the view page refreshes, enter the name of your SQL analysis server and select the cube you want to use.  Then click the Apply button and you should have access to your data.  Finish designing your view and don't forget to select the user categories that should be able to see it (the default is no one).  Click the Save button at the bottom of the page.

Go back to your PWA home page, select Data Analysis and your new view.

Let us know what happens...

Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
0
 

Author Comment

by:ACoggin
Comment Utility
Bob,

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.
0
 
LVL 13

Expert Comment

by:bobsegrest
Comment Utility
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
0
 

Author Comment

by:ACoggin
Comment Utility
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.
0
 
LVL 13

Expert Comment

by:bobsegrest
Comment Utility
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
0
 

Author Comment

by:ACoggin
Comment Utility
Thanks Bob,

I am away for the next two days now. Ok if we pick this up again on Monday.

Thanks
Andy.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 13

Expert Comment

by:bobsegrest
Comment Utility
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
0
 

Author Comment

by:ACoggin
Comment Utility
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
0
 
LVL 13

Expert Comment

by:bobsegrest
Comment Utility
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
0
 
LVL 13

Assisted Solution

by:bobsegrest
bobsegrest earned 500 total points
Comment Utility
Hi Andy,

Its pretty straight forward.  Here is what I did...

Create a new Data Analysis view and select the Timesheet cube.
Open the Field List.
Drag the Timesheet Resource List into the rows area (left side) of the pivot table.
Then drag the Timesheet Task List and drop it in the same area just to the right of the resource list.
Drag the Actual Work Billable into the main grid area.
Drag the Time into the column header area.

Keep in mind that the cube is only going to display administrative tasks with data...

If you are not seeing your administrative tasks at this point there are a couple of things you need to check...

1. Have you configured the timesheets on your server?
2. Has anyone actually created AND submitted a timesheet?
3. If you configured your system to require timesheet approval, have the submitted timesheets been approved?
4. Have you rebuilt your cube since the timesheets were submitted?

Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
0
 

Author Comment

by:ACoggin
Comment Utility
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.
0
 
LVL 13

Expert Comment

by:bobsegrest
Comment Utility
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
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now