Dependent Parameter: A simple but very important aspect of BI report Development. So first thing first: What exactly is a dependent parameter. Simple Answer: A parameter which has the values dependent on the other parameter. Let’s take an example of Car Make and Car Model. If my car make is “Mercedes”, my model can be “C300”, “C250”, “E520” etc but not Corolla. On the other hand if the make of my car is Toyota, Model can be “Camry” or “Corolla” and not “C300”. So you see, model of the car is always dependent on the make of the car. If I have to create a report on this example, Model of the car is a dependent parameter. And it is dependent on Make parameter.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
Dependent Parameter Creation:
So second question, how to do that in Oracle Fusion. Again a very simple answer: You need to create 2 parameters by:
1. Creating a data model
2. Go to Parameters tab on left hand side. Click on the “+” icon. Give the name as you deem fit. I will name it as “Vehicle_Make”.
3. Click on the “+” sign again and create another parameter. I will name it as Vehicle_Model. Here is how they look like at this point of time.
4. Now go to “List Of Values” and Click on “+” sign to create the LoV. Create a new LoV. I’ll name it Vehicle_Make_LoV. Query can be something like:
SELECT VEHICLE_MAKE
FROM VEHICLE_MAKE_TABLE
5. Create another LoV by clicking on “+” Icon. I’ll name it as VEHICLE_MODEL_LOV and query can be something like
SELECT VEHICLE_MODEL
FROM VEHICLE_MODEL_TABLE
WHERE VEHICLE_MAKE = :Vehicle_Model
This :Vehicle_Model is nothing but the parameter we created in second step above.
6. Now go back to the parameters. And change the VEHICLE_MAKE parameter from “Text” to “Menu”. Assign the LoV VEHICLE_MAKE_LOV to it. Check the checkbox “Refresh other parameters on change”
7. Go to parameter VEHICLE_MODEL. Change it from “Text” to “Menu”. Assign the LoV VEHICLE_MODEL_LOV to it.
Go on and create your dataset & eventually the report. You can see the behavior by going to the data model and trying the various combinations in Make and Model field. You are all set. Good Luck!!!
Related Posts:
BI Report Development
RTF Date Formatting With Example
RTF Number Formatting With Examples
How To Develop an RTF Template
Looping Finite Number Of Times in RTF
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com
Check out the Amazon Deals of the day based on your interests..
