I have an excel created dashboard which I want to link to a Web Report Studio created, cube based report. I have been trying to use the 'hyperlink' function in Exel by opening the report in WRS and then copying and pasting the address in the browser, in this case as below (some details removed):
The issue is that in the browser you have an authenticated session. When you ask Excel to open that same URL, it has no session, so authentication must occur first. (The same would be true if you pasted that URL into a new browser window.)
Another problem seems to be that WRS doesn't redirect you back to the requested report once the auhentication is complete. I believe this is a known issue in WRS 4.1.