Passing a parameter to a BW Web Report via a URL

[Former Member]

Hi,

I have a BW Web Report that has a selection screen that allows a project to be selected.

I would like to call the report passing the project as a variable, automatically populate the selection screen field and execute the report.

Is this possible/how could I do this.

Many Thanks.

[Former Member · Accepted solution]

OK I have the syntax for populating the variable with a value passed in the URL but how do I get it to execute the report now?

http://erp-dev-bw:8100/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&INFOCUBE=0PS_C04&QUERY=ZZZ...

If I remove "VARIABLE_SCREEN=X" from the URL it executes but seems to ignore the variable I have passed. If I leave "VARIABLE_SCREEN=X" in doesn't execute the report.

Many Thanks

[Former Member · Accepted solution]

Hi,

when the input is ignored, when you don't use the variable screen, the problem is often that you didn't specify the values correctly. For example, if you have selection option variables (and the naming of your variable indicates this), you need to specify additionally the

also var_operator_I=EQ and var_sign_I=I and var_value_low_ext_I=yourValue

with I the number of your variable (for example 3 in your case)

See here:

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

Heike

[Former Member]

Hi Paul,

Can you let me know how this can be achieved using URL based Iview BW report.

The URL is as follows: I have the Variable Name as VAR_CISNUMBER and the Value for it should be Populated as 100020.

http://cnqdc01605.cnb.corp.net:50100/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.p...

Immidialte help will be Very much appreciated.

Regards

Vishwanath

[Former Member]

Guys - does anyone know how to do this in BI 7?

[Former Member]

I often use the RSRT2 transaction in situations like this...it shows you the URL generated each time you navigate in a web report.

[Former Member]

RSRT2 gives the url generated when you execute from the selection screen.

But if you just contruct the url from here and input into a new ie browser it won't work as the CMD=LDOC is not used.

It's almost like you need 2 steps, first where you trigger CMD=LDOC.......etc. and then CMD=PROCESS_VARIABLES.... But I need to do this in 1 step

Thanks

[Former Member]

Heike, Thanks very much.

It should have been

http://erp-dev-bw:8100/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&INFOCUBE=0PS_C04&QUERY=ZZZ...

[Former Member]

Hi,

that was roughly what I had but I can't seem to get it to populate the selection screen with the variable I enter.

my url

http://erp-dev-bw:8100/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&INFOCUBE=0PS_C04&QUERY=ZZZ...

[Ashwin]

Hi !

I think you need to enter &CMD=PROCESS_VARIABLES&SUBCMD=VAR_SUBMIT

at the end of your url to executes the variable screen directly.

with regards

Ashwin

[Former Member]

Hello,

have you checked the HELP page:

http://help.sap.com/saphelp_bw21c/helpdata/en/3a/3c9d398f38407ee10000000a11402f/frameset.htm

You have to add the &FILTER_IOBJNM=0COUNTRY (Filter Object: InfoObject for the project and the value &FILTER_VALUE=DE.

like:

http://your_its/scripts/wgate.dll/WebRFC/!?_function=WEBQUERY&CMD=LDOC&WBID=D9EW857MLP6EN0AEM9BZSQP3...

Kind regards

Michael