SAP Dashboards (Xcelsius) Query Browser limitations

Introduction: Query browser is a brand new addin in SAP Business Objects 4.0. Before dashboards 4.0 when you want to source the dashboards with corporate data, you would use QAAWS/live office (query as a web service). From 4.0 onwards SAP has given a provision to connect to the universes directly using query browser. That’s only one side of the enhancement. The other side being that you can connect to a BEx query directly from the query browser. This has replaced the need for using the SAP Netweaver BW connection.

Advantages of using Query Browser: Before looking at the limitations of this topic, let’s look at the advantages of using the Query browser. SAP is promoting the query browser big time. Let’s look at why Read more

SAP Dashboard Query Browser Alternative – BIWS

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.

unable to map bex var to excel

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