none
Accrue At field in Project Server Reporting RRS feed

  • Question

  • Where can I find accrue at information for a resource in project server reporting database

    Regards,

    Chrisma Andhika

    Wednesday, June 20, 2012 2:49 PM

All replies

  • Chrisma,

    The RDB schema is part of the Project Server SDK. Try the MSP_EpmResource_Userview view first to find this field. Let me know if you don't find it.

    Thanks!

    Treb Gatte

    • Proposed as answer by Kashif Nizam Saturday, July 27, 2013 12:09 PM
    Wednesday, June 20, 2012 4:20 PM
    Moderator
  • Agreed with Treb. You can get the ResourceCostPerUse either from MSP_EpmResource_Userview or MSP_EpmResource table. Microsoft Project calculates cost totals when rate-based resources, resources that have per-use costs, and cost resources are assigned to tasks.
    SELECT [ResourceUID]
          ,[ResourceName]
          ,[ResourceCostPerUse]
          ,[ResourceType]      
      FROM [MSP_EpmResource]
    Hope that helps.

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Proposed as answer by Kashif Nizam Saturday, July 27, 2013 12:09 PM
    Thursday, June 21, 2012 6:06 AM