nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to work with dependent presentation variable

user652652

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.

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

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

user652652

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]

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

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 Acha

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

Thansk all for your suggestions.

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

Gianni Ceresa

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]

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