topic Re: SAS Visual Analytics - Running a Stored Process with prompts from a dashboard in SAS Visual Analytics

SAS Visual Analytics - Running a Stored Process with prompts from a dashboard

Chokin — Mon, 21 Mar 2016 02:00:46 GMT

Hi there

We have added a new section to our dashboard and inserted a stored process object which has many prompts, some being mandatory.

In the viewer when the stored process is selected the stored process and is immediately executed. The prompt do not dialog is not appear and do not have any opportunity to enter prompt values.

We have no difficulty running and selecting prompt values in VA when this is not attached to a dashboard.

I have enclosed the message that is appearing.

This is frustrating - any clues or assistance would be greatly appreciated.

Thanks

Re: SAS Visual Analytics - Running a Stored Process with prompts from a dashboard

MichelleHomes — Mon, 21 Mar 2016 02:12:34 GMT

What version of SAS Visual Analytics are you using? I'm assuming 7.3 and using the modern version. You may need to change it to the classic version to use stored processes with prompts as described at http://support.sas.com/kb/57/009.html

Kind Regards,

Michelle

Re: SAS Visual Analytics - Running a Stored Process with prompts from a dashboard

Chokin — Mon, 21 Mar 2016 04:34:11 GMT

Hi Michelle

We have 7.1.

We have looked into the 7.3 user guide which mentions the classic viewer and modern viewer however in 7.1 there is no mention of this.

Do you know if this can be done in 7.1?

Many Thanks for your comments.

Regards

Re: SAS Visual Analytics - Running a Stored Process with prompts from a dashboard

MichelleHomes — Mon, 21 Mar 2016 05:36:33 GMT

Hi,

The modern viewer is new in 7.3 so not available in 7.1 https://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#vaugwhatsnew73.htm

If you are using Internet Explorer, this may explain the error your experiencing http://support.sas.com/kb/57/829.html

Kind Regards,

Michelle

Re: SAS Visual Analytics - Running a Stored Process with prompts from a dashboard

Chokin — Tue, 22 Mar 2016 20:51:06 GMT

Many thanks Michelle

Yes we tried this using a Chrome browser and the prompts appeared as was suggested.

Thanks again - your comments were very much appreciated.

Unfortuntaely, we have another issue which we will raise another thread whereby when making multiple selections in a prompt which has a dynamic list, the stored process does not run however works fine in Enterprise Guide, Excel using SAS Addin and Stored process web application (which we have created an external link from dashboard). If we reduce the selections for the prompt in VA it runs ok. Strange??

Re: SAS Visual Analytics - Running a Stored Process with prompts from a dashboard

MichelleHomes — Tue, 22 Mar 2016 21:02:37 GMT

Pleased to hear the suggestion worked.

With regards to your other issue it does sound strange. It might be useful to look at the log files for SAS Visual Analytics and the Stored Process server to see if there are any messages.

Re: SAS Visual Analytics - Running a Stored Process with prompts from a dashboard

Sac2001 — Sat, 22 Jul 2017 21:49:42 GMT

Can you share your SP SAS code. I presume you are not using _webout in your SP? SP can be deployed with prompts in SAS VA

Re: SAS Visual Analytics - Running a Stored Process with prompts from a dashboard

PK_DataScience — Sat, 15 Jun 2019 11:40:03 GMT

Hi,

I would like to know how stored process prompts can be executed and selected in VA. Currently my stored processes having prompts are executed from SAS Information Delivery Portal, which I need to migrate to Visual Analytics. The stored process reports are simple tabular reports which then need to be downloaded in Excel.

Thanks much.