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 
No comments:
Post a Comment