In this post we’ll show you how to generate Dependent LOV in Oracle Fusion Reporting Tools. Creating dependent parameters for a BIP report must be a feature that gets a lot of use.
Business Requirement
The business requirement is to produce a fusion BIP Report that displays the user-input values in the order that they are selected by the user. One important feature of the report is that the values displayed in the dependent parameters can change depending on the independent parameter selected.
Steps to Create Fusion BIP Report Dependent LOV in Oracle Fusion
- Create a Data Model with SQL query
- Create 2 list of values(LOV), pass parameter in dependent LOV query.
- Create 2 Parameters, select their respective list of value(LOV).
- Save the Data Model
- Run BIP Report, Dependent LOV is changing based on Independent values.
For Example: we are creating 2 parameters, When the independent value changes, the dependent LOV changes as well.
- Header_ID : Independent Parameter
- 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, VENDOR_CONTACT_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.