Hi Experts.
My requirement is to update the value of days field to 1 if it is 0.
example : here when day 1 is June 30 and day 2 is june 29 then days_between gives -1 and in the below first select logic I will get DAYS as 0. And in the second sel...
Hi Experts,
My HANA DB RELEASE : 1.00.122.22..
As per the note tying to add hint
WITH HINT (NO_CS_PROJECT, NO_USE_HEX_PLAN);
but getting an error as Invalid Hint when using NO_USE_HEX_PLAN ...
Hi Experts,
HANA DB version 1.0
BW Version 7.4 SP16
Q1) Please clarify on the numeric overflow issue with the following case statement which is written in AMDP procedure in BW transformation.
FIELD3 NVARCHAR(4) - VALUE 003
...
Hi Experts,
Please help me with how to loop the records and append new records to the output table in table function. I want to use this table function in Calculation view thats why not going with procedure.
My Requirement : I need to generate du...
Hello Experts,
Please advise the way for this problem.
This is related to Graphical Calculation view and procedure.
1) I have 2 data sources A and B both have same structure. I have to combine this data and filter out the records based on one condi...
Thanks a ton to both of you for the quick solutions. Could you please tell me is there a way to implement the logic in 2nd and 3rd select instead of 1st select. Apart from 0 all other values to be allowed i.e both positive and negative . This stateme...
Hi Venkat, mateuszadamus Thanks for your reply.a) The error should be Divide by Zero but why it is showing numeric overflow.so trying to know why numeric overflow error message?
Hi Florian ,Thank you for the reply, we are using HANA 2.0 SP01.If possible please provide a link or example for XS Advanced passing tabular input parameters to table functions within calc. views
Hi Florian, it is working if I remove single quotes for input parameter and by adding the DATE function.
Below statement is working good.
if(daysbetween(DATE("0DUEDATE"), DATE($$IP_DATE$$)) > 100, '100','')
Thank you for helping me to fix the ...