How to reference the value of a session (request) variable in Narrative or Title view

Mark.Thompson

I'm developing an analysis, dashboard prompt, and dashboard page in OBIEE 11.1.1.9.

The repository initializes a session variable called Selected_Term, and that variable has the 'Any user can change the value' checkbox ticked.

My dashboard prompt for the Term column populates that variable.

My analysis has a column whose formula references that session variable, so that I can see the value.

The formula in the analysis works just fine.  It shows the initial value as initialized during sign-on, but when I select a new value of the Term column from the dashboard prompt, and the session variable value changes, the column shows the changed value of that variable.  So I know the variable is getting updated by the prompt.  There is clear evidence of it in the column contents.

Now I am attempting to display the (changed) value of that variable in a Title (subtitle field) or a Narrative, using this syntax:

@{biServer.variables["NQ_SESSION.Selected_Term"]}

I want to see the changed value of Selected_Term in my Title and/or Narrative.  Unfortunately, that syntax isn't showing me the changed value that is plainly and clearly shown in the column that references that session variable.  Instead, it always shows the same INITIAL value that was set when I signed on, not the changed value.   

What is the proper syntax for displaying the CHANGED value of the session variable in a Title or Narrative, so that it matches what is correctly displayed by the column formula?