Suppose you want to access two SAP Datasphere spaces using the same SQL user, how do you create such a user? That’s what we will go through in this blog post. As an example, we have two spaces as the below screenshot shows. We will create a SQL user that can access both of these […]
sql
SQL Scripts in SAP HANA
One of the best techniques to achieve code-to-data paradigm, allow developer to write more complex logic which is not possible with simple views in HANA. This helps us to squeeze the best performance out of HANA DB. This is DB programming language. SQL script is a collection of extensions to SQL (DDL. DML, DQL, DCL). […]
5 shades of input parameter types in calculation views
Introduction Anyone who has made a jump into the development of HANA native objects will come across graphical Calculation Views (CV) very soon. On the one hand, they offer easy handling because they work with very few basic elements (projection, union, join, aggregation and ranking). On the other hand, they offer high processing speed because […]