Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A


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


Former Member
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question