There seems to be a glitch in the way obiee (11.1.1.6.0) interprets server variables when using them as default values for a dashboard prompt: only when the variable name is in uppercase and contains no underscores will it be recognised.
For example, I have declared and initialised 3 server variables:
STORENBR
SV_STORE_NBR
storenbr
All 3 contain a value after logging on, I verified this in the obiee admin tool 'manage sessions' screen.
In the dashboard prompt, when chosing 'server variable' as default selection, only NQ_SESSION.STORENBR results in the default value being set. The other two can not be addressed it seems, I have tried variations:
NQ_SESSION.SV_STORE_NBR
NQ_SESSION."SV_STORE_NBR"
NQ_SESSION.storenbr
NQ_SESSION."storenbr"
The same goes for default selection type 'variable expression': the expected result is achieved when using @{biServer.variables['NQ_SESSION.STORENBR']}, yet no such luck using:
@{biServer.variables['NQ_SESSION.SV_STORE_NBR']}
@{biServer.variables['NQ_SESSION."SV_STORE_NBR"']}
@{biServer.variables['NQ_SESSION.storenbr']}
@{biServer.variables['NQ_SESSION."storenbr"']}
The only way I can actually address the other two values to set the default value, is through the default selection type 'sql result', in which I look up the variable value using the dimension to which it refer:
SELECT "dimension"."store number"
FROM "subject area"
WHERE "dimension"."store number" = VALUEOF(NQ_SESSION."storenbr")
What am I missing? (Apart from the obvious answer: it's a bug.)