Hi All,
My question here is on architecture design.
Consider the below points:
1. There is an architecture where S4HANA and BW4HANA both exist.
2. Most reporting requirements require historical reporting as well.
3. The SAC Standard content by default connect to S4HANA CDS views.
So, in this scenario, if we want to deliver one of the standard SAC story, would we re-model the architecture to look like the below:
A. Live Data
Standard CDS --> Custom Datasource in BW4HANA --> Open ODS --> Composite Provider --> BW query --> Custom SAC Model (Copied from the standard SAC model) --> Custom SAC Story (Copied from standard SAC story)
B Import Data
Standard CDS --> Custom Datasource in BW4HANA --> Open ODS --> Composite Provider --> BW query --> Custom SAC Model (Copied from the standard SAC model) --> Custom SAC Story (Copied from standard SAC story)
Also, please correct me if I am wrong here about using Open ODS in both Live and Import. I guess both Open ODS and aDSO can be used depending on whether data needs to be persisted in BW but considering we need to report on History as well, would aDSO be a better option in either or both of these scenario A & B?
Looking forward to your answers.
Regards,
Shyam