Skip to Content
avatar image
Former Member

SAP HANA scripted Calc View syntax

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 23, 2014 at 12:34 PM

    Hi,

    Can you please share your code?

    BR

    Sumeet

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2014 at 02:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded