on 05-24-2011 2:39 PM
Hi All,
Here's my scenario:
1. am running a bEX bw template as an iview from portal.
2. a portal event causes 2 parameters to be passed to the BW template e.g. material and plant.
3. I pick these 2 parameters up using javascript and construct the URL which i call using SAPBWOpenURL(d_url).
My problem is that it would appear that only one parameter is being used by the query. So say i have plant 1011 and material 900322. It's bringing back the plant alright, but it's bringing back all materials for that plant, instead of just the material being passed.
I have tested the query independently of portal and it works fine when i input the plant number and material, so I would assume that the query is fine, it's the way I'm constructing the URL??
Can anyone see anything wrong with this:
function myEventReceiver( eventObj ){
var darray = eventObj.dataObject .split(",");
var url = location.protocol "//"location.host+SAP_BW_URL_Get();
url = url + "&data_provider=DATAPROVIDER_1&FILTER_IOBJNM=0MATERIAL&FILTER_VALUE=" + darray[0] +"&filter_collapse=" + "&FILTER_IOBJNM=0PLANT&FILTER_VALUE=" + darray[1] + "&filter_collapse=";
SAPBWOpenURL(url);
}
Any guidance would be most welcome as i'm under pressure to get this issue resolved and have no idea what to try next.
Thanks in advance,
Liz.
you need to be '_1' after FILTER_IOBJNM and FILTER_VALUE and continue sequentially:
url = url + "&data_provider=DATAPROVIDER_1&FILTER_IOBJNM_1=0MATERIAL&FILTER_VALUE_1=" + darray[0] +"&filter_collapse=" + "&FILTER_IOBJNM_2=0PLANT&FILTER_VALUE_2=" + darray[1] + "&filter_collapse=";
SAPBWOpenURL(url);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.