Greetings. Its Alias.
I have one question. Actually I already post this question but at designer forum.
I am using SQL.
Example I have Order Date field and from this field I want to subtract the date by minus one day or two days or three days, etc.
I got the solution for designer (example):
DATEADD (dd , -3, EPJ_IPMS.dbo.DO_DATA.DO_DATE_D)
But at webi level it does not work.
I also do not understand why at designer and webi level may have different SQL select statement.
Can someone help me please.
Best regards,
Alias