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

How to work with dependent presentation variable

Received Response
33
Views
8
Comments
user652652
user652652 Rank 4 - Community Specialist
edited Aug 13, 2024 5:23PM in Oracle Analytics Cloud and Server

Hi Experts,

We have a scanario: We need two filters in dashboard prompt dept and emp.

Filter2 'emp' should be dependent on filter1 'dept' . If we select department 10 in filter 'dept',  filter 'emp' should display all employees of department 10

Flter1: EXECUTE PHYSICAL  CONNECTION POOL " ABC "."XYZ" Select dept_no from employe.   Presentation variable : dept

Filter2:  EXECUTE PHYSICAL  CONNECTION POOL " ABC "."XYZ" Select emp from employe where dept_no = '@{dept}'  

User can select multiple department no .

Please suggest.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    One checkbox in the "emp" column prompt: "Limit values by"

    Capture.PNG

  • user652652
    user652652 Rank 4 - Community Specialist

    Thanks for your reply.

    But we don't have the model in RPD and we are creating a DDR. That's why we are using  EXECUTE PHYSICAL  CONNECTION POOL " ABC "."XYZ"  in prompts.  In this case how we can achieve it.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    user652652 wrote:But we don't have the model in RPD and we are creating a DDR. That's why we are using  EXECUTE PHYSICAL CONNECTION POOL " ABC "."XYZ" in prompts. In this case how we can achieve it.

    Use the tool as it's designed and built and you will get all its functionalities.

    Use it like Notepad and you will get....pretty much nothing.

  • user652652
    user652652 Rank 4 - Community Specialist

    Thanks for your rsponce. I agreed with you.But we are using an OLTP query and thats why we are using DDR. Is it not possible to achieve dependent prompt  in OBIEE? 

  • Joel
    Joel Rank 8 - Analytics Strategist

    I think what has been suggested earlier is that you use the tool to is full capabilities. What you’re trying to do is simple OOTB functionality and I strongly recommend that you take a step back and reevaluate your OBIEE usage. Even if you’re reporting directly from an OLTP DB, you use the business model to mimic a star schema which will open up all of OBIEEs Analytical functionality.

  • user652652
    user652652 Rank 4 - Community Specialist

    Thansk all for your suggestions.

    So we are sying, it is not possible to achieve dependent prompt  in OBIEE?

  • Gianni Ceresa
    Gianni Ceresa Mod

    There have been multiple threads on this topic.

    If you set the prompt as auto-submit as soon as you pick a value for the first one the page reload and the variable exists. So you can use it in the second query. Just make sure to manage default values correctly so that the second query still work with or without variable value.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    a) Yes it is

    b) You need multiple prompt objects instead of one since you are gong against how the tool was built

    c) Gianni outlined how to do it