How to create dependent LOV in Oracle Fusion BI Reports

 

Steps

1. Create a Data Model with SQL query
2. Create 2 list of values(LOV), pass parameter in dependent LOV query.
3. Create 2 Parameters, select their respective list of value(LOV).
4. Save the Data Model.
5. Run BIP Report, Dependent LOV is changing based on Independent values.




For Example: We are creating 2 parameters and when the independent LOV value changes, the dependent LOV changes as well.

1. Header_ID : Independent Parameter
2. Line_ID: Dependent Parameter

(1) Create a Data Model

Navigation:  Navigator > More > Report and Analytics > Browse Catalogue > New > Data Model

Data Model SQL Query: 

Select PO_Header_id, Type_lookup_code, segment1,Vendor_id

From PO_Headers_all;

(2) Create 2 list of values(LOV)

Create 2 list of values, one is independent and another one will dependent, pass parameter in dependent list of value SQL query



Write SQL query for each list of Value(LOV)



Pass parameter values in SQL query for dependent LOV



(3) Create 2 Parameters



Select highlighted options for both parameters



(4) Save the BIP Report

Click on Save icon from the right top of the window and choose the location where you want to save the data model.

(5) Run BIP Report

To run the BIP report click on View Data button from the right top window screen, choose any Header_ID from the first LOV and you will find second parameter Line_ID list of values are changing.