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

All Column Values in Direct Database Request

3240307

I have seen a few blog posts for bringing multiple column values into a DDR but I haven't seen any that make the All Column Values option in a dashboard prompt work with a Direct Database Request. Is it possible? If yes, are there examples out there?

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

WAT?

Prompts don't do DDR's - they always go over Subject Area queries written in LSQL, not physical.

3240307

Christian,

I'm referring to this method: OBIEE in IL: OBIEE - Direct Database Request and Presentation Variables

You recommended an Opaque View in the conversation but I just wanted to make sure there was no way to do All Column Values via this method before I tried an Opaque View and the modeling thereof.

Gianni Ceresa

Did you try to look at what kind of query is executed when you select "all values" in your prompt?

Because that's how you can then find your solution: look at what is done, apply the required piece of logic to manage it and give you the expected output.

What you already know is that "all values" doesn't mean the variable contains all the values separated by a comma...

3240307

That was the interesting part, when I did that, nothing seemed to have passed to the query. The query ran with just the default value I have setup in the Presentation Variable reference in my query.

[Deleted User]

Ah. Heh wow. My own blog post comment used to confirm me. Talk about weird

So yeah if you write an opaque view in the RPD and then use that BM to source the dashboard prompt then you get "all values".

Of course if you don't care about performance and drag column X into the in-line prompt of - for example - a table view then you kind of also have a "prompt showing all possible values". Just not all at the same time. For that you'd have to drag it into the table as a column again.

3240307

I do have a particular model built already which is what I'm using for just the dashboard prompt values. SO, to sum up, All Column Values is not supposed to work with a DDR?

[Deleted User]

Not for a dashboard prompt - the stand-alone object - no.