topic Re: WRS InfoMap Prompt Values as STP Global Variable in Web Session in SAS Web Report Studio

WRS InfoMap Prompt Values as STP Global Variable in Web Session

metalray — Tue, 17 May 2011 14:43:23 GMT

Hello,

we have a stored process that is part of an information map.
the stp just fetches and cleans some OLAP data while the info map
provides the prompts and clean data presentation. now we
have the info map in the web report as a source and we place
an additional stp on the web report which should get the values from
the prompts as global macro variables to be used on other reports as well (other stps).

our issue is:
how to access the values from the prompts?

we cant use the following:
http://support.sas.com/kb/40/758.html
-because prompt values are defined in the info map, if defined in STP the
prompts are displayed before the data is ready and they dont work

regards,
bob

Re: WRS InfoMap Prompt Values as STP Global Variable in Web Session

metalray — Wed, 18 May 2011 08:01:20 GMT

Just to clarify. I am looking for the SAS Base code that I can use in my STP to access the variables.

when we do a proc print statement in an stp that should simply print the marco variable that has been created through the user prompt selection and insert that STP in the web report we did not see a result.

Re: WRS InfoMap Prompt Values as STP Global Variable in Web Session

metalray — Fri, 20 May 2011 15:34:03 GMT

Hello,

we have three prompts that are defined within an STP that is then inserted on
a web report. The hope is that those three prompts (their source is an InfoMap)
will create three macro variables that share the same name as the prompts themselves.

We read a tutorial that mentioned that Prompt and their values will be available as global macro
variables automatically but this is not what we observed hence,
on the same web report is a second STP that makes those macro variables global macro variables:

--STP 2--
%global year quarter month indicator scenario wertetyp;

A third STP on the very same report is then trying to use those macro variables (global or not)
but we have no success. The STP (3) does not display anything.

proc sql;
create view work.DrillThrough as
select a.team, b.*
from new a join v_fakt b on a.wer_id=b.werr_id
where jahr="&year" and quartal="&quarter" and monat="&month";
quit;

As a temporary solution we write the values to a data set and read it out of there
but the solution does not scale up well for hundreds of users.

Any ideas?

Re: WRS InfoMap Prompt Values as STP Global Variable in Web Session

AngelaHall — Mon, 23 May 2011 18:43:01 GMT

Here is a SAS Sample on how to utilize prompts within all sections of your Web Report Studio Report:

http://support.sas.com/kb/40/758.html

~ Angela

Re: WRS InfoMap Prompt Values as STP Global Variable in Web Session

metalray — Thu, 26 May 2011 08:49:08 GMT

Hi Angela,

I just learned that Global macro variables are so named because they have global scope
within a single SAS process (as compared with local macro variables
scoped within individual macros in the same process). Unfortunately
they are not global across SAS processes which is why we multiple stored process
are not able to "communicate" to each other.

What we are doing now, is passing values between the stored process
by using shared data sets and that seems to be the only solution.

Regards,
Bob