Skip to Content

Step by step BW Extraction process using SAP BODS

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.

Process.gif

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
You must be Logged on to comment or reply to a post.