Oracle Analytics and AI

mmajdana1

Hi I am using OIBIEE 12.2.1.2.0

My issue is like this

I have a prompt page, analysis and a drill down from analysis,

I have to pass one parameter from prompt page to drill report, that prompt is not shown on a report from which drill down is made, so i cant make just  is prompted filter on a drill report

i am talking about checkbox and when nothing is selected my presentation variable is not filling with values,and i need that it fills with all values , how can i make some sort of override?

Like  nvl((@P_PROMPT), column_values)

Notice:

It is not an option that I put all values as a default values  on prompt!

Thx, Matija

Robert Angel

Hi,

try a case statement on the filter so when your default {AllValues} is selected it does the equivalent of 1=1 on the filter

case when @{PresentationVariable} = 'AllValues' then TheColumnBeingFiltered else @{PresentationVariable} end = TheColumnBeingFiltered

Btw - did you abandon the other questions from yesterday - it is good form to close them as minimum, better to mark what was correct / helpful - or people do tend to stop helping you...