Is it possible to use Dashboard Prompts to override Session Variables?

display prompt values in Excel
March 18, 2009
OBIEE Training
March 18, 2009

This is a two step process:

1) Tick “enable any user to set variable” checkbox in the RPD for the session variable
2) When you create a dashboard prompt, in the Set Variable list, choose to populate a variable for the dashboard prompt using a server request variable.

If you set a server variable it will override explicitly the value of this variable set via the initialization block.

The variable is changed in the dashboard that uses the prompt( where the variable is set).


  1. Adeel Javed says:


    A similar question, is there any way to pass a variable from report to rpd file and by variable I mean when a user clicks on a link in report it passes some cirteria, can we somehow pass this criteria to rpd file as well? Thanks.

  2. Rick Harris says:

    This seems to be mixing two concepts, session vars and request vars. Is there a prefix I need to use for session vars to set those? Just putting in the session var name doesn’t appear to be working.


  3. Andriy Yakushyn says:


    How are you trying to put a variable? I suggest you create a topic on OTN forum – there’re plenty of people who would assist in solving the problem. I’m just not sure what do you mean exactly by “mixing two concepts, session vars and request vars”.

  4. KRISHNA says:

    Hi Gurus,
    Hi All,

    My Question is Can we create a Check Box Prompt as a dashboard Prompt, if possible please tell me asap

    Thanks & Regards


  5. KRISHNA says:


    1. Would it be possible to provide ranking on graphs by department based on their actual sales?

    2. If ranking is possible, Would it be possible to sort the department vertical graph bars by ranking?

    If not possible, please provide me the the alternative solution?

    Thanks & regards
    Krishna Mohan

  6. Mithun says:

    Hi friends,

    Even I have similar kind of question.

    I have one rdp where in the physical layer the data is retrieved using a stored procedure with some input variables, so what I’m try to do is provide a prompt to the user in the Answer/Dashboard so that they can select value in that so that this selected value will be passed to the input parameter of the stored procedure.

    Is it possible in OBIEE 10g? If so can some one let me know how to do this?

Leave a Reply