5 Replies Latest reply on Jun 6, 2012 5:54 PM by 657753

    Multi select drop down option in Answers direct data request

      We are using OBIEE version. We have few Answers Direct data request where we want to make user able to select multiple items in drop down list of the prompt for genrating reports. currently user can select either all_choices or one of them. Like from the department drop down list either genrate report for all the departments or select only one the report. We want user to be able to select more than one departemnt for report generation.

      How it can be done in direct data request?

      example, how we are suing prompt in sqls-

      Dept = CASE WHEN NVL('@{dept}{All Choices}', 'All Choices') = 'All Choices'
      THEN dept ELSE '@{dept}{All Choices}' END