You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to add List of values via SQL for a Oracle BIEE Reports

edited Apr 15, 2024 1:22PM in BI Publisher Learning Center


We have developed a OTBI report with 90 fields and added some parameters to it. Due to limitations the report is fetch 25K records only so user requested us to develop a BI Report. I have used OTBI analysis SQL query to Develop a report and developed a Oracle BIEE report.

Content (please ensure you mask any confidential information):

I am trying to add Parameters to the report with List of values Via SQL query both independent and dependent(Depending on the Business unit the PO's should be populated in List of values). Also wanted to add MULTIPLE PARAMETER VALUE SELECTION feature to the report. I tried adding this feature with below SQLs but it didn't worked

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!