06-27-2014 10:41 PM
I have been working around with integrating SAS Stored Process in Visual Analytic. I have written a Stored Proc which expects a Value from the VA Designer to process and return the result back.
Scenario is :
i am filtering the records based on "Name of a person" from the drop down using "Controls" . I have a city column in source table . so the corresponding City for the filtered "Name of a person" needs to be passed as a parameter/macro variable to the Stored Process.
Can we perform this ? or is there a a work around for this ?
06-30-2014 04:50 PM
If you are using 6.4, you can use an external link and link to that stored process and specify the parameters that you are looking for to tie to the stored process. Just an FYI if you use the stored process object in the report builder, it won't give you the results I perceive you are looking for. I hope this helps.
06-30-2014 09:20 PM
All I want is to run a stored process when the user opens the report in the VA Viewer and show the stored process output in the section . Based on the User Selection .can we do this ?
Since i am not able to do above , Is there any work around for this situation ?
3.1 can I pass the parameters from the section 1 bar graph to section 2 stored process
3.2 can I pass the parameters from the section 1 bar graph graph selection to the same section stored process .
Very Strange , i am not able to pass paramaeter to stored process from VA, is it i am missing anything or this feature is not present ?
07-01-2014 10:28 AM
You have to use the external link for what you are trying to do. You can't pass the parameters through the stored process control in Designer. This may change going forward at some point, but currently this is the only way to do what you are looking for in terms of functionality.