Skip to Content

Hi,

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.

years.JPG

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.


OptionalPrompt.JPG

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


MapPrompt.JPG


Hope this helps

Gerrie


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply