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
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
