INFORMATION DESIGN TOOL -IDT

[Former Member]

Hi All

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

Information Design Tool 4.1

Build: 14.1.6.1702

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

Ade

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Many thanks

Best Regards

Ade