5 Replies Latest reply on Mar 25, 2015 8:21 AM by FTisiot

    Can you use an NVL with session variables in a dashboard prompt

    Lance Botha

      Hi All,

       

      I am wondering whether it is possible to use something similar to an NVL with session variables in a dashboard prompt default selection?  Ultimately what i am trying to achieve, is if the value of first session variable is null, then i would like the second to be returned instead.

       

      For example, i currently have prompt for 'Period' which has a default selection 'Server Variable' as NQ_SESSION.GL_PERIOD.  I also have a session variable for NQ_SESSION.CUSTOM_PERIOD.  I would like to update the dashboard prompt default selection 'Server Variable', so that if NQ_SESSION.GL_PERIOD returns no value, then NQ_SESSION.CUSTOM_PERIOD is used instead.

       

      Any help would be much appreciated.

       

      Thanks