Hide Parameters in Oracle BI Publisher

Here is a 2 min read to learn how to hide parameters in BI Publisher report.

Why Hide Parameter(s)

Let’s first try to undresand the need to hide parameters. One of the obvious question is if it is a parameter, don’t you want to show it to the user? Well, let me explain!!

Imagine a use case where you are drilling down from a summary report in BI Publisher report to a detailed report in BI Publisher. And you are passing certain ID parameters like Vendor Id, Invoice Id from the summary report to the detailed report. In this case when the detail report executes, the parameters will be shown to the user. And which user likes to see ID values. They would rather see the Invoice Number and Vendor Name, instead of Invocie Id and Vendor Id.

In the above use case, what we can do is to define the parameters in the data model, and hide the paraemters in the report. This way we can still use this in the where clause in the data set query. And the user doesn’t have to see the ID values.

If this is not clear, do reach out to me and I am happy to explain more!!

Let’s hide the parameter(s)

I am assuming you know how to define a parameter in the data model. If not, go ahead check out this video where I cover how to define a parameter in the data model.

[embed]

👉 Step 1: Navigate to BI Publisher Catalog

👉👉 Step 2: Edit the Report

👉👉👉 Step 3: Hide Parameters

In the next window, you have the option to show or hide the parameters as shown.

Once you have made the changes click on OK and Save the report. That is all the magic or trickery you have to do to hide the parameters in the report.

Conclusion

Let me know if you have questions. I have a ton of content on my YT channel explaining some of these concepts. So check out the videos. While you are there, consider subscribing to the channel.

Here is the link to the channel.