SAP BW/4HANA by Christensen, Jesper -- Read -- Imperial Library of Trantor

Index

Dear Reader Notes on Usage Table of Contents Preface

Who This Book Is For How This Book Is Organized Acknowledgments Conclusion

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

← Prev
Back
Next →

← Prev
Back
Next →