none
Project Server 2010 - Custom Field Reporting RRS feed

  • Question

  • how do i create a business intelligence report on project level custom fields when the custom fields do not meet the requirements to be included in a cube?  my report should list; by customer the value for each custom field.  i am flexible on what to do with the data when more than one value exists for a given custom field (ie., additional column, included in existing column, additional row, etc.).   for instance, i have project level custom fields connected to look up tables and those custom fields can have multiple values.  for example, we can select more than 1 product for each customer. 

    please let me know if you have any questions.

    Tuesday, August 30, 2011 1:48 PM

Answers

  • If the data is not in the OLAP cube you need to build a report against the reporting database. The common technique for this is to use SQL Server Reporting Services and develop the reports with Report Builder. The options and how to are covered in a white paper that you can find here:

     

    http://technet.microsoft.com/en-us/library/gg188101.aspx


    Jack Dahlgren blogs at:
    Project and Retrovention
    and rarely Twitter
    Tuesday, August 30, 2011 2:14 PM
    Moderator

All replies