Passing multi-value input parameter from Calculation View to Table Function in SAP HANA – step by step guide

SAP HANA Studio, SAP BW/4HANA, SAP HANA, BW SAP HANA Modeling Tools (Eclipse)

Introduction I demonstrated how to create Table Functions (TF) in SAP HANA XS Classic. One of the TF disadvantage, which I mentioned there was the fact, that they are not supporting multi-value input parameters – and this is official: Personally I think this is quite a big limitation, because when some functionality cannot be covered […]

Continue reading


Analysis of Memory Management & Host/Resource Utilization Statistics in BW ON HANA and above

BW SAP HANA Data Warehousing, SAP BW, SAP HANA, SAP BW/4HANA, SAP HANA Studio

Many a times users of SAP face performance issue on the system which in turn impact their daily tasks and business. One of the common cause behind such performance issues can be less efficient memory management analysis or improper load distribution which leads to high host/resource utilization. I am going to write series of blog […]

Continue reading


SAP Analytics Cloud: Live Data Connection to SAP BW/4HANA Using CORS and SSO

SAP Analytics Cloud, SAP BW/4HANA

This blog post will cover the usage of the direct live data connection in SAP Analytics Cloud to SAP BW/4HANA. Architecture of live data without a reverse proxy but using CORS SSO with SAML using the direct connectivity with Azure AD and SAP Cloud Platform Identity Authentication Service (IAS) Architecture without a reverse proxy We […]

Continue reading


Removing invalid and non-printable characters in HANA based BW transformation

SAP BW/4HANA, HANA SQLScript

Most customers know the problem that invalid characters can be found in data records. Data load or DSO activation for char type InfoObjects can fail due to permitted or non-printable characters in BW. There exist several solutions for this problem. Some customer uses function module calls in ABAP transformations for example RSKC_CHAVL_OF_IOBJ_CHECK or RSKC_ALLOWED_CHAR_GET. Other […]

Continue reading