Passing parameters to BI 7 report and dynamic execution

[Former Member]

Hello all,

We have a BI 7.0 Web Report that has a selection screen that allows a ID number to be selected.

We would like to call the report passing the ID number as a URL parameter, automatically populate the selection screen field and execute the report. (Without the display of variable screen).

Based on the inputs from the <a href="http://help.sap.com/saphelp_nw04/helpdata/en/07/ff413a3ace7022e10000000a11402f/content.htm">SAP help link</a> we had tried out following

http://<host>.<domain>:<ABAP Port>/sap/bw/BEx?sap-language=EN&bsplanguage=EN&INFOCUBE=ZCRI_ODS&QUERY=CR_QUER1&DUMMY=2&CMD=PROCESS_VARIABLES&VAR_NAME_1=VAR_20070503004019&VAR_VALUE_EXT_1=200001

If the above URL is processed the report brings data of ID number 2000001 only and works as desired. But the Content displayed is of BW 3.x version and not BI 7.0 version.

Now, if we try out

http://<host>.<domain>:<J2EE Port>/sap/bw/BEx?sap-language=EN&bsplanguage=EN&INFOCUBE=ZCRI_ODS&QUERY=CR_QUER1&DUMMY=2&CMD=PROCESS_VARIABLES&VAR_NAME_1=VAR_20070503004019&VAR_VALUE_EXT_1=200001

then the report behaves weird and displays all the records. (the desired output being only data related to ID number 200001 displayed).

We need to show up this report with uniform look and feel as other reports are of BI 7.0 version. So we need to get it working with BI 7 look and feel.

Hope my explainations are clear enough.

Can expets throw some light on this?

Thanks...

Regards,

Ravi

[Former Member · Accepted solution]

Hi,

in BI 7.0 the URL for setting variable values is different.

See the links below for further info.

http://help.sap.com/saphelp_nw2004s/helpdata/en/44/605a2fb5bd6d11e10000000a1553f6/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/ef05462480025ae10000000a1553f7/content.htm

[Former Member · Accepted solution]

Thanks a lot Shailesh.

With this info I will try to sort out our issue.

Regards,

Ravi

[former_member184494]

Ravikiran,

You cannot process variables directly since the BI7 Template works through portal and the JAVA Stack - you would have to use the command Editor web item that is supplied and use that accordingly.

Arun

[Former Member]

Hi Arun,

Thanks for your reply.

Can you please elaborate your answer? How to use the command Editor web item.

It would be great if you can help us out.

thanks...

regards,

ravi