none
Project Server 2010 - Embedding Business Intelligence Dashboard into another website RRS feed

  • Question

  • Hi there :)

    I have a question about so called dashboards in business intelligence area in project web app. One of my bosses has created a dashboard for a specific customer with data from all of this customers projects. Now we have our Team Foundation Server where all projects are developed and all documents are stored. The customer does not have any access to the Project Server.

    My boss wants that his created dashboard shows up in the customer TFS SharePoint website without the customer realising that the dashboard comes from somewhere else. Is this somehow possible?

    Regards Sascha

    Edit:

    Additional info: the customer have Active Directory accounts in our domain.

    • Edited by savobe Monday, August 29, 2011 11:12 AM additional info added
    Monday, August 29, 2011 11:04 AM

Answers

  • Hi there,

    Assuming that you have cretaed a Excel Dashboard report with a data connection with a Read only access to account on Reporting database. You have everything ready , You can use an Excel Web Access Web Part, which enables you to view and interact with a live workbook by using a browser. Hoping that you have TFS & Project server in same domain.

    Please read the below msdn article:
    http://msdn.microsoft.com/en-us/library/ms546696.aspx

    Other than this, there are 3rd party tools, to display the Excel dashboards to display in sharePoint sites.
    http://store.bamboosolutions.com/p-71-data-viewer-web-part.aspx

    Hope that helps. 


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, August 29, 2011 12:06 PM
  • Agree with Amit.  All of the reporting data is coming from SQL.  No need
    to share farms.  If you have Excel Web Services or PerformancePoint on the
    TFS farm, you should be ok.
     
    Minor caveat however, in theory, all users accessing real time data from
    Project Server will need a user license for Project Server (even if they're
    only looking at reports/dashboards).  Check with your licensing rep for the
    actual details, but that's the rule of thumb.
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Monday, August 29, 2011 1:08 PM
    Moderator

All replies

  • Hi there,

    Assuming that you have cretaed a Excel Dashboard report with a data connection with a Read only access to account on Reporting database. You have everything ready , You can use an Excel Web Access Web Part, which enables you to view and interact with a live workbook by using a browser. Hoping that you have TFS & Project server in same domain.

    Please read the below msdn article:
    http://msdn.microsoft.com/en-us/library/ms546696.aspx

    Other than this, there are 3rd party tools, to display the Excel dashboards to display in sharePoint sites.
    http://store.bamboosolutions.com/p-71-data-viewer-web-part.aspx

    Hope that helps. 


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, August 29, 2011 12:06 PM
  • Agree with Amit.  All of the reporting data is coming from SQL.  No need
    to share farms.  If you have Excel Web Services or PerformancePoint on the
    TFS farm, you should be ok.
     
    Minor caveat however, in theory, all users accessing real time data from
    Project Server will need a user license for Project Server (even if they're
    only looking at reports/dashboards).  Check with your licensing rep for the
    actual details, but that's the rule of thumb.
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Monday, August 29, 2011 1:08 PM
    Moderator