Skip to Content

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

/wp-content/uploads/2012/08/1fig_130148.png

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).

/wp-content/uploads/2012/08/2fig_130149.png

From the query browser, select Add Query

/wp-content/uploads/2012/08/3fig_130150.png

Select BEx and click Next

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

/wp-content/uploads/2012/08/4fig_130151.png

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:

/wp-content/uploads/2012/08/5fig_130152.png

The projects will bind to the Category X series

/wp-content/uploads/2012/08/6fix_130153.png

/wp-content/uploads/2012/08/7fig_130154.png

Save project to the BI Platform

Open the Dashboard in the BI Launchpad

/wp-content/uploads/2012/08/8fig_130155.png

You can also learn about this if you attend the ASUG Pre-Conference BI4 Tools in a Day.  Read more about ASUG Sessions here http://scn.sap.com/community/events/teched/blog/2012/07/21/time-to-talk-teched–asug-sessions

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. zimkhita buwa

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

    (0) 
  2. Rajendra Cheraku

    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.

    Thanks,

    Raj

    (0) 
  3. shiva k

    Hi Tammy Powlas,

    We are using the system Feature Pack 3/SP4, but when we open the dashboard builder (version 6.0.0.0 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 .

    (0) 
  4. 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.

    (0) 
  5. 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

    (0) 

Leave a Reply