8 Replies Latest reply: Aug 1, 2012 2:23 AM by GregGaszewski RSS

    SUM in CASE in mapping

    GregGaszewski
      Hi Guys!

      I am loading data from Oracle to Essbase and have a question for you.
      Can i do something lika that in ODI mapiing:

      CASE
      WHEN (select sum(DataSource.value) from DataSource where Account like 'K410%') >= 0
      THEN 'Profit'
      WHEN (select sum(DataSource.value) from DataSource where Account like 'K410%') < 0
      THEN 'Loss'
      END

      Best regards,
      Grzegorz