3 Replies Latest reply on Dec 18, 2012 11:33 AM by SriniVEERAVALLI

    Can I create a new Group by column in  OBIEE analytic Report ?

      Hi Everyone,
      Here I have a report
      ProductID Price
      LCD1 12
      LCD2 11
      LCD3 10
      TV 100
      GAME 50

      I hope to add a new column on this report in OBIEE and the result should be like below:
      ProductID Price New_ProductID_Grouped
      LCD1 12 LCD
      LCD2 11 LCD
      LCD3 10 LCD
      TV 100 TV
      GAME 50 GAME

      I hope to show LCD* products as LCD in the New_ProductID_Grouped field.

      Is it possible in OBIEE?
      I hope to create the column and then do hierarch later.
      Thanks in advance.