1 person found this helpful
What problem are you trying to solve exactly, and which OBIEE version are you asking about? Are you familiar with the description ID and "double column" feature of OBIEE? There is a good article on this here: https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-handling-double-columns-iddescription-interoperability/
If you're unfamiliar, it might be worth reading to see if that is the actual problem you're trying to solve.
This is exactly what I was looking for. Thank you!