Introduction

15

History of Data Warehousing

15

Evolution of In-Memory-Based Data Warehouse Solutions

17

The Evolution of Cloud-Based Data Warehouse Systems

18

Acknowledgments

18

1 Introduction to SAP BW/4HANA

21

1.1 SAP BW/4HANA Overview

21

1.1.1 A Brief History of SAP Business Warehouse

21

1.1.2 SAP Business Warehouse 7.x Objects

23

1.1.3 Evolution of SAP BW/4HANA

29

1.1.4 SAP BW/4HANA Design Principles

30

1.2 What’s New in SAP BW/4HANA?

35

1.2.1 Eclipse-Based Modeling Tool

35

1.2.2 SAP BW/4HANA Data Modeling Objects

37

1.3 Summary

48

2 Overview of SAP BW/4HANA Migration

49

2.1 Business Scenarios

49

2.1.1 Organizations without an SAP Business Warehouse Landscape

49

2.1.2 Organization with an SAP Business Warehouse System Landscape

50

2.2 SAP BW/4HANA Conversion Types

53

2.2.1 Greenfield SAP BW/4HANA Implementation

54

2.2.2 In-Place Conversion

55

2.2.3 Remote Conversion

58

2.2.4 Shell Conversion

61

2.2.5 Landscape Transformation

62

2.3 Phases in SAP BW/4HANA Conversion

63

2.3.1 Conversion Prepare Phase

63

2.3.2 Conversion Realization Phase

65

2.4 Project Management

67

2.5 Summary

68

3 System Preparation and Prerequisites

69

3.1 System Requirements for SAP BW/4HANA

69

3.2 Impacts on the System Landscape

71

3.3 Preparing the System

74

3.3.1 Minimum Supported Release for Original System

74

3.3.2 Minimum Support Release for Target System

75

3.4 Supported Source Systems

76

3.4.1 SAP Business Suite Applications

76

3.4.2 SAP Business Warehouse

76

3.4.3 SAP Source System and Operational Data Provisioning Readiness

77

3.4.4 Other Source Systems

78

3.5 Maintenance Planner

78

3.6 Data Volume Management

83

3.7 SAP Business Warehouse Sizing

84

3.8 Installing the Note Analyzer Report

92

3.9 SAP Readiness Check for SAP BW/4HANA

94

3.9.1 Readiness Check Basics

94

3.9.2 Basics of the ST-A/PI Add-On

95

3.9.3 Prerequisites

96

3.9.4 Executing SAP Readiness Check for SAP BW/4HANA

98

3.9.5 Functions Available in the SAP Readiness Check for SAP BW/4HANA

100

3.9.6 Viewing the SAP Readiness Check for SAP BW/4HANA

102

3.10 Prechecks for SAP BW/4HANA Migration

105

3.10.1 Installing Precheck Tools

106

3.10.2 Executing Prechecks

107

3.10.3 Fixing Issues in the Precheck Report

114

3.10.4 Sizing Report

116

3.10.5 Code Scan

117

3.10.6 Cleanup Reports

119

3.11 SAP BW/4HANA Simplification List

119

3.11.1 SAP Business Warehouse 3.X Data Flows

120

3.11.2 Core Data Warehouse Modeling Objects

121

3.11.3 Data Staging

126

3.11.4 Source Systems

131

3.12 Summary

133

4 Remote Conversion

135

4.1 Overview of Remote Conversion

135

4.2 SAP BW/4HANA Target System Provisioning

136

4.2.1 Installing the SAP HANA Database

136

4.2.2 Installing SAP BW/4HANA

141

4.2.3 Post-Installation Steps

151

4.2.4 Creating Source Systems

155

4.2.5 Settings in the SAP BW/4HANA System

159

4.2.6 Installing Essential Add-Ons

163

4.3 SAP BW/4HANA Sender System Provisioning

166

4.3.1 Data Migration Integration Server Checks

166

4.3.2 Sender System Landscape Preparation with Note Analyzer

166

4.4 Source System Provisioning

168

4.5 Preparing for Remote Conversion

169

4.5.1 Project Planning and Understanding

169

4.5.2 User Roles and Authorizations

170

4.6 Basics of the SAP BW/4HANA Conversion Cockpit

175

4.6.1 Overview

176

4.6.2 Scope Check Tool

179

4.6.3 Task List Based on Transaction STC01 and Transaction STC02

183

4.6.4 Essential Checks before Remote Conversion

185

4.6.5 Evaluating Scope Objects

187

4.7 SAP Business Warehouse Data Model

187

4.8 Package Creation

190

4.9 Execution

192

4.9.1 Package Settings

192

4.9.2 Collect Scope and Metadata Transfer

194

4.9.3 Define Object Mapping and Store Object List

198

4.9.4 Prepare Propagate Request

201

4.9.5 Map InfoObject for InfoProvider

202

4.9.6 Select Main Partition Criteria for Semantically Partitioned

203

4.9.7 Determine Usage of Involved Objects

203

4.9.8 Checklist for Usage of Involved Objects

204

4.9.9 Confirm Metadata in Target System with Data Transfer Prep

205

4.9.10 Setup Phase

211

4.9.11 Select Conversion-Relevant InfoObjects

217

4.9.12 Define Mapping Values

218

4.9.13 Make Settings for Conversion-Relevant InfoObjects.

219

4.9.14 Generation Phase

220

4.9.15 Preprocessing Programs During System Lock

225

4.9.16 Copy Delta Queues from SAPI to ODP Technology

226

4.9.17 Confirm That Delta Was Loaded to Cloned DataSources

229

4.9.18 Check Whether Delta Queues Can Be Copied from SAPI to ODP

231

4.9.19 Confirm the INIT SIMU Procedure

231

4.9.20 Make Settings to Prepare to Lock All Data Changes

231

4.9.21 Migration Phase

235

4.9.22 Make Runtime Settings for Migration

235

4.9.23 Reset Cluster Data Deletion Date

236

4.9.24 Start Migration

237

4.9.25 Monitor: Transformation Status (Optional)

237

4.9.26 Confirm Data Selection and Unlock Data Loading

239

4.9.27 Verify Task Completion

239

4.9.28 Post Processing Activities During System Lock

240

4.9.29 Execute RSRV Checks in the Target System

241

4.9.30 View Time-Related Migration Statistics (Optional)

241

4.9.31 System Settings After Migration (Active Phase)

242

4.10 Post-Conversion

247

4.11 Useful Reports and Tables

248

4.12 Summary

250

5 Shell Conversion

251

5.1 Overview of Shell Conversion

252

5.1.1 Business Cases

252

5.1.2 Shell Conversion Flow

252

5.2 System Landscape for Shell Conversion

253

5.3 SAP Business Warehouse System Compatibility

254

5.4 SAP Business Warehouse System Provisioning

255

5.4.1 Target SAP BW/4HANA System Provisioning

255

5.4.2 Sender System Provisioning

255

5.4.3 Sender and Target System Landscape Preparation

256

5.5 Prechecks and Simulation

257

5.6 Realization Phase

259

5.6.1 Scope Object Identification

259

5.6.2 Scope Selection Execution

263

5.6.3 Define Object Mapping and Store Object List

266

5.6.4 Map InfoObjects for InfoProvider

270

5.6.5 Select Main Partition Criteria for Semantically Partitioned Objects

271

5.6.6 Determine Usage of Involved Objects

271

5.6.7 Checklist for Usage of Involved Objects

272

5.7 Post-Conversion Activities

274

5.8 Summary

277

6 In-Place Conversion

279

6.1 Overview of In-Place Conversion

279

6.2 System Landscape for In-Place Conversion

281

6.3 SAP Business Warehouse System Provisioning

282

6.4 Sender System Provisioning

286

6.5 Realization Phase

287

6.6 Introduction to the SAP BW/4HANA Starter Add-On

288

6.6.1 Process during In-Place Conversion

288

6.6.2 SAP BW/4HANA Starter Add-On

289

6.7 Operating Modes

295

6.7.1 Switching Modes

296

6.7.2 Mode Switch and Prerequisites

297

6.7.3 Handling Unsupported Objects

298

6.7.4 Landscape Considerations

300

6.8 Transferring Standard Authorization

301

6.8.1 Conversion Rules for Authorization Objects

301

6.8.2 Scope Transfer and Authorization Conversion

302

6.8.3 Initial and Delta Run

303

6.8.4 Simulation Mode

303

6.8.5 Authorization Transfer Process (Initial Run)

304

6.9 Execution Overview

309

6.9.1 General Features

309

6.9.2 Cleanup Execution

310

6.9.3 Data Transfer Logic

311

6.9.4 SAP Business Warehouse Data Model

312

6.10 Starting In-Place Conversion

315

6.11 Scope Transfer

317

6.12 Executing Scope Selection

318

6.12.1 Collect Scope for Transfer

318

6.12.2 Define Object Mapping and Store Object List

320

6.12.3 Prepare Propagate Requests

322

6.12.4 Map InfoObjects for InfoProviders

324

6.12.5 Select Main Partition Criteria for Semantically Partitioned Objects

324

6.12.6 Determine Usage of Involved Objects

324

6.12.7 Checklist for Usage of Involved Objects

324

6.12.8 Copy Delta Queues from SAPI to ODP Technology

326

6.12.9 Confirm Delta Was Loaded for the Cloned DataSources

328

6.12.10 Synchronize Delta Queues between SAPI and ODP

328

6.12.11 Extract from PSAs of DataSources and Error Stacks

329

6.12.12 Master Data Activation

330

6.12.13 Propagate Requests

330

6.12.14 Lock All Data Changes

330

6.12.15 Prepare Request Mapping for Transfer

331

6.12.16 Save Data

331

6.12.17 Transfer Metadata

331

6.12.18 Transferring the Request Info to the New Status Management

332

6.12.19 Retrieve Data

332

6.12.20 Unlock Loading and Data Target Changes

332

6.12.21 Post Transfer Checks

333

6.13 Transfer Standard Authorization (Delta)

336

6.14 Objects Deletion

337

6.14.1 Technical Content

338

6.14.2 Delete Other SAP Business Warehouse Objects

338

6.14.3 Delete SAP Business Warehouse Queries

339

6.15 Final System Conversion

339

6.16 Summary

343

7 SAP BW Bridge for SAP Datasphere

345

7.1 Introduction to SAP Datasphere

345

7.2 Introduction to SAP BW Bridge

347

7.3 Shell Conversion with SAP BW Bridge

350

7.3.1 Prepare Phase Activities

351

7.3.2 System Preparation

356

7.3.3 Realization Phase

360

7.3.4 Connect the Sender System to SAP BW Bridge

362

7.3.5 Create an SAP BW Bridge Project

366

7.3.6 ABAP Cloud Project in ABAP Development Tools

369

7.3.7 Object-Specific Simplification

373

7.3.8 Prework

374

7.3.9 Execution

375

7.4 Remote Conversion with SAP BW Bridge

382

7.4.1 Preparation

382

7.4.2 Execution

386

7.4.3 Post-Migration Options in SAP Datasphere

404

7.5 Summary

407