0 Replies Latest reply on Jun 7, 2013 11:20 PM by user6287828

    OBIEE-> Prompt -> Checkbox option ?

    user6287828
      We have a standalone report in OBIEE (not a dashboard report).

      In the report we have two amounts say "School Amount" and "Charity Amount"

      For example
      Date Name School Amount Charity Amount
      1/2/2012 ABC 5.00 NULL
      2/2/2012 DEF NULL 6.90
      2/4/2012 GHI 0.00 NULL
      3/4/2012 DFK NULL 0.00

      Now what I am trying to do is to have a checkbox for this report that says

      Exclude $0 Amount <with a checkbox that user can check or uncheck>

      So that if user checks this checkbox he does not see the rows with zero dollar amount that is he only sees below rows

      Date Name School Amount Charity Amount
      1/2/2012 ABC 5.00 NULL
      2/2/2012 DEF NULL 6.90

      I am unable to figure out the checkbox option under the prompts.

      What I tried first was use a Presentation variable "Amount" prompt with operator "not equal to/does not contain"
      and then use that variable value in the filters that says

      School Amount "not equal to /does not contain " @Amount
      OR
      Charity Amount "not equal to /does not contain " @Amount

      But Instead of a text box prompt I want to use checkbox option.


      Can anyone help me on how to make checkbox option work.

      Thanks a lot.