IDT 4.0, Data type issue while complete integrity check

[#1]

Hi All,

I am encountering a set of error while processing my universe (developed in IDT 4.O) through Integrity check. All the date fields are highlighted as incorrect data type.Though its the same data type in the database.

Here is the list:

Dimesnsion name	Dimesnsion in Business layer	Data type in Source Database	Data type assigned in IDT
Month Close Date	pad(to_char( Extract (Month from DBName.DBSOURCE.CLOSE_DT)),2,0)	Date	Date
Month Issue Date	lpad(to_char(Extract (MONTH  from  DBName.DBSOURCE."IssueDate")),2,0)	Date	Date
Close Date	DBName.DBSOURCE."IssueDate"	Date	Date
Completed Dt	TO_CHAR(DBName.DBSOURCE.COMPLETED_DT,'DD/MM/YYYY')	Date	Date
Change Date ( test)	MFIVE.DBSOURCE.CHANGE_DT	Date	Date

Please could some one help me to figure out what going wrong here?

I have been checking and changing them to see, but not making any difference .

Many Thanks

[joseph_lara]

Those dims (and calculated columns) with the to_char function should be set to 'String' in the Business Layer since you're converting date to char.