Passing parameters from an URL to a WAD Web Template 7.0

[Former Member]

Hi guys, I need to pass parameters from an URL to a web template created with WAD 7.0. We need to open a template with certain filters starting from a link button located on an Xcelsius Dashboard. Our customer wants a web template to be opened with the filters defined within the Xcelsius

The idea is to run the template with the filters defined in the URL. I know this was incredibly easy with WAD 3.x, but I didn't find any suitable solutions to use with WAD 7.0.

What is the easiest way to do this with WAD 7.0?

Thanks in advance and regards.

Fabio Cristi

[Former Member]

Hey Fabio,

did you manage it to generate an according URL?

If yes, could you may provide me an example for that?

Thanks and regards.

[Former Member]

here the solution:

"http://[bwsystem]:10060/sap/bw/BEx?sap-language=EN&bsplanguage=DE&cmd=ldoc&TEMPLATE_ID=Y_Y30931B_002&"

"var_name_1=YWAER002&var_value_ext_1="{?CurrencyType}

"&var_name_2=YBUCH003&var_value_ext_2="{?0P_COCD}

"&var_name_3=0I_FPER&var_value_low_ext_3="(RIGHT({?YFPERIOD},3)"."LEFT({?YFPERIOD},4))"&var_value_high_ext_3="(RIGHT({?YFPERIOD},3)"."LEFT({?YFPERIOD},4))

Edited by: Markus M on Oct 19, 2011 6:18 PM

[former_member192142]

Hi,

It is possible in 7.0, but unfortunately it is a lot more complicated than i 3.x. There are quite a few examples here:

http://help.sap.com/saphelp_nw70/helpdata/en/43/ef05462480025ae10000000a1553f7/content.htm

I used it in a case where I wanted to embed a Web template in a BPS application and pass characteristic filters from the BPS application to the web template - similar to your requirements. Basically you need the following just to restrict one characteristic :o(

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_SELECTION_STATE

&BI_COMMAND_1-TARGET_DATA_PROVIDER_REF_LIST-TARGET_DATA_PROVIDER_REF_1=DP_1

&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-SELECTION_1=SELECTION_INPUT_STRING

&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-SELECTIONS-SELECTION_1-SELECTION_INPUT_STRING=PDS06

&BI_COMMAND_1-CHARACTERISTICS_SELECTIONS-CHARACTERISTIC_SELECTIONS_1-CHARACTERISTIC=0D_PH2

I could only get it to work with one characteristic and I suspect, that the reason is that the URL simply gets to long (very quickly). You have to repeat the above for every characterstic you want to use :o(

Hth,

Jacob