[OBIEE 10g] Dynamic Prompt Content

OBIEE Dynamic prompt content 

This is  to show one of the ways to create dynamic prompt content. First create a small dropdown prompt which contains a FilterName LOV:

SELECT case when 1=0 then "D2 Market"."M01  Market"  else ‘Market’ end FROM "Sample Sales" Union all SELECT case when 1=0 then "D2 Market"."M01  Market"  else ‘Area’ end FROM "Sample Sales" Union all SELECT case when 1=0 then "D2 Market"."M01  Market"  else ‘District’ end FROM "Sample Sales" 

 

Put the result in a presentation called "filtername"

Create a new promt for the dynamic content in the column put:

case when ‘@{filtername}{Market1}’= ‘Market’ then "D2 Market"."M01  Market" else case when ‘@{filtername}{Market1}’   = ‘Area’ then "D2 Market"."M02  Area" else  case when ‘@{filtername}{Market1}’= ‘District’ then "D2 Market"."M03  District" else  "D2 Market"."M03  District" end end end

It’s very sensitive on the place of the single quotes!

Add a dynymic filter to your report: