BA report input parameter dropdown

Hi @naija 

There might be other ways, but this is what i found to work:

Create an IAL that returns the desired options (text could simply be: select ‘Yes’ from dual union select ‘No’ from dual)

Create a Quick dimension from the IAL

Connect the quick dimension to the information source   

Add it to your BA report and create the parameter; Parameter Type = Display Item

-----------------------

To make it work, filling in these 2 fields seemed to be required for it to work as a dropdown.