Stored Procedure in WRS

[jcbell]

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

[Jay_OAG]

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

[jcbell]

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

[metalray]

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.

[Nithin]

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

-Nithin

[metalray]

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