parameters depends on each other in BIP

Question

Summary

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!

Misstram94 · Answer

Thanks for your help, I have resolved this problem.

Thomas Dodds · Answer

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

Pavle Kostic · Answer

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.