How to add List of values via SQL for a Oracle BIEE Reports
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