Consuming CDS views in SAP BW
what is the best practice to consume a CDS view in SAP BW?
Example scenario - let's say we have an SRM system with embedded BW running on HANA. We have built some ABAP managed CDS Views on top of the SRM tables. Now we would like to reuse the results of those views in SAP BW - combine it with some other data loaded into BW from other sources, use the BW authorization concept etc.
Andrey Eliseev replied
If CDS view have no input parameters (i.e. it is a common view inside DB, not a table function), you can import it into BW as OpenODS View based on the corresponding view inside HDB and use it for reporting. Then put it into Composite Provider in order to make transformations available (Composite Provider can be the source of a transformation, OpenODS View cannot). In such way you can consume also HANA information views.
But keep in mind, that OpenODS view is like a proxy object to HDB (not an ABAP dictionary), so it doesn't know of changes in its source. You have to keep changes in sync manually.
Another way is a Virtual Provider based on FM (inside FM you can use Dictionary-managed CDS) to work only with ABAP objects, but it looks to cumbersome and unnecessary.