Wednesday, February 27, 2013

OBIEE 11g - Description ID column

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