Master Course Business Consulting
Data warehouse and Business
Intelligence
Introduction to
SAP NW / BI 7.20
Health Care Management
Case Study
Hochschule Furtwangen,
Business Informatics Systems
Fernanda Castillo Almeida, MSc
Content:
1.
2.
SAP NW/BI Architecture
SAP NW/BI Workbench
2.1 . SAP NW/BI Objects
2.2. SAP NW/BI Definition
SAP BI Solution Implementation
3.1. Creation of InfoObjects
3.2. ETL Process: Master Data
3.3. ETL Process: Transactional Data
3.
2
3/2/16
1. SAP BI Architecture
3
Hochschule Furtwangen,
Marketing & ffentlichkeitsarbeit
3/2/16
1. SAP BI Architecture
Basic Business Intelligence Architecture
4
Hochschule Furtwangen,
Business Informatics Systems
Source: Database Systems: Design, Implementation, & Management, Rob & Coronel
3/2/16
2. SAP Netweaver Workbech
5
Hochschule Furtwangen,
Business Informatics
3/2/16
2.1. Objects in SAP Netweaver: Modeling
Info Provider
Info Source
Info Area
Data Transfer Process
Info Cube
Transformation
Data Source
InfoObjects
Application Component
Info Object Catolog
Info object Character
Info Object Key figure
Info package
Transformation
2.2. Objects in SAP Netweaver: Definitions
InfoProvider
Are objects for which the queries in SAP BW can be created or executed. Contains :
Physical data.: InfoCubes, ODS objects, and InfoObjects (characteristics with attributes, texts, etc)
No physical data: InfoSets, RemoteCubes, SAP RemoteCubes, and MultiProviders.
Info Cube
An InfoCube is a group of relational tables arranged according to the star schema.
It is also an object that can function as both a data target and an InfoProvider.
Transformation
With transformations, data loaded within the SAP NetWeaver BI system from the specified interfaces is
transferred from a source format to a target format in the data warehouse layers.
The transformation permits you to consolidate, clean up and integrate the data and thus to synchronize it
technically and semantically, permitting it to be evaluated.
7
2.1. Objects in SAP Netweaver: Definitions
InfoCube Example
8
2.2. Objects in SAP Netweaver: Definitions
Info Area:
An InfoArea is a directory of InfoProviders and InfoObject catalogs used in the same
business context. Every InfoProvider or InfoObject catalog belongs to exactly one single
InfoArea.
Info Object Catolog
InfoObject Catalog is a collection of InfoObjects grouped according to application
specific criteria. There are two types of InfoObject catalogs: Characteristic and Key
Figure.
Key figures provide the values to be
analyzed. They can be quantities,
amounts, or numbers of items, for
example Admission Time, Discharge
Time and Duration Time.
Characteristics are sorting keys, such
as product, customer group, fiscal year,
period, or region.
2.2. Objects in SAP Netweaver: Definitions
Info Source
Data that logically belongs together and is stored in the SAP (BW) System in the form of InfoSources.
An InfoSource contains a number of InfoObjects which defined the structure and information needed to create InfoCubes / ODS
Objects in the SAP (BW) System.
An InfoSource is an object that, at the request of SAP (BW) System, makes data available to the InfoCubes .
Data Transfer Process
DTP is used to transfer data within BI from one persistent object to another object, in accordance with certain
transformations and filters.
10
2.2. Objects in SAP Netweaver: Definitions
11
Hochschule Furtwangen,
Wirtschaft Informatik
Database Systems: Design, Implementation, & Management, Rob & Coronel
PSA (Persistent Staging Area)
After being extracted from a source system, data is transferred to the entry layer of the
Enterprise Data Warehouse, the persistent staging area (PSA). The data from the
source system is stored unchanged in this layer. It provides the backup status at a
granular level and can offer further information at a later time in order to ensure a quick
restart if an error occurs.
12
Hochschule Furtwangen,
Wirtschaft Informatik
Database Systems: Design, Implementation, & Management, Rob & Coronel
2.2. Objects in SAP Netweaver: Definitions
Data Source
A DataSource is a set of fields that provide the data for a business unit for data transfer into BI.
From a technical viewpoint, the DataSource is a set of logically-related fields that are provided to
transfer data into BI in a flat structure (the extraction structure), or in multiple flat structures (for
hierarchies).
Types of DataSource:
DataSource for transaction data
DataSource for master data
Info package
Infopackage is Data loading Scheduler from where You can execute your extraction of data from
Source system.
Info Package also an object which is used to load data from one target to other in BW system.
13
2.2. Objects in SAP Netweaver: Definitions
14
3. Business Intelligence Implementation in SAP NW/BI
Type
CLINICAL
Key KPIs
Drill down KPI
Clinical Outcomes
After defining:
1. Business Case
2. KPIs (Key Performance Indicators)
3. Data Model (Star Schema, etc)
Diseases
Medical Treatment
ER Performance
OPERATIONAL
Outcome for each patient admitted based on
their medical condition; considering:
Length of stay
Status of patience
1. Total of Patients per Disease.
2. Most Common Disease
1.
Most Common Medical Treatments
2.
Medical Treatment Costs
1. Number of Patients in ER
2. Average of Length stay in ER (Waiting
Times)
Inpatient Mortality Rate
1. Total death rate per disease
2. Total death rate per medical Procedure.
Health Insurance
1. Number of patients that dont have health
insurance Coverage.
2. Number of Patient per Health Insurance.
KPI Example for a BC in HealthCare Industry
15
3/2/16
3. Business Intelligence Implementation in SAP NW/BI
Star Schema Example for a BC in Health Care Industry
16
3/2/16
3. Business Intelligence Implementation in SAP NW/BI
1. Creation of InfoObjects
2. ETL Process of Master Data
3. ETL Process of Transactional Data
4. Creation of Queries, Reports, etc.
17
3/2/16
3.1. InfoCatalogs and InfoObjects
1. Create InfoArea
2. Create InfoCatalogs
1. Characteristics
2. Key Figures
3. Create InfoObjects
1. Characteristics
2. Key Figures
18
Hochschule Furtwangen,
Wirtschaft Informatik
3.2. ETL Process 1 : Master Data
InfoObject
1. Select Source System (CSV file)
2. Create Data Source
TR
3. Create InfoPackage
4. Create Transformation
5. Create and Start Data Transfer Process
NOTE: Before starting the Transformation of Master Data, add
the infoobjects into the InfoProviders.
19
Hochschule Furtwangen,
Wirtschaft Informatik
3
Data Source
3.3. ETL Process 2:Transactional Data
1. Create InfoCube
Add the Dimensions (InfoObjects)
Add Key Figures
Check Navigation Attributes
2. Create Data Source
3. Create InfoPackage for DataSource
4. Create InfoSource
5. Create Transformation for InfoSource
6. Create Transformation for InfoCube
7. Add formula in the InfoCube
8. Create and Start Data Transfer Process
20
Hochschule Furtwangen,
Wirtschaft Informatik
Example of the Data Flow