How to create reports using BI Centre RRS feed

  • Question

  • This is a general question to point me in the right direction.

    I have set-up Server, and Reporting via Olap Cubes.

    So I can get to Excel Pivot Tables and add fields etc.

    What I need to understand is what data is stored where - and be able to convert what I want into a report.


    Managers want a report on individuals and what they are tasked with in a week on a daily basis.

    So I need Resource Names, Project Names, AssignedTasks, TaskStart and Task Finish and then show current week and display it somehow.

    Where can I go ,if  anywhere, to learn this - books, documnets, blogs or sample reports (other than BI)

    Hopefully you understand where I am coming from.


    Cheers Andy

    Monday, January 31, 2011 3:28 PM


All replies

  • Best place to look for, would be SDK, the SDK download contains the Reporting DB / Cube Schema explained


    However Project Server by default has couple of sample reports pre built in BI Centre

    Hope this helps,

    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Monday, January 31, 2011 6:46 PM
  • Thanks for this - started to have a look at - and may help?

    Getting to basics for starters though

    What field(s) would I use to look at MyTask assigned for this week for myself in a report.

    If I could understand this basic request I may start to understand the system.

    So no problem in getting tasks, project names, resource names  but how to filter for this week?

    Cannot use Assignmnet start or assignments finish - as longer tasks are then not seen as dont start or finish in this week.

    Tuesday, February 1, 2011 10:11 AM
  • Hi,

    When I was trying to get my head around the reporting db and how to write reports that access the data within, I started off looking at the PS 2007 Reporting Packs which included a number of Reporting Services reports across most aspects of the PS reporting schema. Perhaps grab a copy from http://msdn.microsoft.com/en-us/library/bb428831(v=office.12).aspx and http://code.msdn.microsoft.com/EPMReportPack.

    I believe the second link has a report similar to what you are after.

    hope this helps,


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, February 1, 2011 10:53 AM
  • Struggling here - I was trying just to use BI centre and Excel to keep it simple for the company. I will be out of here in 4 weeks and need to educate them how to produce simple reports.

    All the SDK's and other articles start mentioning Visual Studio, SQL reporting 2008, C# code , Js scripts bits of code.

    Is the simple answer No you can't do it?

    Or can anyone tell me for example just using BI and Excel can I produce a report showing what individuals are doing in which projects over a week period.

    Joe Bloggs                             Mon 1/2   Tue 2/2  Wed 3/2  Thur 4/2  Fri 5/2

    Project X

           Task Build a report              8h            8h

            Test Reports                                                   8h


    Thanks hopefully Andy

    Tuesday, February 1, 2011 1:25 PM
  • Hi Burnley

    Just a suggestion, for simplification purpose, there are preconfigured sample reports already available in BI centre for tutorial

    now coming to developing simple reports, have a look at "SCHEMAS" folder in SDK download location, it contains the excel sheet which has reporting DB schema defined, and before you start reporting you need to understand the Reporting DB Schema / Cube Schema, from where you are going to Pull what data, as you wouldn't know what your next requirement is going to be and definitely would help

    for your existing query you can look for Assignemnt Timephased cube to obtain the inforamtion requested, it has all the data you require, just connect to the cube using excel and pull the required info

    Hope this helps

    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Tuesday, February 1, 2011 5:17 PM
  • Burnley:

    Check out our book http://projectserverbooks.com/books/managingprojectsprojectserver2010.aspx Managing Enterprise Projects using Microsoft Project Server 2010, which includes an excellent step-by-step tutorial for building Excel reports and dashboards in the BI Center. You can leave the bookk behind so that your users can reference it rather than bugging you!

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG
    Tuesday, February 1, 2011 8:20 PM