OBIEE 11g rpd we have new feature to show double columns value using a single one (column) – Description ID double click on any of the BMM column in general tab you can see Description ID column
Advantage : While generating the query WHERE clause will now use ID instead of descriptive values query performance will be good
As shown below let say product is our column I want to show the product names with their product key’s in dashboard prompt
Advantage : While generating the query WHERE clause will now use ID instead of descriptive values query performance will be good
Open RPD – BMM layer – Product Key (Column) – Double click – General tab Description ID Column – Set -- > Product Type Key
Create a new column prompt and select “Enable user to select by Code Column”
So product Type comes with product type key (Description ID)
If you want to show it on filters(answers/analysis) check "Select by Product Type Key"
Note : Above filter option will not work in case of Operator other than is equal/not equal/between