About Me

Having 12 years experience in Microsoft technologies.Since more than 7 years working in SharePoint technologies. Expert in providing consultation for SharePoint projects. Hands on with development and administration.

Thursday 5 February 2015

Performance Point Services 2013 - Score card error when creating KPIs in SharePoint 2013

When importing KPIs as part of creating score cards in PPS designer 2013, we may get following error
An unexpected error occurred.  Error 47205
Following is the event log entryException 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)
Strangely GAC has this assembly….
But the answer is we should install analysis Management objects (AMO ) package. NOT the ADOMD.net
The AnalysisServices.DLL will not be installed as part of AMDO.Net installation. Hence, we should install AMO package. Please mind that when you download the AMO package based on you SQL server version like 2008 R2, 2012, 2014.
For SQL Server 2008 R2
Click ‘Install Instructions’ and search for ‘AMO’
For SQL Server 2012
Click ‘Install Instructions’ and search for ‘AMO’
For SQL Server 2014
Click ‘Install Instructions’ and search for ‘AMO’
After installing the AMP package, you can see AnalysisServices.DLL in GAC..
Note: Install the respective package in all SharePoint web front end servers and reset IIS


Cheers!
Mohan


 

No comments:

Post a Comment