Solved

Help with Data Analysis / Views in Project Server

Posted on 2008-06-24
12
4,067 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 13

Accepted Solution

by:
bobsegrest earned 500 total points
ID: 21856983
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
ID: 21863906
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
ID: 21864177
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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:ACoggin
ID: 21864419
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
ID: 21864505
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
ID: 21867370
Thanks Bob,

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

Thanks
Andy.
0
 
LVL 13

Expert Comment

by:bobsegrest
ID: 21873469
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
ID: 21898156
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
ID: 21898260
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
ID: 21902040
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
ID: 21906030
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
ID: 21908710
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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Old act to CRM 2 148
how to eliminate duplicates in a string variable in t-sql? 30 86
Help  needed 3 44
Find results from sql within a time span 11 55
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
A simple overview of the possibilities of using technology for project management.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 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