PivotTable in Excel Report 2010 and field types RRS feed

  • Question

  • Hi,

    Do the PivotTable in Excel Report 2010 have the same constraints as the Analysis views in 2007 : for ex. No Multivalue field as a dimension...?


    Thursday, February 3, 2011 4:53 PM


All replies

  • Hi Wlid,

    I've not tried it, but I would expect so, assuming the Excel Services file is using the OLAP cube.  This is of course a function of OLAP, and not of the front end client tool.

    Ben Howard [MVP] blog | web
    Thursday, February 3, 2011 6:07 PM
  • Multivalue fields are also difficult to get into an ODC file for a normal non-Pivot Excel report.  I'd suggest avoiding them on anything that will need to go into any report (i.e. non Project Center view).
    Andrew Lavinsky [MVP] Twitter: @alavinsky
    Friday, February 4, 2011 2:42 AM
  • Hi all,

    I quoted  Multivalue field  as an example, but what about the other fields?

    I think like Ben that's the same things, but I would like confirmation on it.

    Tuesday, February 8, 2011 8:22 PM
  • HI WLID1966,

    you can add your project/resource etc custom fields to your OLAP cube as dimensions and measures. the issue is with the multi-valued custom field only. Also go through this excellen post by Brian about how to add the custom fields to the cube: http://blogs.msdn.com/b/brismith/archive/2010/09/01/project-server-2010-olap-where-are-my-custom-field-dimensions-and-measures.aspx

    Hope this helps.

    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    • Proposed as answer by Khurram Jamshed Tuesday, February 8, 2011 8:59 PM
    • Marked as answer by WLID1966 Tuesday, February 8, 2011 9:28 PM
    Tuesday, February 8, 2011 8:58 PM