Business Objects OLAP Analysis reporting with SAP HANA – Part 2

Welcome to part-2 of the SAP Business Objects OLAP Analysis tutorial where we continue from Part-1. If you directly landed on this page, please make sure to read the first part by clicking here.

If you followed all the steps in the previous part 1 tutorial, the SAP Business Objects OLAP Analysis application would have now opened up. Similar to the excel add on, this web based alternative also requires you to define rows and columns of the report. Also, background filters can be defined but are optional.

The screen pretty much tells you what to do. First, we drop the SCORE column to the “Drop Columns” area.

OLAP Analysis

We see that there are no rows in this table yet so the scores have aggregated up.

Let’s fix this. Drag and drop EMP_ID into rows.

OLAP Analysis



1

This splits up the data by employee ID and we get a table as seen below.

We can have multiple types of analysis in the same report. Let’s go ahead and add a pie chart too.

To do this, first, switch to the “Insert Tab”

OLAP Analysis

Click on the button that looks like a pie chart to insert one.

OLAP Analysis

This brings up a pie chart which shows a distribution of overall scores by Employee in a Sub-Analysis.

OLAP Analysis




1

OLAP Analysis – Saving the report

Once a report is created, it’s important to save It into the SAP Business Objects repository so that other users can also access it. To do this, press the “Save” button as shown below.

OLAP Analysis

The default folder that opens up is usually the “Favorites” folder but it is recommended that you save these reports in a project folder where the user would come read it from. To view the list of public folder, click on the “Folders” button.

OLAP Analysis

Upon clicking the “Folders” button, it brings up the list of “Public Folders”. Save to your existing folder or else, create a new folder here.

Let’s create a new one which we will also use throughout the course of this section of the “Reporting on HANA” tutorial.

Press the Create folder button shown below.

OLAP Analysis

It would ask you for a folder name as shown below. I give it the name TEACHMEHANA.

Press OK when done.

OLAP Analysis

Click on this newly created folder and give it a filename. For example, I give it the name Employee_Analysis here. Press Save when done.

OLAP Analysis

The file name now reflects on top of the document. This confirms that the document was saved.

OLAP Analysis

This concludes our SAP Business Objects Analysis for OLAP integration with SAP HANA tutorial.

Please share this document across social media if you liked the content to help support this website.

Comment and subscribe to keep the community active.

Check out our next tutorials to learn more.

<<Previous Page                                                                                           Next Tutorial>>

Content Protection by DMCA.com

One Comment

Leave a Reply