Hello People ,

Here is a document on simple reporting in dashboard 4 for beginners ,who are very much new to Dashboard Reporting Tool version 4.1

Here our source is BW System working on HANA database , we will be using the BICS(Business Intelligence Connectivity Services ) connection to consume the BEx Query created in BW on HANA  into our Dashboard Reporting Tool

Following are the steps :

Go to Start –> All Programs –>SAP Business Intelligence –> SAP Business Objects Dashboards 4 –> SAP Business Objects Dashboards

/wp-content/uploads/2015/04/1_687989.png

After Clicking  on  SAP Business Objects Dashboards then click on  blank model

/wp-content/uploads/2015/04/2_687991.png

    Dashboard’s main screen will get open

/wp-content/uploads/2015/04/3_687996.png

   Click on file –> New

/wp-content/uploads/2015/04/4_688004.png

   Go to Query Browser –> Add Query

/wp-content/uploads/2015/04/5_688006.png

    Click on Add Query.

/wp-content/uploads/2015/04/6_688007.png

    Once you click on add query fill login credentials and then click ok.

/wp-content/uploads/2015/04/7_688008.png

You will find two options universe and BEx. As our source is BEx Queries from  BW on HANA  we will select  BEx and click on Next.

/wp-content/uploads/2015/04/8_688009.png

  Now select your username and click next.

/wp-content/uploads/2015/04/9_688010.png

You will find BW7.4 connection under connections and then click next

NOTE : This connection is already created , if not please contact the respective administrative team

/wp-content/uploads/2015/04/10_688011.png

   Now select the respective BEx query on which the reporting needs to be performed.

/wp-content/uploads/2015/04/11_688012.png

   Check the “Refresh Before Components Are Loaded “and click ok

/wp-content/uploads/2015/04/13_688016.png

   Go to Query Browser –> Select a particular dimension or measure and connect it with the spreadsheet ,by clicking on red arrow beside

   “Insert in Spreadsheet ” and then Select the Range

/wp-content/uploads/2015/04/14_688017.png

    Now color the selected cell (it is not mandatory step , just for our reference so that we don’t get confused ).

/wp-content/uploads/2015/04/15_688022.png

    Go to Components –> Select  Charts or Selectors as per requirement

   We have selected a simple Spreadsheet Table

/wp-content/uploads/2015/04/16_688023.png

    Select spreadsheet table chart

/wp-content/uploads/2015/04/17_688025.png

    Once you select spreadsheet chart drag and drop it.

/wp-content/uploads/2015/04/18_688026.png

Select that spreadsheet chart and click on preview button , you can view a very basic report

/wp-content/uploads/2015/04/19_688027.png

For End to End Scenario of Web Intelligence Reporting please find a link below :

End to End Scenario of SAP -BW on HANA-Web Intelligence Reporting


To report this post you need to login first.

3 Comments

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

Leave a Reply