How to get BEx query result in Java?

[chinthan_yajamaan]

Hi All,

I am new to BEx, so am sorry if this is very basic question.

My question is, is there a way to get BEx query result in Java? We have a requirement to download data into excel format defined by the customer which can not be achived through standard report. Please help.

Thanks

Chinthan

[former_member225306 · Accepted solution]

Hi,

Yes you can get the query result from Java. But you need java stack. Please check the note:

917950.

Configuration Steps:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0a5216a-349c-2a10-9baf-9d4797349f6a?QuickLink=index

Once you done configuration BW and EP. You can directly execute the query in java and download the

data into excel with default SAP delieverd template(0analysis_pattern).

Thanks,

Venkat

[arvind_doomra]

Hello Chinthan,

Yes, for this firstly you need to have Java Stack. then you need to have Java stack (portal) configured/integrated to ABAP (BW) with help of Note 917950.

After the integration of BW and JAVA, please check whether the configuration is correct with Note 937697.

Once this is all done, you can run the report in Java either through Backend ie TX RSRT or using the 

BEX Frontend tools.

Regards,

arvind

[Former Member]

Hi,

Your BW system should have to be in BI Release 7.x , then only you can run queries in Java web.

You must also have installed Java stack.

Please also check following note.

917950   SAP NetWeaver 2004s: Setting Up BEx Web

805344   How URLs are generated automatically in BW

Regards,

Amit

[Former Member]

Hi,

You can run the query either directly from Query Designer or from transaction RSRT2 using the

button 'Java web'.

This will give you the query result in Java.

Also you use create web-template using the Web Application Designer and include your query

there.

In Web Application Designer you have options to include buttons for Excel export, PDF export.

Web-template created using Web Application Designer 7.0 runs in Java and gives output in Java

web.

You can export your result also in excel or PDF.

Regards,

Amit