Forum Stats

  • 3,873,497 Users
  • 2,266,589 Discussions
  • 7,911,553 Comments

Discussions

Can a Dashboard Prompt be stored in a Session Varaiable?

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
Tagged:

Answers

  • Hello,

    check this.. http://gerardnico.com/wiki/dat/obiee/logical_sql/obiee_set_request_variable_dashboard_prompt
    Kishore Guggilla
  • 718918
    718918 Member Posts: 7
    @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
This discussion has been closed.