Skip to Content
0
Former Member
Feb 27, 2007 at 07:45 PM

BI Report in BPS Web Interface

59 Views

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>