This discussion is archived
3 Replies Latest reply: Dec 18, 2012 3:33 AM by Srini VEERAVALLI RSS

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

user6673757 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points