SAP HANA scripted Calc View syntax

[Former Member]

Hi HANA experts,

My scenario is as follows:

Currently, I have a calculated column with the following logic:

IF ( now() > daydate(string(component(now(),1))+'1010'), daydate(string(component(now(),1))+'1010'),

IF ( now() > daydate(string(component(now(),1))+'0710'), daydate(string(component(now(),1))+'0710'),

IF ( now() > daydate(string(component(now(),1))+'0410'), daydate(string(component(now(),1))+'0410'),

IF ( now() > daydate(string(component(now(),1))+'0110'), daydate(string(component(now(),1))+'0110'),

daydate(string(component(now(),1)-1)+'1010') ) ) ) )

I want to create a scripted calc view with the same such logic in a column.

What is the proper syntax to do so?

I have already tried using case statements and if statements using common sql syntax but can't seem to get it to work

Thanks in advance!

John

[varma_narayana]

Hi John,

Can you try the syntax like this inside the scripted calculation view:

Note: We have to use CASE..THEN.. END instead of IF

Example below:

SELECT CASE WHEN month(now()) = '12'

       THEN 'DEC'

       WHEN month(now()) =  '11'

       Then 'NOV'

       ELSE

            'Other'

       END  as V_monthname  -- result variable

       from DUMMY;

Let me know if you have see any concerns.

best regards,

Varma

[former_member226419]

Hi,

Can you please share your code?

BR

Sumeet