3 Replies Latest reply on Mar 25, 2013 2:28 PM by SriniVEERAVALLI

    OBIEE - changing imported column datatypes

      Hi All,

      I am trying to join 2 tables in physical layer but the columns on which I am making join condition have different datatypes defined(one is datetime,another is timestamp).Hence, I am getting error incompatible datatypes can't be joined.

      I don't want to change the columns datatypes in ohysical layer bcz I am not sure if some other report using this rpd might be using the join conditions based on existing datatypes.Is there any alternative to this?

      Please suggest.