Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Prompt Default Selection session variable not working

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
-
Bump
0 -
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>)
0 -
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?
0