BW Reports

[former_member188977]

Hi all,

I need to pass parameters dynamically in a BW Report iview.

for example, I'm passing the month as parameter like:

<i>var_name_1=ZCALMON&var_value_ext_1=05.2005</i>

and I should like to pass "actual month"

I know that from BW I would do it, but my question is if I can solve it from portal

Regards.

Nacho.

[Former Member · Accepted solution]

Hi Ignacio,

When we want to dynamicaly pass params to BW reports from the portal we use java iViews. Very simple java iViews. Essentialy they are nothing more than an IsolatedHtmlContainer displaying a BW Report iView, or even simpler, sometimes the java iView will simply redirect itself using something similar to

Form myForm = this.getForm();
myForm.addRawText("<script>self.location="/irj/servlet/prt/portal/prtroot/com.sap.portal.appintegrator.sap.BWReport"+
"?CMD=LDOC&System="+BW_SYSTEM+"&Report=TEMPLATE_ID%3d"+QUERYNAME+
"%26FILTER_IOBJNM_1%3d0CUSTOMER%26FILTER_VALUE_1%3d"+kunnr+"";</script>");

You can find some more info in this thread

https://forums.sdn.sap.com/thread.jspa?threadID=30253

I hope that it helps you.

Patrick.

[Former Member]

Hi Ignacio,

Another solution is to write a "Customer Parameter Provider".

See the following link for an example:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/ep/how to start transaction iviews with a dynamically computed language.pdf

Hope that helps,

Yoav.