Inhaltsverzeichnis

Alle Kapitel aufklappen
Alle Kapitel zuklappen
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
The Author
409
Index
411