Hi Gurus,
In Calculation view, I have a parameter IP_CALYEAR which of NVARCHAR (4) with input value 2019.
Would like to do some calculations as 2019 - 1 or 2019 + 1.
If I convert them then I am getting error as "Invalid Number" as shown in the ...
Hi All,
I would like to add this filter expression to the projection node in calculation view by using add months SQL funtion like this. This is possible if I change the language to SQL
"CAL_YR_MTH" >= add_months(to_date('$IP_DATE_TO$','YY...
Hi All,
I have a query regarding cost centre reporting as header report which displays as output YTD. This query has got inputs as company date and a date (input ready variable.) Using this date variable thru a customer exit report displays the YTD...
Dear All,
Extractor "0COSTELMNT_TEXT" delivering old or wrong texts.
For example 0COSTELMNT or 0GL_ACCOUNT 100000 hast got text as "Travel expenses - Other travel expenses" but with the extractor I am getting "travel cost for private car".
If I...
Hi All,
I am trying to display messages in the sql console by using SQLSCRIPT_PRINT in HANA version 2.00.031.00.. Program is executing sucessfully but no messages are displayed in the output.
I remember in Oracle we have to use SET SERVEROUTPUT O...
Thanks for your replyCAL_YR_MTH format is YYYYMM eg 201801 , 201906.IP_DATE_TO format is YYYYMMDDJust wanna know how I can write the same logic with Column engine expression