Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

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.

1 comment:

  1. Sounds great. However, when I tried to do the same and used InfoObject Hierarchy as a source, the transport of the transformation does not work. It does return RC=0, but in the QA system, it does not show in RSA1, and for that reason, the DTP also is not able to activate in the transport.

    ReplyDelete

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget