Skip to Content

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.

To report this post you need to login first.

2 Comments

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

  1. Ahalya Inturi

    Hi

    Very good document.. helpful for knowing how to extract data from BW.

    please post more documents on basics  of BW extraction process using BODS, if possible…. let me know the links of your post on the same…….. thanks

    (0) 

Leave a Reply