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.
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.
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.