I had a requirement to work on some BI capabilities of SharePoint 2013 with SQL Server 2012 database. I was trying to configure Performance Point Services 2013 to connect to SSAS cubes and generate analytic reports out of it. But immediately I started running into issues first connecting to SSAS and reading cubes, and then importing KPIs defined in the cubes. The symptom was that you could easily connect to relational database but not to SSAS.

I had tested same functionality with SharePoint 2013/SQL Server 2008 R2 SP1 combination and things were smooth at that time and I didn't hit any issues.

So I started digging around and found that these issues were not specific to me, and perhaps, there was some things missing.

Below are the symptoms, exception messages that were logged, and the fix

1) PerformancePoint Services 2013 couldn't read any SSAS cubes when using Analysis Services data source. The dropdown simply didn't populate any cubes though permissions and accounts were all fine. This is the exception message that got logged in the ULS.

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.ADOMDClient.dll, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file

With SQL Server 2012, the version of ADOMDCLIENT that comes is 11.0.0.0 but seems like PerformancePoint 2013 still uses previous version and was looking for it. Since SharePoint 2013 also didn't seem to install it or list it as a pre-requisite. When I tried looking for solution, I came across two possible solutions to this issue:

a) Install the version of client it was looking for. (I went with this, merely because of second issue as well)

     Install Microsoft® SQL Server® 2008 R2 ADOMD.NET (SQLSERVER2008_ASADOMD10.msi)

      http://www.microsoft.com/en-us/download/details.aspx?id=16978

b) You could direct PerformancePoint 2013 Service to use higher version of client assembly. The way you would do that is change the Assembly Binding section of config file below to point to newer version of assembly.

     C:Program FilesMicrosoft Office Servers15.0WebServicesPpsMonitoringServerweb.config

      <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

      <dependentAssembly>

        <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" culture="neutral" />

        <bindingRedirect oldVersion="9.0.0.0" newVersion="10.0.0.0" /> —replace this with below line

        <bindingRedirect oldVersion="10.0.0.0" newVersion="11.0.0.0" />

      </dependentAssembly>

    </assemblyBinding>

 2) Another issue I came across was when I tried to import SSAS KPIs into PerformancePoint Services.  This gave me an exception message "An unexpected error has occurred. Additional details have been logged for your administrator". A quick look at ULS logs came up with this exception 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. 

Yet another older version assembly being referenced. The fix is obivous, just install the version it is looking for.

Install Microsoft® SQL Server® 2008 R2 Analysis Management Objects (SQLSERVER2008_ASAMO10.msi)
http://www.microsoft.com/en-us/download/details.aspx?id=16978

Leave a Reply

Your email address will not be published. Required fields are marked *