BusinessObjects Board

SYSDATE function

building semantic layer
#1

Hi

I am trying to use sysdate function in an object but when I parse the object it says “Parse failed: Exception DBD, ORA 00903, invalid table name”

object1 = sysdate

Any suggestions?

Cheers

Aussie2582 (BOB member since 2008-04-16)

#2

You can use sysdate but it won’t parse. I assume what you are trying to create is a predefined condition with the syntax you posted?

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

#3

Also, be careful with just using “= sysdate”, that will include comparison to the timestamp too.

You are better off using “= trunc(sysdate)” if you just want to compare to the current date.

#4

Although if you add sys.dual to the universe, and outer join sys.dual.dummy to a char value (any will do) on your main table you can than add the table sys.dual to the object definition (by clicking the tables button, and selecting it) it will then parse. this is especially useful for the older webi versions as they moan that there isn’t a table selected (or if you have an anal testing department who believe that all parsing errors cause issues).

edit :- I quoted the wrong message, whoops.

bourner (BOB member since 2005-01-17)