Passing variable parameters via URL

Hi,

I am able top pass the variable values of a BW report via a URL. However I am unable to automatically execute the report to get the results bypassing the variable screen.

There is a parameter SUBCMD='VAR_SUBMIT' which if placed in the URL executes the variable screen directly.

http://www.abc.com:8002/sap/bw/BEx?cmd=ldoc∈focube=TEST_M&query=Z_MKTG_SPEND&CMD=PROCESS_VARIABLES&SUBCMD=VAR_SUBMIT

However in combination with supplying the values of the variables as shown below the CMD='VAR_SUBMIT' does not work. It shows the variable screen with the filled values from the query string. Not good enough. If I can fill the values of the variables in the variable screen automatically, i should be able to execute also automatically without having to manually click the execute button.

http://www.abc.com:8002/sap/bw/BEx?cmd=ldoc∈focube=TEST_M&query=Z_MKTG_SPEND&VAR_NAME_2=Z_MKTGID&VAR_VALUE_EXT_2=12345&CMD=PROCESS_VARIABLES&SUBCMD=VAR_SUBMIT

any help will be greatly appreciated.

Sunil

IBM-Switzerland