cancel
Showing results for 
Search instead for 
Did you mean: 

Help me!!

Former Member
0 Kudos

How to pass multiple parameters to a BW Report Iview from portal?

Iam using EPCF's doNavigate functionality.

EX:

My BEx Query String is: CMD=LDOC&TEMPLATE_ID=XXXXXXXXX.

I built an iview with this string.Itz fine.It opens up the report.

Now we wanna try sending filters or parameters to the report.

parameters to be passed are:

&PAR_1=XXX&PAR_2=YYY&PAR_3=ZZZZZ.

I tried something like,

<a href="BW Report"

onclick="return EPCM.doNavigate(

'ROLES://portal_content/com.cop.....myiview?DynamicParameter=PAR_1%3dXXX&26PAR_2%3dYYY&26PAR_3%3dZZZZZ

', 1);void(0);">

BW Report with paramaters</a>

Itz not opening the BW Report with parameters(Filters) sent Instead it opens the same iview.I tired changing the filter values but no affect on the URL.....

Iam dubious abt the way the parameters are passed to the URL.

Itz kind of urgent, Anyone's help wud be gr8'ly aprreciated.

Thanx SDN Folks.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You said that you're passing the parameters like

PAR_1%3dXXX&26PAR_2%3dYYY&26PAR_3%3dZZZZZ

I don't know if you've copy pasted that or just type it but you've written &26 instead of %26 (which is &).

The filter parameters passed to the BW system have to be named as follows (I'm filtering on 0SHIP_TO in this example)

FILTER_IOBJNM_1=0SHIP_TO&FILTER_VALUE_1=000123456

You name the filtered field and then give the filter value. The next filter may look like

FILTER_IOBJNM_2=0CUSTOMER&FILTER_VALUE_2=000654321

Just keep increasing the number and use %3d and %26 if you have to.

I haven't used EPCM.doNavigate() with this so I can't help you if the problem lies around that but make sure your paramters are written like above.

I hope it helps,

Patrick.

Answers (0)