Skip to Content

Hi,
If you have a still an SAP BW that is not running on HANA, you can even get the data from there into ADP.
Remember that ADP uses SAP HANA SDI to connect to different sources, and there is a BW connector there.

Mind SAP Note: 1968598 – Mass data in Bex queries: Options and Workarounds which says: “Bex queries are not made for mass data extraction.”

Do not try to load millions of records when connecting to a BW query!

If your BW is on HANA, you can connect to the HANA database and skip the slow BW Query layer. (ABAP application server). You can generate HANA views for your queries (RS2HANA)

Take a look at the video!
Cheers,
Miguel

To report this post you need to login first.

2 Comments

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

  1. Kuldeep Jain

    Hi Miguel,

    You have given new Idea for replacing ADP based slow Bex queries to sap Hana data provisioning agent.

    Can you make your video more clear and elaborative? Voice and steps are not clear enough to understand.

    Thanks for your contribution to the community.

    KD Jain

     

    (0) 
  2. Miguel Peredo Zurcher Post author

    Hi,

    Here I’m just showing how to get data from a BEx query using ADP. In the context of self-service BI and if there is not much data to be transferred this adds value for the end users (controllers, etc). They can get data from BW queries to ADP and then combine it with other sources for example.

     

    I mention that if you have BW on HANA (and the correct licenses) or if you have BW/4 HANA, you do not need to connect to the query in the application server. You can ask the system to generate a HANA view, and connect to that view. (Which is way faster but not all query features are supported)

    I did not understand what you mean by this: “You have given new Idea for replacing ADP based slow Bex queries to sap Hana data provisioning agent”

    Miguel

    (0) 

Leave a Reply