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

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

StephenOverton — Thu, 02 Sep 2010 13:46:50 GMT

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??

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

MarkBodt_NZ — Mon, 06 Sep 2010 06:31:07 GMT

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.

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

StephenOverton — Tue, 07 Sep 2010 12:58:13 GMT

Very good idea, I'll try now!

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

StephenOverton — Tue, 07 Sep 2010 13:22:40 GMT

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??