IDT 4.0, Data type issue while complete integrity check

[Former Member]

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.

[Former Member]

Hi Pawan,

What is your backend datanase?

I think you can't use database functions on IDT like plad,to_char,extact etc.

Please check whether these functions are available on IDT or not.

Also you dont have to add database name like you are adding for DBName.DBSOURCE."IssueDate"

Just add IssueDate instead.

I hope you got my point.

Thanks,

Swapnil