Table of Contents

Open all
Close all
Preface
15
Who This Book Is For
15
How This Book Is Organized
15
Acknowledgments
16
Conclusion
17
1 Introduction to SAP BW/4HANA
19
1.1 History of SAP BW
19
1.1.1 SAP BW Release 1.0
20
1.1.2 SAP BW Release 1.2
20
1.1.3 SAP BW Release 2.0 and 2.1
21
1.1.4 SAP BW Release 3.x
21
1.1.5 SAP BW Release 7.0 to 7.3
22
1.1.6 SAP BW 7.4 and 7.5 Powered by SAP HANA
23
1.2 SAP BW/4HANA Overview
25
1.2.1 SAP BW/4HANA Design Principles
25
1.2.2 Simplified Data Model
26
1.2.3 Openness
28
1.2.4 Modern Interfaces
30
1.2.5 High Performance
31
1.3 Implementing SAP BW/4HANA
32
1.3.1 New Installation of SAP BW/4HANA
33
1.3.2 System Conversion of Existing SAP BW System
33
1.3.3 Landscape Consolidation
36
1.3.4 Recommendation for Implementing SAP BW/4HANA
36
1.4 Summary
37
2 Introduction to SAP HANA
39
2.1 What Is SAP HANA?
39
2.1.1 Traditional Database versus In-Memory Database
40
2.1.2 SAP HANA
41
2.2 SAP HANA as an Application Platform
43
2.3 SAP HANA as a Database for SAP Applications
44
2.3.1 SAP Enterprise Resource Planning
44
2.3.2 SAP Business Warehouse
48
2.4 SAP HANA Deployment
49
2.4.1 SAP HANA Hardware Options
50
2.4.2 Scaled-Up SAP HANA Systems
51
2.4.3 Scaled-Out SAP HANA Systems
52
2.5 Virtualization
55
2.5.1 What Is Virtualization?
55
2.5.2 SAP HANA Virtualization
56
2.6 Summary
58
3 Installation and Setup
59
3.1 Preparation
59
3.1.1 Requirements
59
3.1.2 Installation Media
61
3.2 Installation
62
3.3 Postinstallation
70
3.3.1 SAP HANA Database Technical User Setup
70
3.3.2 SAP BW/4HANA Setup
71
3.3.3 RFC and Parameter Configuration
72
3.3.4 Configuring SAP BW/4HANA Workspaces
73
3.3.5 SAP BW/4HANA Table Placement
73
3.3.6 Client Copy
75
3.3.7 Service Pack Upgrade and SAP License Installation
76
3.4 Summary
76
4 SAP BW/4HANA in the Cloud
77
4.1 Choosing a Cloud Provider
77
4.1.1 Performance
78
4.1.2 Technology and Certification
79
4.1.3 Service-Level Agreements and Reliability
79
4.1.4 Ecosystem and Community
79
4.1.5 Security and Compliance
79
4.1.6 Costs
80
4.1.7 Preferred Providers
80
4.2 Cloud Providers
81
4.2.1 SAP HANA Enterprise Cloud
81
4.2.2 Amazon Web Services
82
4.2.3 Microsoft Azure
84
4.2.4 Other Providers
86
4.3 SAP BW/4HANA Cloud Deployment Steps
87
4.3.1 Setting Up the Cloud Provider Account
88
4.3.2 Selecting Your Deployment
92
4.3.3 Logging On to the Instance
95
4.3.4 Managing Instances
96
4.3.5 Renewing Licenses
98
4.4 Summary
99
5 Data Modeling
101
5.1 Modeling Perspectives
101
5.2 Modeling Objects
104
5.3 InfoObjects
106
5.3.1 Characteristics
107
5.3.2 XXL
113
5.3.3 Key Figure
114
5.3.4 Unit
117
5.4 SAP BW/4HANA InfoProviders
117
5.4.1 Field-Based Modeling
118
5.4.2 Open ODS Views
119
5.4.3 Advanced DataStore Objects
125
5.4.4 CompositeProvider
134
5.5 Summary
139
6 Data Acquisition
141
6.1 SAP BW/4HANA Source Systems
142
6.1.1 Creating a Source System
143
6.1.2 Connection Type: SAP HANA Local and Tenant Database Schema
145
6.1.3 Connection Type: SAP HANA Smart Data Access and Big Data
146
6.1.4 Connection Type: File
149
6.1.5 Connection Type: Operational Data Provisioning
149
6.2 SAP BW/4HANA DataSources
154
6.2.1 Creating a DataSource with the Native Eclipse-Based Wizard
155
6.2.2 Creating a DataSource for File-Type Source Systems
162
6.2.3 ODP DataSources
166
6.3 SAP BW/4HANA Data Flows
168
6.3.1 Creating a Data Flow
170
6.3.2 Creating Transformations
172
6.3.3 Currency Conversions and Unit of Measures Validation
175
6.3.4 Transformation Version Management
176
6.3.5 Transformation Metadata View
176
6.3.6 Transformation Runtime Status
177
6.3.7 ABAP Managed Database Procedures
177
6.4 SAP BW/4HANA Data Loading
178
6.4.1 Creating DTPs
179
6.4.2 Creating Process Chains
182
6.5 Manual Data Acquisition
185
6.6 Summary
187
7 Reporting and Analytics
189
7.1 SAP BW/4HANA Queries
190
7.1.1 Creating a Query with Eclipse-Based Query Designer
191
7.1.2 Query Properties
195
7.1.3 Filters
201
7.1.4 Variables
205
7.1.5 Query Sheet Definition
212
7.1.6 Query Elements
214
7.1.7 Query Conditions
222
7.1.8 Query Exceptions
224
7.1.9 Query Transport
226
7.2 Interfaces for Analysis
228
7.2.1 Multidimensional Interfaces
228
7.2.2 Lightweight Consumption Interfaces
229
7.3 SAP BusinessObjects Tools
232
7.3.1 Universes
233
7.3.2 SAP HANA
233
7.3.3 SAP HANA: Online
236
7.3.4 SAP BEx
237
7.4 Third-Party Business Intelligence Tools
239
7.4.1 ODBC Data Source
239
7.4.2 OData Data Source
244
7.4.3 OLEDB Data Source
246
7.5 Summary
248
8 Integrating External Data
251
8.1 SAP HANA Smart Data Access
251
8.1.1 Supported Remote Sources
252
8.1.2 Configure SAP HANA Smart Data Access
253
8.1.3 Create Remote Source via Smart Data Access Adapter
255
8.2 SAP HANA Smart Data Integration
260
8.2.1 Configure SAP HANA Smart Data Integration
261
8.2.2 Create Remote Source with Smart Data Integration Adapter
273
8.2.3 Create Remote Source Connection to Oracle
275
8.2.4 Create Remote Source Connection to Hadoop
277
8.2.5 Create Virtual Tables
278
8.3 Integration with SAP BW/4HANA
279
8.3.1 Combining Data under Schema SAPSR3
279
8.3.2 Combine Data via Open ODS Views or CompositeProvider
281
8.4 Summary
287
9 Data Lifecycle Management
289
9.1 Data Retention Strategy
290
9.2 Data Temperature
296
9.2.1 Warm Data in Extension Nodes
298
9.2.2 Cold Data in Near-Line Storage
303
9.3 Data Archiving
305
9.3.1 Creating Near-Line Storage Connections
306
9.3.2 Creating a Remote Source in SAP HANA Studio
309
9.3.3 Using SAP IQ for Near-Line Storage
312
9.3.4 Using Hadoop for Near-Line Storage
315
9.3.5 Creating Data Archiving Processes
321
9.3.6 Administration of Data Archiving Processes
324
9.3.7 Reading Near-Line Storage Data in Transformation Rules
327
9.4 Summary
330
10 Administration
331
10.1 Daily Administration Tasks
331
10.1.1 Check Database Storage
332
10.1.2 Check SAP HANA Workload
336
10.1.3 Check ABAP Workload
340
10.1.4 Perform System Checks
347
10.1.5 Automate Daily Tasks
355
10.2 Daily Load Monitoring
356
10.2.1 Monitor SAP BW/4HANA Computing Center Management System Alerts
356
10.2.2 Monitor Process Chains
358
10.3 Weekly, Monthly, Quarterly, and Annual Tasks
359
10.4 Summary
361
11 Security
363
11.1 Authentication and Single Sign-On
363
11.1.1 Application Server for ABAP Authentication
364
11.1.2 SAP HANA Authentication
364
11.2 Authorization in Application Server for ABAP
365
11.2.1 Authorization Fields
367
11.2.2 Activity Fields
368
11.3 Standard Authorization Objects
369
11.3.1 Developer and Administrator Authorizations
369
11.3.2 Reporting Authorizations
372
11.3.3 SAP HANA Authorizations
373
11.4 Analysis Authorizations
376
11.4.1 Creating an InfoObject for Analysis Authorizations
376
11.4.2 Defining Analysis Authorizations
377
11.4.3 Automatically Generating Analysis Authorizations
378
11.5 Roles
380
11.5.1 Administrator Roles
381
11.5.2 End User Roles
381
11.5.3 Role Templates
382
11.6 User Administration
385
11.6.1 Defining Users
385
11.6.2 Assigning Analysis Authorizations to Users
387
11.6.3 User Administration Tools
389
11.7 Troubleshooting Authorization Problems
390
11.7.1 Standard Authorization Errors
391
11.7.2 Analysis Authorization Errors
392
11.8 Summary
396
12 The Future of SAP BW/4HANA
397
12.1 SAP BW to SAP BW/4HANA Roadmap
397
12.2 Openness
399
12.2.1 Operational Data Provisioning Source System Type
400
12.2.2 SAP HANA Source System Type
400
12.2.3 Big Data Source System Type
401
12.2.4 File Source System Type
401
12.3 Simplicity
402
12.3.1 Simplicity in Data Integration
402
12.3.2 Simplicity in Modeling Activities
403
12.3.3 Simplicity in Data Flow Maintenance
403
12.3.4 Simplicity in Data Lifecycle Management
404
12.3.5 Simplicity in Business Content
406
12.4 User Interfaces
407
12.4.1 Data Flow Modeler
408
12.4.2 Process Chain Monitor
411
12.4.3 Business User Interface
411
12.5 High Performance
411
12.6 Future Innovations
412
12.7 Future Migration Options
413
12.8 Summary
414
Appendices
415
The Authors
415
Index
419