Skip to Content
author's profile photo Former Member
Former Member

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2004 at 07:50 AM

    Hi,

    as I understand your problem you want to fill variables via URL and bypass the variable screen.

    You should do this by using the parameter variable_screen= .

    Then the variable screen won't be displayed if all mandatory variables have been filled.

    With cmd=ldoc you don't need the command process_variable_screen

    (which then would be a second command of a command sequence),

    as you can parametrize the ldoc command.

    Please refer to

    http://help.sap.com/saphelp_bw33/helpdata/en/07/ff413a3ace7022e10000000a11402f/frameset.htm

    So to summarize s.th. like this should work:

    http://www.abc.com:8002/sap/bw/BEx?cmd=ldoc∈focube=TEST_M&query=Z_MKTG_SPEND&variable_screen=&var_name_1=ABC&var_value_ext_1=123

    Regards

    Heike

    Add comment
    10|10000 characters needed characters exceeded