topic Stored Procedure in WRS in SAS Web Report Studio

Stored Procedure in WRS

jcbell — Tue, 15 Mar 2011 21:17:25 GMT

I have a stored procedure that is performing some basic ETL for a IM and a WRS report.

I'm curious if I need to write a STP for each report or is there a way to get the name of the WRS report that I'm running from within the stored procedure? Does WRS surface any information about the report to the Workspace Server?

If I have the name - we can look up the parameters of the report in a control table to generalize the STP.

Thanks,

John

Re: Stored Procedure in WRS

Jay_OAG — Tue, 22 Mar 2011 17:44:59 GMT

John,
In the STPServer log (I found mine located in /sas92config/Lev1/Logs), the macro vars are displayed with values (similar to the debug output from IntrNet)... _program was listed in my log. There is also a macro variable ( _APSLIST ) which appears to contain a list of the macro vars.

Hope this helps...

Jay

Re: Stored Procedure in WRS

jcbell — Tue, 22 Mar 2011 17:59:49 GMT

Thanks everyone. I've confirmed that there is no way to get the name of the WRS report that is running.

Time for plan B.

Thanks,

John

Re: Stored Procedure in WRS

metalray — Wed, 30 Mar 2011 12:29:23 GMT

Hi John,
whats your plan b? I noticed that the web report name becomes part of the URL. is that a way?

We are also looking at a STP that generates links dynamically using the browser language and the report that is actually using the STP. We dont want to generate hundreds of STPs so it would be good if some value from the WRS that uses it can be used as a parameter.

Re: Stored Procedure in WRS

Nithin — Tue, 05 Apr 2011 14:12:19 GMT

I would suggest configuring STP in SAS Information Map Studio if you are planning to generalize the functionality.

-Nithin

Re: Stored Procedure in WRS

metalray — Tue, 26 Apr 2011 14:13:57 GMT

we used some java script in a STP that is then inserted into a web report.
thanksfully, the last part of the URL in web report studio or information delivery portal always contains the report name:
var userLang = (navigator.language) ? navigator.language : navigator.userLanguage;
var fullurl = document.location.href;
var reportname = fullurl.substring(fullurl.length -10);