none
PerformancePoint dashboard in SharePoint with Forms Based Authentication RRS feed

  • Question

  • Hi,

    I am having an issue. We have a SharePoint farm and PerformancePoint Server installed on one of the SharePoint server and integrated with SharePoint farm. I can build the dashboard elements in dashboard designer and published it to a SharePoint web application (http://intranet) and I had extended this web application and created a forms based authenticated web application which SSL certified for extranal users (https://extranet).

    I manually deployed the monitoring webpart and changed the web config file of my extranet web application https://extranet.

    When I published the dashboard to http://intranet, everything works fine. But when I try to see it in https://extranet, it shows me an error. The Dashboard is unavailable. Contact your system administrator for assistance.

    Somewhere I read that, If we get this error then it means that we don't have permissions on the dashboard. But the PerformancePoint dashboard works with the application pool account right?

    I created a service account and assigned it to application pools of PerformancePoint Monitoring Server and SharePoint Web applications deployed with Dashboard Viewer Web Part. And also assigned this account a reader permission to all the elements in the dashboard, data source and also SQL Server databases and cubes.

    It works fine with windows authentication, can't we dispaly dashboard with forms based authentication?

    My doubt is Can we dispaly PerformancePoint dashboard in SharePoint with Forms Based Authentication?

    Thanks,
    Karthik

    Wednesday, June 10, 2009 3:50 PM

Answers

  • After taking the microsoft support call, I can able to display PerformancePoint Dashboards in SharePoint with Forms Based Authentication.

    From what I learned, we will have to allow access to all authenticated users to everything in PPS. To do this go to the Office Button->Options->Server tab->connect->then click permissions. Add the group NT Authority\Authenticated Users as an admin here. Republish all dashboards in the SharePoint site.

    Tuesday, June 23, 2009 5:22 PM

All replies

  • Hi Karthik,

    Please check this link http://social.technet.microsoft.com/Forums/en-US/ppsmonitoringandanalytics/thread/da7b28dd-0d8d-455e-a4c2-91a0b34fc9de will provide additional information


    Thank you,
    Sundar - MSFT
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, June 10, 2009 5:15 PM
  • Hi Sundar,

    I have gone through that white paper associated with the link you provided, and came to know that Given the requirements for PerformancePoint 2007 and Windows Authentication, this whitepaper will only focus on the Windows Authentication Provider.

    I am again on the same page. My understanding is PerformancePoint Dashboard in SharePoint uses Application Pool account to dispaly the dashboard to the users. Then why it don't work with Forms Based Authentication in SharePoint.

    Any Thoughts...

    Thanks,
    Karthik
    Wednesday, June 10, 2009 9:56 PM
  • Hi Karthik,

    We do support using ISA server to allow for an extranet deployment through forms based authentication but active directory accounts are still required.   It is by design in V1.

    Thank you,
    Sundar - MSFT
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, June 12, 2009 1:43 PM
  • Karthik,

    You are correct, PerformancePoint requires Windows Authentication to work. V1 cannot take advantage of Forms Based Authentication. However, if your goal is to authenticate to SharePoint using Forms based authentication and still have PerformancePoint access reports using the SharePoint application pool (PPS default security) then that could work.

    The issue you may be running into is that it sounds like you are using SharePoints Alternate Acces Mappings (AAM) to create these internal and external sites. Is that correct? If so, V1 of PerfomancePoint does not have the ability to work with AAMs. To work around this, you will have to create 2 seperate SharePoint sites, 1 internal and 1 external and then configure PPS to work for both sites.

    Thanks,
    Jon Thomas
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, June 12, 2009 2:20 PM
    Moderator
  • Sundar,

    Right now my issue is, I am not able to display PerformancePoint dashboard in SharePoint Forms Based Authenticated Web Application which I could not figure out why?

    Thanks,
    Karthik
    Friday, June 12, 2009 3:05 PM
  • Jon,

    Thanks for you reply. I am not using AAM's for internal and external sites. I created Host Headers for my Web Applications for both internal and external sites and changed Authentication Providers for both the Web applications and then configured PPS on those sites.

    But  the site with Windows Authentication is displaying dashboards exactly how it should be but the site with Forms Authenticated is not showing up and displays an error messages as mentioned in my first post.

    Is there anything that I am missing ?

    Thanks,
    Karthik
    Friday, June 12, 2009 3:56 PM
  • After taking the microsoft support call, I can able to display PerformancePoint Dashboards in SharePoint with Forms Based Authentication.

    From what I learned, we will have to allow access to all authenticated users to everything in PPS. To do this go to the Office Button->Options->Server tab->connect->then click permissions. Add the group NT Authority\Authenticated Users as an admin here. Republish all dashboards in the SharePoint site.

    Tuesday, June 23, 2009 5:22 PM