Skip to Content

Adding ‘All’ in query prompts in SAP Dashboards.


Here’s a quick and easy way to add ‘All’ in query prompts in SAP BusinessObjects dashboards.

Environment: SAP BusinessObjects Dashboards 4.1 SP 2

I start by creating a combo box with 2 columns, one for the ‘Display value’ and one for the ‘Prompt value’. B3 is empty and this is important for the solution.


Combo box.JPG

Next you set the prompt to an ‘Optional prompt’ under the ‘Edit Prompt’ values to allow for the blank value to be send to the prompt when running the query.


Lastly you map the prompt to the destination of the combo box:


Hope this helps


Be the first to leave a comment
You must be Logged on to comment or reply to a post.