This discussion is archived
4 Replies Latest reply: Oct 25, 2013 9:06 AM by ZFMA86 RSS

Adding a "Goal" column for each team

ZFMA86 Newbie
Currently Being Moderated

Hi Everyone,

Using OBIEE 11g, I'm attempting to create a column titled "Goals" for 12 individual teams.  Each team has a specifc Goal number.  Example:  Team 1's goal is 200 widgets, Team 2's goal is 120 widgets, etc.


My Team column formula looks like this: CASE WHEN "Data table"."Folder name" LIKE '%~99~%' AND "Second folder"."Digits" BETWEEN '00' AND '15' THEN 'Core 1'.  (note, this is edited somewhat to protect information, but it should work).

 

Now I'm trying to figure out code that says, "When the team name equals 'Team 1', then Goal = 200."  Any suggestions?  I'm on a beginners level with OBIEE SQL.

 

 

Thanks everyone.

Legend

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