Table of Contents

Open all
Close all
Introduction
11
1 Introduction to SAP BW on SAP HANA
17
1.1 Classifying SAP BW on SAP HANA Implementation Scenarios
17
1.1.1 Side-by-Side and Integrated Approaches
18
1.1.2 Operational Analytics
22
1.2 Current Challenges for SAP BW
24
1.2.1 Changing Environment
24
1.2.2 Disadvantages of Relational Databases
25
1.2.3 Distributed Data Retention
27
1.3 Reasons for Migrating an SAP BW System to SAP HANA
28
1.3.1 SAP BW Restrictions
29
1.3.2 Advantages of SAP BW on SAP HANA
31
1.4 Basic Technical Principles
34
1.4.1 In-Memory Technology
35
1.4.2 Column-Based Data Retention and Compression
37
1.4.3 Insert-Only Procedure
39
1.4.4 Partitioning
40
1.4.5 Push-Down Principle
41
1.5 Summary
43
2 SAP HANA Architecture
47
2.1 Hardware
48
2.1.1 Certification
49
2.1.2 Cloud
50
2.1.3 Scale-Up/Scale-Out
53
2.1.4 High Availability/Data Availability
54
2.1.5 Main Memory Management
55
2.2 Software
59
2.2.1 SAP HANA and Other Applications
59
2.2.2 SAP HANA on Virtual Machines
60
2.2.3 Operating System
62
2.3 Processes
64
2.3.1 Index Server
65
2.3.2 SAP HANA Engines
66
3 Migration and Implementation of SAP BW on SAP HANA
69
3.1 Migration and Implementation Scenarios
69
3.1.1 New Installation
72
3.1.2 Manual Migration
80
3.1.3 Migration Options: Database Migration Option (DMO) and Post Copy Automation (PCA)
85
3.1.4 Rapid Deployment Solutions
96
3.2 Technical Requirements for Migration
99
3.3 Preparation Steps
104
3.3.1 Creating a Homogenous System Copy
105
3.3.2 Cleanup Activities (SAP BW Housekeeping)
108
3.3.3 Identifying and Checking Sizing Requirements
121
3.3.4 Preliminary System Validation
132
3.3.5 Additional Tools
137
3.4 SAP BW on SAP HANA Migration
142
3.4.1 Export Preparations
145
3.4.2 Export Phase
149
3.4.3 Import Preparations
158
3.4.4 Import Phase
160
3.5 Post-Migration Steps
166
3.5.1 General Post-Processing
167
3.5.2 SAP BW-Specific Post-Processing
169
3.5.3 Identifying and Remedying Inconsistencies
170
3.5.4 SAP BW on SAP HANA-Specific Post-Processing
174
3.5.5 Concluding Activities
177
4 Migration Tips and Tricks
179
4.1 General Recommendations
179
4.2 Proof of Concept
188
4.3 Migration of an SAP BW System Landscape
195
5 Data Modeling in SAP BW on SAP HANA
209
5.1 Special Characteristics in Data Modeling for SAP BW on SAP HANA
210
5.1.1 Optimized Concepts for SAP BW on SAP HANA
210
5.1.2 New Features in SAP BW on SAP HANA
213
5.1.3 Impact of SAP BW on SAP HANA on ABAP Development
229
5.2 Developing and Modeling Environments in SAP HANA Studio
231
5.2.1 SAP BW Modeling Tools
231
5.2.2 Modeling SAP HANA Views in SAP HANA Studio
240
5.3 SAP HANA-Optimized InfoCubes
249
5.4 Simplification in Process Chains
258
5.5 Layered Scalable Architecture ++ (LSA++)
262
5.5.1 Consistent EDW Core of an LSA++
269
5.5.2 Open Operational Data Store Layer
277
5.5.3 SAP BW Virtual Data Mart Layer
291
5.5.4 Benefits of the LSA++ Architecture
292
5.6 The Concept of Non-Active Data (Hot/Warm/Cold)
294
5.7 Consuming SAP HANA Models in SAP BW
301
5.8 Planning Application Kit
313
6 Administration with SAP HANA Studio
319
6.1 Administration Perspective
322
6.1.1 Systems View
322
6.1.2 Administration Editor
324
6.2 User and Authorization Administration
326
6.2.1 Creating and Managing Users
327
6.2.2 Creating and Managing Roles
331
6.3 Monitoring
333
6.3.1 Main Memory and CPU
333
6.3.2 Hard Disks
339
6.3.3 Database Performance
342
6.3.4 Historic Performance Data
342
6.3.5 Troubleshooting
345
6.4 Database Configuration
351
6.4.1 global.ini
353
6.4.2 indexserver.ini
355
6.4.3 statisticsserver.ini and nameserver.ini
356
6.4.4 xsengine.ini
356
6.4.5 filter.ini
357
6.4.6 Creating and Restoring Backups
357
7 Reporting with SAP BW on SAP HANA
359
7.1 Reporting Trends
359
7.2 SAP BusinessObjects Business Intelligence as a Reporting Platform
363
7.2.1 Server Components
363
7.2.2 Client Tools
379
7.2.3 Summary for Reporting Using SAP BW on SAP HANA
410
8 Nearline Storage for SAP BW on SAP HANA
411
8.1 Connecting the Nearline Storage System with SAP BW
414
8.2 Data Archiving
417
9 Outlook: The Future of SAP BW Reporting
427
9.1 SAP HANA Live for Operational Reporting
428
9.2 Reasons for SAP BW
433
Appendices
437
A Appendix
439
A.1 List of Abbreviations
439
A.2 SAP Notes Used
442
A.3 ABAP Reports Used
447
A.4 Important Transactions
448
A.5 Important Views
451
A.6 SQL Statements
452
B The Authors
457
Index
459