Incompatible objects while parsing in universe designer 4.0
I am working with UDT 4.0 and running across a problem. Basically, what I am trying to do is merge objects from 2 universes in Webi to create a combined report. I have created a derived table containing all the report elements in one of the universe. I want to merge objects from the derived table with the other universe so that I can get the combined report. However, there are 2 objects (start_date & end_date) in the derived table that have been defined as Character data type, while they have been defined as Date data type in the other universe. So, when I click on the object and try to change the data type to Date in UDT, it does not parse (incompatible object message). Should I just change the data type to date and ignore the parsing message? Am I going to get the correct results doing so? How do I go about fixing this issue? I've attached the object properties snapshot below. Thanks.
I will suggest to define both as Date type. Then will need to be of the same datatype for merging..
If your data in the derived table is already char the just create a date object in universe with data type as date using wither To_date or To_char