parameters depends on each other in BIP

Misstram94

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!

Thomas Dodds

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

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.

Misstram94

Thanks for your help, I have resolved this problem.