none
Excel Pivot Table in BI 2010 RRS feed

  • Question

  • Hi,

    In PWA2010, Business Intelligence feature, I'm trying to build an Excel Report based on an OLAP database, but I don't know where/how to add enterprise custom fields to this OLAP cube or to the Excel Pivot Table.

    Thanks

    Sunday, January 9, 2011 10:55 PM

Answers

  • Hello Wilid1966

    From Server Settings,

      Database Administration

         OLAP Database Managementg

       Either create a NEW OLAP database or select the OLAP cube row and then you can click on CONFIGURATON.

    Cheers!


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    www.WhartonComputer.com
    • Marked as answer by WLID1966 Monday, January 10, 2011 7:44 PM
    Sunday, January 9, 2011 11:48 PM
    Moderator
  • Hi WLID1966,

    I think your issue is more than of creating and configuring an OLAP cube, you have added dimensions and measures to your cube but you do not see them.  Where are they? rite ?

    Are you trying using MSP_Portfolio_Analyzer cube? and the custom fields you have added are not appearing in your cube? This cube is actually a virtual cube constructed from the Assignment and Resource Timephased cubes, so if want any of your custom fields to be appear in this cube you have to add that custom field to one of these cubes. Apart from portfolio analyzer cube, MSP_PROJECT_Sharepoint and MSP_PROJECT_Timesheet are also virtual cubes.

     

    For more details, there is an excellent blog by Brian Smith: http://blogs.msdn.com/b/brismith/archive/2010/09/01/project-server-2010-olap-where-are-my-custom-field-dimensions-and-measures.aspx.

    Also there is a workaround mentioned in this blog: http://blogs.catapultsystems.com/epm/archive/2010/08/19/adding-departmental-breakouts-to-the-risk-and-issues-reports.aspx . But i prefer to do it the say Brian has explained.

     

    Does that help?


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Monday, January 10, 2011 5:15 AM

All replies

  • Hello Wilid1966

    From Server Settings,

      Database Administration

         OLAP Database Managementg

       Either create a NEW OLAP database or select the OLAP cube row and then you can click on CONFIGURATON.

    Cheers!


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    www.WhartonComputer.com
    • Marked as answer by WLID1966 Monday, January 10, 2011 7:44 PM
    Sunday, January 9, 2011 11:48 PM
    Moderator
  • Hi WLID1966,

    I think your issue is more than of creating and configuring an OLAP cube, you have added dimensions and measures to your cube but you do not see them.  Where are they? rite ?

    Are you trying using MSP_Portfolio_Analyzer cube? and the custom fields you have added are not appearing in your cube? This cube is actually a virtual cube constructed from the Assignment and Resource Timephased cubes, so if want any of your custom fields to be appear in this cube you have to add that custom field to one of these cubes. Apart from portfolio analyzer cube, MSP_PROJECT_Sharepoint and MSP_PROJECT_Timesheet are also virtual cubes.

     

    For more details, there is an excellent blog by Brian Smith: http://blogs.msdn.com/b/brismith/archive/2010/09/01/project-server-2010-olap-where-are-my-custom-field-dimensions-and-measures.aspx.

    Also there is a workaround mentioned in this blog: http://blogs.catapultsystems.com/epm/archive/2010/08/19/adding-departmental-breakouts-to-the-risk-and-issues-reports.aspx . But i prefer to do it the say Brian has explained.

     

    Does that help?


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Monday, January 10, 2011 5:15 AM