Integrating BW Report in a Web Dynpro Application

[Former Member]

Hi,

I have a webdynpro application which has two views where the report in the first view must display data from an R/3 system and the report in the second view must display data from a BW system.

I am able to display the R/3 report. Can anyone tell me how I can integrate the BW report in my second view?

( As suggested in many posts, I doubt if I can use a SAP Standard BW iview )

Thanks and Regards,

Reena

[Faaiez · Accepted solution]

Hi Reena

You can find a <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5a40f2f7-0c01-0010-d69f-c6317c5165cd">How To…Integrate SAP NetWeaver 2004s BI Application UI Elements and Visual Composer UI Elements by service enabling</a> here on SDN.

Although the title specifies integrating BI and Visual Composer, in the document it states ‘<b>This concept can be extended to any SAP toolset, such as Webdynpro for ABAP, BSPs, WebDynpro for Java, etc…</b>’

Regards

[Former Member]

Hi,

Perhaps you can just put an IFrame in the BW report view and display the BW report by giving the IFrame the reports' URL.

On one project where we had to display lots of BW reports in the portal we couldn't use the standard BW Report iView because we wanted to dynamicaly pass parameters to the reports; so what I did was simply construct the URL for the report, with parameters, in Java and displayed the report in an IsolatedHtmlContainer.

Since you're using WebDynpro just use an IFrame.

I hope it can help,

Patrick.

[Former Member]

Hi Patrick,

Thanks for the reply.

I got what you are saying. But my question is how do you create a BW Report in WebDynpro.

I have been creating reports which diplay data from R/3 using the Adaptive RFC Model, Jcos etc. But have not created one which connects to BW. So I have no idea from where to start.

Any pointers regarding this would be helpful.

Thanks and Regards,

Reena

[Former Member]

Hi,

you can use bi java connector.

There is a how to on sdn how to use bi connector in webdynpro.

/people/moya.watson/blog/2004/12/27/three-new-how-to-guides-for-the-bi-java-sdk

Also you can find the bi java connector on sdn with alot of examples how to execute mdx statements.

/people/moya.watson/blog/2004/03/30/java-developers-take-note-the-bi-java-sdk-is-here

Florin