Stored Process and Information Maps

[hkotian]

Can Stored Process bound to a Stored Process Server be used with SAS Information Maps or SAS Web Report Studio

[Cynthia_sas]

Hi:
Hi...there's not one yes/no answer to your question. The answer is No...and...Yes.

Here's why: A stored process can be executed on either the workspace server (WS) or the stored process (SP) server. However, some limitations come into play when you add Information Maps into the mix -- because Information Maps act as DATA sources, not as REPORT output.

WRS can -execute- a stored process that is defined to execute on the Stored Process (SP) Server or the Workspace (WS) server. To use the SP in this context of WRS, you would NOT choose a data source, for this section of the report or for this report. You would just insert the SP into the report area. We show this in our SP class -- the SP that you use could be executed on either server. Although, honestly, most people use the SP server for this scenario.

A stored process (SP) can also be used to provide data for an Information Map. Since Information Maps are "served up" by the Workspace server, then an SP that's bound to an Information Map or providing data to an Information Map, can ONLY execute on a Workspace server, as it says here: http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/program.html (look under the description of the Workspace server)
Information map stored processes are supported only on the workspace server.

So your question was:
"Can Stored Process bound to a Stored Process Server be used with SAS Information Maps or SAS Web Report Studio "
NO, your SP cannot be bound to an SP server if you're going to use is to populate an Information Map with the SP data results. Under this scenario, your SP must execute on the WS server. (The SP is providing DATA results to the Information Map & the Info Map is a DATA source in WRS.)
and
YES, your SP CAN execute on the SP server, if your SP results are just being inserted into a WRS report as REPORT output. (The SP is providing REPORT results to the WRS report.)

cynthia

[hkotian]

Thank you for the detailed response. It really helped

[hkotian]

Thank you for the detailed response. It really helped