This discussion is archived
1 Reply Latest reply: Feb 20, 2013 2:10 PM by Srini VEERAVALLI RSS

User input prompt in CASE statement

SweetieSophia Newbie
Currently Being Moderated
I would like to obtain user input via a prompt and use what the user selects in my OBIEE Report case statement.

For example &START_DATE AND &END_DATE are user inputs:
CASE when SHIP_DATE BETWEEN &START_DATE AND &END_DATE THEN 1

Thanks
  • 1. Re: User input prompt in CASE statement
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Use presentation variables for start and end_dates
    In the criteria tab->SHIP_DATE->click on fx
    on Edit Column Formula->Bin Tab->
    Add Bin->Add button->Variable->Presentation
    Use the presenation variables with with required condition
    Okay then set 1 at Edit Bin Name

    Mark if helps

    Srini VEERAVALLI on Feb 7, 2013 5:23 PM

    Any updates on this?

    Edited by: Srini VEERAVALLI on Feb 20, 2013 4:10 PM

Legend

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