All column values range - how to?

Question

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

Gianni Ceresa · Answer

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.

3280272 · Answer

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 · Answer

"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).