Oracle BI Publisher - Optional Parameter

Question

Summary

Content

Hi All,

Is there any way we could make parameter in Oracle BI Publisher data model/report optional.

By default parameters are mandatory, though there is no asterisk notation. I need like, if no value passed to the parameter it will take default value mentioned in the query and in this case optional parameter will not have asterisk notation, others will have it.

Please let me know if this is possible and steps.

Thanks,

Xavier

Venkat Thota - BIP · Answer

yes possible ,

you can create parameters in data model but can hide at report level , first create data model with parameter, then create report , edit the parameter tab in report screen,where you have to disable the parameter for the report , assign default value like 'novalue' for the parameter, same value has to be handled by query  ,for this  you can apply logic like ((field_name=:param) or  (:param='novalue') or (:param is null) ),

let me know if you have issue, Thanks