cancel
Showing results for 
Search instead for 
Did you mean: 

XI BI integration

Former Member
0 Kudos

Hi,

I read the blog _ how to integrate xi into BW.

i have difficulties with the proxy part.

in the abap proxy code it is mentioned to use

l_s data TYPE zoxab5011 what does zoxab5011 stand for ?

Accepted Solutions (1)

Accepted Solutions (1)

sridharreddy_kondam
Active Contributor
0 Kudos

Hi Udi,

zoxab5011 is a Target structure created in BI(this structure holds the fileds that re being sent to BI say material,calday, amount,Currency) for which the BI is receving the fields to deltaqueue, this structure is created when u follow the below link(these we can say as target fields to be extracted in BI)... check this (Step 4 .1 in the doc u have a link mentioned as)

http://service.sap.com/~sapidb/011000358700011142902001E/HOWTOSENDXMLDATATOBW.DOC

After u followed the above steps u can see the structure in SE11 in BI server ...

If any further issues u can reply as i have successfully completed this integration XI-BI..

Regards,

Sridhar

Former Member
0 Kudos

Hi Sridhar,

i have followed the documentation. i am running a file - > XI > BW scenario. when running this i see in the SXMBMONI in BW the checkers flag however in SA37 it seems that the data is not recieved into the delat queue.

In the document they say to import the RFC but what should i do with it? ibuilt a file sender , built the xml and sent it to the proxy .

Former Member
0 Kudos

here is my proxy code:

METHOD zii_order_ib~execute_asynchronous.

      • **** INSERT IMPLEMENTATION HERE **** ***

DATA: l_text TYPE string,

l_s_data TYPE zoxbwd0114,

l_t_data TYPE TABLE OF zoxbwd0114.

FIELD-SYMBOLS <l_line> LIKE LINE OF input-order_mt-item.

LOOP AT input-order_mt-item ASSIGNING <l_line>.

MOVE-CORRESPONDING <l_line> TO l_s_data.

APPEND l_s_data TO l_t_data.

ENDLOOP.

CALL FUNCTION '/BI0/QI6AZSD_BW_XI_RFC'

EXPORTING

datasource = '6AZSD_BW_XI'

TABLES

data = l_t_data

EXCEPTIONS

OTHERS = 1.

IF sy-subrc NE 0.

  • MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

  • WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4 INTO

  • l_text.

  • RAISE EXCEPTION TYPE

  • zcx___bi0__qi6azsd_bw_xi

  • EXPORTING text = l_text.

ENDIF.

Former Member
0 Kudos

Hi Udi,

The RFC will be used in the receiver interface side on things.

Has this been set up ?

Can you see a message coming into BW in SXMB_MONI (in BW) ?

Cheers

Colin.

sridharreddy_kondam
Active Contributor
0 Kudos

Hi Udo,

Have u used the QOS as EOIO or not ? If not use the EOIO (only EOIO is used for Proxy)and then Mention the Queue name...

and also once execute the proxy in BI server and see whether the data is being sent to the target?

And one thing when u have followed the link which i mentioned earlier how to send XML data to BW an RFC is Created internally say e.g <b>/BI0/QI6ASENDXMLTOBW_RFC</b>

And this has to be imported in XI and can be used as mentioned in the DOC ...

If further u r welcome...

Regards,

Sridhar

Message was edited by: sridhar reddy kondam

Former Member
0 Kudos

Why do i need the RFC for ? i am using a proxy

i see that i get a flag in the BW but nothing happens

Former Member
0 Kudos

Hi,

Are your queues running ok in BW and are they active ?

Check trx SMQ1 / SMQ2 / SMQR in BW.

Use trx SXMB_ADM to manage your queues in BW if required.

Cheers

Colin.

Answers (0)