Hi,

I found a nice way to use the ‘FIND’ function in excel to trigger and refresh multiple queries from a single cell in excel using SAP Dashboards (Excelsius) and then reset the trigger field.

Environment: SAP BusinessObjects Dashboards 4.1 SP 2

My dashboard has multiple combo boxes and 5 time dimensions in a radio button control.

Selections.JPG

If any of the selections change (combo or radio) a group of queries should run. The queries are grouped by time dimension.

First I concatenated the destination fields of the 3 controls above where the radio button destination is B1 (important for the solution).

A1=CONCATENATE(B1,C1,D1)

I then created a grid where A23=’Day’ and B23=FIND(A23,A1) and so on:

Grid.JPG

Then under the ‘Usage Options’ of the query you select the ‘When Value Becomes” = 1. For the screenshot below I used a ‘Day’ query. The ”FIND’ returns a numeric value of the first occurrence of the sting value, in this case 1.

Trigger.JPG

Also set the ‘Loading Message’ = 0 to reset the trigger. The desired queries will run and reset the trigger cell. This works fine for multiple queries pointing to the same trigger field. Any interaction with any of the controls will then repeat the process.

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