Hi,
I am using a HANA view as my source that accepts 1 Input Parameter. I used the 'Generate Select SQL' in HANA and used the same select statement in my SQL transform in BODS. When I am hard coding the value, the SQL transform works fine. But When I am trying to pass the value through a global variable, BODS throws the error: 'invalid Number not a valid number string'. Please help.