Skip to Content
Author's profile photo Former Member

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


Assigned Tags

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