Skip to Content

ECC on HANA is Source system and BW on HANA is Target system.


Analytic View (ms/ANV) is in Source ECC on HANA system.

Requirement is this Analytic view output data has to be loaded to DSO of BW system.

temp.PNG

As per the classical approach, the data would be loaded into BW PSA via DB Connect / Data Provisioning options. Then DSO loading from PSA.

If PSA data is not deleted on a regular basis, It will increase the cost of data storage, the downtime for maintenance tasks and performance of the data load.


I have done this requirement using ODP – SAP HANA Information Views approach.

In this ODP approach, Data is directly stored into Target DSO from ECC HANA Information Views using DTP.

It is making PSA Storage and Info Package execution are obsolete 


The first step in the data load, ODP – SAP HANA Information Views Connection (RFC ABAP Connection) need to be created in BW system.

In Connection Parameter, the Target as ECC system Host name has to be mentioned.

Once connection Tests are successful, New RFC Connection created under  ODP – SAP HANA Information Views Folder.


temp.PNG


The ODP – SAP HANA Information Views Connection (RFC ABAP Connection) between the Source and Target system is,

temp.PNG

Data source created in BW System. In the pop-up, ODP Context would be displayed as HANA Information Views.

In Operational Data Provider Text Box, The HANA Information View Name (Analytic View / Calculation View) name has to be mentioned.


temp.PNG


The help pop-up show the list of Information views available in the Source ECC HANA System.

From the list, appropriate Information view has to be selected.

Once Data Source Creation is done, no need to create Info Package.

temp.PNG


BW Target would be either Classic DSO / Advanced DSO.

Target DSO/ADSO created and Transformation mapping done from ODP Data Source to DSO.

In DTP, ODP – SAP HANA Information Views as Source, Delta Extraction mode won’t be supported. So Extraction mode changed to Full.

Under Parameters of the Data source,

Data Extraction selected as “Directly from Source system. PSA not used (for small amount of data)”


temp.PNG


Ignore the Warning Pop-up “Last change is incompatible with SAP HANA Processing”.

(DTP SAP HANA Execution Processing mode will be disabled)

temp.PNG


DTP Adapter changed to “Extraction from SAP Source system by Operational Data Provisioning”

temp.PNG


Activate the DTP and Execute the DTP execution. After DTP execution completed, DSO data has to be activated.

DSO Output is,

temp.PNG

Data is getting loaded into BW DSO successfully from Source SAP HANA Information Views without PSA Storage and Info package execution.

Your thoughts and comments are welcomed.

Regards,

Muthuram




To report this post you need to login first.

15 Comments

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

  1. Daniel Ray

    Hi muthu,

    how can we use SLT for the classic BW on HANA standard extractors for eg. 2LIS_13_VAITM where its further loaded to hana optimized IC. …I mean if we have BW on HANA, and want to use SLT to extract data to BW using this standard data extractor. Do we need to use webservice to extract data from ECC on HANA to BW on HANA using SLT.

    Can we use your above process to do this ? Please advice.

    Thanks

    DR

    (0) 
    1. Muthuram Shanmugavel Post author

      Hi Daniel,

      Sorry, I have not worked in this scenario.

      From My Learning, What I understand is,

      Using ODP-SLT approach, We can extract ECC Tables to BW.

      But I don’t know How to use SLT to extract data to BW using this standard data extractor.

      This document might helpful for you.

      Transferring Data from SLT Using Web Service – Modeling – SAP Library

      http://sapassets.edgesuite.net/sapcom/docs/2015/07/62c8dbf4-5a7c-0010-82c7-eda71af511fa.pdf

      Regards,

      Muthuram

      (0) 
      1. Daniel Ray

        I got another reply from Martin Grob that we can’t use LO datasource’s through SLT replication for BW on HANA. Well how about , we can still go use the LO extractors through SLT to a HANA Info view’s through Data services designer, and replicate these views to BW and use a Virtual provider on top of it with BW MD, and use it in BW bex reporting. Are you aware of this ?

        My intention is use the existing functionality of the standard SAP delivered ECC LO extractors to HANA. I don’t think we need to fill setup tables and all as this can be controlled through HANA replication. for eg. 2lis_13_VDHDR to HANA. How do we do that ?

        Thanks

        DR

        (0) 
  2. Alexander Zlobin

    Hi Muthu!

    I’ve SDA connection in BW from ERP system. I have DB connect source system in BW  ( on SDA connect).In this system I can create datasource based on calculation view 

    I can do this using ODP. What advantages/ disadvantages have this two approaches   ?

    Regards

    AZ

    (0) 
    1. Muthuram Shanmugavel Post author

      Hi Alexander,

      Using ODP,

      Target BW system connected to Source ECC System via RFC Connection.

      Using SDA,

      Target BW System connected to Source HANA System using SAP HANA Source System (DB Connection).

      If We take Data Transfer as a factor,

      In ODP,

      Data will me moved from Source HANA DB –> ECC

                                            ECC –> BW

                                            BW –> Target HANA DB.

      In SDA,

      Data will be moved from simply Source HANA DB to Target HANA DB without

      Application Server Intervention.

      If We want to create Virtual Data warehouse, SDA is most welcomed.

      Using SDA Connection,

      We can create Open ODS Views in Target BW on Source HANA Views.

      Reference: https://open.sap.com/courses/bwhana1-1/items/2tP65VpqDpx1X4k1kQ9qW1

      temp.PNG

                                      

      Regards,

      Muthuram

      (0) 
  3. glen spalding

    hi

    Data Extraction selected as “Directly from Source system. PSA not used (for small amount of data)”


    using this setting, were you able to optimize the DTP for HANA processing?

    (0) 
    1. Muthuram Shanmugavel Post author

      Hi Glen,

      No. I am not able to optimize for HANA Processing.

      So I continued without selection “SAP HANA Execution” Option.

      temp.PNG

      Regards,

      Muthuram

      (0) 
  4. siva ramalingam

    hi
    We are in BW 7.5 SP3 and while replicating datasrc using ODP as the source system connector, in BW while replicating the datasource getting the below error.
    ————————
    Error while saving DataSource 0INDUSTRY_TEXT_0001 xxxCLNT060
    No fields were supplied

    Source system xxxCLNT060: metadata upload with errors
    Message no. RSDS554
    —————————–
    Any thoughts ???

    (0) 
  5. Abdullah Shareef Mohammed

    Hi Muthuram,

    I was about to make HANA -BW Connection, i followed the above steps provided.

    I have created RFC Connection with ECC Application Host Name, Not with ECC HANA Studio Host Name.

    It asked for the Source System Type and Release –Don’t know what to be mentioned, However i have given some name as it says it starts from S.

    After that I am not able to get Views present in HANA Studio.

    Please let me know, is there anything missing in authentication?

    Thanks
    Abdullah

    (0) 

Leave a Reply