title: Can I create a new Group by column in OBIEE analytic Report?
body: <p>Here I have a report:</p>
  
  <pre><code>ProductID Price
  LCD1 12
  LCD2 11
  LCD3 10
  TV 100
  GAME 50
  </code></pre>
  
  <p>I hope to add a new column on this report in OBIEE and the result should be like below:</p>
  
  <pre><code>ProductID Price New_ProductID_Grouped
  LCD1 12 LCD
  LCD2 11 LCD
  LCD3 10 LCD
  TV 100 TV
  GAME 50 GAME
  </code></pre>
  
  <p>I hope to show LCD* products as LCD in the <code>New_ProductID_Grouped</code> field.</p>
  
  <p>Is it possible in OBIEE?</p>
  
  <p>I hope to create the column and then do hierarchy later.</p>
  
  <p>Thanks in advance.</p>