If you need alternatives to query browser in SAP Dashboards, Consider BIWS (SAP Business Intelligence web services)
Background: Your company has invested millions of dollars and purchased the BI 4.0 suite for reporting and dashboarding.
Problem: You are trying to build a dashboard in the traditional way and now you cannot map Bex variables to excel spreadsheet.
What does that mean to a dashboard design? SAP has restricted its customers from mapping the variables from BEx to excel spreadsheet. That means the only we can refresh a query is to use the “Query Prompt selector“. The query prompt selector itself works fine but its always a combo box for selection from user. If the user wants to click on the chart and refresh a query then its not possible. That is when you need to map the variables to the excel spreadsheet.
What can be done? Read more