Parameterizing Replacement path variable in a URL.

[Former Member]

I have a web template with a query which has a variable which is populated by a replacement path query which has a second variable whose value the user enters. I build up the parameterized URL.

http://dw1-sap.app.*******.com:1041/sap/bw/BEx?SAP-LANGUAGE=E&PAGENO=1&CMD=LDOC&TEMPLATE_ID=<b>PRDPROF</b>&VARIABLE_SCREEN=&VAR_NAME_1=<b>PRDTXT</b>&VAR_OPERATOR_1=CP&VAR_SIGN_1=I&VAR_VALUE_LOW_EXT_1=FEM

The template PRDPROF is based on a query and has a variable PRDID which is a replacement path which is filled by a query whose variable is PRDTXT and is filled in the above URL. PRDTXT is a selection option variable whose entry is optional and is checked ready for input. 'Change during query navigation' is unchecked.

For some reason, the variable values are passed onto the parameterized URL and will fill the variable screen but the screen waits for the user to push the execute button.

Can anybody see what the problem is ? Any input is apperciated.

Thanks.

[Former Member]

Bhanu,

I see that the default web template in BW IMG is a different one, Z_QUERY_TEMPLATE. But, the forcevariablescreen is turned off for that template too.

Thanks.

[Former Member]

Deepu, Changing prdtxt variable did not help. Doing that is making the variable to reject any values (except maybe variable exit in abap, I am guessing) and so would give out all the values for that characteristic or as in my case would timeout. I have tried to create a sample query with just the pre-query and not the actual query with rep path and the same parameterized URL and it is working fine. The issue I am guessing is that the actual variable in the web template's query is prdid whose value the template is expecting. But, I am passing variable values for prdtext. I am not really sure if there is any special way to treat the 2 variables that would be involved in a replacement path situation when we deal with parameterized web templates.

Bhanu, This leads to our observation. I have looked at both my template and the standard template (i am guessing 0query_template) and made sure the forcevariable screen option is turned off . This didn't help either. Please let me know if I am missing something.

Let me know if something else pops out to you. Thanks for the replies.

[former_member188975]

Deepak,

" standard template (i am guessing 0query_template) "...

You can check the BW IMG > BIW > Reporting relavant settings > Web based settings > Determine settings for web templates. This will confirm what your standard web template is...

[former_member188975]

Hi Deepak,

I think the following is going on:

. When you execute your web template, it causes the pre query to execute in the background.

. When talking about RRI on the web, SAP says: ...Another query started on the Web (with the standard Web template for ad-hoc analysis) or another Web application, where the entry variants are filled by the selection requirements and item definitions of the selected cells in the sender query...

. Going by this may be you can check your standard web template for the "Force Variables Screen Display" attribute.

Hope this helps...

[Former Member]

Or change the variable PRDTXT and uncheck the ready for input option. In this case you will not be able to change the variable using the var screen.

Thanks.