Skip to Content
S S

Consume HANA Calculation View from Remote HANA system in SAP BW on HANA

Hello Experts,

I need to consume HANA Views in SAP BW and combine them in Composite Provider with BW Cube.

Situation is below:

HANA Views are on different HANA database – HB1

SAP BW on HANA is on different HANA Database – HB2

So, could you please share how I can consume HANA views from Remote HANA system in BW system and combine then in Composite Provider?

Do, I need to persist data of HANA View in SAP BW before I could combine it with Cube?

SAP BW = 7.4, SP 17

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 27, 2019 at 11:35 AM

    SDI HANA Adapter allows you to create a virtual table which pointing to remote database (HDB in your case).

    So once you installed HAAN provider in data provisioning agent you can create an Open ODS View in BWoH pointing on any table on remote HANA.

    then add it to composite provider ...

    Add a comment
    10|10000 characters needed characters exceeded

    • HI Andrey,

      Thank You for the reply. Before accepting this as answer would lie to confirm if we can we use DB connect to consume the HANA views from Remote HANA in BWoHANA if not by SDi? What are your views on this connection.

      Requirement is to consume HANA view and join it in Composite provider using Open ODS View. Thanks

  • Posted on Jan 23, 2019 at 08:39 AM

    You can use SDI HANA adapter …

    See documentation for it.

    Add a comment
    10|10000 characters needed characters exceeded

    • HI Andrey,

      Thank You for the reply. Before accepting this as answer would lie to confirm if we can we use DB connect to consume the HANA views from Remote HANA in BWoHANA if not by SDi? What are your views on this connection.

      Requirement is to consume HANA view and join it in Composite provider using Open ODS View. Thanks

  • Posted on Jan 16, 2019 at 04:00 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.