3 Replies Latest reply: Mar 25, 2013 9:28 AM by Srini VEERAVALLI RSS

    OBIEE - changing imported column datatypes

    NehaSSharma
      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.

      Thanks,
      Neha