BusinessObjects Board

Issue to produce yesterday date in Universe with Hive

building semantic layer
#1

Hi,
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

Any ideas

ash0550 :canada: (BOB member since 2011-09-12)

#2

Hi there,

Did you define your dimension as Data Type = Date?

Did you include another object in your query?

Can you share the SQL from your webi report?

jemstar :ireland: (BOB member since 2006-03-30)

#3

Did you define your dimension as Data Type = Date?
Yes

Did you include another object in your query?
Yes

Can you share the SQL from your webi report?

Select * from Table A where A.calendar_date=date_add(current_date(),1);

ash0550 :canada: (BOB member since 2011-09-12)

#4

The code below is from Webi? i.e. when you click View Script

Select * from Table A where A.calendar_date=date_add(current_date(),1);

jemstar :ireland: (BOB member since 2006-03-30)

#5

yes, i amusing the same condition to filter at my dfx and when i try to build a query in the IDT this is the SQL

ash0550 :canada: (BOB member since 2011-09-12)