Hi,
Please can you tell me if you know how to resolve this problem.
I'm using Business Objects to query a Teradata datawarehouse. Some date fields are declared as Timestamp datatypes so the appropriate universe objects are declared as type Date and are simply selects from the db columns (eg CUSTOMER_ORDERS.DELIVERY_TM). This approach works fine when the objects are used as a Result Object. The time element can be shown by formatting the cell correctly. However an error occurs when I try to use these same objects as Condition Objects. When I try to do this I get the error...
[NCR][Teradata RDBMS] Invalid operation on an ANSI Datetime or Interval value. -5407
The only solution I've found seems to be changing the object select statement to "cast(CUSTOMER_ORDERS.DELIVERY_TM as date)" for use as a Condition, however this strips the time element which is no good when used as a Result Object. So I've had to create two objects, one for use as a Result Object and one for use as a Condition Object. Is there a way to get the best of both worlds from a single object?
Many Thanks, Joobie
Please can you tell me if you know how to resolve this problem.
I'm using Business Objects to query a Teradata datawarehouse. Some date fields are declared as Timestamp datatypes so the appropriate universe objects are declared as type Date and are simply selects from the db columns (eg CUSTOMER_ORDERS.DELIVERY_TM). This approach works fine when the objects are used as a Result Object. The time element can be shown by formatting the cell correctly. However an error occurs when I try to use these same objects as Condition Objects. When I try to do this I get the error...
[NCR][Teradata RDBMS] Invalid operation on an ANSI Datetime or Interval value. -5407
The only solution I've found seems to be changing the object select statement to "cast(CUSTOMER_ORDERS.DELIVERY_TM as date)" for use as a Condition, however this strips the time element which is no good when used as a Result Object. So I've had to create two objects, one for use as a Result Object and one for use as a Condition Object. Is there a way to get the best of both worlds from a single object?
Many Thanks, Joobie