Can a Dashboard Prompt be stored in a Session Varaiable?

718918

I have a requirement to store dashboard prompt (multiselect prompt); can I set the prompt value as value of a dynamic or non-system session variable and use it in a report or in BMM layer? If yes can you direct me, thanks your input
Somu

Kishore Guggilla

Hello,

check this.. http://gerardnico.com/wiki/dat/obiee/logical_sql/obiee_set_request_variable_dashboard_prompt

718918

@Kishore,

Thanks for your reply, yes I did visit Nico's blog but I am using a multiselect prompt so I do not have the option of using a 'Set Variable'.

However in his blog he talks about using 'SET VARIABLE' clause in sql results box, I am not sure how exactly to use it; meaning how can I use this clause in the
SQL Results box as I need to store the prompt value in it?

say 'MyYear' is my NON-SYSTEM server variable name

SET VARIABLE MyYEAR=?

any idea