All column values range - how to?

3280272

Hi! In Prompt we have an option call Include all column values choice in the list.

When it's choice then we get's all values, not depend of list that we chose (it's take all values, even if they are not on our list)

Is there any chance to config this option for get only a specific range?

Like in our list we specifi value like 1;2;3;4

When option Include all column values choice in the list is marked we get 1;2;3;4;5;6...

But I need only 1;2;3;4 with option Mark all

L. Fernigrini

You should ask the one that programmed that functionality...

Is that an Oracle tool (like SQL Developer or a any other Oracle provided software) the one you are showing? Or it is part of an application your company bought from someone, or developed in house?

3280272

it is part of an application mycompany bought (Oracle Biee 12c) and I ask about any option of modification for this opction

L. Fernigrini

Then you may be luckier on the space for that product,

Gianni Ceresa

"All Column Values" doesn't include all the values of the column, it actually bypass the filter and tell OBIEE to not filter on that column.

Therefore what you look for it's impossible because of how "All Column Values" work.

And there is nothing in OBIEE allowing you to do what you ask for.

Workarounds could be achieved with a weirder model at the data level and a fake value in the column which will behave as you wanted (only 1, 2, 3 and 4).

3280272

So this option is useless if we use a list of value and we don't want to take other value (not from our list)?

I was hope that I can give users an options to mark all or non value in one click (whitout create another presentation filter).

Gianni Ceresa

Yeah, for your need this option is absolutely not what you look for. The behaviour is fine because it's better from a performance point of view to not have a WHERE condition instead of having it with 10'000 values.
But your need is fairly different and not so common.
By using hierarchies (so having an higher level on that prompt which could group things together based on your own needs) is how you could deal with it.