Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
parameters depends on each other in BIP
Summary
parameters depends on each other in BIP
Content
Hi guys,
How to parameters in report depends on each other?
Ex:
Department Class
1 A
1 B
2 C
2 D
when Department #1 is selected then class A and B are loaded.
Do you have any ideas for this?
Thanks!
Answers
-
Use a lookup value with menu type parameters and set "refresh other parameters on change" to on
:dept LOV SQL = SELECT Department from tblDepartments ORDER BY Department <-- refresh other parameters
:class LOV SQL = SELECT Class FROM tblClasses WHERE Department = NVL(:dept,Department) ORDER BY Class <-- will show all classes if no department selected
1 -
You may put that mapping in db table. Then just modify your query to look for classes based on Dept# param.
Other way is to use hard-coded mapping of functional variable in data model, but I doubt it is good solution.
0 -
Thanks for your help, I have resolved this problem.
0