Error in Importing KPI’s to Performance Point 2010 Dashboard designer from SQL Server 2012 Analysis Services MultiDimensional cube

Standard

This blog post is meant to document how I solved an error while trying to import KPI’s to Performance Point 2010 Dashboard Designer from SSAS 2012 Multidimensional cube. The error said “An unexpected error occurred.. details have been logged for your administrator”. Here are the details:

1) few days back, I had solved the error listed here: “An unexpected system error occured…” – While trying to establish a Data Connection in Performance Point 2010 Dashboard Designer –  And after I had solved this error, I got another error and this time it was about importing KPI’s in the Dashboard Designer. Here’s how I was able to solve it:

2) So to view the error I used the SPTraceVIew Tool

3) And via SPTraceVIew, I was able to see the message:

An unexpected error occurred.  Error 47205.
Exception details:
System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.
File name: ‘Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’
at Microsoft.PerformancePoint.Scorecards.Server.ImportExportHelper.GetImportableAsKpis(DataSource asDataSource)
at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetImportableAsKpis(DataSource dataSource)

4) I checked that the Microsoft.AnalyisServices dll was present at c:/windows/assembly

5) What I didn’t realize was that the version number was different. The version that I had on my machine was 11 while the message clearly mentioned that it required 10. Thanks to this tip here: Creating scorecard error

6) So I followed the instructions that was on the MSDN forum thread and installed the AMO with version 10 via “Microsoft SQL Serer 2008 feature pack, April 2009”

7) And after installing the version 10 of the AMO, I was able to import KPI’s from SSAS 2012 multidimensional cube!

“An unexpected system error occured…” – While trying to establish a Data Connection in Performance Point 2010 Dashboard Designer

Standard

So I got an error while trying to set up a Data Connection via Performance Point 2010 Dashboard Designer: “An unexpected system error has occurred . additional details have been logged for your administrator” – and so I did quick searches and read this & this & this & this & this and with the help of the links I solved the error. Now, there are lots of moving parts but for machine I was able to solve the error by:

1. SharePoint 2010 Central Administration

2. Manage Services on Server

3. Stopping “PerformancePoint Service”

4. And then Starting it Again.

5. If you are still facing issues then consider re-booting the server. In my case, it was a demo machine and so I quickly rebooted it.

Simple? Yeah but I spent 30 odd mins trying to figure out how to solve this error and so I thought I would document this.

 

Works? Yes? Great! No? Try:

-> Configure secure service store and unattended service account.

-> you can check out the links that I added earlier.

 

Before I got the error – I had

1. Successfully Added “PerformancePoint Service Application” via “Manage Service Applications”

2. I had made sure that the PerformancePoint Service and the Secure Store Service were Started.

3. Created a Business Intelligence Center Site and checked the Site Collection Features were properly configured.

But I got an error while trying to create a Data Connection. And I solved it! And Now can spend time creating few reports! That’s about it for this post.

performance point 2010 sharepoint business intelligence microsoft