Joining multiple views from different HANA systems

[former_member674890]

Hi

We are on Business suite on HANA environment ;that means ECC , CRM , BW on different HANA DB / instances.

For reporting ; i would like to combine calculation / analytical views from these different  systems.

Any thoughts on approach?

Thanks in advance

[sagarjoshi]

If you are looking at something like HANA Live from multiple systems then check following

But if you are really looking at multiple HANA systems and remote connectivity options then may be links below helps out. There are bunch of articles on Cross-System reporting/SDA so may be you can do some research.

I have not tried this so can't give real hands-on feedback

Smart Data Access: Connecting multiple SAP HANA... | SAP HANA

[Former Member]

Good question, I did not tried, but it might be possible I think, just try to built your analytic view with tables belongs to different HANA systems.

if you need a guide for creating views, use this guide:SAP HANA Modeling Guide | SAP HANA