So I am trying to create a filter for a date field in my universe and the DB is Hive.
I wrote this formala where yeterdaysdate=date_add(current_date(),-1) . When i parse it in Universe it works and when i check the values it gives me the right date but when i bring into queries on IDT or to a filter on webi where I use object from query and effectivedate=yesterdaysdate it throws an error saying
Function Sequence Error.
I tried to copy the query and paste it on my DB tool and it runs fine , but it doesnt in webi
ash0550 (BOB member since 2011-09-12)