When configuring PerformancePoint Services in SharePoint 2013, I struggled for a while with two problems when trying to create a Data Source for in the PerformancePoint Dashboard Designer:

• No matter what server name I entered I didn’t get an error.
• The database dropdown was always empty, irrespective of whatever server name was entered.

After many hours effort, recreating the PerformancePoint Service Application several times, I finally stumbled across this blog entry .  This seemed to tally exactly with what I was encountering, though I didn’t spot the exception in the ULS logs, but at this point I was happy to try anything.  The solution appeared to be to install the ADOMD.NET 10.0 on the SharePoint Server which is running PerformancePoint Services.  I did this but had to do the additional step of running an IISRESET in order to get the change to kick in properly and sure enough after this I managed to connect successfully to the Analysis Services cubes.

Hope this helps and thanks to James Love for this invaluable nugget …

Cheers

Dave Mc