Till now in our project we were using SAP HANA Native for creating views, which were then consumed by Analysis For Office (AFO) directly.
Now we may plan to expose all these view through BW4HANA system. And now I'm wondering what is the best way of doing that. My initial plan was following:
<em>HANA View</em> -> <em>Composite Provider</em> -> <em>Query </em>-> <em>AFO</em>This seem to be working fine, however I noticed that there is also possibility to consume HANA Views using Open ODS Views.
The differences (which I see) for consuming calculation views between Composite Provider and Open ODS view which I discover for this kind of implementation are: