Question

BA report input parameter dropdown

  • 19 November 2020
  • 1 reply
  • 21 views

Badge +1

Is there any option to add ‘Yes’ or ‘No’ dropdown for BA report input parameters (IFS10)? Currently I am able to connect only ListOfValues to input parameters. Kindly help


1 reply

Userlevel 5
Badge +11

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.

 

Reply