3 Replies Latest reply on Apr 13, 2016 1:45 PM by kzane

    Prompt Default Selection session variable not working

    kzane

      Hello everyone,

       

      I have a Choice List prompt for countries column. It only has two choices/values ENG and GER. I'm using a Session Variable called COUNTRY to set the default (Default Selection option) for this prompt. In session manager for a sample user session variable COUNTRY has 'GER' value. However the prompt loads with 'ENG' selected.

       

      I have tried with either:

       

      Default Selection: Server Variable

      NQ_SESSION.COUNTRY

       

      Default Selection: Server Variable

      COUNTRY

       

      Default Selection: Variable Expression

      @{biServer.variables['NQ_SESSION.COUNTRY']}

       

      None of this works however, the prompt always loads with 'ENG' selected, no matter what is in the session variable COUNTRY. What seems to be the problem here, is it not possible to load session variables as defaults for a prompt or am I doing it wrong?

       

      Version: OBIEE11g 11.1.1.7