BI Report in BPS Web Interface

[Former Member]

hi gurus,

Iam trying to link the BI web report into BPS web interface and also pass BPS variable values into BI report. Iam able to sucessfully link the report and excute it, however the variable is not getting passed from BPS web interface, below is the code Iam using, please advise;

<iframe id="BPSREPOR"

name="BPS Report"

src="/sap/bw/mime/bex/icons/pixel.gif"

width="1000" height="600"></iframe>

<script language="JavaScript" type="text/javascript">

var frame = document.getElementById( 'BPSREPOR' );

var url = 'http://wbvmburpr10.warnerbros.com:50100/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=';

var filter = '&FILTER_IOBJNM=0COMP_CODE&FILTER_COLLAPS=&FILTER_VALUE_EXT=';

// Example using fiscal year 2004 and variant K4: K4/2004 => comp = #K4/#

var comp = '';

var appl = 'BPSREPOR';

var varvl = '<%descr(BPS_VARIABLE/value)%>';

// Option: Adjust the 'SELECT' to your local language

if (varvl != "" && varvl != "-- SELECT --"){

// expected formatting of variable selector: Text(Key) or Key

var convert = /((.*))/;

convert.exec(varvl);

// If there is value in brackets it is the key

if ( RegExp.$1 != "") varvl = RegExp.$1;

// create URL

url = url + appl + filter + comp + varvl;

// remove possible white spaces

url = url.replace(/ /,"");

// set source attribute of iframe to new URL

frame.src = url;

}

</script>

[Former Member]

Syed

A couple of things:

1. If you're calling a web template you'll need to modify you're url variable and replace the word "QUERY" with "TEMPLATE"

2. You can't use the 3.5 command urls (&FILTER_IOBJNM=0COMP_CODE&FILTER_COLLAPS=&FILTER_VALUE_EXT=) in the 7.0 runtime environment. You'll need to use the new form of command URL parameterization. This link will help:

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

[Former Member]

Thanks Todd. Iam using the BEx Query. I will look at the help link provided by you.