Because most people that I’ve talked to are not implementing Kerberos yet (although I highly recommend you reconsider it as it makes security implementation easier!), I’ve written these instructions under the assumption that NTLM authentication is being used and hard-coded credentials in Excel and/or SSRS are being used to authenticate the user for the reports’ data sources.
This particular example I’ve developed assumes one Analysis Services source – for Excel reporting – and one SQL Server source – for SSRS, but you shouldn’t assume this means that you can’t use SQL Server as a source for Excel reports or SSAS as a source for SSRS. You just need to create the Business Data Catalog (BDC) as appropriate for your source and associate it with Web part pages as an action. The key difference between the two sources for the BDC is how you pass parameter values to the Web part page.
Here are thumbnails linked to the full images…
First, the results of a search with the two links that I show later highlighted here in red:
Link to full-size image
Here is the link to an Excel Web part page:
Link to full-size image
And finally the link to an SSRS Web part page:
Link to full-size image