Sap gbi

© SAP SE

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.