Home > Uncategorized > Issues Importing SSAS 2008 KPIs into PerformancePoint 2007

Issues Importing SSAS 2008 KPIs into PerformancePoint 2007

Getting PerformancePoint 2007 to work with SQL 2008 (and SQL 2008 R2) has always been a bit of a hack.  Officially it wasn’t supported at all until PPS 2007 SP2 was released.

Background

Basically, all the PPS assemblies reference v9.0.242.0 SQL assemblies (SQL 2005) and 4 key SQL 2005 packages from the SQL 2005 Feature Pack are pre-requisites before PPS 2007 can be configured.  Namely, these are:

– Microsoft ADOMD.NET (SQLServer2005_ADOMD)

– Microsoft SQL Server Native Client (SQLNCLI)

– Microsoft SQL Server 2005 Analysis Services 9.0 OLEDB Provider (SQLServer2005_ASOLEDB9)

– Microsoft SQL Server 2005 Management Objects Collection (SQLServer2005_XML)

Issues Importing KPIs

So everything is finally configured and PerformancePoint Dashboard Designer seems to be working nicely with your data sources all set up etc…

But, when you try to create a new Scorecard based on existing KPIs in your SSAS Cubes, you find it fails with the following:

image

Looking inside the Event Log, you’ll find the following error:

image

The important stuff….

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)

In other words…

The assembly which controls the import from SSAS (Microsoft.PerformancePoint.Scorecards.Server) has a reference to v9.0.242.0 of Microsoft.AnalysisServices which it cannot find.

Solution

Following many failed attempts to re-install the SQL 2005 components in order to get this assembly installed and references, I decided to manually copy this file from an existing SQL 2005 installation into the GAC of this server. 

This I did, however I then received a subsequent Microsoft.Analysis.Connection.Exception:

Microsoft.AnalysisServices.ConnectionException: Cannot connect to Analysis Services version ‘10.0.1600.22’.
   at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
   at Microsoft.PerformancePoint.Scorecards.Server.ImportExportHelper.GetImportableAsKpis(IBpm pmService, DataSource asDataSource)
   at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetImportableAsKpis(DataSource dataSource)

The upshot is that v9 of the assembly is referenced, however I need v10 to be able to connect to my SQL 2008 repository.

So here’s what I finally did:

In .NET we can redirect the assembly bindings in the web.config.  I added the following to the Web.Config file for the PPS Monitoring WebService which 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>

Saved the file and did a IISReset.

On reloading Dashboard Designer, I can now successfully Import my KPIs!!!

image

Additional Info

I must point out that this issue was on a single server development machine and as such, may be a quirk of my setup.  For starters I couldn’t get SQL Server 2005 SP2 Management Objects to install – and this problem may be the result of this. 

I haven’t tried using a separate client machine to import SSAS KPIs using PPS Dashboard Designer.

Regardless of the above, this may help some other PPS / SSAS developers out there who have experienced this problem.

Thanks

Thanks to my colleague Tony Pounder (@WorTony) for help with doing the .NET Assembly redirect statements.  Also, big thanks to Bill Wang’s blog entry on something similar, which led me down this path.

 

 

Advertisements
Categories: Uncategorized Tags: ,
  1. Pr0ffot
    December 3, 2014 at 6:32 am

    Привет всем Посоветуйет ,по каким критериям выбрать Часы один к одному как оригинал , очень важно качество при этом дешевые , да и какую маорку выбрать. Какие нибудь крутые ценой до 200 бакинск.
    Перенесите пожалуйста ,если что не туда

    прописка в новосибирске Часы Longines копии в Новосибирске в на наручные часы +с обратным ходом

  2. March 13, 2013 at 12:04 am

    I need to to thank you for this very good read!! I certainly loved every bit of it.
    I’ve got you saved as a favorite to look at new things you post…

  3. John B
    August 10, 2011 at 4:15 pm

    Of course, 5 minutes after my question I found the correct web.config.
    C:\inetpub\wwwroot\wss\VirtualDirectories\80

  4. John B
    August 10, 2011 at 3:36 pm

    Can you tell me which web. config file you modified? I modified the one at C:\Program Files\Microsoft Office Servers\14.0\WebServices\PpsMonitoringServer but I am still getting this error.

    However, I should point out that the error is being thrown NOT when I import the KPIs, but when I try to edit the properties of a filter in SharePoint designer or from within the web browser, when I try to do the same thing on the web part.

  5. March 18, 2011 at 2:19 pm

    Here are this and some other articles on SSAS KPIs:

    http://ssas-wiki.com/w/Articles#KPI

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: