Open Hub Service using SAP BI 7.0

Open Hub Destination functionality is used to distribute data from SAP BI to other non-SAP data systems. In earlier version, it was part of InfoSpoke but in SAP BI 7.0 this can be used independently.

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



1) Execute transaction RSA1, Press 'Open Hub Destination'

2) Select InfoArea and right click to 'Create Open Hub Destination

3) Enter Name and Description

4) Go to 'Destination' tab, enter Destination Type as 'File type'. In this example, we will be exporting data in a .csv file, select Directory to 'Desktop'

5) Go to 'Fields Def.' tab, select the InfoObjects you would like to have in your exported file

6) Activate the Open Hub Destination by pressing 'Activate' button

7) Select the Open Hub Destination and right click to 'Create Transformation'

8) Enter source of transformation as InfoCube

9) Accept the proposed mapping and activate

10) Create Data Transfer Process for transfering data from InfoCube to Desktop as .csv file

11) Enter source of DTP as InfoCube

12) Activate DTP and Execute, Data will be exported to .csv file which will be stored at desktop

13) Press 'Yes' to check the status of request monitor

14) Data is exported as the monitor status is green

15) Check the exported file at desktop