Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply