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