Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
All Column Values in Direct Database Request
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?
Answers
-
WAT?
Prompts don't do DDR's - they always go over Subject Area queries written in LSQL, not physical.
0 -
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.
0 -
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...
0 -
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.
0 -
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.
0 -
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?
0 -
Not for a dashboard prompt - the stand-alone object - no.
0
