Query using $[USER] changes to the id in the query on SAP b1 on HANA

[Former Member]

Hi, we are using a fs that varies the results acording to the user, in the query we use this WHERE T10.USERID = (SELECT $[USER]), when we save it and open again in the query manager the query changes to WHERE T10.USERID = (SELECT 1), 1 being the user id of manager, anyone have a fix or sugestion??

Regards

[Former Member]

Just a correction we are using from dummy: T10.USERID = (SELECT $[USER] FROM DUMMY)

[Andrzej_HK]

Any idea how to solve it? I have similar issue in ver 10.0. While saving query It shows in Where clause $[USER] but later on when you edit query it returns your UserId