Description ID column - OBIEE 11g

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

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