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

[TammyPowlas]

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 http://scn.sap.com/community/events/teched/blog/2012/07/21/time-to-talk-teched--asug-sessions