Skip to Content
0
Former Member
Nov 23, 2007 at 09:39 PM

Passing parameters to BI 7 report and dynamic execution

9 Views

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 SAP" target="_blank">http://help.sap.com/saphelp_nw04/helpdata/en/07/ff413a3ace7022e10000000a11402f/content.htm">SAP help link 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