Sap hana case study pdf

CASE STUDY

Product

SAP ERP on HANA Release 6.07 G.B.I.

Level

Undergraduate Graduate Beginner

Focus

Big Data Analysis

Authors

Kristof Schneider Stefan Weidner

Version

2.30

MOTIVATION

This case study describes how to analyze and visualize data using the GBI Sales Monitor. The scenario (three questions varying from easy to difficult) is based on sales data of the Global Bike Inc. enterprise in the US and Germany.

The main learning objective is to analyze and report on extensive sales order data based on the GBI dataset using a simple web-based analysis application.

PREREQUISITES

The free-of-charge demo system is hosted at SAP UCC Magdeburg. The application is available via the following link: http://gbionhana.ucc.ovgu.de User TEST_USER Pass hana2015 For more scenarios please check the GBI Sales Monitor exercises.

NOTES

This case study uses the Global Bike Inc. (G.B.I.) data set, which has been created exclusively for SAP UA global curricula. The authors would like to thank Tom McGinnis and Simha Magal as well as the many hardworking graduate students at Grand Valley State University and Otto von Guericke University Magdeburg who contributed to the development of this curriculum material.

Big Data Analysis using GBI Sales Monitor with SAP ERP on HANA This case study introduces the GBI Sales Monitor as a data analysis and visualization tool using three exemplary scenarios based on GBI sales data.

http://gbionhana.ucc.ovgu.de/
© SAP SE Page 2

CASE STUDY

Process Overview

Learning Objective Get familiar with data analysis and visualization. Time 30 min

Scenario Every day, Global Bike Inc. employees use various standard sales reports implemented

both in SAP ERP and SAP BW. In addition to these operational problems management requests

need flexible ad-hoc reporting. In contrast to desktop tools like SAP Lumira (see Big Data

Analysis Using SAP Lumira Desktop curriculum), the GBI Sales Monitor is a light-weight web

application running in any Internet browser.

Employees involved Alex Kuhn (Vice President Marketing US)

Karim Messalem (Sales Person US West, San Diego)

Jacque Bonnet (Sales Person Germany South, Heidelberg)

Scenario 1 Alex Kuhn (Vice President Marketing US) needs an ad-hoc

report on total revenue for Big Apple Bikes.

Scenario 2 Karim Messalem (Sales Person US West) is looking for order

details of sales order #8077.

Scenario 3 Jacque Bonnet (Sales Person Germany South) needs to find

the best and third-best product (by profit) of customer NeckaRad .

Scenario details

© SAP SE Page 3

CASE STUDY

Scenario 1 – Total revenue

Task Report the total revenue for Big Apple Bikes. Time 10 min

Short Description Use the GBI Sales Monitor web application to find out the revenue total for

customer Big Apple Bikes.

Name (Position) Alex Kuhn (Vice President Marketing US)

In order to run the GBI Sales Monitor web application, open an Internet

browser and type in (or copy) the following URL:

http://gbionhana.ucc.ovgu.de

Web application link

The following HANA Login screen should appear.

HANA Login screen

Please type in the below login credentials and press Enter.

User: TEST_USER (must have the underscore between

TEST and USER)

Password: hana2015

Demo user

Now, you should be displayed the first tab (Sales Monitor) of the web

application – see screenshot below. Initially, you see all sales orders as no

particular customer was preselected.

GBI customers

All customers are shown on the world map as well as listed in the table

beneath – sorted by their IDs in GBI’s SAP ERP system.

http://gbionhana.ucc.ovgu.de/
© SAP SE Page 4

CASE STUDY

On the right, you see a list of all GBI sales orders (11582) with a revenue

total of 393,069,835.21 USD.

Sales order list

Because no sales order was preselected, the order details beneath the list

appear blank.

Sales order details

In order for Mr Kuhn to report the revenue total for Big Apple Bike, he

needs to select this customer. There are two options to do so.

Reporting

Option 1 Zoom into the map and click on the correct pin for Big Apple

Bikes (in New York).

© SAP SE Page 5

CASE STUDY

Option 2 Select Big Apple Bikes by clicking on the customer’s row in the

table beneath the world map.

As a result, you see all orders for Big Apple Bikes in the sales order list on

the right.

Sales order list

On the very right side, you can read the total net revenue for the selected

customer.

Total net revenue

Note In order to deselect a customer (to go back to the full sales order list

for all GBI customers), click on the cross in the customer details pop-up on

the world map.

Deselect customer

© SAP SE Page 6

CASE STUDY

Scenario 2 – Sales order details

Task Find out order details of sales order #8077. Time 10 min

Short Description Use the GBI Sales Monitor web application to find out the revenue total, the

customer (ID and name), the order status and the line items of sales order #8077.

Name (Position) Karim Messalem (Sales Person US West, San Diego)

In order for Mr Messalem to find order details of sales order #8077, he

needs filter the sales order ID column in the list on the right side.

Reporting

Note If customer Big Apple Bikes is still selected (from scenario 1) please

deselect the customer by clicking on the cross in the customer details pop-

up on the world map.

Deselect customer

To filter sales orders, click on the Sales Order ID column header until the

following popup appears.

In the Filter text box, type in sales order number 8077 and press Enter. This

will reduce the sales order result list to the sales order of interest.

8077

From the sales order overview (sales order list), you can already find the

sales order total net revenue (41,003.25 USD) and the customer name

(SoCal Bikes).

41,003.25 USD SoCal Bikes

In order to find the other details, you need to select the sales order in the

sales order list by clicking on the one remaining row.

© SAP SE Page 7

CASE STUDY

On the General Data tab, you see that the order is Completed and that

SoCal Bikes’ customer ID in the SAP ERP system is 9000. Then, click on

the Order Items tab.

Completed

9000

Now, the system displays line item details such as material, quantity, and

revenue.

© SAP SE Page 8

CASE STUDY

Scenario 3 – Best products by profit

Task Find the best and the third-best product of customer NeckaRad. Time 10 min

Short Description Use the GBI Sales Monitor web application to find the best and the third-best

product (by profit) sold to NeckaRad.

Name (Position) Jacque Bonnet (Sales Person Germany South, Heidelberg)

In order for Mr Bonnet to find the best and the third-best product sold to

customer NeckaRad, he needs to select the customer first.

Reporting

Either zoom into Germany on the world map and click on the pin for

NeckaRad (in Heidelberg) or select the customer from the list beneath the

map.

Then, leave the SALES MONITOR tab by clicking on the REPORTING

tab (at the top of the screen). On the right, the application displays the top

materials by net revenue and profit.

You can see that the Professional Touring Bike (red) was the best-selling

material to customer NeckaRad with 1,082,389.89 USD.

Professional Touring Bike

(red)

© SAP SE Page 9

CASE STUDY

The third-best product (by profit) sold to NeckaRad was the Professional

Touring Bike (silver) with 986,312.22 USD.

Professional Touring Bike

(silver)