Tuesday, 22 September 2015

Passing Multiple characters from prompt to filters using presentation variable in OBIEE 11g

Create report in which user wants to pass multiple characters(values) from prompts directly to column filter.
So I have used below syntax with filter functions. And the reports returned results as expected. :)

(“- Table Name”.”Column name “ IN ( @{Variable}[‘@’]{‘Default Value’} )


Example: Per_Name_Month in ( @{p_month}['@']{'2015 / 07'} ) 
If you selected Per Name Month are 2015 / 08 and 2015 / 09, then result: 

Per_Name_Month in ( '2015 / 08','2015 / 09' )

No comments:

Post a Comment