Wednesday, March 5, 2014

SharePoint 2013 PerformancePoint Services Not reading SSAS Cubes

Microsoft has for some reason decided that PerformancePoint should use the SQL Server 2008 OLAP drivers to connect to the cube so if you have an environment that is running SharePoint 2013 and SQL Server 2012, what will happen is PerformancePoint will not be able to access the cubes. the following is copied from another blog with the solution

ERROR : The data source provider for data sources of type 'ADOMD.NET' is not registered. Please contact an administrator. PerformancePoint Services error code 10115

I was trying to Connect with Performance Point DashBoard Designer. i check my performancePoint service its configure correctly,  

After providing Server name , When i click at database: its shows nothing . ?

I Log i got i was Getting Following error : "The data source provider for data sources of type 'ADOMD.NET' is not registered. Please contact an administrator. PerformancePoint Services error code 10115"




Solution : 

On SQL Server you need to  install SQL Server 2008 R2 ADOMD.NET 

And After that you need to Restart IIS .

It Will Work.