Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question