1 person found this helpful
Unfortunately there is not such an option for prompts out of the box.
- Concatenate country and Currency (in your example) and use that as prompt: be aware that this solution has an impact on the SQL pushed down to database
- Create an analysis and with a narrative view simulate a prompt (PortalPageNav or GoURL can help you), a narrative will allow you to customise the layout in HTML
- Leave the prompt as default and add a table next to it with Country->Currency conversion.
The 1st and 2nd option are kind of an hack. the 3rd one uses the default features of OBIEE but doesn't provide you exactly what needed.