Skip to Content

In this job we need to import open hub table from BW system to BODS. Make sure that RFC connection from BW to BODS is established properly and is running successfully. Before executing the BODS job all the objects in BW should be activated. The steps for creating and importing open hub table from BW to BODS are:

Step 1: Log on to SAP GUI and type T-Code RSA1.

Step 2: Click on Open Hub Destination under Modelling tab which is in the left pane. Right click on the Info Area created and select Create open Hub Destination.

/wp-content/uploads/2014/12/1_601705.jpg

Step 3: Provide the name for OHD and its description. Also provide the object name which could be info cube or DSO or multi provider or info object etc., and its corresponding name. Enable create transform and DTP option, it will create transformation and DTP while we activate the OHD table. Click OK.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 4: Select third party tool in destination type and provide RFC destination which is running successfully from BW to BODS.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 5: Activate the OHD table.

Step 6: Click on OHD created and double click on DTP and activate it.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 7: Go to T-code RSPC. Right click on Process chains header and create display component.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 8: Provide a name for application component and its long description.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 9: Now right click on application component and select create process chain.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 10: Provide a name for process chain and its long description. Click ok.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 11: Click on the highlighted option to create process variant.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 12: Provide a name for process variant and its long description. Click ok.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 13: Select start using meta chain or API option and save it and go back.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 14: Click ok.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 15: Provide the DTP technical name which was created during the activation of OHD. Click Ok.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 16: Provide connection from start to DTP and activate it.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 17: Logon to BODS. Go to datastores tab in local object library and right click on free space and select new.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 18: Select datastore type as SAP BW Source. Provide the details of application server, user name and password of BW. Click on advanced option and provide details of client number, system number. Select data transfer method as RFC and provide RFC destination name. Provide routing string of BW server. Click on apply and then select ok.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 19: Now expand the datastore and right click on open hub tables and select import by name.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 20: Enter the OHD table name which we have created at BW side and select import.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 21: Create a job in project area after selecting a project. Drag and drop workflow inside the job. Double click on work flow and drag and drop data flow. Double click on data flow and drag and drop OHD table which we have imported as source. Create a template table as a target. Connect source and target using query transform. Map the columns from input schema to output schema inside the query transform.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 22: Double click on OHD table. Click on execute process chain before reading and provide the corresponding process chain name which we have created.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 23: Logon to Management console and select administrator. In administrator expand SAP Connections and select RFC Server Interface and select the corresponding RFC connection and click on start.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 24: At BW side enter T-code as SM59 and select the corresponding RFC in TCP/IP connections.

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 25: Click on connection test. If connection test is successful then execute the job in BODS.

/wp-content/uploads/2014/12/1_jpg_601769.png

/wp-content/uploads/2014/12/1_jpg_601769.png

Step 26: After the job is executed we can see that BODS job triggers the process chain.

/wp-content/uploads/2014/12/1_jpg_601769.png

/wp-content/uploads/2014/12/1_jpg_601769.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply