Have Geek Brain

Import Analysis Services 2008 KPIs into a PerformancePoint Scorecard

I am trying to import KPIs from Analysis Services into a PerformancePoint Scorecard and when I do that, Dashboard Designer throws an error:

An unknown error has occurred. If the problem persists, administrator. There may be additional information in the server application event log.

When I look at the event log, I find the following exception:

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
   at Microsoft.PerformancePoint.Scorecards.Server.ImportExportHelper.GetImportableAsKpis(IBpm pmService, DataSource asDataSource)
   at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetImportableAsKpis(DataSource dataSource)

I found this thread which recommends reinstalling Microsoft ADOMD.NET, but the installer will not run to do this because the server already has a newer version of the product (the server is running SQL Server Analysis Services 2008 which includes Microsoft.AnalysisServices.AdomdClient.dll version 9.0.3042.0)

Anyone have any ideas (unless you find the DLL yourself and manually install it in the GAC)?

+1


a source to share


3 answers


I believe you need the SQLServer2005_ASOLEDB9 file from the SQL Server 2005 Feature Pack . If that doesn't work for you, you can simply remove the DLL from your existing 2005 installation and use it.



0


a source


I have installed SQLServer2005_ASOLEDB9. However, it doesn't work. My problem: I couldn't help but import KPIs from the same database. on the same server, I can import kpi from leftover databases.



0


a source


http://macraem.wordpress.com/2010/08/25/issues-importing-ssas-2008-kpis-into-performancepoint-2007/

In .NET, we can redirect assembly bindings to web.config. I added the following to the Web.Config file for the PPS Monitoring WebService that the Dashboard Designer uses to connect to SSAS:

<runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1″> <dependentAssembly> <assemblyIdentity name="Microsoft.AnalysisServices" publicKeyToken="89845dcd8080cc91″ culture="neutral" /> <bindingRedirect oldVersion="9.0.242.0″ newVersion="10.0.0.0″/>
</dependentAssembly> </assemblyBinding> </runtime>

0


a source






More articles:


All Articles