How to Read Infocube data via standard RFC API's or BAPI's

[Former Member]

Hi,

Is BAPI or a web Service in BI from which an external system can access the characteristics and keyfigures values from an infocube by passing the infocube name as a parameter?

Thanx and Regards,

Sunil Narendran

[Former Member]

Hi Sunil,

Welcome to SDN!!

In Addition to above mentioned ideas, here is another one you might want to try.

I have not tried this, so I am not sure as to what kind of issues you might encounter.

The Function Module to read data from Infocube / ODS is <b>RSDRC_CUBE_DATA_GET</b>.

You can write your own Remote Enabled Function Module, and envelope <b>RSDRC_CUBE_DATA_GET</b>.

Hope it helps. Let us know.

Best Regards,

Sanyam

[Former Member]

Hi Sunil,

Welcome to SDN!!

You can use Java/JSP and get the data from cube using MDX queries. This uses the SOAP service. The output would be in the form of XMLA. You can get more details on http://service.sap.com/bi -> BIInfoindex -> XML.

Bye

Dinesh

[Former Member]

Hi

The answer is yes to ODS's (ODSObject.ReadData

) and No to Cubes.

The BAPI for Cubes does not have a read data method.

I would also look at other option to get data from BW, such as Open Hub, Direct SQL reads, ABAP etc.

Thanks Edan