Below are the steps required to create an Open Hub Destination in BI 7.0

1.  Click on Open Hub Destination from left side panel after executing RSA1.

Right click on InfoArea where the Open Hub Destination will reside and select “Create Open Hub Destination”

Fill in the following:

• Open Hub Destination:  Z_IFSFFPT (up to 9 characters only)
• Description:  IFS FFP Interface Test
• Object Type:  DataStore Object

• Name:  ZRV_O904

2.  Click on the Destination Tab.

Select “File” from the drop down box

Select the directory… for testing purposes, save to your desktop

Click on the Application Server Box… notice the Application Server “MVSADBDV1” will be displayed initially as the default application server.

For migration to production, you want to work with Basis to setup a ‘logical file path/name’.  This will ensure that the logical path and logical name can be migrated into all environments without having to specify the server name.

For R8.1 IFS, we are using the newly created Logical File Name “Z_OPENHUB_IFS”

From AL11 in BA8, you can see the Logical File Name “Z_OPENHUB_IFS” directories

3.  Now you are ready to specify the fields for the Open Hub Destination.

Select the Tab “Field Def”.

4.  Now you are ready to create the Transformation (source).

Right click on the saved Open Hub Destination “Z_IFSFFPT”, and select “Create Transformation” from dropdown box.

5.  Select “DataStore Object” from the Object Type drop down box.

Select “ZRV_O904” from the drop down box.

Click on the Green Check Mark to continue.

6.  Now, you can do all of the activities available to a Transformation:

              Create Start Routine

              Create End Routine (see below)

              Create Formulas (see below)

Activate the transformation when completed.

7.  Now, you are ready to create the Data Transfer Process for the Open Hub Destination.

Right click on the Open Hub Destination “Z_IFSFFPT”, and select “Create Data Transfer Process” from the drop down box.

The target and source will be prepopulated, so you may not need to do anything; however, you can also specify the details. 

Click on the Green Check Mark to continue.

8.  From the Extraction Tab:

Select Extraction Mode:  Full

Click on the Radio Button “Active Table (Full Extract Only)

No steps required in the Tab “Update”.

No steps required in the Tab “Execute”.

9.  Finally, click on the Activation Icon.