Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE-Create all value in table prompt
Hi,
I am a beginner with OBIEE, and the version I applied is 11.1.1.9.
I used table prompt to filter the content in pivot table, and I know I can create the "All Value" option in the table prompt.
But thing is the attribute that I want to create an "All Value" option for, there are almost 600 distinct values in it.
Is this the only way to add these values one by one to create the "All Value" option?
Best regards,
Sting wu
Answers
-
3185546 wrote: I know I can create the "All Value" option in the table prompt.
I'm not sure what you mean by "create" the option...that's one single click in the config of a prompt and has nothing to do with the number of members in an attribute column:
0 -
Hi Christian:
I am talking about the pivot table prompt.
The prompt you mentioned will disappear after user picked a value.
The pivot table prompt will act like a filter and it can be drag to table or drag to be a prompt in an analysis.
Thank you,
Sting wu
0 -
Hi Christian:
What I taking about is just like the pic shown as below:
and I wish to the default option is 'All values', not '131110013'.
Thank you,
Sting Wu
0 -
a) No it will not disappear since I am talking about the actual prompt object.
b) What you mean with "disappear" is what is called an "in-line prompt" and is part of the object definition of an analysis rather than a stand alone object (see a)
c) So what you are talking about is the "Prompt" section of a pivot table's view construction. Again something totally different. And most importantly: "prompting" a pivot table does NOT filter the data! It only shows one subset of data at a time. All the data is already present and is only shown/hidden by the prompt. There is no filtering happening it's just the GUI playing around. Check the query logs and you'll see.
So basically you gotta think about what you actually want to achieve here. As stated above you have the three option
- view prompt (lowest level, least possibility to configure and doea NOT filter)
- in-line analysis prompt (one level higher, more possibilities to configure, actually filters data, part of the analysis xml)
- actual prompt object (highest level, filters data, own object, reusable, full configuration possibilities)
0 -
As Christian already said you can use a) because if not in-line prompt ( b ) it will not disappear.
And your actual column in the prompt section can only display the values of your column: so if you don't have a value "all values" it will never display all values because it's not a filter and it's just about showing or hiding some data, so "all values" doesn't have a meaning there.
0 -
In case my response was tl;dr or you're just not interested in the background then have a look at the example I built here: http://slc02okq.oracle.com:7780/analytics/saw.dll?Answers&path=%2Fshared%2FOTN%2FPivot%20table%20in-line%20prompt%20with…
prodney / Admin123 to log on
0 -
Thanks to Christian and Gianni.
I am sorry for that I misleading you both.
Yes, prompts do not filter data.
Actually, what I faced now is migrating reports from Discoverer to OBIEE.
And I found a report in Discoverer, its prompts are more like pivot table prompts in the "Prompt" Section.
At beginning, those prompts are shown and with "All values" being selected in the drop list.
And a user can easily drag prompts into report or drag it from report to prompt section, and the prompt still has "All values" in the drop list.
The example you built, I tried it before.
The problem is if I have more than one prompt, it will show the first one, after a user select a value in the first prompt, the other prompts show.
Is there any way to fix this behavior?
Best regards,
Sting
0 -
The other problem is if I use your example to implement in my analysis, the measure column will show a total as below:
It shows only the highest hierarchy level with a total measure.
But what I expected is more like
As you can see, the hierarchy remains.
So, the "All values" in the Discoverer is more like "does not pick any value".
I tried using dashboard prompt to achieve my goal, but with dashboard prompt the problem will be users can't drag the prompt into report.
0 -
3185546 wrote: The problem is if I have more than one prompt, it will show the first one, after a user select a value in the first prompt, the other prompts show. Is there any way to fix this behavior?
"Fix" - no because that's how the solution works. While you're in Answers for example and still modifying the analysis definition, then changing the pivot table in-line prompt to a certain member will actually store the reference to that member as a configuration settin in hte XML of the analysis.
With regards to your other post I am not sure I understand what you mean with "It shows only the highest hierarchy level with a total measure." when underneath you just use a hierarchical column and that's fine for you (or so I interpret it at least).
Also: "users can't drag the prompt into report." Why do users have to be able to drag the prompt into the analysis? I think you need to take a step back and be a bit more precise about what you're trying to do fundamentally and what should be achieved with it and why. Especially the "dragging the prompt into an analysis" is surprising.
0
