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

kzane

Bump

choracy69

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

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?