How to Parse the Condition in Universe?

building semantic layer
1

I Tried to create a Condition Filter in the universe.My Requirement is to
Limits date to last 365 days.I used the following formula at the where condition but it is not parsing.I am using DB2 database.

DATEDIFF(CURDATE(), Incdi.XIMDAT)<365.

Thanks in Advance for Helping me .

Pooja :frowning: :frowning:

ktm :us: (BOB member since 2008-11-12)

2

And the error message is?

Please, always provide as much information as possible. Don’t let us guess.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Its the old current date / sysdate not referencing a table syndrome, did you try searching this hads been discussed Many, many, many times… :wink: .

Try running it in your report, it will work…

Mak 1 :uk: (BOB member since 2005-01-06)

4

I had similar problem, even tough it dosent parse it would work in your report:-)

toblerone65 (BOB member since 2009-08-21)

5

The Error are given Below:

Parse failed:Exception:DBD,[IBM] [iseries Access ODBC Driver][DB2 UDB] SQL 0204- DATEDIFF is LIBL type * not found

I save the condition and try to run at web I also it is not woking at the report Level As well.

Thank You
Pooja

ktm :us: (BOB member since 2008-11-12)

6

Well a simple search on Google showed me that datediff is not DB2 syntax, have a look at the Day function…

Mak 1 :uk: (BOB member since 2005-01-06)

7

Thanks for your reply.Can you please suggest me what should i use instead of DateDiff?

Thank You
Pooja

ktm :us: (BOB member since 2008-11-12)

8

You might want to bookmark this page if you’re doing work with DB2 and don’t know the functions…

Dave Rathbun :us: (BOB member since 2002-06-06)

9

In addition, I told you…:slight_smile:

Mak 1 :uk: (BOB member since 2005-01-06)