OBIEE Version: 12.2.1.3.0
Hello Board,
I am need of some advice, hoping someone can tell me how easy this fix will be
I have a variable prompt which is listing out 1- 10 as a static prompt which is then tied to an 'RCOUNT' column in the report (tied via presentation variable.)
My question is: how do I get the "All Column Values" checkbox to reappear in this new variable prompt drop down? Currently I am select one of the numbers, the prompts to reflect said number to show only that row, but then when I hit the drop down again - it doesn't show the "All Column Values" box again at the top and instead has the '1' at the top. This might seem trivial but it would definitely cause more clicks aka more work for an exec and we all know that wont fly
is there some code i can put in the SQL results portion of the variable prompt edit section? or some other way to get that drop down to behave uniformly the same after it has been applied for a specific row?
please let me know if you need more detail or something was stated vaguely....
before
after 
the variable prompt edit screen