I think you can only use the prompt or string character on the placeholder. What I found out as a workaround is to keep the prompt definition in IDT as string. After the IDT sql has been validated successfully, I go and change the HANA parameter, i...
I had a similar experience. What I found out is a workaround. In HANA, I made the parameter datatype as NVARCHAR, then in IDT, it will validate successful (I tried changing IDT datatype but I think it only allows string). Once validated, I go back...