topic Re: Execute Stored Process on SAS VA report load in SAS Visual Analytics

Execute Stored Process on SAS VA report load

TedP — Tue, 08 Mar 2016 20:51:29 GMT

I'd like to execute a stored process immediately when a SAS VA report is first loaded.

My current workaround is to simply have a stored process embedded in the VA report and making its container as small as possible, but it would be cleaner if the report was able to envoke the stored process upon load.

Thanks,

Ted

Re: Execute Stored Process on SAS VA report load

TedP — Tue, 08 Mar 2016 22:17:40 GMT

I found an even better workaround. I put the stored process at the bottom of the SAS VA report and then used jquery to remove the element and had the original div it was contained in fill its parent height.

Re: Execute Stored Process on SAS VA report load

TriciaAanderud — Sun, 03 Apr 2016 12:07:06 GMT

This sounds interesting ... could you share your code?

Re: Execute Stored Process on SAS VA report load

TedP — Mon, 04 Apr 2016 13:58:16 GMT

<head>	    
	<script src="scripts/jquery.min.js"></script>
</head>
<body>
<script> 
    $(document).ready(function(){
        var $stp_div=$(".stpFrame", window.parent.document)
				            .filter(function(){ return  $(this).children().length=== 0;}).parents().eq(1);
        var $stp_div_parent = $stp_div.next();
        $stp_div.hide();
        $stp_div_parent.css({"height":"100%"});
});
</script>
</body>

I am not a web developer by any means but this should work. I had to inspect the html to find the correct class name for the stored process frame. The tricky part was looking outside the current stored process frame with window.parent.document. After finding the element, just hide it, get the last element above it and fill the rest of the page with it.

This thread helped me put jquery in the right place on the server to have access to it.

Re: Execute Stored Process on SAS VA report load

TriciaAanderud — Mon, 04 Apr 2016 14:00:23 GMT

I'll have to give it a try after SGF. I've been playing with STPs in VA ... testing the limits and seeing how to make things work better than expected. 🙂