How to use sysdate/currentdate in Universe pointing to DB2

building semantic layer
1

Hello friends I want to create new objects like currentdate,current year,previous year,last week ,etc. My universe is connected to DB2 database. Can you tell me how to use current date in Universe?.
I have created a new class and in select statement i typed current date, but it gives me error saying table name shld be given. ANy help/ideas friends?
Thanks a ton,
Toby

toblerone65 (BOB member since 2009-08-21)

2

This has been discussed many times…

Such an object will not parse as it does not reference any table/view.
But do not dispair, such an object used in conjunction with “regular” universe objects will work just fine when creating a report, try it out :mrgreen:

Andreas :de: (BOB member since 2002-06-20)

3

thank you so much for the quick response:-), so shall i just use some random table name? or Object name?. For example, table1.current date?
Thanks again

toblerone65 (BOB member since 2009-08-21)

4

NO, do not use any table name. Again the object using CURRENT DATE in the SELECT part will not parse, that is OK.
When you create a report and use this object in conjunction with a “normal” universe object everything will be fine. Again, try it out.

Andreas :de: (BOB member since 2002-06-20)

5

Works like charm:-), thanks a ton!

toblerone65 (BOB member since 2009-08-21)