In traditional data warehouse, real time data analytics is not possible. It is limited by the design consideration or lets say its not designed to be Real time.
SAP HANA is an in-memory database and application platform. What makes it different is the design consideration, which was not in traditional databases. It uses or lets say it stores data (all of it) in In-memory, making mixed used of Columnar and Row storage . The data compression ratio could be as high as 1:10. It allows you to stay away from indexes, materialization and aggregation, which now can be done on the fly.You can run your Analytics and OLTP application on the same instance there by reducing the system landscape complexity and do adhoc analysis .
Traditional Way : –
Limitation in this design :-
- Redundant data at multiple places.
- Reduced speed because of multiple data access from different sources and models.
- No single source of truth.
With SAP HANA: –
- Single source of truth.
- No redundant data
- Less complex landscape and ease of maintenance.
Image courtesy (all right reserved – “Real Time Analytics with SAP HANA “ ) .
As shown in the above diagram, With SAP HANA, the key is pushing as much of the logic execution into the database as possible. Keep all the data intensive logic down in the database as SQL, SQLScript, and HANA Views.
So then the question arises what is S/4 HANA ?
S/4HANA is natively built on SAP HANA with simplified data model, without indices , aggregates and no redundancies. It leverages the multi tenancy functionality of SAP HANA. It can be deployed on premise, cloud or mixed/hybrid . It is natively designed with SAP Fiori offering an integrated user experience .
Frankly speaking, in essence S/4HANA is ‘just’ a new name for the same good old ERP functionality – the difference however is in that ERP can now run on an in-memory database (SAP HANA).
(Image courtesy – http://scn.sap.com/docs/DOC-65111)
So now I have brief idea about SAP HANA and S/4 HANA , what is then SAP Simple Finance ?
SAP Simple Finance is an add-on to ERP, which means it is a standard product developed to work on top of SAP ERP (ECC6.07 to be precise). The official name used to be ‘SAP Simple Finance add-on 2.0 for SAP Business Suite’. The Finance add-on replaces the classic Financials applications in your SAP ERP system. In contrast to accounting in SAP enhancement package 7 for SAP ERP 6.0, Simple Finance comes with a simplified data model. Totals tables and application index tables have been removed and replaced with HANA views with the same technical names. A list can be found at the below table. This means the impact needs to be assessed on your interfaces, your data warehouse, your authorization profiles and potentially your monitoring tools.
If you want to get practical issues and resolutions straight to your inbox, please SUBSCRIBE. We respect your privacy and take protecting it seriously.
If you liked this post, please hit the share button at the left side of your screen.
Thank you very much for your time!!
About the Author: Vinay Singh
Vinay Singh has MBA and BE (CS) degrees and is an SAP HANA/BI architect at Freudenberg Sealing Technology, Germany, working in the SAP Analytics area. He has nearly 10 years of SAP experience in the field of SAP product development and consulting. Before joining Freudenberg, he worked with companies such as SAP Labs, Adobe, and T-systems, which gave him a good mix of product development and consulting experience. He has been an author and coauthor on numerous articles in various journals and has officially reviewed a couple of books on SAP Analytics topics. He is also a visiting faculty at Hochschule Furtwangen University, BW, where he teaches SAP HANA under the SAP UCC program.
Series on SAP HANA
Featured image source: salvadorgimeno.com