PPS M&A Dashboard does not render graphs published on SSRS2005.

Question

PPS M&A Dashboard does not render graphs published on SSRS2005.

siraj.alimohamed

SSC Enthusiast

Points: 109
More actions
April 30, 2009 at 7:24 am

#208768

We have developed a dashboard using PPS M&A & Reporting Services that will be hosted on a SharePoint portal. In our development environment, everything works as designed.
The development environment is a Virtual Machine and all the software that are used for the dashboard is installed on this single machine. The software installed are:
-SQL Server 2005 - Enterprise Edition – Service Pack 2
oRDBMS
oAnalysis Services
oIntegration Services
oReporting Services
-ProClarity Analytics Server – 6.3
-ProClarity Desktop Server – 6.3
-MOSS 2007 – Enterprise Edition
-PPS M&A – Service Pack 2
However, when we deploy this solution onto the UAT environment at the client site, we are facing chart rendering problems with the dashboard. With all the configuration done, the charts do not show up (they have cross marks all over) and so does not make any sense to anyone.
The UAT environment is setup with two servers – Database & Application. The servers are both Intel Xeon 2.6Ghz Quad Core, 8GB RAM, 200GB HDD each. The software configuration is as follows:
Database Server – hosts all the databases for the BI application, and the content databases for Reporting Services, ProClarity Analytics Server & SharePoint (installed on the application server)
-SQL Server 2005 – Enterprise Edition – Service Pack 2
oRDBMS
oAnalysis Services
oIntegration Services
oReporting Services
Application Server
-ProClarity Analytics Server – 6.3
-ProClarity Desktop Server – 6.3
-MOSS 2007 – Enterprise Edition
-PPS M&A – Service Pack 2
Note: During the PPS M&A installation, as a pre-requisite, we have had to install reporting services and due to licensing constraints, we have installed SQL Server Reporting Services 2005 Standard Edition.
Has anyone come across this before? Do you know why we could be having this issue?
One of the work-around that we have found so far is to enable the “Show Toolbar” radio button on PPS dashboard Report Settings, and the dashboard now comes back with charts – but also contains the Reporting Services toolbar (the one that allows you to export the report into different formats etc.), which doesn’t give the dashboard its crisp look that we would like to achieve.
Do you spot anything obvious that we are doing incorrectly, and could fix the problem? Any help would be really appreciated.
Thanks in advance!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

Are the charts contained in Reporting Services reports or are they PPS charts? If the latter, have you connected to the UAT using PPS designer and fired up the preview (versus publishing and reviewing)?

Also, all SP's of PPS and SQL (all components) are the same on both environments?

Steve.

denglishbi SSCrazy Eights Points: 8831 More actions · Answer 2

Are you able to preview the SQL Server Report items in Dashboard Designer when you configure them? When you deploy to Preview can you view the report items properly? Do you only see this once deployed to a SharePoint document library and viewing through SharePoint? Has Kerberos been properly configured so that you are able to pass security credentials between servers? Have you taken a look at the Application Event logs on the servers to see if there are any errors?

I don't think it should matter, but have you checked your browser security settings and made sure under the Miscellaneous section that you have Enabled the 'Access data sources across domains'. Are you running Reporting Services natively or in SharePoint integrated mode?

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com

siraj.alimohamed SSC Enthusiast Points: 109 More actions · Answer 3

The charts are all contained in Reporting Services.

Both the environments are on the same Service Packs and versions

siraj.alimohamed SSC Enthusiast Points: 109 More actions · Answer 4

We've just heard back from Microsoft about the issue. It was to do with the way we had installed the software on the two machines...

This is how we had setup the servers:

Database Server

SQL Server 2005 – Enterprise Edition (SP2)

-Databases

-Analysis Services

-Integration Services

-Reporting Services

Application Server

MOSS 2007

ProClarity Analytics Server 6.3

PPS M&A

SQL Server 2005 Reporting Services Standard Edition (as a pre-requisite to PPS M&A)

However, this is what we needed to do: