INFORMATION DESIGN TOOL -IDT
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
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.