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.
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.
Finally click ok to complete the query.
Now the query is ready.
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.
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.
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.
Now the data is ready to display.
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.
Hope this document helped the beginners, please leave your valuable comments and suggestion to improve the document.