Skip to Content
avatar image
Former Member

Incompatible objects while parsing in universe designer 4.0

Hie Guys,

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.

date.jpg (176.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 18, 2013 at 01:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 18, 2013 at 02:17 PM

    Hi Jeevan,

    In order to merge two objects, fundamental criteria is both of them should be of same data type. So in this since both are of different data type, you may not get the desired output.

    Thanks

    Raghu

    Add comment
    10|10000 characters needed characters exceeded