none
Project custom fields in MSP_Portfolio_Analyser (PWA 2007) RRS feed

  • Question

  • Hi,

    I need to add 2 project level custom fields (Text + Lookup table) in the MSP_Portfolio_Analyzer cube.

    I published every project with these 2 custom fields (via WPA)

    I added these 2 fields in the Configuration page, then I ran the calculation of the OLAP cube. But when I want to build my Data Analysis view, I don't find these 2 custom fields in the Dimension list.

    What did I miss? Thanks


    • Edited by WLID1966 Sunday, October 2, 2011 1:42 PM
    Sunday, October 2, 2011 1:02 PM

Answers

  • To which cube(s) did you add the custom field?  The MSP_Portfolio_Analyzer cube is a virtual cube.  You'll need to add your custom field at least to the Assignment cube.


    Reid McTaggart Partner DeltaBahn LLC
    • Marked as answer by WLID1966 Monday, October 3, 2011 6:05 AM
    Sunday, October 2, 2011 9:19 PM

All replies

  • The fields should be there unless they are multi-value fields, in which case they will not be available.

     


    Ben Howard [MVP] blog | web
    Sunday, October 2, 2011 7:22 PM
    Moderator
  • Hi Ben,

    My custom fields (Text project level with lookup table) are not "multivalue". :-(

    Thanks

    Sunday, October 2, 2011 8:00 PM
  • To which cube(s) did you add the custom field?  The MSP_Portfolio_Analyzer cube is a virtual cube.  You'll need to add your custom field at least to the Assignment cube.


    Reid McTaggart Partner DeltaBahn LLC
    • Marked as answer by WLID1966 Monday, October 3, 2011 6:05 AM
    Sunday, October 2, 2011 9:19 PM
  • Great !

    Thanks a lot! That worked!

    Monday, October 3, 2011 6:06 AM