Skip to Content

Step by Step procedure of how to consume SAP HANA views in Dashboards.

Hello,

This is a very simple document which will give you step by step guidance on how to consume HANA views in Business objects dashboard.

you have to create a universe in semantic layer using IDT (Information Design Tool). Using the universe we create a report in Dashboard.


Creating dashboard on HANA views involves three basic steps.


Prerequisite:

HANA views- Analytic view is already created in SAP HANA.

Execution steps:

  1. Creation of a universe.
  2. Creation of a dashboard.
  3. Publishing and viewing dashboards.

For Universe Development Please Click here

http://scn.sap.com/community/developer-center/hana/blog/2015/04/17/end-to-end-integrated-scenario-of-ecc-hana-and-bo-ecc-to-hana-and-hana-modelling-part-1

Detailed Steps:

1.   Click on Start –>SAP Business Intelligence–>SAP Business Objects Dashboards.

/wp-content/uploads/2015/04/s1_687921.png


Dashboard main screen gets open

/wp-content/uploads/2015/04/s2_687950.png

Click on file –>new

/wp-content/uploads/2015/04/s3_687952.png

After clicking on new you will find new sheet on your screen.

/wp-content/uploads/2015/04/s4_687960.png

Now to select your chart go to component tab which is on the left side.

Click on column chart

/wp-content/uploads/2015/04/s5_687961.png

Drag and drop the column chart on the main screen

/wp-content/uploads/2015/04/s6_687962.png

After that go to query browser–>Add query.

/wp-content/uploads/2015/04/s7_687963.png

System will ask you username and password after filling all details click on ok.

/wp-content/uploads/2015/04/s8_687980.png

You will get multiple options universe and BEx.

Choose universe and then click next

/wp-content/uploads/2015/04/s9_687981.png

Your system name and universe will get reflect and then click on next.

/wp-content/uploads/2015/04/s9_687981.png

Your system name and universe will get reflect and then click on next.

/wp-content/uploads/2015/04/ss10_687987.png

Select your universe name BL_Po_Analysis.unx and click on next.

/wp-content/uploads/2015/04/s11_687988.png

Once you select your universe all dimensions and measure will get visible on left side under BL_PO_Analysis.

/wp-content/uploads/2015/04/s13_687992.png

Drag and drop dimension PO_Nmbr and Measure Qty in the result objects and click ok.

/wp-content/uploads/2015/04/s14_687993.png

After Build Query then comes Preview query result where you can see PO_nmbr and Qty then click ok.

/wp-content/uploads/2015/04/s15_687998.png

In this usage options We can set the Refresh Options and Load Status messages.

Click “OK” to confirm the selection and execute the Query.

/wp-content/uploads/2015/04/s16_687999.png

After this you can see your column chart on screen and on right side there is radio button name By Range click on that radio button.

/wp-content/uploads/2015/04/s17_688000.png

Go to query browser–>Result Objects. Your dimension PO_Nmbr and measure Qty, Click on  Insert in Spreadsheet one after the other.

/wp-content/uploads/2015/04/s18_688020.png

Choose po_nmbr. Once you select po_nmbr which is dimension then spreadsheet range will get display.

/wp-content/uploads/2015/04/s19_688028.png

Then select number of columns listed under po_numbr in the below spreadsheet.

Just for our understanding you can add color the selected fields.

/wp-content/uploads/2015/04/s20_688029.png

After selecting fields from po_numbr click ok.

/wp-content/uploads/2015/04/s21_688030.png

In the same way select Qty that is measure select it and click on ok in the select a range box.

/wp-content/uploads/2015/04/s22_688034.png

Give different colour for better understanding.

/wp-content/uploads/2015/04/s23_688035.png

After selecting qty click ok.

/wp-content/uploads/2015/04/s24_688036.png

Once you click on by series radio button then select qty which is your measure in the spreadsheet then range value will get display and then click on ok.

/wp-content/uploads/2015/04/s25_688037.png

In the same way now select po_numbr which is dimension then range value gets display and then click ok.

/wp-content/uploads/2015/04/s26_688038.png

When you select your dimension and measure that is po_numbr and qty from the below spreadsheet then click on preview button which is on the top.

/wp-content/uploads/2015/04/s27_688039.png

Now here you can see your column chart ready after clicking on preview button.

/wp-content/uploads/2015/04/s28_688043.png

In this chart you can see series2 which is nothing but when you choose by series radio button series get reflect and po_nmbr (dimension) and Qty (Measure).

/wp-content/uploads/2015/04/s30_688044.png





Hope this helps to the freshbees on SAP HANA and Business Objects Dashboards.

Thanking you,

Shraddha Adsule

Be the first to leave a comment
You must be Logged on to comment or reply to a post.