How to install and deploy BSM 2005 into MOSS 2007

April 26th, 2007 — ¥ong¥s
Online project management, task software, and free collaboration workspace: AJAXWorkspace
AJAXWorkspace is a free online workspace that offers task tracking software, team collaboration, online calendar, document sharing, and file management for project management and teamwork.

Business Scorecard Manager 2005 is not supported officially in MOSS 2007. Here are some work around to make it work.

To install BSM 2005:

  1. Make sure all prerequisite software like ADOMD.NET and msxml were installed.
  2. Run updateBSM.vbs update registry for SharePoint site. You need to run it again when creating a new site.
  3. Proceed to run server.msi and builder.msi

To deploy BSM 2005 to MOSS:

  1. In your MS Business Scorecard Builder IDE, proceed to deploy to SharePoint site as usal. The newly deployed page never work. We just want to deploy necessary web parts and it’s scorecard entry to SharePoint server.
  2. To view the Scorecard, add “Office Scorecard View” and “Office Report View” web part to your page. If you encounter error web part cannot desirable, make sure you add in the
    <add key=”Bpm.ConnectionString” value=”Integrated Security=SSPI;Initial Catalog=ScorecardServer; Data Source=(local)”/>
    in web.config under appsetting and change the data source accordingly.
  3. Once web part added, just modify the web part as usual to select your Scorecard and View.
Posted in SharePoint.

5 Responses to “How to install and deploy BSM 2005 into MOSS 2007”

  1. Louis Says:
    August 6th, 2007 at 11:21 pm

    Hello,

    Got that kind of issue: couldn’t upload BSM webparts to MOSS extended site… So no other possibility to deploy my scorecard to MOSS… Because deploying scorecard to MOSS is not working either with BSM Builder :-(
    I get an error with some issue with format… My BSM server is remote and my OLAP server two…

    I think it has something to do with web.config

  2. ¥ong¥s Says:
    August 6th, 2007 at 11:56 pm

    Hi Louis,

    There are some tricks to deploy the scorecard to moss. You need to create one dummy sharepoint site to sovle it. It funny but solve teh problems.

    1. Before install BSM, make sure u at least have 2 web app created. eg . http://portal:1000 and http://portal:2000 (as dummy site where you are never use it)

    2. While installing BSM select web app http://portal:2000

    3. Do an iisreset then proceed to connect to your BSM server in the builder. It should works. If some how it cannt be connected. There must be someone access the dummy site (http://portal:2000). The idea is, you can have either BSM server up or Sharepoint site up.

    4. once conntected, you can proceed to deploy to sharepoint site (http://portal:1000). You will not able deploy to port 2000 since only either one can up. Once deploy, it ill open the deployed page. Just ignore it. We just want the webpart.

    5. Finally, you can manually add the bsm webpart to you preferrer pages. Make sure you manually put in “Bpm.ConnectionString” key in the web config as above in 1000 port web.config. If you are connecting to other db server, make sure you change the datasource and there able to authenticate. Or you can use SQL authentication to conitnue (this for sure will work) This will solve the webpart cannt be desirable error.

    I spend quite some times on this issues. So far it works fine now. There other thing regarding using with OLAP cube, make sure you cube set the roles, else you BSM cannt open the connection.

    Hope these help to solve your problem…

  3. Shai Says:
    September 14th, 2007 at 2:37 pm

    Hi

    Thanks for this. I caannot help but wonder,how in God’s name were you able to figure out the registry entries ? I have been battling with this over a day , hence the sense of wonder :-) . I saw mention of a “compatibility release” online somewhere but am still confused as to whether the current download is compatible with MOSS or have the released a new patch of sorts as the doco just says “install compatibility release” !! Anyways this helped me to install the server so am grateful for that . Still am curious about the registry entry

    Shai

  4. ¥ong¥s Says:
    September 14th, 2007 at 8:29 pm

    Hi Shai,

    The god’s name is “Google” :) If you search carefully, you can find the same script in other place. But I list down the detail steps, tricks and error to make it easy to follow. Hope this can help others since I spent few days to make it up and running…Btw, I have no idea with the “compatibility release” issue as well… I still have to use the script.. Cheers.

    ¥ong¥s

  5. How to install and deploy BSM 2005 into MOSS 2007 « yyTech Blog on .Net, SQL, SharePoint, Collaboration and tech tips. Says:
    August 17th, 2008 at 12:16 pm

    [...] Read the rest of this entry (moved to http://www.bronios.com) » Posted in SharePoint. [...]

Leave a Reply

« 70-542… Pass?

Where is my book??? »