Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Prevent Stored Process in SAS Visual Analytics from running automatically

Reply
Occasional Contributor
Posts: 6

Prevent Stored Process in SAS Visual Analytics from running automatically

Hello All, I have a Stored Process that I am using in SAS Visual Analytics. Everything is working fine. I have a prompt with a dynamic list. When I select the Section in the Report that has the Stored Process, it automatically runs the Stored Process with the value that was chosen fron the last save of the Stored Process. I understand this is how it is supposed to work but are there any work arounds that will make it not automatically load or is there a way to display a blank HTML page then the user can select the prompt?

 

Here is the code I am using.

Libname Serv '/shares/groups/Lean Six Sigma Analytics Reporting/Service Event Reports';
/* Example 5: Create a CSV file for downloading using */
/* %STPBEGIN and %STPEND */
*ProcessBody;
data _null_; 
rc = stpsrv_header('Content-type','application/vnd.ms-excel'); 
rc = stpsrv_header('Content-disposition','attachment; filename=temp.csv'); 
run;
%let _odsdest=csv;
%stpbegin;
Proc Print Data=Serv.Ztable label noobs; 
Where MII_DESCRIPTION="&MII_Description."; 
Var _ALL_; 
run;
%stpend;

Ver:9.04.01M3P062415

Server version

Lin x64

 

Super User
Posts: 1,102

Re: Prevent Stored Process in SAS Visual Analytics from running automatically

Hello @JoeRotford,

 

I don;t develope code or reports since years, so probably others gan give you better solutions, but I would propose you for now, to create one stored process that will generate the empty results you are looking for, and then a button or link to call this stroed process.

Occasional Contributor
Posts: 6

Re: Prevent Stored Process in SAS Visual Analytics from running automatically


JuanS_OCS wrote:

Hello @JoeRotford,

 

I don;t develope code or reports since years, so probably others gan give you better solutions, but I would propose you for now, to create one stored process that will generate the empty results you are looking for, and then a button or link to call this stroed process.


 

That is what I was kind of thinking. I found this sample but I am not sure if I need a new button or how to just display text.

 

http://support.sas.com/kb/37/050.html

Super User
Posts: 1,102

Re: Prevent Stored Process in SAS Visual Analytics from running automatically

You found a great example! I would say: just play with it for a bit, I think it will give you all the tools you need.

Trusted Advisor
Posts: 1,216

Re: Prevent Stored Process in SAS Visual Analytics from running automatically

I haven't called stord processes from VA, but I'm surprised at the problem you describe.

 

Are you saying that the first time a user calls the stored process, they will see the prompt, make their selection, and hit run.  And everything works like you want.  But then after that when the user opens the report they never see the prompt again?

 

Or is it that VA by default runs the stored process when the report is opened (with the previously saved values), and still shows the prompt somewhere on the side, so a user could change the values?

 

It's got to be VA that is remembering the prompt values and passing them when the report is opened.  Can you see the URL that VA is using to call the stored process?  I agree with your question, would be nice to have a way to turn off this feature.  Yes, you could change your stored process design so that instead of returning a result it returned an HTML form where the user would enter their prompt values.  But ugh, that seems like a good bit of work that should not be necessary.

 

 

Occasional Contributor
Posts: 6

Re: Prevent Stored Process in SAS Visual Analytics from running automatically


Quentin wrote:

I haven't called stord processes from VA, but I'm surprised at the problem you describe.

 

Are you saying that the first time a user calls the stored process, they will see the prompt, make their selection, and hit run.  And everything works like you want.  But then after that when the user opens the report they never see the prompt again?

 

Or is it that VA by default runs the stored process when the report is opened (with the previously saved values), and still shows the prompt somewhere on the side, so a user could change the values?

 

It's got to be VA that is remembering the prompt values and passing them when the report is opened.  Can you see the URL that VA is using to call the stored process?  I agree with your question, would be nice to have a way to turn off this feature.  Yes, you could change your stored process design so that instead of returning a result it returned an HTML form where the user would enter their prompt values.  But ugh, that seems like a good bit of work that should not be necessary.

 

 


 

By default when you load the Report and navigate to the Section that has the Stored process, it automatically starts running. You can still access the prompts. I need a way for it to not run until the user selects the prompt. It uses the value of the last version of the Stored Process that was saved.

Ask a Question
Discussion stats
  • 5 replies
  • 212 views
  • 6 likes
  • 3 in conversation