Skip to Content
avatar image
Former Member


Hi All

I’m trying to create a new set on universes using the following

Information Design Tool 4.1


Version: 4.1 Support Pack 6

Within this universe I have a large selection of Dates which I’d like to expose, the underlying dimensions have the fields as “DATE” data type

a refresh of the data foundation has since change them to “VARCHAR” and now each of the dates is failing an integrity check.

How do I get to keep the “DATE” data type through to the universe layer?

Many thanks in advance

Best Regards


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 03, 2015 at 11:20 AM

    SQL Server's newish date datatype isn't supporting in XI3 and this may well have carried over into BO4.

    Replacing table.col with cast(table.col as datetime) would fix it, as would changing the data type in the database itself until SAP brings a patch level out that supports the new data type (note that they don't support varchar(max) fields either.

    Add comment
    10|10000 characters needed characters exceeded