During the course of last 2 years, I’ve conducted SAP HANA performance workshops and reviewed information models at various customers. I encounter similar modeling issues or mistakes almost at all customer projects. The good news is that most of the performance problems can be resolved by making with minor changes to the model.
However it is critical to understand the reasons behind the performance problems consistently observed in the HANA implementations. Here are my observations.
- HANA modelers have pretty good idea on how to build attribute views, analytic views, and calculation views which are part of HANA modeling. However, there is significant gap in the knowledge of using these HANA information views effectively to address the business requirements.
- Some of the HANA modelers do not have data warehousing background and hence lack the knowledge of basic multi-dimensional analytical reporting, which leads to poor solution design.
- Modelers and developers seems to have the knowledge of “what works and what does not work”, but they seem to lack the knowledge “Why it is behaving the way it is behaving”, hence the struggle to apply the knowledge effectively while building the models.
- Finally there is a fundamental flaw in the understanding of Software Development Life Cycle (SDLC). Is performance testing a phase before Go-Live or is it part of unit testing? HANA’s query response is extremely fast for the smaller data set regardless of the modeling approach. This gives a false positive of efficient modeling. The realization of performance issues become visible only in Staging/QA system where models are tested against large data volumes.
As I mentioned earlier most of these problems can be resolved with very little changes. Performance improvements at various customers are
Beverage Major (Before 5mins, after 3sec)
Pension Plan Management Company (Before 30sec, after 3 sec)
Grocery Retailer (Before: 19sec, after: 300ms)
Audit Firm (Before: 19min, after 8secs)
So it is essential to build the model right the first time. So let’s learn to model the right way the very first time.
Join the session to discover the arts and science of tuning HANA models for performance.
Webinar details HDE Webinars | HDE
Nov 12, 2015 / 8:00 – 9:00 AM Pacific, 11:00 – 12:00 PM Eastern (USA), 5:00 PM CET (Germany)
Link to join the “HDE webinar” series: https://sap.na.pgiconnect.com/i800545
Participant Passcode: 110 891 4496
US and Canada: 1-866-312-7353 tel:+18663127353,,,1108914496#
Germany: 0800 588 9331 tel:08005889331,,,1108914496#
UK: 0800 368 0635 tel:08003680635,,,1108914496#
India: 1800 266 0327 tel:18002660327,,,,1108914496#
China: 800 820 8010 tel:8008208010,,,1108914496#
China: 400 613 8112 tel:4006138112,,,1108914496#
See here for dial-in numbers for all the countries.
Add to your calendar/ Meeting request: SAP HANA iFG CALL 124 HDE Webinar – The Art and Science of Tuning HANA Models f.ics