SAP BW/BW HANA Training Complete Guide (196 Pages)

Table of contents

1 INTRODUCTION TO BUSINESS INTELLIGENCE & DATA

WAREHOUSING ....................................................................................................... 3

1.1. 1.2. 1.3. 1.4. 1.5. 1.6. BUSINESS INTELLIGENCE AND DATA WAREHOUSING .................................... 3

THE CLASSIC STAR SCHEMA .......................................................................... 4

INTRODUCTION TO SAP BW .......................................................................... 5

SAP BW ARCHITECTURE .............................................................................. 6

THE SAP BW STAR SCHEMA ......................................................................... 8

INTRODUCTION TO ADMINISTRATOR WORKBENCH (AWB) ......................... 13

2 INTRODUCTION TO INFOOBJECTS & INFOCUBES ............................ 16

2.1. INTRODUCTION TO INFOOBJECTS ................................................................. 16

2.2. TYPES OF INFOOBJECTS ............................................................................... 16

2.3. CHARACTERISTIC INFOOBJECT .................................................................... 18

2.4. CREATING A CHARACTERISTIC IN THE INFOOBJECT TREE ........................... 28

2.5. KEY FIGURES ............................................................................................... 30

2.6. INFOCUBES .................................................................................................. 34

2.7. BASISCUBES ................................................................................................ 35

2.8. CREATING AN INFOCUBE IN THE INFOPROVIDER TREE ................................ 39

2.9. TECHNICAL IMPLEMENTATION OF SAP BW STAR SCHEMA ......................... 43

3 DATA TRANSFER PROCESS IN SAP BI .................................................... 59

3.1. 3.2. 3.3. 3.4. 3.5. 3.6. 3.8. 3.9. OVERVIEW OF DATA TRANSFER PROCESS .................................................... 59

DATA TRANSFER PROCESS – EXAMPLE ........................................................ 61

CREATING AND MANAGING DTP ................................................................. 62

ERROR HANDLING OF DTP .......................................................................... 67

ERROR STACK IN DTP ................................................................................. 68

TEMPORARY STORAGE FOR DTP ................................................................. 72

3.7. DTP MONITOR ............................................................................................. 74

MANAGING INFOCUBES-DATA MAINTENANCE ........................................... 80

USING BW MONITOR ................................................................................... 93

4 DATA STORE OBJECTS (DSO) ................................................................... 98

4.1. 4.2. 4.3. 4.4. DATA STORE OBJECT DEFINITION: ............................................................... 98

DATA STORE OBJECT TYPES ...................................................................... 100

DATA STORE OBJECT ADMINISTRATION .................................................... 107

DATASTORE OBJECT ADMINISTRATION - PERFORMANCE: ......................... 110

5 MULTIPROVIDERS ..................................................................................... 112

5.1. ADVANTAGES OF MULTIPROVIDER ............................................................ 1135.2. 5.3. MULTIPROVIDER, APPLICATION EXAMPLE ................................................ 113

CREATING A MULTIPROVIDER ................................................................... 116

6 AGGREGATES .............................................................................................. 119

6.1. USING AGGREGATES .................................................................................. 119

6.2. AGGREGATES AND MASTER DATA CHANGES ............................................ 125

7 ADMIN COCKPIT ......................................................................................... 132

8 PROCESS CHAINS........................................................................................ 132

8.1. 8.2. OVERVIEW OF PROCESS CHAINS ................................................................ 132

STRUCTURE OF PROCESS CHAINS ............................................................... 133

9 GENERIC R/3 DATA EXTRACTION ........................................................ 137

9.1. 9.2. 9.3. CREATING VIEWS IN R/3 ............................................................................ 137

CREATING DATASOURCES IN R/3. ............................................................. 139

LOADING DATA FROM R/3 INTO BW ......................................................... 140

10 LOGISTICS COCKPIT ............................................................................. 145

10.1. 10.2. WHAT IS LOGISTIC COCKPIT (LC)? ........................................................ 145

LOGISTIC COCKPIT FUNCTIONS .............................................................. 146

11 REPORTING AND ANALYSIS ............................................................... 151

11.1. SAP BW BUSINESS EXPLORER ............................................................... 151

11.2. WORKING WITH BEX ............................................................................. 153

11.3. BEX ANALYZER ..................................................................................... 159

11.4. RESTRICTED KEY FIGURES .................................................................... 167

11.5. CALCULATED KEY FIGURES .................................................................. 170

11.6. VARIABLES ............................................................................................ 175

11.7. CONTENT VARIABLES ............................................................................ 179

11.8. EXCEPTIONS ........................................................................................... 180

11.9. CREATING EXCEPTIONS ......................................................................... 180

11.10. CONDITIONS ........................................................................................... 187

12 BEX WEB APPLICATION DESIGNER ................................................. 189

12.1. INTRODUCTION ...................................................................................... 189

12.2. FEATURES .............................................................................................. 189

12.3. SAMPLE WEB DASHBOARDS .................................................................. 196