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 AI and Analytics

Child Item

OBIEE-Create all value in table prompt

User_PA24J

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

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

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:

User_PA24J

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

User_PA24J

Hi Christian:

What I taking about is just like the pic shown as below:

擷取.PNG

and I wish to the default option is 'All values', not '131110013'.

Thank you,

Sting Wu

[Deleted User]

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)

Gianni Ceresa

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.

[Deleted User]

@3185546

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

User_PA24J

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

User_PA24J

The other problem is if I use your example to implement in my analysis, the measure column will show a total as below:

擷取.PNG

It shows only the highest hierarchy level with a total measure.

But what I expected is more like

擷取.PNG

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.

[Deleted User]

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.

Upcoming Event

Oracle Webinar OCI AI Foundations Certification
Prepare-se para sua certificação em OCI AI Foundations Inteligência Artificial está transformando a forma como empresas desenvolvem aplicações, automatizam processos e utilizam seus dados. Para aproveitar esse potencial, é essencial compreender os principais conceitos de IA e como essas tecnologias se conectam aos serviços…