This discussion is archived
2 Replies Latest reply: Nov 23, 2012 3:35 AM by 937325 RSS

Dashboard prompt needs to work like column selector functionality

937325 Explorer
Currently Being Moderated
Hi Experts,



I had a requirement to create two dashboard prompts i.e Year and Quarter ( In Radio Button) but should not display values of those columns. so when we select Year Radio Button then the x-axis of graph Reports in dashboard page should display based on year values, if we select Radio Button as Quarter then the x-axis of graph report in dashboard page should display
based on Quarter values.

Normally this is a column selector Functionality, But how can we achieve this in Dashboard Prompt.

Please reply me the valuable answers as the requirement is very urgent.


Thanks & Regards,

Tinku.
  • 1. Re: Dashboard prompt needs to work like column selector functionality
    user248025 Guru
    Currently Being Moderated
    Hi,

    This Can be done by using variable prompt


    1) Go to analytics --> create dashboard prompt ->.select new prompt column (type as variable prompt)
    2) set Prompt for presentation vairable as SELECT_COLUMNS and select user input as "choice list" then
    3) add required columns (selection list like column selector) then
    4) you can alos set as Default selection column then
    5) Go to edit your analysis set it like below (use user variable prompt value)
    "table name"."@{SELECT_COLUMNS}{default Column}"
    and also u can set dynamic column header just set it @{SELECT_COLUMNS}{default Column}

    For more refer the below steps,
    http://atlantabi.blogspot.com/2012/01/obiee-11g-using-dashboard-prompt-as.html

    Thanks
    Deva

    Edited by: Devarasu on Nov 23, 2012 12:53 PM
  • 2. Re: Dashboard prompt needs to work like column selector functionality
    937325 Explorer
    Currently Being Moderated
    Hi,

    I tried it and its worked, thank you very much for your help and i think its the 2nd Q u answered me today. It was really urgent and thanks once again.

    Regards,
    Tinku

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points