HANA Input Parameters with texts

Introduction   On one hand HANA Variables are easy to use and, mostly, perform well on well-modeled HANA views. There are always exceptions with big tables where join happens at a very granular level, then it is smarter to use Input Parameters, mapped through nested layers of HANA views instead of just a Variable in the topmost one. Performance-wise you can achieve a saving of 20-50% (personal observations), but then…