How to extract data directly from XMii to BW?

[Former Member]

Hi Experts,

Does anyone have experience on how to extract data directly from XMii to BW without any middlewares? What is the configuration in BW and in XMii?

Thank you,

CL

[Former Member]

I used the bapi: RSDRI_ODSO_INSERT_RFC through a JCO connection

That way you dont need to start abapping to write some simple data into a flat table (datastore) in BI.

[Former Member]

Guest,

Can you please provide with all steps you had to follow?

We have a similar situation where we have several instances of SAP MII.

We need to get all the data into SAP BW and then report on it.

Please send as much information as possible.

I have not worked with MII systems before , so need help.

Thanks,

anya

[former_member711559]

Hi Experts ,

I am also having same requirement to extract data from SAP MII to SAP BW.

Could you please let me know what input parameters need to be mapped to BAPI RSDRI_ODSO_INSERT_RFC.

Thanks and Regards,

Madhavi

[Former Member]

No experience yet but did you check https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b06f5eb1-2f03-2a10-5790-9b4493da... ?

[Former Member]

Thanks for the link but it is talking about querying in XMii from BW. What we are looking for is querying in BW but extracting data directly from XMii.

Thanks a lot,

CL

[Former Member]

Allrite, but what data would you extract from xMII ? It doesn't have a database OR are you looking @ DATASOURCE <---- xMII <----- BW?? Here the DATASOURCE could be anything (SAP, MES ,Plant Floor data historians etc.)

[Former Member]

User requests to load Plant Floor data into BW and then reported out from BW because we will have 70 XMii Servers which we would like to summarize the data in BW and report out from BW.

Thanks,

CL

[Former Member]

You can access xMII Transactions as Webservices and this is the most common way that other systems integrate with xMII.

Hopefully BW can do that as well.

[salvatore_castro]

CL,

The mechanism that I recommend to achieving this is by using Virtual Info Cubes. Set your cube to use a WebSerivce OR URL call to a Business Logic Service transaction as it's data source. This will require some ABAP in defining the parsing of the XML response from BLS, but nothing too tricky. There are plenty of documents that you can find via Google on how to populate data in a Virtual Cube via a WebService call. Have fun and let me know how it works out for you.

-Sam

[Former Member]

Sam,

Thank you for the reply. I will give it a try.

CL

[Former Member]

Sam,

I try to look for some step by step help but I am not lucky enough to find that. Could you please help me on that? As I am new to WEB services and not knowing much in this area.

Also. you have replied another question on:

David,

You're problems with naming a very understandable since it really depends on your background with BW on what you call a cube versus a catalog. If you deal with internal transaction (ie: RSA1) versus external transactions (ie: MDXTEST) the nomenclature is different:

Internal External

Catalog No Equivalent

Cube Catalog

Query Cube

View Query

Most likely you do not have the proper port specified, SICF then at the top select Goto -> Port Information the port number is the HTTP port and not the SAPHTTP port. Also in Query Designer don't forget to remote enable the cube, this is mentioned in the connection guide. Finally if you still can't get it to work, what is the error message you are getting in the General Log? Hope this helps.

-Sam

I am having the same porblem where I am hanging at step 10, in the window where we should see the cube name, it said "No Data Available". I double checked the query, it is remote enabled, I checked the port and URL, everything is fine. for username and password, I am using my ID which is used for BW access. I ran MDXTEST and I can see the query. So, what else can I check.

Thank you very much,

CL

[salvatore_castro]

CL,

The How to Guide is on the SDN and the PDF can be downloaded <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how%20to%20report%20from%20external%20data%20via%20virtualinfoproviders.pdf">here</a>.

As for the error message take a look at <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b06f5eb1-2f03-2a10-5790-9b4493daa938">this document</a> and maybe it will help you troubleshoot.

If the Query works in MDXTest and you have the OLAP -> XML/A component installed for BW or BI then the query should work in the xMII OLAP Query Template.

Hope this helps.

-Sam