Excel ‘FIND’ function to trigger queries in SAP Dashboards.
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.
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).
I then created a grid where A23=’Day’ and B23=FIND(A23,A1) and so on:
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.
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