Skip to Content
Author's profile photo Tammy Powlas

Creating a Dashboard against a BEx Query, Feature Pack 3/SP4

These are steps I learned last week in Ingo Hilgefort Mastering BI workshop in Melbourne.  A similar workshop will be available as a pre-conference at SAP TechEd, October 15th.

These are great features in Feature Pack 3/SP4 if you are a BW user.  In previous versions to use Dashboards you needed the BI Java type installed on BW.  This version you do not.

Note these steps are using BI4 SP4, using Dashboards against the BEx Query

First, you need to make this setting in the advanced tab of the BEx Query


The “allow external access to this query” flag needs to be turned on.  Then launch the Dashboards Design software (note that I installed ALL patches, up-to-date, using Download Manager).


From the query browser, select Add Query


Select BEx and click Next

At this point, it will depend on how the OLAP connections are built in BI4


Select a BEx Query

Next, we will add a component such as a column chart to the Dashboard

Then, you need to bind the data to the query.

In this example, we will bind the balance column to the Values Y series:


The projects will bind to the Category X series



Save project to the BI Platform

Open the Dashboard in the BI Launchpad


You can also learn about this if you attend the ASUG Pre-Conference BI4 Tools in a Day.  Read more about ASUG Sessions here–asug-sessions

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      I can't wait to start playing around with what I learnt at the workshop! This is really useful Tammy thank much easier than setting up universes,etc!

      Author's profile photo Former Member
      Former Member

      Hi Tammy, Thank u so much. It is very nice document.

      Did u see any performance difference between BICS(SAP NW BW Connection) and Add query(BEx).

      Please share if any.



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      No performance difference...but to be honest, I am always careful about what I am sending back (small amounts of data)

      Author's profile photo Lars Schubert
      Lars Schubert

      Nice post, thx!

      Author's profile photo Former Member
      Former Member

      Hi Tammy Powlas,

      We are using the system Feature Pack 3/SP4, but when we open the dashboard builder (version and Build 14,0,2,641) and click on add query , it is giving pop up to log into BOE , and after login to that , it is asking to add universe. As shown by you in the above screen shots we are not getting add bex query in the add query option. Please help us , as we are not able to diplay the reports from dashboard bulider into BOE.

      Thanks for the help .

      Author's profile photo James Batchelor
      James Batchelor

      The feature is very convenient but lacks many features from the BICS connection.  Like asking the query to return current filter values just run.  I use this to set data dirty flags that cause a refresh or some other state change.  I think the data connection is slower than either QaaWS or BICS.  At least in the models I have built in all three approaches to get the same BW data.  You cannot set hierarchy filter values via a component other than the query prompt component and this component cannot be driven via other components.  At least you do get a live hierarchy in this component though.

      Author's profile photo Former Member
      Former Member

      Very Informative post....even for first time user like me....thanks once again.

      Author's profile photo Lars Schubert
      Lars Schubert

      Hi Tammy, thanks for this post ... do SAP calls this also BICS?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Yes, I believe it is using the BICS interface to "talk" to the BEx Query

      Author's profile photo Lars Schubert
      Lars Schubert

      Thanks again, this naming confusion ... 🙂

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Dear Tammy,

      It was very helpfull for building a solution....

      Perfect document to understand the basic concepts of  " Dashboard against a BEx Query". Very nicely written article. I learnt the key views. It has been summarized very nicely