Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Hi Experts,

In the below I given a step by step process to extract data from SAP BW(Cube) through OHD(Open Hub Destination) using SAP BODS. It is not a detailed  document, but summarized.

As transaction source I used CSV.

Overview of Practice:

    1. Should create OHD.

     2. OHD will create on top of Cube.

     3. So, Should create Cube also.

     4. Cube is the combination of Characteristics & Key Figures under respective catalogues.

     5. For Characteristics & Key Figures we should contain appropriate source for sustained steps.

     6. Create Source(in our case it is file(.csv)).

Step by Step procedure:

     1. Logical System LS_BWDI

     2. RFC Destination

Program ID: DI_SOURCE

Logical System: LS_BWDI

     3. Configure RFC Destination under DS Management Console and test it on BW

     4. Source system of File type created(LS_BWDI)

     5. Source file created on Desktop.

     6. Info Area created under Info Objects(ZIA_SALES-Info Area for Sales)

     7. InfoObject catalogues created,

ZCTLG_CHA(Characteristics)

ZCTLG_KEY(Fey Figures)

     8. InfoObjects created for respective Catalogues,

Z_CST - CUSTOMER

Z_MT - MATERIAL     0CURRENCY - CURRENCY

Z_REV - REVENUE    0UNIT - UNIT OF MEASURE

     9. Create InfoCube(ZIC_STRAN) under Infoprovider on our InfoArea(ZIA_SALES),

Configure Charactaristics & Key Figures, and units will com automatically.

     10. Create Application Component(ZAC_BALA) under DataSources tab.

     11. Create DataSource(ZDS_STRANS) on (ZAC_BALA) under DataSources.

     12. Create Info Package(ZIP_STRANS) under DataSource(ZDS_STRANS).

     13. Create Transformation (ZTR_STRANS) under InfoProvider, Under Cube(ZIC_STRAN).

     14. Create Data Transfer Process-DTP(ZDTP_STRANS) under InfoProvider, under Cube(ZIC_STRAN).

     15. Check whether data to cube loaded or not.

     16. Create an OHD (ZOHD_STRA) under on (ZIA_SALES) under Open Hub Destination Tab.

     17. Create Transformation (ZTR_OHD) on ZOHD_STRA.

     18. Create DTP(ZDTP_OHD) which executes the OHD Loading.

     19. Click on Open Hub Destination Tab and create Process Chain(ZPC_STRAN)

Process Variant ZPV_STRAN

     20. Now can import OHD into Local Repository and work on it.

Note: This is my first post in SCN, Please can accept the mistakes.

2 Comments
Labels in this area