locked
Setting up Performance Point Dashboard Designer RRS feed

  • Question

  • Been running Project Server 2010 for two weeks now -

    So its time for reporting - creating some reports and dashboards from BI.

    To create better visibility looks like Performace Point Dashboard designer, after initial problems of error messages saying not setup correctly. Worked out that unattended service userid was not present - so setup with sss details.

    So trying to create Data Source but Database does not allow me to enter anything and when you use dropdown menu is briefly says loading and then leaves a blank database field .

    Any ideas?


    Burnley81
    Wednesday, January 26, 2011 8:10 AM

Answers

  • It still sounds like it's security related, but if Excel works, you clearly
    have access to the Reporting database. 
     
    Are you creating the data source using the PerformancePoint Dashboard Designer?
     Have you tried doing so (just navigate to a PerformancePoint list and hit
    new to trigger the download and opening of the Designer)?
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky
    Monday, January 31, 2011 4:51 PM

All replies

  • Hi Burnley81,

    this usually happens if you are unable to access your DB server. Is you DB server on the same machine? also check if you have the permission to access the database.

    Let us know if it helps or provide us with more detail to dig deeper.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Wednesday, January 26, 2011 8:45 AM
  • In addition to Khurram's advice, you may wish to start a bit slower, and
    begin with making sure you can create simple Excel reports - pulling data
    directly from the Reporting DB.  Once you have the security issues resolved
    there, it's not too much harder to graduate to PerformancePoint.
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky
    Wednesday, January 26, 2011 1:58 PM
  • If you mean - can I use the Business Intellengence centre - run reports from templates, open them in Excel, Excel then connects to the server, update them and save them back to the PWA - then the answer is yes I can.

    The only thing I cannot do, in addition to PerformancePoint, is use visual reports in a project within project client. This may be something completely different though.

     

    Thanks Andy

     


    Burnley81
    Wednesday, January 26, 2011 2:08 PM
  • No - I mean a blank Excel report from scratch by pointing the Data connection straight to SQL.
    Andrew Lavinsky [MVP] Twitter: @alavinsky
    Wednesday, January 26, 2011 2:28 PM
  • Just tried that and yes I can create a report after setting up the data connection.
    Burnley81
    Wednesday, January 26, 2011 2:34 PM
  • Just to clarify this - I can use Excel and point to data connections straight to SQL - but I cannot use Performancepoint yet.
    Burnley81
    Monday, January 31, 2011 11:49 AM
  • Visual reports is completely different, relying on Excel 2007/10 and Visio Pro 2010.
    Ben Howard [MVP] blog | web
    Monday, January 31, 2011 1:08 PM
  • It still sounds like it's security related, but if Excel works, you clearly
    have access to the Reporting database. 
     
    Are you creating the data source using the PerformancePoint Dashboard Designer?
     Have you tried doing so (just navigate to a PerformancePoint list and hit
    new to trigger the download and opening of the Designer)?
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky
    Monday, January 31, 2011 4:51 PM