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!!

--

--

--

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

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Oracle EBS ( E-Business Suite 12.2.8 ) Step by Step Installation — Part 1

Introduction to Django

Building a Statically Typed Python (Part 1: Lexing and Parsing)

Real-time data processing pipeline — Part 1 — Visual time series data generation

How to reduce your AWS Cost -Part 2

Book introduction: “Getting Started with Java on Raspberry Pi”

All about Git & GitHub!!

Writing your first Serverless Function

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

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

More from Medium

Advanced Pivot Table Exploration

CS373 Spring 2022: Week 4

Reasons for Not Choosing a Signature Model Surfboard

Madden 22: A detailed guide to the best option settings