Archive

Archive for December, 2006

Microsoft Business Scorecard Manager (BSM) 2005 and MOSS 2007

December 28th, 2006 No comments

Microsoft Business Scorecard Manager (BSM) 2005 encompasses two components (very similar to what Reporting Services offers )



Server : Allows you to manage scorecards. It is comprised of an ASP.NET web service, a metadata database, and a series of Web parts that can be used in sharePoint sites. ASP.NET Web service provides interactions with other applications such as Biztalk , SharePoint and etc.


Microsoft Business Scorecard Builder : A windows Form application which provides a way to quickly prototype, create scorecards and publish them via the server component  to SQL Server Reporting Services or Microsoft SharePoint Products and Technologies , so Builder is nothing except an authoring tool.


As for the integration of BSM with SharePoint products here is a summary of both versions :


1)SPS2003 (SharePoint Portal 2003): All functionalities of BSM is available , because it gives you the authoring tool to create scorecards and/or KPIS and it also gives you the server component to publish them to SharePoint. In addition to all these , it also provides some web parts that user can get an instant graphical representation of the KPI behavior.


2)MOSS 2007: Microsoft Office SharePoint Server 2007 will be a supported platform for BSM 2005 for sure, but the existing product can NOT be installed on MOSS 2007 so we cannot give a proper answer until service pack 1 (ten weeks after MOSS 2007 is publicly available) is released. The Service Pack will include a roll-up of released Quick Fix Engineering (QFE) updates and a number of fixes that are specific to MOSS 2007 integration. To acquire BSM 2005 Service Pack 1 customers will require a BSM 2005 license. It is not necessary for current BSM 2005 customers running on Microsoft Office SharePoint Server 2003 to apply Service Pack 1.  Service Pack 1 is required only when customer deploy BSM 2005 on MOSS 2007.  It will be released through the Microsoft Developer Network (MSDN).



I tried installing BSM2005 onto the RTM and BSM Server will NOT install.   Seems some API’s and database structure changes in SharePoint make BSM Server install fail. Here is it what it gives me:


 Web Parts


Passed                        Microsoft .NET Framework 1.1


Passed                        Microsoft ASP.NET 1.1


Passed                        Microsoft Internet Information Services (IIS) 6.0


Passed                        Windows SharePoint Services 2.0 or Microsoft SharePoint Portal Server 2003


Failed                          Microsoft SharePoint Extended Site


 


Web Service


Passed                        Microsoft .NET Framework 1.1


Failed                         Microsoft XML Core Services (MSXML) 4.0


Passed                       Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)


Failed                         Microsoft ADOMD.NET 8.0 


Passed                        Microsoft ASP.NET 1.1


Passed                        Microsoft Internet Information Services (IIS) 6.0



As you can see it is only looking for an older version of WSS and SPS for the web parts. For the web service it is complaining about   ADOMD.NET 8.0  which I think is required to hook up the scoreboards to cubes for multi-dimensional processing.



Here is a fact sheet that gives you so ideas about this product:
http://www.microsoft.com/presspass/newsroom/office/BusinessScorecardManager_2FS.mspx


This one talks about increased BI investment (including scorecard) in office 12 platform by Microsoft:
http://www.microsoft.com/presspass/press/2005/oct05/10-23BiLaunchPR.mspx


Microsoft Office Business Scorecard Manager 2005 Documentation can be downloaded here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=D2F8C636-602D-4744-BA7D-D3821F8920D5&displaylang=en#filelist


And the trial version is here ( in two different components mentioned above)
http://www.microsoft.com/downloads/details.aspx?familyid=96F12385-AD47-494B-9DA4-60BBCD0D1B57&displaylang=en



Software and hardware requirements and a step by step how to articles are all explained here:
http://office.microsoft.com/en-us/help/HA101056881033.aspx


Categories: Uncategorized Tags: