Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

parameters depends on each other in BIP

Received Response
71
Views
3
Comments
Misstram94
Misstram94 Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    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
    Pavle Kostic Rank 3 - Community Apprentice

    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
    Misstram94 Rank 5 - Community Champion

    Thanks for your help, I have resolved this problem.