Skip to Content
3
Jan 15, 2019 at 08:57 AM

BW/4HANA modeling scenarios

1920 Views Last edit Jan 15, 2019 at 09:01 AM 2 rev

Hello,

we are using BW/4HANA and I am wondering which approach is better for modelling (data transformation, complex calculation):

  1. Use only BW objects (Data Sources, Advanced Data Store Objects, Composite Provider) and add complex logic in ABAP (start / end / expert routine on transformations);
  2. Use BW objects but add complex logic in HANA Calculation View & Table Functions – complicated data transformation and calculation would be done using SQL.

Most probably sometimes ABAP usage is necessary, but personally I prefer second option, where the flow is built as following:

When I compare ABAP routines and SQL views or table functions, in my opinion SQL objects are easier to write, to debug, to understand for support team and to document. When I think of performance, I bet HANA views would be faster, but probably in some cases ABAP routines are performing better.

Looking forward for some other opinions.

For reporting we are using Analysis for Office and 3rd party tool.

SAP R3 is the source system, but business content can’t be used.

Attachments

flow.png (12.5 kB)