Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Oracle BI Publisher - Optional Parameter
Summary
Oracle BI Publisher - Optional Parameter
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
Answers
-
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
0