Photo by PhotoMIX Company from Pexels

Passing Multiple Parameter Values to BI Publisher Report Web Services Call

I have written detailed blogs about how to invoke Oracle BI Publish Report using Web Services. Recently there was a question in Cloud Customer Connect forum regarding how to pass multiple values for a specific parameter while invoking the Web Services call. I was able to answer that question. So here is how you.

Pre Requisites

Please read my blog “Invoke Oracle BI Report using Web Services” to understand the basics of using ExternalReportWSSService web services end point to invoke an Oracle BI Publisher Report. You should have access to Oracle ERP Cloud instance and should have the data model and report already created.

Data Model

First things first, there should be a parameter defined in the data model. In my data model I have a parameter called p_period.

Since the user may pass multiple values for the parameter, I have used “IN” clause instead of “=” in the WHERE condition. Check out Line# 5.

Scenario 1 : Parameter Type Menu / List of Values

In this scenario, you have a list values associated with the parameter. The parameter type is Menu. You have enabled Multiple Selection (the user can select multiple values for the parameter).

The pay load will be as shown below. Check out line numbers 10, 11 and 12. We have one line for each value you want to pass for the p_period parameter.

Scenario 2 : Parameter Type Text

In this scenario, the parameter type is Text. You have enabled Text Field contains comma-separated values.

The payload will be as shown below. Check out line number 10. You are passing the multiple values as comma separated string.

Conclusion

We saw two different ways to pass multiple values to a parameter while invoking the Oracle BI Publisher Report using ExternalReportWSSService Web Service. Let me know if you know of other ways to accomplish the same.

If you want me to create a video on the same let me know. Happy learning!!

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Arun Raj

Arun Raj

107 Followers

Manager (Oracle Cloud ERP, EPM), Integration Specialist, Big Data, Data Science & Python Enthusiast)