Skip to Content

How to create Dashboard using Query Browser (BICS)

Hi All,

Idea behind this document is show simple scenario how to create dashboard using the Bex Query with the help of query browser for the beginners/novice. I have seen many blogs or document which have already explained this, but not completely like how to append the query browser objects into the spreadsheet.

Not getting too much into the prerequisite, because lot many have already discussed about this in the community. You can go through the below document which explains this in detail about the prerequisite.

Creating BO Dashboard from BEx Queries

Note: Query Browser will not support cross tab reports created in SAP BW, Either you need to list the output of the query in horizontal or vertical view.

I have used two objects Plant & Net value and previewed them in the bottom part of the screen.

ScreenHunter_24 Aug. 06 15.21.gif

Finally click ok to complete the query.

ScreenHunter_25 Aug. 06 15.25.gif

Now the query is ready.

ScreenHunter_26 Aug. 06 15.27.gif

So far what we have seen from the tutorials is to bind the objects directly to the components, but here what i am trying to do is appending into spreadsheet and then taking them into the chart. This helps to play with the data rather than directly binding them.

Always the best practice would be to color it down in the spreadsheet to identify, where you have mapped the data. Randomly i have taken 40 cells i.e., Sheet1!$C$5:$C$40 to bind the Plant medium Text data. This you need to consult with the functional or corresponding team. They can provide you the details like how many rows are there and maximum it can reach.

ScreenHunter_28 Aug. 06 15.43.gif

After Mapping both the Plant & Net value now its time to bind the ranges into the component. Here i have taken the Bar chart to display the data.

ScreenHunter_29 Aug. 06 15.50.gif

From the above screenshot i have taken the ranges of the same Sheet1!$C$5:$C$40 for Plant & Sheet1!$D$5:$D$40 for the Net value. Presently there is only 30 to 35 rows it may increase in future, so use the “Ignore blank cells” option in behavior tab.

ScreenHunter_30 Aug. 06 15.53.gif

Now the data is ready to display.

ScreenHunter_31 Aug. 06 15.56.gif

As of the display looks raw, changing the scale into “Fixed” and making the axis into “logarithmic” from “linear” will help the other plant to display the value in the same chart.

ScreenHunter_32 Aug. 06 16.00.gif

Final Display.

ScreenHunter_33 Aug. 06 16.02.gif

Hope this document helped the beginners, please leave your valuable comments and suggestion to improve the document.


Suman T

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