0 Replies Latest reply: Oct 9, 2012 1:50 PM by 967160 RSS

    How to make column range based on a column in Oracle BI 11g

    967160
      Hello everyone!

      I want to know, how to make column range from a column in oracle bi 11g.

      for example!

      I have a column amounts and I want to build on this with other values of quantity, other column range 1-9,10-49,50-99,100-249, 249 o more.

      regards!

      when I try to make the range I have error.

      Syntax error [nQSError: 26012] . (HY000)
      SQL Issued: SELECT CASE WHEN "CUBO_DEEE_TAB"."CANTIDAD" BETWEEN 1 AND 9 THEN 1 a 9 ELSE "CUBO_DEEE_TAB"."CANTIDAD" END FROM "DM_DEEE"

      Edited by: 964157 on 09-oct-2012 11:50