Process Chain Creation using SAP BW 3.5

Process chains are used extensively in SAP Business Warehousing for executing loads, running reports etc. sequentially or parallel.

There can be number of steps with in a process chain. You can also decide what has to be done incase a particular step fails. In case of failure you can decide to sent notification email to concern person who can correct the issue.

In this section we will see how to create a process chain using SAP BW 3.5. Using this process chain we will load data in Infocube.

1) Execute transaction RSPC

2) Press 'Create', enter 'Name' and 'Description' of the process chain, press 'Continue'

3) First step in the process chain will be a 'Start' step,

press 'Create' to create a process variants

4) Enter 'Name' and 'Description' of the process variant

5) 'Save' process variant and go back, 'Change selections' is used to schedule the process chain, we will revisit this again later

6) Press 'Continue'

7) Select the InfoPackage which is used to load data in

Infocube, drag InfoPackage to right panel

8) Select the process variants as InfoPackage using fucntion key F4

9) Select the InfoPackage ZAAA and press 'Continue'

10) Following steps will be added in the process chain

11) Join 'Start' step with step 'Indexes' by selecting 'Start' step and

dragging the line to 'Indexes'

12) Go back to 'Start' step and right click to 'Maintain Variant'

13) Select 'Immediate' to schedule the process chain immediately

14) 'Check' the process chain and 'Activate' the process chain

15) Execute the process chain, enter the server name in the following screen

16) Process chain will start executing, to check the status, Press

17) Select 'Yesterday and Today' to check the status of the process chain

18) Following screen shows that load is still not completed

19) Once completed, the status will appear as follows,

incase there is any failure, the status will appear as cancelled

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

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

Open Hub Service using SAP BW 3.5 & BI 7.0

Open Hub Service functionality in SAP BW 3.5 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).

Open Hub Service 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.
As there is a significance difference between SAP BW 3.5 and SAP BI 7.0, we are providing here steps of Open Hub Service creation process for both the versions.


Open Hub Service using SAP BW 3.5

Open Hub Service using SAP BI 7.0

Infocube Creation Step 4 using SAP BI 7.0

In this section, we will see how to define Data Transfer Process and load data in InfoCube using SAP BI 7.0. Data Transfer Process makes the transfer processes in the data warehousing layer more transparent.28) Now define, Data Transfer Process as shown

29) Enter the source of DTP

30) Activate the DTP after maintaing the required settings

31) Create a InfoPackage by right clicking the DataSource

32) Execute the InfoPackage to load data into PSA

33) Check the data load in PSA by double clicking the DataSource

34) Execute the DTP

35) Check the data in InfoCube