Skip to Content
Former Member
Jun 09, 2016 at 03:45 PM

Currency Conversion in SQL Scripted view - features disabled ?


Hi ,

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:




Untitled2.png (54.5 kB)
Untitled.png (54.8 kB)