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.
I was afraid of that.
So as it stands, I have 12 teams. I need to create a Goal column, and each team has a separate goal. These Goals are not in a table or anything, they are numbers that I made up.
Team 1s goal should be 200.
Team 2s goal should be 120.
How do I get OBIEE to insert each corresponding goal with the teams? My team column formula is above in my first post.