cancel
Showing results for 
Search instead for 
Did you mean: 

Passing variable parameters via URL

Former Member
0 Kudos

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&infocube=TEST_M&query=Z_MKTG_SPEND&CMD=PROCESS_VARIABLES...

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&infocube=TEST_M&query=Z_MKTG_SPEND&VAR_NAME_2=Z_MKTGID&V...

any help will be greatly appreciated.

Sunil

IBM-Switzerland

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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&infocube=TEST_M&query=Z_MKTG_SPEND&variable_screen=&var_...

Regards

Heike

Former Member
0 Kudos

Hi,

Thanks for your response. I tried to follow your approach but unfortunately still no luck. I also tried to uncheck the Force the variable screen property in the Web application designer to see if it bypasses the variable screen. But what seems to be the case is that no matter what you do, as soon as you pass the variable values in the query string, you cannot escape the variable screen from being displayed. This is rather strange. I am still researching. Any other ideas please feel free to send them along... Thanks.

Sunil

Former Member
0 Kudos

Hi,

are you really sure you filled all mandatory variables?

With variable_screen= the variable screen shouldn't appear when all mandatory variables are filled (correctly). Perhaps the variable value has not been entered correctly in the URL?

Which URL are you using now exactly?

Regards

Heike

Former Member
0 Kudos

Hi

can u send me your email id at sunil.lalwani@unistudios.com and i will send u a snapshot of the variable screen so it might be more clearer.

there are only two variables in the variable screen and i have filled both in. still the variable screen is displayed with the filled values.