Need to skip the variable selection screen when using dropdown

[Former Member]

Hello Friends,

I have created a web template having a dropdown, a table and a text element. Basically I am trying to follow the guide "How to Use a Dropdown Box to Set Variable Values". It shows how to select values for a variable using dropdown.

NOTE: The guide can be found here:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/2642ab90-0201-0010-9193-d59...

What is happening is when I select a value for the variable in the dropdown, the correct url is getting formed but instead of displaying the report using the selected value, the variable selection screen appears. Given below is the url that gets formed:

http://abcdev.wdf.sap-ag.de:8000/sap/bw/BEx?SAP-LANGUAGE=E&PAGENO=1&REQUEST_NO=3&CMD=PROCESS_VARIABL...

Please assist me to get rid of the variable selection screen. Thanks!

Regards,

Prem.

[Former Member · Accepted solution]

Hi,

maybe ceck if the variable VARIABLE_SCREEN is set to ' '. Maybe this will help.

http://help.sap.com/saphelp_nw04/helpdata/en/fe/1f813b310c4a0ee10000000a114084/content.htm

regards,

Raymond Baggen

Uphantis bv

[Former Member · Accepted solution]

Hello Ray,

Thanks for your reply. This has partially resovled the issue. I have awarded you points for that. Now I am able to skip the variable screen.

However, the query results are not getting refreshed. I wanted to restirct the values based on the value given in the variable selection (In my case the dropdown box). Somehow I am not able to link the dropdown with the variable or the "SAPBWOpenURL(url);" function is having some issues.

Please assist. Thanks!

Regards,

Prem.

[Former Member · Accepted solution]

Make sure you have the characteristic and structure correctly set in properties of the dropdown. Also make sure that if you have more than one data provider, the data provider for the table is checked of in "affected dataproviders" property of the dropdown.

[Former Member · Accepted solution]

Thanks Dhwanil,

I really appreciate that even after a long time you cared to respond to the question. I will try that. Thanks again!

Regards,

Prem.