Performance Point Services not showing SSAS databases

Sometimes in this blog I write things that I don’t want to forget. So I’ll be able to find them again some day when I need them.

This Monday I was at a customer showing the great things you can achieve with Performance Point Services in SharePoint 2013. I explained them that the greatest analytics of PPS where obtained when connecting to Analysis Services and not to what PPS calls a Tabular data source (which in PPS case is a relational table from SQL Server and not a Tabular instance of Analysis Services).

So we connected to a SSAS instance but there where no cubes to be found there even if there were plenty of cubes in the database. To be sure, I opened Excel and was able to connect to the same instance and discover the available cubes without any problems. And I was connected with the same domain users when using Excel and PPS.

This was clearly a PPS / SharePoint problem. I couldn’t blame the person that installed the software in front of the customer since it was me so I needed to try a solution quickly since we were 10 people sitting in a workshop looking at my PPS demos. I didn’t want to waste anymore of their time.

The fact is that Performance Point 2013, just like Performance Point 2010 is packaged with ADOMD.NET version 10. So if you need Performance Point to use version 11.0 and you will if you’re using SharePoint 2013, you’ll have to tell Performance Point to use the right version.

This is something new in Performance Point 2013 which allows you to redirect to the new provider version without having to upgrade Performance Point. This is helpful it your organization uses different versions of Analysis Services and SharePoint.

The redirect assembly instruction is found in the web.config of Performance Point Services and has to be corrected on each server running Performance Point Services in your setup.

The path to the web.config file is : C:\Program Files\Microsoft Office Servers\15.0\WebServices\PpsMonitoringServer

At the bottom of the web.config there is a <assemblyBinding> block

<runtime>
<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″ />
</dependentAssembly>
</assemblyBinding>
</runtime>

Change the values in the <bindingRedirect> element from oldVersion=”9.0.0.0″ to oldVersion=10.0.0.0″ and from newVersion=”10.0.0.0″ to newVersion=”11.0.0.0″.

So you go from :

<bindingRedirect oldVersion=”9.0.0.0″ newVersion=”10.0.0.0″ />

To:

<bindingRedirect oldVersion=”10.0.0.0″ newVersion=”11.0.0.0″ />

This will allow PerformancePoint to use the GAC version 11 of ADOMD.NET assembly when calling Analysis Services 2012 (and earlier versions).

It will also allow you to use the latest PowerPivot models as data sources in PerformancePoint.

Happy SharePointing !

About these ads

3 comments

  1. Tanks!!! good post

  2. pshrestha · · Reply

    Could i use tabular data cube as data source in PPS? if yes, are there any limitations in features offered by PPS while using a tabular data cube compared to that of using a multidimensional data cube? it’s urgent to know this, i could not find any help online so far. thank you.

    1. Hi, yes you can. Tabular data is turned into “microcubes” within Dashboard Designer. Each tabular data source can define dimension and fact data types in the data source definition editor.
      Main limitation is that data is flat so no parent child relationships…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 579 other followers

%d bloggers like this: