Archive

Posts Tagged ‘PerformancePoint’

Issues Importing SSAS 2008 KPIs into PerformancePoint 2007

August 25, 2010 5 comments

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: ,

PerformancePoint Session at SUGUK London

June 4, 2010 Leave a comment

A little belated due to my holiday, but here’s a quick post on my recent speaking engagement. 

On 25th May I was delighted to be invited to speak at the London SharePoint User Group (SUGUK), despite it being the evening before I was due to fly to Menorca on holiday (the Mrs was not impressed!).

The session was titled, ‘The Evolution of PerformancePoint’ and it aimed to bring the audience up to speed with how the product has progressed from its inception through to the integrated application within SharePoint 2010 we now have.

Despite a delayed start, which meant cutting out a fair chunk of demo, it seemed to be reasonably well received and I hope it was informative for those who attended (which was very low for London).

This now lays the foundations to perhaps return at a later stage and focus solely on SharePoint 2010 dashboards in practise and demonstrate an example case study perhaps.

Thanks to Matt as always for organising the event. 

The slides are now available for download:  The Evolution of PerformancePoint Services

Categories: Uncategorized Tags: ,

Installing and Configuring PerformancePoint Server 2007 in a Distributed Environment (Part 3)

April 26, 2010 3 comments

This post is part of a series focussing on installing and configuring PerformancePoint Monitoring Server across multiple servers e.g. SharePoint Farm.  Other parts can be found here:

https://macraem.wordpress.com/2010/04/23/installing-and-configuring-performancepoint-server-2007-in-a-distributed-environment-part-1/

https://macraem.wordpress.com/2010/04/23/installing-and-configuring-performancepoint-server-2007-in-a-distributed-environment-part-2/

 

In this part, I will step through configuring the ‘Dashboard Viewer for SharePoint Services’ – AKA PerformancePoint Web Part.

This step will be carried out on our SharePoint WFE. In this case, we only have one WFE, but this step will need to be repeated for all WFE’s in the farm.

Pre-Requisites

I cannot stress the importance of making sure you have all your pre-reqs installed, PRIOR to installing PPS Monitoring Server and SP3 on this WFE.  If you haven’t, or not sure, go back a check the list on Part 1.

Configuring the PerformancePoint WebPart / MasterPage

Right, now we’re set, run the Monitoring Server Config Wizard, and you should be presented with the pre-req check screen, which should all light up green except the SSRS components (unless you have SSRS installed on your WFE). Click Next.

image

On the next screen, ensure that ‘Distributed Configuration’ is selected, and ensure that the only component selected is ‘Dashboard Viewer for SharePoint Services’ (remember we configured the Monitoring database and Web Service in Part 2). Click Next.

image

Next, you’ll be asked for the SQL Server and Database Name. This is so the Web Part can locate the published dashboards and dashboard items for display.  Enter these details and click Next.

 image

The final piece of information is a Site Collection URL on which to deploy this component.  Now this is actually a bit misleading.

There are essentially two components deployed here:

1. The PerformancePoint Dashboard WebPart will be added to the GAC and deployed as a solution to the Web Application containing the selected Site Collection above.

2. A dashboard master page will be deployed to the chosen Site Collection. This will be used by default when deploying an entire dashboard to that SharePoint Site Collection. If you’re like me and just add the Web Part to your existing Master Page, you wont be too fussed which Site Collection you select.

So taking all that in, select an appropriate Site Collection and click Next.

image

You should see confirmation that we are ready to proceed, click Next.

image

Finally, double check your settings and click ‘Configure’.

image

Fingers crossed, this component will be installed successfully!

Issues:

Most issues arise from the following causes:

– The pre-requisites haven’t been installed successfully prior to installing PPS 2007 Monitoring Server and SP3 (prior to installing PPS, not prior to configuring).

– The user account running the Configuration Wizard doesn’t have permissions to add assemblies to the GAC or solutions to the SharePoint Central Admin solution store.

– The user account running the Configuration Wizard doesn’t have Site Collection Admin rights on the Site Collection selected in the Config Wizard.

Next, we shall look at setting up Dashboard Designer ready to begin creating some BI Dashboards!

Categories: Uncategorized Tags: