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

display prompt values in Excel
March 18, 2009
OBIEE Training
March 18, 2009
0
Published by OBIEE Architect at
Categories
Tags

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).

OBIEE Architect
OBIEE Architect

Related posts

April 16, 2013

OBIEE visualization best practices

Read more
July 28, 2012

Values In OBIEE 10g Multiselect Prompt Are Not Sorting in Alpha-Numeric Order In Large LOVs

Read more
July 12, 2011

Oracle’s master notes for OBIEE

Read more

6 Comments

  1. Adeel Javed says:
    April 3, 2009 at 10:56 am

    Hi,

    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:
    April 23, 2009 at 4:31 pm

    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.

    Thanks!

  3. Andriy Yakushyn says:
    April 27, 2009 at 10:58 am

    Rick,

    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:
    November 25, 2010 at 2:35 am

    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

    Krishna

  5. KRISHNA says:
    November 30, 2010 at 8:53 am

    Hi

    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:
    January 19, 2011 at 1:17 am

    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