Categories
BI Publisher report with a parameter does not return any data when the parameter is hidden
Summary
BI Publisher report with a parameter does not return any data when the parameter is hidden
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
Answers
-
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.
0 -
Hi Mani
Thanks for your answer. That's a bit surprising as the documentation states:
Show
This property controls whether the parameter is displayed to the user. Disable the Show property if you do not want the user to see or change the parameter values that are passed to the data model.
As you can see this says that the parameters are still passed to the data model when hidden.
Thanks
Colin
0 -
Hi Colin,
Yes this is the expected behavior. Hidden parameters are not considered during run time so values cannot be passed.
Thanks,
Mani
0 -
Yes, This Property is set at report level, You need to default your parameter value in Report or DM.
0 -
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)
0
