Using an exsiting BI query in Web Dynpro

[Former Member]

I am interested in using an existing BI query in Web Dynpro. The NetWeaver Developer Studio 7.0.06 contains some good documentation about how to create and execute an MDX statement on a BI cube. However, I find this approach both complicated and impractical and I'd like to maintain my queries solely in the BI Query Designer. I cannot find any documentation on importing an existing BI Query and using it within Web Dynpro. I find this odd since the BI Java SDK Developers Guide specifically recommends this. Is it the case that a BI Query can be treated as a cube within the Java code and found through IBIOlap? Further, I cannot find any examples that show me how to construct a graph from the data as portrayed in the "BI Java SDK: A Business Scenario" portion of the NetWeaver documentation, or, place the result set on a table that can be used in an IView. Also, all of the examples in the documentation are Servlet based. I'm looking to create IViews for Portal deployment. In summary, I'd like to create a table and graph combination, based on a BI Query, that I can deploy to the Portal using Web Dynpro. Can you provide some insight on these questions and point me to some concrete examples of how to do these things?

[Former Member · Accepted solution]

Hello

did you consider using BEx Web designer to build the custom report and chart and expose it as an iView in the portal? This should take you just minutes of work. I do not see any real advantage to use webdynpro here unless you also need to attach BW query data to some context nodes for further processing.

regards,

Vitaliano Trecca

[Former Member · Accepted solution]

Vitaliano,

You make a very good point. And it is probably the way that we will go. However, my task is to evaluate Web Dynpro and Visual Composer for our needs. Especially since the graphing capabilities in Web App Designer are limited for our needs. We will, at some point, have a need to combine warehoused information in BI with real-time data in R/3. I'm anticipating that this is where Web Dynpro will be useful for us. Therefore, my questions as stated regarding Web Dynpro. I just find it strange that none of the SAP documentation elaborates on the topics that I am concerned with, even though tantalizing capability summaries are dangled throughout.

Thank you.

[Former Member]

Hi Bhagat,

Did you find an answer to your query. Because i too need the same procedure that you are asking for, if you have already found solution for problem. please mail me the procedure or example pertaining to it. my mail id is karthik_chk@yahoo.com.

Awaiting to hear from you.

Regards,

karthikj

[Former Member]

Kurt,

Did you come with more information regarding this post? I'm also trying to call a BW query from Web Dynpro and use the data for not only a graph but also for a navigational tree.

I would be very interested in how to call the BW query through an RFC.

julian

[Former Member]

Maksim,

I have seen this document. It does not answer the questions I am asking. Thank you for trying.

[Former Member]

Did , find a solution for the question posted by you on your own or from other. please let me if yes or no, i am also in search for the same. will, so keep you updated if i found the solution. retrieval of query from BI to dynpro.

Thanks,

cheers,

karthik

[former_member182372]

Hi Kurt,

Check this https://media.sdn.sap.com/javadocs/NW04/SPS15/bi/docs/howtos/How_To_BI_Java_SDK_WebDynpro_App.pdf

Best regards, Maksim Rashchynski.