Skip to Content
Oct 17, 2018 at 09:03 AM

Usage of Open ODS View vs Composite Provider while consuming HANA Views.

4052 Views Last edit Oct 17, 2018 at 09:04 AM 2 rev

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:

  • In Composite Provider we can UNION/JOIN multiple data sources which makes it more flexible
  • In Composite Provider there is a possibility to map input parameters from HANA View

  1. So if the Composite Provider is more flexible than Open ODS View, then what is the use case for consuming HANA Views via Open ODS View ?
  2. Considering I have a calculation view without input parameters, which InfoProvider should I use?