SAP BW/4HANA - An excellent choice for data warehousing
Use Cases and Deployment Scope
We use SAP BW/4HANA as our one stop global and holistic data warehousing platform for business analytics that drive business decisions. It is also used for some financial planning use cases to seamlessly blend actuals and planning data to predict and project future outcomes which can be easily analyzed by the business in Analysis for Office and SAP Analytics cloud tools. The embedded BPC 11 component within SAP BW/4HANA is also used for month end financial consolidation as part of the financial close process. SAP BW/4HANA helps us consolidate and harmonize business data from multiple SAP and Non-SAP systems to help better manage and organize data in one central repository that ensure data integrity and identical results across various lines of business globally. I personally have been working with BW and BPC for over 25 years now right since its inception in 1998 and have seen the product evolve and mature immensely over the years and hence big fan of this platform.
Pros
- Very strong out of the box integration with core SAP ERP platforms including S/4 as well ability to integrate non SAP sources of data. The additional bonus is the pre-delivered SAP built business content to jump start analytics projects and reduce time to value significantly.
- Very well thought out data modeling, integration and monitoring tools besides strong ETL capabilities to transform and enrich business data.
- Strong integration with the other SAP cloud offerings such as SAP Analytics Cloud and SAP Datasphere make it an even more valuable platform. Not to mention the Excel friendly Analysis for Office tool that every business user loves and is very easy to adopt and deploy. The performance on HANA is also excellent to manage huge volumes of data as well as access it quickly for planning and analytics use cases.
Cons
- It would be nice to see tools available within SAP BW/4HANA for cross platform esp. other SAP systems integration from a data extraction and scheduling standpoint. This is to ensure BW data stays consistent with its sources and is refreshed only after completion of core business process activities in its source systems. This is also relevant from a SAC and Datasphere integration standpoint for data being fed from SAP BW/4HANA as these platforms currently only support time based scheduling options with no dependencies possible against SAP BW/4HANA processes. Currently most companies employ an external third party scheduling tool to manage this.
- With the advent of Analysis for Office the ability to publish AFO workbooks has been lost directly from the SAP BW/4HANA platform unlike its BEx Analyzer predecessor which had the Broadcaster. The use of BO Platform is not an ideal use case for this functionality which is very basic in its scope.
- In this age of AI would be nice to see functionality introduced for AI co-pilots like Joule to speed by data modeling and scheduling activities as well as a natural language based querying options within AFO.
Likelihood to Recommend
SAP BW/4HANA is certainly an excellent choice when it comes to setting up a data warehousing platform within a landscape of existing SAP systems ecosystem for realizing quick time to value and ROI over the long term. Many non-SAP analytics tools such as Power BI , Qlik also now offer connectors to leverage SAP BW/4HANA data as additional options to deploy third party visualization tools which make it a more open ended platform of choice.
But with the future roadmap of SAP and industry in general being focused towards cloud based offerings (SAC and Datasphere) infused with AI capabilities one has to make a judicious choice among these depending on the use case, capabilities of platforms and existing systems landscape and the overall long term IT strategy. SAP BW/4HANA may not be a good platform of choice if starting a native greenfield data warehousing implementation with cloud first approach which would require data integration across SAP and Non-SAP sources and one should consider other SAP cloud offerings which however still have some time to reach a level of maturity as SAP BW/4HANA has reached over the years.
