18 07 2012
Connecting to Analysis Services on SQL Server 2012 from PerformancePoint on SharePoint 2013 Preview
You might notice in PerformancePoint Dashboard Designer that when you create an Analysis Services Data Source, typing in a server name throws no error but the Database dropdown box never populates.
Look to the event logs and you might find this error shown shortly after loading Dashboard Designer:
Unable to load custom data source provider type: Microsoft.PerformancePoint.Scorecards.DataSourceProviders.AdomdDataSourceProvider, Microsoft.PerformancePoint.Scorecards.DataSourceProviders.Standard, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.AnalysisServices.AdomdClient, 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.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’
at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)
at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName)
at System.Type.GetType(String typeName, Boolean throwOnError)
at Microsoft.PerformancePoint.Scorecards.Server.PmServer.InitializeCustomDataSourceProviders()
PerformancePoint Services error code 10107.
As you can see, PerformancePoint here isn’t using ADOMD.NET 11, the SQL Server 2012 version.
You need to find the version 10 of ADOMD.NET installer which comes with the SQL Server 2008 R2 Feature Pack from the Microsoft Download Centre. Install this, perform an IIS Reset then open PeformancePoint again to see the Data Source editor working fine once again.
Direct Link for ADOMD.NET10 for x64
Microsoft Download Centre page for SQL Server 2008 R2 Feature Pack
If You Do This, I Hate You SharePoint Server 2013 Preview – Testing BI on SQL Server 2012? You need CTP3!
Thanks so much for your post on this topic. It really saved my bacon. Who’d have thunk it that Microsoft would have used the 2008 R2 version of ADOMD.net to connect to SQL 2012 inside of PerformancePoint Dashboard Designer 2013. Crazy. I think you’re the only one who figured this out and has the solution.
I installed the ADMOMD.net version 10, did an IIS reset on my SharePoint 2013 server and wallah – the database and cubes from my Analysis Services 2012 server now show up.
Thanks again for your post.
No worries, glad to see it’s helped someone else out!
Many Thanks
It was really difficult to find out this issue even you have read the event log we couldn’t imagine that Dashboard designer 2013 is using ADMD.net version 10. I lost 2 hours trying to understand what happened analyzing PPS unattended account, Secure store configuration, SQL profiler to understand with which account PPS is connecting and event viewer to check PPS errors.
Many many Thanks again
This comment has been removed by the author.
Thanks a lot, it took many hours for me confused before I reached your blog.
Thanks for posting this one. Great Help. Saved lot of time as i was having hard time understanding the cause of this behavior.
where do we need to install ADMD.net? on all SharePoint servers? or only to Front-End or Applicaiton Server? or DB server?
Many thanks!
i installed adomd.net.it is populating database but not showing me cube.plase help me fix this problem
thanks
Check the permissions to the cubes – your PerformancePoint Service application account, and your SharePoint Web Application Pool account must be granted access to your cubes.
i followed as u gave.it is populating me database but not showing me cube.please help me out
Check the permissions to the cubes – your PerformancePoint Service application account, and your SharePoint Web Application Pool account must be granted access to your cubes.
[…] http://omicron-llama.co.uk/2012/07/18/connecting-to-analysis-services-on-sql-server-2012-from-perfor… […]
[…] http://omicron-llama.co.uk/2012/07/18/connecting-to-analysis-services-on-sql-server-2012-from-perfor… […]
You save the day for me.
Thanks!
[…] Connecting to Analysis Services on SQL … – 15 thoughts on “ Connecting to Analysis Services on SQL Server 2012 from PerformancePoint on SharePoint 2013 Preview ” […]
[…] Connecting to Analysis Services on SQL Server 2012 from … – 16 thoughts on “ Connecting to Analysis Services on SQL Server 2012 from PerformancePoint on SharePoint 2013 Preview ” […]