BusinessObjects Board

Current Date Object in BO Designer (Teradata)

building semantic layer
#1

I’m using BO XIR2 and Teradata. I need to create an object which will return current date. The below queries work in teradata, but when I try to create a date object with definition “date” or “current_date” in BO universe designer, it doesn’t work.

select date

or

select current_date

Appreciate if someone could help.

gan_j (BOB member since 2007-02-19)

#2

Hi, this question is covered in the Designer FAQ on this post. Basically you can ignore the parse error and the object will work as long as it’s used with at least one regular table-based object.

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

#3

Thanks a lot for your response.

gan_j (BOB member since 2007-02-19)

#4

This will work, I already tested using date functions with teradata as source. You can also use other date manipulations. Just ignore the errors you encounter in designer.

armel9979 (BOB member since 2008-09-27)