BI Publisher report with a parameter does not return any data when the parameter is hidden

Question

Summary

Content

Hi, I have a report with one parameter, with three possible options from a drop down list, which works fine when the parameter is displayed. If I un-tick the Show box to hide the parameter then the report does not return any data and displays a message saying 'No data found'. Am I missing something? I am using OBIEE 11.1.1.7.1

Any help greatly appreciated

Thanks

Colin

YGUTTIKONDA · Answer

you will need to have a default value  (which can be passed to the query) or you can pass all values in your query something like below

WHERE

A.DEPT = NVL(:P_DEPT, A.DEPT)

Sandeep S. Chauhan-Oracle · Answer

Yes, This Property is set at report level, You need to default your parameter value in Report or DM.

Venkat Thota - BIP · Answer

If you can think hidden param is passing value , you can try this As you said you have 3 values (3 options in param drop down) , along with 3 values create or add extra value 'ALL' . so total value will be 4 and keep this 4th value as default in parameter section and disable parameter then run the report. Note: you have to handle 'ALL' value in the source , i.e if you disable param and by default BIP will pass 'ALL' value to data source ,write a code to handle value Like  param_name='ALL'. Let me know if you have any issues.