Cannot view PPS Dashbord from client. - PerformancePoint Server

Learn Microsoft BI Forum BI Front Ends PerformancePoin... Cannot view PPS Dashbord from client.

3/17/2009 11:23 PM

	anibis.knowledge
1 posts

Cannot view PPS Dashbord from client.

Hi, I have a dashboard designed in PPS. The data is fetched from CUBE which is residing in the same box. In the server I am able to view the Dashboard but from my client machine I am not able to view. Its not displaying any error message, I am able to view the reports but without data. I created a group in Server and added all the users in that group including myself. I created a role and provided read permission to that group. In PPS, I provided read permission to that group. My PPS Dashboard is using PIVOT Charts. My local system (client) is having OWC Installed. After deploying, in the preview, I am able to view the reports in the server. But when I am trying to connect it from my client machine, the charts are not visible to me. I have made the necessary changes in IE, still no luck. While connecting from Clients machine, the reports datasource is getting cleared. I mean the server connection string is there but the Cube name is getting cleared. As a result the report is not displaying any data. While I am seeing it in the server, the datasource is present as a result the reports are visible. Can any one come across this type of issue. Please let me know if there is any way to resolve this.

3/18/2009 10:53 AM

	cutley
363 posts

Re: Cannot view PPS Dashbord from client.

I have not come across this issue before but here is what I would try. On the client machine, can you create a connection to the cube using Excel? If so, that shows that connectivity works. Then, I would check to make sure you have the same version of OWC, OLE DB, ADOMD, SNAC, etc. Is this SQL 2005? If so, have you applied the latest updates (http://support.microsoft.com/kb/953752)? And have you applied those to both the client and server?

--Craig

8/4/2009 10:15 AM

	Chandra
1 posts

Re: Cannot view PPS Dashbord from client.

I have come across the same issue.But I resolved this issue by changeing the Analysis services account local to network service account. steps to change the local service account to network service account. Go to Start-->Programs--->MS SQL Server 2005/2008-->Sql serverver configurations You can found the All services accounts like SQL Server Agent ..etc. and Analysis services as well. Goto Analysis services properties change local services account to network services account then restart the Analysis service account.

Page 1 of 1

Learn Microsoft BI Forum

BI Front Ends

PerformancePoin...

Cannot view PPS Dashbord from client.