Extraction of InfoCube data from BW system to non SAP system

[Former Member]

Hello All,

Is the extraction of InfoCube data from BW system to non SAP system availbale only for BW 3.5 release ? If yes, how can we extract the InfoCube data to a non SAP system with SAP BW 3.1 ?

Hope to get some help.

Best Regards,

Loveline.

[Former Member]

Hi Gianfranco,

Thanks for replying.

Yes I know that open hub service is the appropriate technique to extract data from the infocube.

But if we look at SAP Netweaver documentation : Prior to SAP NetWeaver '04(since the SAP BW release I am working is 3.1); We find that we have the option to extract to a DB table or flat file.

Now if we look at SAP Netweaver documentation : SAP NetWeaver '04; In addition to the above we have the option to extract to a non SAP system.

My requirment is to extract data from InfoCube to a non SAP system. The SAP BW release I am using is 3.1

Best Regards,

Loveline.

[former_member181887]

Hi,

SAP NetWeaver '04 (SAP BW 3.5) has the same Open hub destinations as prior releases. One addition is enhanced links to 3rd party systems (i.e. schedulers/ETL tools).

One addition extraction option in SAP BW 3.5 is output from a query/query view as an XML list. This does not handle deltas like open hub does though.

I hope this helps,

Mike.

[GFV]

BW works as an Open Hub Platform since 3.0A.

There are several ways to extract IC data:

1 - Open Hub -> RSA1 / Tools / Open Hub Service

2 - TCODE RSCRM_BAPI: noy officialy supported!

3 - LISTCUBE ... not so elegant but quite good

The first one is the most emphasized and reccomended way: take a look in http://service.sap.com/bw -> InfoIndex there you find very good documention about.

Hope it helps

GFV