1 person found this helpful
Ebin posted the solution, for the why ... it's simple: Mark is a text, so you can't just write it like that in the middle of an expression. In OBIEE (like in Oracle SQL) text must be between single quotes, like Ebin wrote: 'Mark'
thanks guys, I dont know how could I missed that
edit: is there possibility to make bi admin tool in this formula to be NOT case sensitive?