For a certain implementation, I want to replace key figures (status value) by texts contained in a characteristic in the same query.
Both the key figure for status and charcateristic are contained in the same ODS.For example :
A row in the ODS has the planning status(characteristic) of 'in process' for a certain company, the representative key figure value for which is 2(key figure).
Can this be done by using BEx variables or formulas somehow ?
I need a status key figure to be able to do exception reporting on it.