We currently have problems with the || -syntax used by HANA in B1UP macros. The problem occurs when you're trying to use || for example in the Set();-function like this:
SET($[$108.0.0]|SQL: SELECT 'HELLO' || 'WORLD' FROM DUMMY);
The issue is that | is used as a paramater sperator in the macro language. This leads to the macro system detecting the | as a part of the macro language. The line above will actually be split into:
SET($[$108.0.0]|SQL: SELECT 'HELLO'
| 'WORLD' FROM DUMMY);
By the macro system which does not make any sense in the macro language.
Currently we can't find a good solution to curb the issue as we cannot change the macro languages use of | without breaking all macros.
We recommend to use the CONCAT -function instead of || like this:
SET($[$108.0.0]|SQL: SELECT CONCAT('HELLO', 'WORLD') FROM DUMMY);