Skip to Content
avatar image
Former Member

#DATA TYPE Error in Business Objects

Hi All,

I've created a WEBI doc which works fine when run in the rich client but once I schedule it from Business Objects, I'm getting a #DATATYPE error in the measure field. I've checked the universe and it is set to the correct data type in there (date). Any ideas?

Thanks

Darren

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 03, 2015 at 01:26 PM

    The data type could have changed in the underlying field - you often see strings showing what purport to be dates but haven't been converted to dates properly.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 01:29 PM

    Hi,

    Can you try with Todate function and check.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 04:14 PM

    Thanks for the suggestion guys but I still couldn't get it working so I had to add the field at universe level instead

    Add comment
    10|10000 characters needed characters exceeded