So you must use the "Descriptor ID" functionality @Christian Berg mentioned in the first reply. That's how OBIEE manage that situation. Configuring columns in the right way in the business model by setting descriptor id and sort columns is one of the activity required once when building the RPD and giving you access to both ID or text value for columns to improve filters and query generation.

That's the solution the tool offer out of the box for your request.