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.