This discussion is archived
5 Replies Latest reply: Jun 6, 2012 10:54 AM by 657753 RSS

Multi select drop down option in Answers direct data request

657753 Newbie
Currently Being Moderated
We are using OBIEE 10.1.3.4.1 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

Legend

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