JAVA(JCO) and BW Connectivity

[Former Member]

Hi,

I am using JCO to get data from R/3. At the same time I want to get data from BW server also. Is there any methods available for this activity.

How make it possible, Please provide details.

Thanks,

Ask123

[Former Member]

Hi Ashok,

Read the following weblog written by me to extract data from BW. It's written in JCA but you could do the same in JCO.

/people/prakash.singh4/blog/2005/03/12/get-bw-data-in-portal-via-jca-using-mdx-statement

[Former Member]

hi,

My name is Ben.

I'm an analyst programmer and i try to connect a Java application to a SAP R/3 BW system.

I checked your messages on the SAP Weblog.

i'm using JCO api.

i encountered some problem with the DATASETID.

Also in transaction se37.

there is the problem:

exception occured (program: CL_RSR_MDX_COMMAND= = = = = = = =CP)

Do you have an idea?

regards, Ben

[Former Member]

can you post more detail about your error.

[Former Member]

thanks for the reply Prakash.

So, i'm using websphere with JCO to connect Bw.

Actually, i encountered the same return message in my java code and during the se37 transaction.

In se37 transaction:

I call the Bapi BAPI_MDDATASET_CREATE_OBJET

I set manually an mdx command generated with MDXTEST

on my BW query.

this BAPI return a DATASETID

the persistence of the object is ok.

after that, if i use the bapi BAPI_MDDATASET_CHECK_SYNTAX

or BAPI_MDDATASET_SELECT_DATA with this DATASETID...

I have always the same error as return message.

RS_EXCEPTION : CL_RSR_MDX_COMMAND========CP

the problem is coming from the DATASETID?

Thanks,

best regards,

Ben

[Former Member]

Hi Ben,

When you are using SE37 to test this function module then you can only test BAPI_MDDATASET_CREATE_OBJET. The other function module will only work if they are called from the same code one after another. YOu can write a quick little function module in ABAP which calls all of these function module. If you give me few days i could post or send a code in ABAP that executes all these bapis.

[Former Member]

hi Prakash.

Thanks a lot.

I appreciate your assistance...

I'll continue to check for a solution with Jco by myself. I'll let you know what I undertakes.

JCO code would be of course easier...and maybe faster...

regards,

[Former Member]

Prakash

I know this was 2 yr old thread but we are currently facing the same issue and we would like to know the solution. Our Java team is trying to access BW data and they are getting BAPI exception error. we are trying to run the modules in SE37 and we are get the same error as Ben mentioned.

Can you please let us know if any update has been made reg this issue?

thanks

[Former Member]

Hi SS

Are you using OLAP BAPIs to access data from BI. If yes I would suggest you create a custom RFC in BI where you write your mdx query and then populate an internal table with the query and pass it to the BAPI_MDDASET_CREATE_OBJECT then using the dataset id returned after the BAPI call make calls to the other BAPIs like BAPI_MDDASET_GET_AXISDATA and BAPI_MDDASET_GET_CELLDATA

Else if you want to do it completely in Java then you better go with BI java sdk with XMLA connector. Here you need to write your java code using the APIs available in BI Java SDK. You can have a look at sdn or SAP help for detail documentation on BI Java. Plz note here you need to configure the XMLA connector through Visual Admin to use it in BI java.

Cheers

Sudip