A very common question, and addressed to some extent here:
https://blogs.saphana.com/2015/07/06/sap-hana-replace-bw-hint-no/
In my view this kind of question doesn't have single "correct" answer, because it depends on several factors such as whether the customer already has a BW system in place, whether there are other source systems apart from S/4 HANA, what is the importance of slowly changing dimensions, what is the requirement for inventory data. All of those factors tilt the playing field towards BW. Do you need text analysis, do you need Hadoop integration, do you need real-time and do you need spatial/series data - those are pluses for native HANA.
Then there is a grey area given that BW and native HANA are getting closely integrated, and this will lead to hybrid solutions with some parts in BW and others in native.
Taking a step back, everything you can do in classic BW, you could also do in native Oracle/SQL Server. In fact the classical BW system itself was essentially an application built on traditional RDBMS. People could have done all their data warehousing in plain Oracle and cut out BW entirely. But many customers still went for BW because of the way it makes things like governance, SCDs and inventory easier to model and handle which are important from a data warehousing standpoint.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.