how i could i fetch data from BW

[Former Member]

Hello Friends

I have a scenario where i have to fetch a excel file that is in BW server in to my webdynpro application. The file may be in infocube .

Can anybody help me to give complete code aur sample scenario related to my problem..

Thanks and Regards

Yogesh

[Former Member]

You can also write an RFC enabled function module in BW. In there you call the query, do your dirty work with data and return just the data you need, the way you need it.

I have chosen this approach as it is much faster during execution (no need to pass metadata, just one login-request-response cycle) and you get a nice model into WebDynpro 4 Java when you import the RFC.-

BI SDK is more powerful but you end up writing much more code. If you are interested I can give you a code snippet on what needs to be done in ABAP.-

regards!

Vitaliano

[vmadhuvarshi_]

Vitaliano,

I'll appreciate if you can post the code snippet for RFC module in BI side here.

Regards,

Vishwas.

[Former Member]

Hi Yogesh,

Please have a look into these following How to links. May be it will not explicitly fulfill your requirement but still will help you a lot.

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60f35908-ecd4-2910-6c89-e75e1054d9d1">Application to execute MDX query using the BI Java SDK</a>

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e49be590-0201-0010-0c83-fc20e5da124f">How To Use the BI Java SDK in a Web Dynpro Application</a>

Thanks and Regards

Avijit.