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

[former_member190408]

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

[former_member302041 · Accepted solution]

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 ...

[former_member190408 · Accepted solution]

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

[former_member302041]

You can use SDI HANA adapter …

See documentation for it.

[former_member190408]

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

[nora_roch]

Hi,

check out Andrey's answer in

https://answers.sap.com/questions/718912/view-sap-hana-calculation-view-in-sap-bw-on-hana-d.html

Cheers,

Nora

[former_member190408]

Hi Nora,

Thanks for sharing the link. My scenario is different in comparison to what's mentioned in link. I need to connect Native HANA DB with BW on HANA. To my knowledge HANA view consumption via ODP is possible for ABAP source systems..

Can I consume HANA vIew on native HANA in BW via ODP?

Thanks

[former_member199415]

Hello SS

Did you find any update on this topic? I have a similar requirement and I think we can use SAP HANA as source, but that would in turn have to use SDA. The problem is that, I am unable to see any tables / datasources once I create the SAP HANA based source system in BW.