Your SAS programs, embedded in web apps and elsewhere

Linking to WRS Report from a Stored Process in the Delivery Portal

Reply
Contributor
Posts: 50

Linking to WRS Report from a Stored Process in the Delivery Portal

I've got a nice visual graph in a URL Display Portlet in the Information Delivery portal. I used a stored process so I can get a lot more control over specific elements and so I can do more customized graphs. To keep the drill through functionality I use the 'html' parameter of the PROC GPLOT to link to a WRS report. The link works initially but if I click the link to return back to the Portal then click the STP again, it sends me just to the opening screen for WRS. I'm trying to figure out how to structure the html link or the ODS statement in the STP so that it doesn't loose track of where I'm going and it goes to the underlying WRS report consistently.

Whats nice about using these links below is that it includes the link in the upper left to return back to the portal. My goal here is to mimic what the standard out of the box links do in the Information Delivery Portal.

These are the different types of links I've tried to use to link to the WRS report:
#1
../SASBIDashboard/Director?_directive=DashboardWRSServlet&rptname=Report%252Bomi%253A%252F%252FFoundation%252Freposname%253DFoundation%252FTransformation%253Bid%253DA5WCU92V.B00000B1&&_target=_top&Referer=http%3A%2F%2F[COMPANY DOMAIN]%2FSASPortal%2Fmain.do

#2
../SASPortal/search/viewItemFromSearch.wiz?com.sas.portal.ItemId=Report%2Bomi%3A%2F%2FFoundation%2Freposname%3DFoundation%2FTransformation%3Bid%3DA5WCU92V.B00000BA

#3
../SASWebReportStudio/openRVUrl.do?rsRID=SBIP%3A%2F%2FMETASERVER%2FShared+Data%2FMisso%2FServicer+Portal%2FReports%2FServicer+Scorecard%2FTop+10+Delq+Counts+By+Servicer+Entity+YTD.srx%28Report%29

#4
../SASPortal/syndication.do?com.sas.portal.ItemId=Report%2Bomi%3A%2F%2FFoundation%2Freposname%3DFoundation%2FTransformation%3Bid%3DA5WCU92V.B00000AC

This is the "parameters" parameter I used in the ODS statement:
ods html body=_webout path=&_tmpcat(url=&_replay) style=Plateau parameters=("drilltarget"="_top");

I'm wondering if I can add more parameters? Has anybody tried to mimic WRS report linking from a stored process??
Occasional Contributor
Posts: 12

Re: Linking to WRS Report from a Stored Process in the Delivery Portal

Something that I've done is (and this is in Portal 4.2) is display the stored process in a dashboard. In this case the stored process displays a couple of complex charts. The user can drill through to a web report.

Here's how I did it.
Add a dashboard portlet to a portal page, create a new dashboard, create a new indicator, and select Display: Graph. Enter the URL to the stored process using the dashboard directive e.g. http://{Mid-tier-serverdomain]:8080/SASPortal/Director?_directive=STPRunParameters&_program=%2FDemo%2FStored+Processes%2FMy+Stored+Process

In the link tab for the indicator, select Web Report as the type and select the applicable report.

Hope this helps.
Contributor
Posts: 50

Re: Linking to WRS Report from a Stored Process in the Delivery Portal

Very good idea, I'll try now!
Contributor
Posts: 50

Re: Linking to WRS Report from a Stored Process in the Delivery Portal

I can display the STP graph just fine BUT the link to the web report does not work. I removed the html link from the stored process and enabled it through the dashboard link. Any ideas??
Ask a Question
Discussion stats
  • 3 replies
  • 600 views
  • 0 likes
  • 2 in conversation