Thursday, January 31, 2013

[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:









No comments:

Post a Comment