Problem in sending data to BW through XI

[Former Member]

Hi all,

I am using "How to..push data to BW from XI".

There a javascript code is given for sending data to BW using XI.

But when I use that code for sending XML file it is showing a java script error:"Automation server can't create object".

I think it has something to do with ADODB.Stream object.

As given in the microsoft document I have deleted the registry entry which disables ActiveX component ADODB.Stream object.

Even then it is showing the same error.

Can someone figure out what is the problem.

Any help will be appreciated.

Regards,

Anand

[Former Member]

Hi,

You can also see the following link

/people/kamaljeet.kharbanda/blog/2005/09/16/xi-bi-integration

RGds,

Vasanth.

[Former Member]

Hi,

Have you seen this document :

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/8c10aa90-0201-0010-98a0-f071394bc9ae">https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/8c10aa90-0201-0010-98a0-f071394bc9ae</a>

This provides a simple step by step guide on getting data into BW.

I would imagine this document can also be used for getting the data out of BW as well.

Cheers

Colin.

[Former Member]

Hi,

Can you please provide the link for the document "How to..push data to BW from XI".

I will be interested in this.

Thanks

Colin.

[Former Member]

Hi Colin,

Check this link for your reference

<a href="http://sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/21d8aa90-0201-0010-5e83-a3798b9a5ee0">Push Data to BW</a>

Regards,

Dhana

[Former Member]

Hi Anand,

I am also doing the same intregation, and using the same guide to send data to RSA7 IN BW, so i have modified a little bit and using abap proxy to send data to BW.

For the time being i am using a sinple xml file pick up by file adapter send to xi and push in bw by abap proxy.

Will keep you updated, but i didnot use the script as i found it a bit complicated,

Just thought to share this with you,

Regards,

Anirban.

[Former Member]

Hi Anirban,

Can you elaborate how you have used ABAP proxy(step by step) to do the same thing.

Thanks,

Anand

[Former Member]

Hi Anand,

Sure, first i tried to send hardcoded data by using a report in bw, and refering the classes from transaction sproxy.

The code was:

REPORT ZZ_TEST_XI_POC.

&----

---

*& Report ZZ_TEST_XI_POC

*&

&----

---

*& start of code by Anirban Ghatak , 14/03/06

*& This Report will send data to sap xi

*&

&----

---

*& start of code by Anirban Ghatak , 14/03/06

DATA prxy TYPE REF TO ZPUSHCO_PROXY_INTERFACE_OB.

*

CREATE OBJECT prxy.

DATA it TYPE ZPUSHPUSH_TABLE1.

TRY.

it-PUSH_TABLE-EMP_NO = 'Anirban'.

it-PUSH_TABLE-EMP_NAME = '393'.

it-PUSH_TABLE-DEPARTMENT_NAME = 'NetWeaver'.

CALL METHOD prxy->execute_asynchronous

EXPORTING

output = it.

commit work.

CATCH cx_ai_system_fault .

DATA fault TYPE REF TO cx_ai_system_fault .

CREATE OBJECT fault.

WRITE 😕 fault->errortext.

ENDTRY.

*& End of code by Anirban Ghatak , 14/03/06

then execute it , this sends data to xi.

Refer /people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

this can send data from bw to xi.

Try have a look and see if you can replicate, actually mine is a POC so i have a little bit of flexibility but if you are working on a live devlopement reconsider the solution.

Anirban.

[Former Member]

Hi Anirban,

This is just like using sproxy in other R3 systems. How does it differs..

Did u use infocube or infosource to extract data into a proxy..If so please provide the info..becuase even i tried the other way round. I have created an info source and package in BW and tried sending the data from file to BW, but it failed.

Regards,

Dhana

[Former Member]

Hi,

Yes you are 100% correct thats why i said, firstly try the hardcoded proxy so we are sure of the settings and services and internal rfc settings between BW server and xi,

then we can extract data from a data source in BW By calling the concerned RFC in the proxy report. Like i will use a rfc like 2LIS_02_HDR in my proxy report and send the proxy report.

So hardcoded proxy is for the first time, also chk if you are able to see XI design objects in sproxy of BW server, and then you get to know the settings are ok or not.

I am not A BW consultant but have tried my best to answer you,

Anirban.