Hello all,
I'm hoping you can help out. I've searched the board for something related to my problem and couldn't find anything.
So here goes:
I'm trying to create a column in an analysis whose values are based on a case statement that's comparing 2 column values. So for instance:
Column3
case
when (column1 = A and column2 = 1 then Value1)
when (column1 = B and column2 = 2 then Value2)
END
To add to the complexity, column1 and column2 are case statements themselves based on their own values.
Any way to do this within OBIEE 11g? I don't have back-end access so I'm unable to make modifications/create new columns on the backend. I'm trying to avoid engaging the devs as their turnaround time is too long.
Any assistance would be greatly appreciated.