1 Reply Latest reply: Feb 20, 2013 4:10 PM by Srini VEERAVALLI RSS

    User input prompt in CASE statement

    SweetieSophia
      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
          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