Table of Contents

Dear Reader

Notes on Usage

Table of Contents

Preface

1   Introduction to SAP BW/4HANA

1.1   History of SAP BW

1.1.1   SAP BW Release 1.0

1.1.2   SAP BW Release 1.2

1.1.3   SAP BW Release 2.0 and 2.1

1.1.4   SAP BW Release 3.x

1.1.5   SAP BW Release 7.0 to 7.3

1.1.6   SAP BW 7.4 and 7.5 Powered by SAP HANA

1.2   SAP BW/4HANA Overview

1.2.1   SAP BW/4HANA Design Principles

1.2.2   Simplified Data Model

1.2.3   Openness

1.2.4   Modern Interfaces

1.2.5   High Performance

1.3   Implementing SAP BW/4HANA

1.3.1   New Installation of SAP BW/4HANA

1.3.2   System Conversion of Existing SAP BW System

1.3.3   Landscape Consolidation

1.3.4   Recommendation for Implementing SAP BW/4HANA

1.4   Summary

2   Introduction to SAP HANA

2.1   What Is SAP HANA?

2.1.1   Traditional Database versus In-Memory Database

2.1.2   SAP HANA

2.2   SAP HANA as an Application Platform

2.3   SAP HANA as a Database for SAP Applications

2.3.1   SAP Enterprise Resource Planning

2.3.2   SAP Business Warehouse

2.4   SAP HANA Deployment

2.4.1   SAP HANA Hardware Options

2.4.2   Scaled-Up SAP HANA Systems

2.4.3   Scaled-Out SAP HANA Systems

2.5   Virtualization

2.5.1   What Is Virtualization?

2.5.2   SAP HANA Virtualization

2.6   Summary

3   Installation and Setup

3.1   Preparation

3.1.1   Requirements

3.1.2   Installation Media

3.2   Installation

3.3   Postinstallation

3.3.1   SAP HANA Database Technical User Setup

3.3.2   SAP BW/4HANA Setup

3.3.3   RFC and Parameter Configuration

3.3.4   Configuring SAP BW/4HANA Workspaces

3.3.5   SAP BW/4HANA Table Placement

3.3.6   Client Copy

3.3.7   Service Pack Upgrade and SAP License Installation

3.4   Summary

4   SAP BW/4HANA in the Cloud

4.1   Choosing a Cloud Provider

4.1.1   Performance

4.1.2   Technology and Certification

4.1.3   Service-Level Agreements and Reliability

4.1.4   Ecosystem and Community

4.1.5   Security and Compliance

4.1.6   Costs

4.1.7   Preferred Providers

4.2   Cloud Providers

4.2.1   SAP HANA Enterprise Cloud

4.2.2   Amazon Web Services

4.2.3   Microsoft Azure

4.2.4   Other Providers

4.3   SAP BW/4HANA Cloud Deployment Steps

4.3.1   Setting Up the Cloud Provider Account

4.3.2   Selecting Your Deployment

4.3.3   Logging On to the Instance

4.3.4   Managing Instances

4.3.5   Renewing Licenses

4.4   Summary

5   Data Modeling

5.1   Modeling Perspectives

5.2   Modeling Objects

5.3   InfoObjects

5.3.1   Characteristics

5.3.2   XXL

5.3.3   Key Figure

5.3.4   Unit

5.4   SAP BW/4HANA InfoProviders

5.4.1   Field-Based Modeling

5.4.2   Open ODS Views

5.4.3   Advanced DataStore Objects

5.4.4   CompositeProvider

5.5   Summary

6   Data Acquisition

6.1   SAP BW/4HANA Source Systems

6.1.1   Creating a Source System

6.1.2   Connection Type: SAP HANA Local and Tenant Database Schema

6.1.3   Connection Type: SAP HANA Smart Data Access and Big Data

6.1.4   Connection Type: File

6.1.5   Connection Type: Operational Data Provisioning

6.2   SAP BW/4HANA DataSources

6.2.1   Creating a DataSource with the Native Eclipse-Based Wizard

6.2.2   Creating a DataSource for File-Type Source Systems

6.2.3   ODP DataSources

6.3   SAP BW/4HANA Data Flows

6.3.1   Creating a Data Flow

6.3.2   Creating Transformations

6.3.3   Currency Conversions and Unit of Measures Validation

6.3.4   Transformation Version Management

6.3.5   Transformation Metadata View

6.3.6   Transformation Runtime Status

6.3.7   ABAP Managed Database Procedures

6.4   SAP BW/4HANA Data Loading

6.4.1   Creating DTPs

6.4.2   Creating Process Chains

6.5   Manual Data Acquisition

6.6   Summary

7   Reporting and Analytics

7.1   SAP BW/4HANA Queries

7.1.1   Creating a Query with Eclipse-Based Query Designer

7.1.2   Query Properties

7.1.3   Filters

7.1.4   Variables

7.1.5   Query Sheet Definition

7.1.6   Query Elements

7.1.7   Query Conditions

7.1.8   Query Exceptions

7.1.9   Query Transport

7.2   Interfaces for Analysis

7.2.1   Multidimensional Interfaces

7.2.2   Lightweight Consumption Interfaces

7.3   SAP BusinessObjects Tools

7.3.1   Universes

7.3.2   SAP HANA

7.3.3   SAP HANA: Online

7.3.4   SAP BEx

7.4   Third-Party Business Intelligence Tools

7.4.1   ODBC Data Source

7.4.2   OData Data Source

7.4.3   OLEDB Data Source

7.5   Summary

8   Integrating External Data

8.1   SAP HANA Smart Data Access

8.1.1   Supported Remote Sources

8.1.2   Configure SAP HANA Smart Data Access

8.1.3   Create Remote Source via Smart Data Access Adapter

8.2   SAP HANA Smart Data Integration

8.2.1   Configure SAP HANA Smart Data Integration

8.2.2   Create Remote Source with Smart Data Integration Adapter

8.2.3   Create Remote Source Connection to Oracle

8.2.4   Create Remote Source Connection to Hadoop

8.2.5   Create Virtual Tables

8.3   Integration with SAP BW/4HANA

8.3.1   Combining Data under Schema SAPSR3

8.3.2   Combine Data via Open ODS Views or CompositeProvider

8.4   Summary

9   Data Lifecycle Management

9.1   Data Retention Strategy

9.2   Data Temperature

9.2.1   Warm Data in Extension Nodes

9.2.2   Cold Data in Near-Line Storage

9.3   Data Archiving

9.3.1   Creating Near-Line Storage Connections

9.3.2   Creating a Remote Source in SAP HANA Studio

9.3.3   Using SAP IQ for Near-Line Storage

9.3.4   Using Hadoop for Near-Line Storage

9.3.5   Creating Data Archiving Processes

9.3.6   Administration of Data Archiving Processes

9.3.7   Reading Near-Line Storage Data in Transformation Rules

9.4   Summary

10   Administration

10.1   Daily Administration Tasks

10.1.1   Check Database Storage

10.1.2   Check SAP HANA Workload

10.1.3   Check ABAP Workload

10.1.4   Perform System Checks

10.1.5   Automate Daily Tasks

10.2   Daily Load Monitoring

10.2.1   Monitor SAP BW/4HANA Computing Center Management System Alerts

10.2.2   Monitor Process Chains

10.3   Weekly, Monthly, Quarterly, and Annual Tasks

10.4   Summary

11   Security

11.1   Authentication and Single Sign-On

11.1.1   Application Server for ABAP Authentication

11.1.2   SAP HANA Authentication

11.2   Authorization in Application Server for ABAP

11.2.1   Authorization Fields

11.2.2   Activity Fields

11.3   Standard Authorization Objects

11.3.1   Developer and Administrator Authorizations

11.3.2   Reporting Authorizations

11.3.3   SAP HANA Authorizations

11.4   Analysis Authorizations

11.4.1   Creating an InfoObject for Analysis Authorizations

11.4.2   Defining Analysis Authorizations

11.4.3   Automatically Generating Analysis Authorizations

11.5   Roles

11.5.1   Administrator Roles

11.5.2   End User Roles

11.5.3   Role Templates

11.6   User Administration

11.6.1   Defining Users

11.6.2   Assigning Analysis Authorizations to Users

11.6.3   User Administration Tools

11.7   Troubleshooting Authorization Problems

11.7.1   Standard Authorization Errors

11.7.2   Analysis Authorization Errors

11.8   Summary

12   The Future of SAP BW/4HANA

12.1   SAP BW to SAP BW/4HANA Roadmap

12.2   Openness

12.2.1   Operational Data Provisioning Source System Type

12.2.2   SAP HANA Source System Type

12.2.3   Big Data Source System Type

12.2.4   File Source System Type

12.3   Simplicity

12.3.1   Simplicity in Data Integration

12.3.2   Simplicity in Modeling Activities

12.3.3   Simplicity in Data Flow Maintenance

12.3.4   Simplicity in Data Lifecycle Management

12.3.5   Simplicity in Business Content

12.4   User Interfaces

12.4.1   Data Flow Modeler

12.4.2   Process Chain Monitor

12.4.3   Business User Interface

12.5   High Performance

12.6   Future Innovations

12.7   Future Migration Options

12.8   Summary

A   The Authors

Index

Service Pages

Legal Notes