We are using live connection for SAP Analytic Cloud (SAC) on S/4 HANA (this has a embedded BW component).
Question :
Is using CDS views better or using BW query built on BW objects like composite provider better?
This is mainly for finance data , finance group reporting , core finance journal items, SKF headcount and Production Volumes. So data volume is huge. Merging of data from different sources is required.
Options we were pondering on
1. Build custom CDS view choosing underlying tables to project only required fields. We have seen that master data and hierarchies are sometimes an issue here.
2. Use standard CDS views and build custom CDS projections on these views. This approach we have found challenges as group reporting standard views are complex to change in above level.
3. Build ADSO as a DSO and build a CDS view over the same and SAC consumes data from here. Can CDS view be made on a ADSO like Infocube?
4. Whole flow in Embedded BW exposing via BW query to SAP analytics Cloud.
Cleo