SAP BW/4HANA 2.0: The Comprehensive Guide

Ready for SAP BW/4HANA 2.0? 

"SAP BW/4HANA 2.0: The Comprehensive Guide" will teach you all there is to know about the next-generation business warehouse from SAP! Start with a fresh installation or migrate from an existing system. Then, get to know the new architecture and master administration tasks for on-premise and cloud deployments. You'll learn to model, transform, and provision data, connect to frontend BI tools like SAP Analytics Cloud, and much more. The data warehouse of the future is here!

  • Migrate to and implement SAP BW/4HANA 2.0
  • Integrate, model, and transform data from sources like SAP S/4HANA and SAP Data Intelligence
  • Manage, maintain, and secure the system
Deployment and Migration

Deploy a fresh SAP BW/4HANA installation or migrate from an existing data warehousing solution using the migration toolbox and the migration cockpit.

Data Acquisition and Modeling

Connect data source systems and provision data with SAP HANA, SAP Data Warehouse Cloud, and more. Once you have your data, learn to model it with SAP 

BW/4HANA's simplified data structures.

Analytics and Business Intelligence
Use tools like SAP Analytics Cloud and SAP Fiori for frontend BI and reporting. Explore advanced analytics and machine learning with the SAP HANA Predictive Analysis Library and SAP Data Intelligence.

  • Installation and migration
  • Administration
  • Data modeling
  • Data integration
  • Data transformation
  • Analytics
  • Machine learning
  • SAP Data Warehouse Cloud
  • SAP Data Intelligence
  • SAP Analytics Cloud
Table of Contents

SAP BW/4HANA and Its Ecosystem of Tools and Services

What is Business Intelligence and How Is It Related to Digitization?

Merging Data Lakes and Data Warehouses

SAP Business Warehouse Releases

  • SAP Business Warehouse on Any Database
  • SAP Business Warehouse 7.4 Powered by SAP HANA
  • SAP Business Warehouse 7.5 and SAP Business Warehouse Edition for SAP HANA
Navigating SAP BW/4HANA
  • Technical Users
  • Business Users
Deployment Scenarios
  • On-Premise
  • Public Cloud
  • Managed Cloud
Related Cloud Technologies
  • SAP Analytics Cloud
  • SAP Data Warehouse Cloud
  • SAP Data Intelligence
  • SAP Cloud Platform
Use Case of this Book

Architecture

The Evolution of the Layered Scalable Architecture (LSA++)

  • From LSA to LSA+
  • Model View Controller and LSA++
Business Intelligence

Business Content

Data Protection Workbench

Multi-Temperature Data Management

  • Data Lifecycle Manager
  • Dynamic Tiering
Installation

Administering Instances in a Public Cloud Environment

  • The Architecture of Amazon Web Services
  • Creating an Account on SAP Cloud Appliance Library and Aligning It with Your Cloud Provider
  • Amazon Web Services Management Access from Windows
Setting Up the SAP BW/4HANA Client
  • Setting Up the SAP HANA Connection
  • Creating an Administrative User
  • Running Task Lists
  • Installing an SAP BW/4HANA License
  • Installing an SAP HANA License
  • Installing Support Packages
  • Setting Up the Generation of External SAP HANA Views
Installing SAP Business Planning and Consolidation, version for SAP BW/4HANA
  • Download
  • Add-On Installation
  • Configuration
Tools

SAP HANA Studio Installation and Configuration

  • Connecting the SAP BW/4HANA Server and SAP BW via a Remote Desktop
  • Installing Eclipse and the SAP BW Modeling Tools
  • Connecting to SAP HANA
  • Creating an SAP HANA Archive Link
  • Configuring the SAP Usage Type
  • Installing the ABAP Development Tools for Eclipse
  • Creating a Repository Workspace and Package
  • Creating a Developer Package
  • Error Handling
SAP HANA Client Tool Installation
  • Creating an ODBC Data Source for SAP HANA
  • HDBSQL Command-line Tool
Enabling SAP BW/4HANA for SAP Analytics Cloud

Connecting to SAP Data Warehouse Cloud

  • Installing the Data Provisioning Agent
  • Connecting and Configuring the Data Provisioning Agent
  • Registering the Data
SAP Data Intelligence

SAP S/4HANA Embedded Analytics

  • Embedded SAP BW in SAP S/4HANA
  • Core Data Services for ABAP
Security and Operations

SAP BW/4HANA Authorizations

  • Protected Actions
  • Protected Data Access
  • Granted Actions and Data Access
Read Access Logging
  • Configuring Read Access Logging
  • Enabling Read Access Logging in a DataStore Object (Advanced)
SAP HANA Authorizations
  • Creating SAP HANA Users Manually
  • Authorization Control via Decentralized User Administration
  • Authorization Control within the SAP HANA Database
  • Setting Up the Authorization Concept for the SAP HANA Database
  • Representation of Authorization Trees
  • Detecting Authorization Errors
  • Setting Up Privileges for ABAP Development
  • Modeling Analytical Privileges 
SAP BW/4HANA Transports
  • Change and Transport Management
  • Transport Management in SAP
  • Mixed Transports
SAP BW/4HANA Operations
  • Data Warehousing Workbench
  • Process Chains App
  • Process
  • Monitoring Views for Core Data Services
Basic Data Modeling

Modeling Objects

  • Creating InfoAreas
  • Creating Source Systems
  • Creating Application Components
  • Creating Data Sources
  • Creating Data Flow Objects
  • Creating Open ODS Views
  • Creating InfoSources
  • Creating InfoObjects
  • Creating Datastore Objects (Advanced)
  • Creating Data Transfer Processes
  • Creating Open Hub Destinations
  • Creating CompositeProviders
  • Creating Queries
  • Creating Variables
  • Creating Semantic Groups
Modeling Process Chains in the SAP BW/4HANA Cockpit
  • Generating Process Chains from Data Flows
  • Meta Process Chains
Master Data Modeling
  • Surrogate ID Tables and Views
  • Text Tables
  • Tables and Views for Attributes
  • Tables and Views for Hierarchies
  • Tables and Views for Enhanced Master Data Updates
Hybrid Data Modeling with SAP HANA
  • Native Datastore Objects
  • Data Distribution Optimizer
Modeling for SAP Business Planning and Consolidation, version for SAP BW/4HANA (Embedded Configuration)
  • Creating a Planning-Enabled InfoProvider
  • Creating Data Slices on the Basis InfoProvider
  • Creating a Characteristic on the Basis InfoProvider
  • Creating an Aggregation Level
  • Creating a Planning-Enabled Query
  • Running a Planning-Enabled Query in SAP Analysis for Microsoft Office
Advanced Data Modeling

Data Distribution

  • Data Distribution in Semantically Groups
  • Data Distribution through Partitioning
  • Data Distribution with Dynamic Tiering
Virtual Data Modeling
  • Virtual Characteristics With SAP HANA Information Views
  • Open ODS Views on Calculation Views
  • Composite Provider on Calculation Views
Modeling CompositeProviders
  • Inner Joins in CompositeProviders
  • Outer Joins in CompositeProviders
  • Row-Level Security With CompositeProviders
Native SAP HANA Data Modeling
  • Generating External SAP HANA Views for SAP BW/4HANA Queries
  • Generating External SAP HANA Views for Characteristics
  • External SAP HANA Views for Datastore Objects (Advanced)
  • Generating External SAP HANA Views for CompositeProviders
  • Naming Convention for Self-Developed Information Models
  • Modeling Calculation Views
  • Modeling Classic Analytical Privileges
Data Modeling in SAP Data Warehouse Cloud
  • Configuring SAP Data Warehouse Cloud
  • Data Modeling in Data Builder
  • Creating Entity-Relationship Models
  • SAP BW/4HANA Model Transfer
Remodeling Code with the ABAP Development Tools
  • Customer Exits in SAP BW/4HANA
  • Developing Transformations with ABAP Managed Database Procedures
Analytics Clients for Business Intelligence

SAP Analytics Cloud

  • Creating an Account
  • Live Connectivity to SAP BW/4HANA
  • Import to SAP BW/4HANA and SAP HANA
  • Live Connectivity to SAP HANA
  • SAP Analytics Cloud Add-In for Microsoft Office
  • Tenant Configuration
  • Cloud Model Building
SAP Lumira
  • Connecting with SAP Lumira, Designer Edition
  • Connecting with SAP Lumira, Discovery Edition
SAP Analysis for Microsoft Office

Native BI Portal Applications with SAP HANA XSA and SAP Fiori

Third-Party Clients for the Mac

  • MicroStrategy Desktop
  • Tableau Desktop
Microsoft Excel via MDX

Deployment Options

Conversion versus Transformation

Planning Your Migration to SAP BW/4HANA

  • Technical Requirements
  • Business Content for SAP BW/4HANA
  • SAP BW/4HANA in a Virtual Private Cloud
  • Installation Procedure in the Virtual Private Cloud
  • Capacity Planning with Amazon Web Services
  • Preconfiguration with AWS Cloud Formation
  • Amazon Machine Images
  • Authorization Concept of Amazon Web Services
  • Scale-Out Architectures with AWS CloudFormation
  • SAP Landscape Management
Greenfield Installation

In-Place Conversion

  • Changes at the Reporting Level
  • Changes to Data Flows
  • Migration Cockpit for SAP BW/4HANA
  • Transfer Tool of the Starter Add-on for SAP BW/4HANA
  • Remote Conversion
  • Shell Conversion
Roadmap

Data Distribution and Management

Data Protection Workbench

Process Chains

Performance Improvements

SAP Analytics Cloud Integration

SAP Data Warehouse Cloud Integration
 
Author's Background and Qualifications

Thorsten Lüdtke is an independent SAP BI architect and founder of BIPortal GmbH. He specializes in data warehouse architectures based on SAP BW/4HANA, SAP HANA, and SAP Data Intelligence. Thorsten entered the analytics field in 1997 as a MicroStrategy employee, developing applications for business intelligence.  

In 1999, he developed the first SAP RapidMarts solution (acquired by SAP BusinessObjects) based on SAP Business Information Warehouse 1.2B at Acta Technology in Silicon Valley. 

From 2002 to 2005, Thorsten worked as an SAP BI consultant and SAP BW trainer for SAP in numerous projects in Germany and the UK. In 2006, he started a joint venture with Bill Inmon as a member of the advisory board and presented the product (BI Master Data Management) at SAPPHIRE 2007 in Vienna. This event marks the beginning of his company, BIPortal GmbH. After office hours, he enjoys classic AI books from the 70s and 80s, as he believes that those early concepts of symbolic computation can augment recent advantages in machine learning. Thorsten studied computer science at the State University of New York at Albany (SUNYA) and information systems at the Technical University of Braunschweig (TUBS) in Germany. Since then, he's been looking for ways to use machine learning in business analytics, as it is now easy to do with SAP BW/4HANA. 

Marina Lüdtke is the managing director of BIPortal GmbH in Hamburg, Germany. Previously, she worked as a sales representative for various chemical companies in Germany, East Africa, and South America. Using advanced analytics, she generated sales of over US$10 million annually. At BIPortal, she helps clients achieve the same success with BIPortal's analytical tools and SAP Analytics Cloud on SAP BW/4HANA. 

AP BW/4HANA 2.0: The Comprehensive Guide

SAP Books

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse

ERPGREAT.com
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.