Friday, March 30, 2012

KPI and report deployment on WSS 3.0

Not sure if I really have the correct forum for this posting so appologies if it is not. My question refers to the basic functionality of the new Sharepoint 3.0 both WSS and MOSS.

In version 2.0 of Sharepoint Services reports were displayed in Sharepoint using Report Explored to navigate and Report Viewer to display the report. Also KPI's were displayed in a web part which came from Business Scorecard Manager 2005.

I have been investingation both WSS3.0 and MOSS and have installed WSS3.0 to test. I notice that I can connect to reporting services with CTP2.0 for sql server. I can upload reports into document lists and run them from there. My question is has the old idea of using the report explorer gone as when you have report manager running in sharepoint integration it has no website to upload files or manage permissions. Is the document upload method the new way or am I missing something.

More importantly though is the display of KPI's is this now only available in MOSS 2007 and no longer a function of WSS3.0 as you cannot install Business Scorecard manager on WSS3.0 but it appears this is built in to MOSS.

Any guidelines to this new functionality would be greatly appreciated

W.r.t. to SharePoint integration, you may find the following blog useful. In SP2 SharePoint integration mode, the Report Manager and Management Studio are not supported. Instead, you can deploy reports to WSS libraries from SharePoint, Report Designer in VS.NET, or programatically.

MOSS has a basic built-in support for creating and importing KPIs but it has less features than BSM, e.g. doesn't support scorecards. You can still use BSM (the 2007 version is currently under way) and integrate its scorecards with WSS 3.0.

|||Thanks for the Low Down that is a great help with planning deployment

No comments:

Post a Comment