We are trying to do currency conversion on measures in a SQL scripted calculation view in HANA (SPS10 and SPS11). We have all the required tables (TCURR , TCURC etc) in the required schema.
The Decimal shift and Currency options are disabled in SQL scripted HANA view where as I am able to see them in Graphical Calculation view . Is there any parameter I have to turn on to enable these options in SQL scripted view? Please find below the screenshots of the issue I am facing. Any thoughts?
On a measure present in Scripted view :
In Graphical view: