Urgent - INSTR() Functions in OBIEE?
926215Apr 20 2012 — edited Apr 23 2012Hi All,
I just got some very good help from the DB experts on these forums about solving a problem with a table join that I had.
But now I have this SQL query and I'm trying to figure out how to implement this in OBIEE:
select *
from TABLE1,TABLE2
where instr(TABLE2.USER_ID,TABLE1.USER_ID) > 0
My question is how do I implement this instr() function on OBIEE? I checked physical and business model mapping layers in the repository and it does not allow me to configure this type of join. Is it possible to configure this type of join function to be invoked automatically everytime a user runs a certain query in OBIEE (as if it was a natural join)?
Any help would be greatly appreciated.
Alan