Prompt Default Selection session variable not working — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Prompt Default Selection session variable not working

Received Response
21
Views
3
Comments
kzane
kzane Rank 4 - Community Specialist

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

Answers

  • kzane
    kzane Rank 4 - Community Specialist

    Bump

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    I think that you should use: VALUEOF(NQ_SESSION.session_variable)

    And maybe in SQL results you should create something like that:

    Select <presentation table>.<presentation column> from <subject area>

    where  <presentation table>.<presentationation column> = valueof(NQ_SESSION.<session variable>)



  • kzane
    kzane Rank 4 - Community Specialist

    I have tried VALUEOF(NQ_SESSION.COUNTRY) as well but it doesn't work.

    But I have noticed something even stranger - even when I don't have anything set for Default Selection option for this prompt, 'ENG' still gets automatically chosen when I enter the dashboard. How is that possible?