Open Hub Service using SAP BW


Open Hub Service using SAP BW  3.5

Open Hub Service functionality in SAP BW is mainly used with InfoSpoke. InfoSpoke is an object for exporting data. InfoSpoke is defined using a data source (from which data is extracted), extraction mode and destination (where data will be stored).

In this section, we will see, how data is extracted from SAP BW InfoCube to a .csv file on a
desktop.

1) Execute transaction RSA1, 'Tools' -> Open Hub Service -> Edit InfoSpoke

 


2) Enter name of InfoSpoke and press 'Create'

3) Enter short description and select the Data Source as 'InfoCube'

4) Select Extraction Mode as 'Full'


5) Go to 'Destination' tab, enter short description. In this example, we will be exporting data in a .csv file, select the 'File' and chose 'Directory' 

6) Go to 'InfoObjects' tab, select the InfoObjects you would like to have in your exported file

7) Go to 'Selection' tab, enter if you want a particular selection criteria, in this example there is no selection used.


8) Activate the InfoSpoke by pressing 'Activate' button

9) After activation, source structure will appear as follows

10) Go back and display the InfoSpoke, press 'Dialog' button





11) Data will be exported to .csv file which will be stored at desktop

12) Go to InfoSpoke Monitor to check status of export


13) Data is exported as the monitor status is green


14) Check the exported file at desktop