none
Custom Fields and Reporting DB RRS feed

  • Question

  • I've created a couple of new custom fields in PS 2010 which both use pre-existing Enterprise Lookup Tables for their values.
    One of them has almost immediately appeared in the MSP_EpmProject_UserView view in SSMS but the other hasn't appeared after over an hour.
    I've updated the values in both using the Project Detail Page that the fields were added to and I've checked the test project in a number of time.
    Am I doing something wrong?
    Why would one work and not the other?

    N03L.

    Thursday, June 19, 2014 3:08 PM

Answers

  • NO3L,

    Is the second field a multi value custom field? If yes, they would not appear in the MSP_EpmProject_UserView, which is reserved for single value custom fields.

    You will find this second field in  MSPCFPRJ_YourMultiValueCustomFieldName_AssociationView


    Prasanna Adavi,PMP,MCTS,MCITP,MCT TWitter: @prasannaadavi Blog: http://www.prasannaadavi.com

    • Marked as answer by NIN03L Friday, June 20, 2014 12:39 PM
    Thursday, June 19, 2014 5:27 PM
    Moderator

All replies

  • NO3L,

    Is the second field a multi value custom field? If yes, they would not appear in the MSP_EpmProject_UserView, which is reserved for single value custom fields.

    You will find this second field in  MSPCFPRJ_YourMultiValueCustomFieldName_AssociationView


    Prasanna Adavi,PMP,MCTS,MCITP,MCT TWitter: @prasannaadavi Blog: http://www.prasannaadavi.com

    • Marked as answer by NIN03L Friday, June 20, 2014 12:39 PM
    Thursday, June 19, 2014 5:27 PM
    Moderator
  • Thank you very much Prasanna.

    I'd never have found that.

    N03L.

    Friday, June 20, 2014 12:40 PM