Hello Everyone,

I have a very strange situation here.

I have 2 columns COP Date and Deactivation Date both of which are DATE type in Physical table.

When I map these directly tot he analysis and run the report in OBIEE,

the expected SQL is

select COP Date as c1,

     Deactivation Date as c2,

from ....

Union All

select null as c1,

     null as c2,

Instead I get it as

select COP Date as c1,

     Deactivation Date as c2,

from ....

Union All

select TO_DATE('1900-01-01' , 'YYYY-MM-DD') as c1,

     TO_DATE('1900-01-01' , 'YYYY-MM-DD') as c2,

from ......

Can any one please help me as to how I get this resolved...

Thanks,

Nikhila.