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 a comment
10|10000 characters needed characters exceeded

Related questions

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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.