BI reports - can only see sample reports RRS feed

  • Question

  • I use Project Server 2013.

    I would like to generate a Resource Usage report using the OLAPPortfolioAnalyzer which is located in the "analytics" section of reports. I am able to see the report in Excel but it doesn't open a template in Excel. That means I cannot drag and drop the fields in the Pivot Table Area. Instead I am restricted to six fields.

    It seems as if I am missing a step as this is the case with the other reports. What do I do so that I can select fields from the full list for my pivot table, in order to generate a comprehensive report?

    • Edited by HFprojects Monday, June 6, 2016 10:19 AM
    Sunday, May 29, 2016 6:53 PM


  • Update:

    After some research, I discovered that I was using Project Server 2013 with MS Office 2010. This was the reason that I only saw the sample reports.

    I upgraded to MS Office 2013 and was then able to access all the reports.

    • Marked as answer by HFprojects Monday, June 6, 2016 10:20 AM
    Monday, June 6, 2016 10:20 AM