SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Linking Excel report to SAS Web report Studio Report

Reply
Contributor
Posts: 33

Linking Excel report to SAS Web report Studio Report

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):

"http://_________.___.___.gov.uk:8080/SASWebReportStudio/launchReportViewer.do?reportAccessMechanism=REPORT_ACCESS_MECHANISM_CURRENT_REPORT"

However, once I have closed WRS and try to use the link I am taken to the WRS log-on screen and, then asked which report I would like to open.

What I need is for the Excel sheet to link straight to a particular WRS report. Is there a way this can be done? If so how do I obtain the link to use in the Excel sheet?

Thanks
SAS Employee
Posts: 44

Re: Linking Excel report to SAS Web report Studio Report

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.
New Contributor
Posts: 4

Re: Linking Excel report to SAS Web report Studio Report

I am looking at a different version of the same problem. I am attempting to base the login to the Portal on the windows authentication. I have not been able to find anything on this.
Ask a Question
Discussion stats
  • 2 replies
  • 224 views
  • 0 likes
  • 3 in conversation