Using KPIUtil, cannot export KPI from SQL Server 2005 Analysis Services to BSM and vice-versa

I am trying to export KPIs created in Analyysis Services to BSM using KPIUtil.

I have KPIUtil installed on my machine which has the following:

Windows 2003 with SP1

Microsoft .NET Framework 2.0

Common Language Runtime 2.0

Analysis Management Objects

Microsoft Office Business Scorecard Builder 2005

The BSM Server is on a separate machine. The scorecards created using BSM(without KPIUtil) work fine.

In the KPIUtil-New Configuration window, I am trying to export KPIs created in Analysis Services 2005 (which is on my machine) to Business ScoreCard Manager(on another machine). After filling in the required details, the Test Connection links on this window work fine, but  when I click button Generate, the utility gives a message  "Some of the KPIs were not exported. Check the log file for more information."

The following error shows up in the log file -

*** Internal ERROR *** Server was unable to process request. --> The Business Scorecard Manager server could not connect to the data source. Verify that all of the required data has been entered and that the connection information is correct. --> The connection either timed out or was lost. --> Unable to read data from the transport connection. --> An existing connection was forcibly closed by the remote host
<1/12/2006 7:41:09 PM>*** KPI Generation Ends ***

I tried doing otherwise(exporting KPIS from existing scorecard to Analysis Service), even this does not work. The same error shows up in this case as well.

Can anybody please help me solve this issue

TIA,

Sandeep

 


 



Answer this question

Using KPIUtil, cannot export KPI from SQL Server 2005 Analysis Services to BSM and vice-versa

  • cmccutcheon

    Hi Sandeep,

    Here are a few suggestions from the product team:

    1. Can you try to give Everyone Full permission to the AS 2005 cube and try again to see if you get the same error message

    2. Also ensure that after you can connect you do the following:

      Publish the sample indicators that are included with KPIUtil.exe to the Business Scorecard Manager server before you generate Business Scorecard Manager KPIs from SQL Server 2005 Analysis Services KPIs.

    -brenda (ISV Buddy Team)



  • kylemad

    Hi Brenda,

    I tried this option, still the problem did not seem to mitigate.

    However, when my account was added to the Administrator group of the other machine ( the one with BSM Server), I was able to export the KPIs from SQL Server to BSM and vice-versa.

    Thanks for your help anyway.

    Regards,

    Sandeep


  • Using KPIUtil, cannot export KPI from SQL Server 2005 Analysis Services to BSM and vice-versa