BW362 SAP NetWeaver BW, powered by SAP HANA

(1)

BW362

SAP NetWeaver BW, powered by

SAP HANA

SAP NetWeaver - Business Intelligence

Course Outline

Course Version: 07

Course Duration: 5 Day(s) Publication Date: 05-08-2014 Publication Time: 1210

(2)

Copyright

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. Additionally this publication and its contents are provided solely for your use, this publication and its contents may not be rented, transferred or sold without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

Trademarks

• Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® and SQL Server® are registered trademarks of Microsoft Corporation.

• IBM®, DB2®, OS/2®, DB2/6000®, Parallel Sysplex®, MVS/ESA®, RS/6000®, AIX®, S/390®, AS/400®, OS/390®, and OS/400® are registered trademarks of IBM Corporation. • ORACLE® is a registered trademark of ORACLE Corporation.

• INFORMIX®-OnLine for SAP and INFORMIX® Dynamic ServerTM are registered trademarks of Informix Software Incorporated.

• UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of the Open Group. • Citrix®, the Citrix logo, ICA®, Program Neighborhood®, MetaFrame®, WinFrame®,

VideoFrame®, MultiWin® and other Citrix product names referenced herein are trademarks of Citrix Systems, Inc.

• HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

• JAVA® is a registered trademark of Sun Microsystems, Inc.

• JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.

• SAP, SAP Logo, R/2, RIVA, R/3, SAP ArchiveLink, SAP Business Workflow, WebFlow, SAP EarlyWatch, BAPI, SAPPHIRE, Management Cockpit, mySAP.com Logo and mySAP.com are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other products mentioned are trademarks or registered trademarks of their respective companies.

(3)

BW362 Contents

Course Overview

Target Audience

This course is intended for the following audiences: • BW Consultants

• BW Project Managers • BW System Administrator

Course Prerequisites

Required Knowledge

• Basic BW knowledge is required

Course Goals

This course will prepare the participant to: • Run BW on InMemory Database (HANA)

• Learn new functions designed especially for SAP BW on HANA 7.4 SP05.

Course Objectives

After completing this course, the participant will be able to: • Explain the BW on HANA Landscape

• Differentiate between HANA-Optimized Datastore Object and standard BW Data Store Object

• Differentiate between HANA Optimized Info Cube and standard BW Info Cube • Explain the consuming of HANA models

• Describe BW powered by HANA

• Working with BW Workspace in the HANA environment • Explain the Layered Scalable Architecture without SAP HANA

(6)

(7)

BW362 Course Outline

Unit 1

Getting Started

Unit Overview

Lesson: SAP HANA Basics

Lesson Objectives

After completing this lesson, the participant will be able to: • Explain the SAP HANA Roadmap

• Explain the SAP HANA Basics

Lesson: SAP NetWeaver BW 7.4 SP05

After completing this lesson, the participant will be able to:

• Give an overview on basic knowledge in SAP NetWeaver BW 7.3-7.4 SP05

Lesson: BW Modeling in HANA Studio

After completing this lesson, the participant will be able to: • Model with SAP HANA Studio-based

(8)

Unit 2

Install, Upgrade and Migration Aspects as

an Overview

Unit Overview

This unit covers the key aspect of upgrading BW 7.x to BW 7.4, the migration from anyDB to HANA and the pre and post upgrade/migration tasks.

Lesson: Migration to SAP NetWeaver BW on SAP

HANA – Best Practice

After completing this lesson, the participant will be able to: • Describe the update process in general

• Know the functionality of the migration cockpit and all the included tools and hints

Lesson: Optimizing Data Management (Non Active

Data Concept – NLS)

After completing this lesson, the participant will be able to: • Explain and use the "Non-Active Data Concept"

• Learn how SAP and you the customer can flag data to support a managed approach to HANA size management.

(9)

Unit 3

Optimisation of BW on HANA

Unit Overview

With BW on HANA although the maintenance UI and look and the presentation of cubes in the Query designer does not change, the underlying star schema does change significantly. This lesson will address these changes. and how to convert to the new data model.

We will also look at other ways to optimise BW on HANA including setting for push down OLAP functions to HANA and push down of transformation to HANA.

Lesson: Optimized Data Model for BW InfoProvider

• Understand the motivation for SAP HANA optimized InfoCubes. • Identify the difference in the architecture and structure compared with

InfoCubes stored in a relational database.

• Explain and handle an SAP HANA-Optimized InfoCube. • Converting Standard InfoProvider to SAP HANA-Optimized. • Elaborate the typical business scenarios where SAP HANA

opti-mized InfoCubes can be used.

Lesson: SAP HANA Optimised Transformations

• Understand how transformations can be pushed down to HANA

Lesson: Replacing BWA with SAP HANA

After completing this lesson, the participant will be able to: • Understand the difference between BWA and SAP HANA

• Understand tasks that are no longer needed when BW is running on HANA and BWA is no longer used.

(10)

• What task need to be maintained or "migrated" specifically addressing BWA only Cubes and the indexing of Virtual Cubes via a snapshot query.

• Identify additional optimisations are possible with HANA beyond BWA

Lesson: Analytic Manager

After completing this lesson, the participant will be able to: • Understand the new Analytic Manager

(11)

Unit 4

Modelling with LSA++

Unit Overview

Lesson: Review of LSA

After completing this lesson, the participant will be able to: • Describe the concepts of LSA

Lesson: Streamline EDW Core

After completing this lesson, the participant will be able to: • Understand how to optimise the design of the EDW Core

Lesson: Enhanced Virtualisation Layer in LSA++

• Understand the new design of the virtualisation layer in LSA++ Describe new modelling opportunities in LSA++ in this layer.

Lesson: Introducing New LSA++ Layers

After completing this lesson, the participant will be able to: • Describe the new LSA++ layers

(12)

Lesson: Introducing a New Modeling Approach

with BW 7.4 on HANA

• Explain the context of Modeling BI functions and integration with SAP BW classical and BW on HANA.

• Understand additional BW7.4 features related to BW on HANA. • Understand and contrast field VS InfoObject modeling.

Lesson: HANA BW Open ODS Field-Based Modeling

• Build a data model on any field data with new Open ODS Views • Cross the border – Open ODS function modeling on remote data

(HANA Smart Data Access)

• Understand the meaning of BW field-based DSOs

• Understand how to integrate field data into the EDW context of InfoObjects • Plan scalability of integration of non-SAP data using field-based

DSOs and Open ODS Views

• Understand the underlying sources of data for OPEN ODS Views • Earn how to establish the semantics for each type of Open DSO

(13)

Unit 5

SAP Landscape Transformation Replication

Server

Unit Overview

In this unit you will get almost all informations about: • Configuration of SAP LT

• Replication and Transformation of data and sure you will perform all this steps for yourself and the result should be to see your "own" Data in SAP HANA

Lesson: Introduction to SLT

After completing this lesson, the participant will be able to: • Explain the positioning of SAP LT Replication Server • Describe the key concepts and features

• List the prerequisites and how to set up the SAP LT Replication Server • Name the benefits of the trigger-based replication approach

Lesson: Configuration Aspects

After completing this lesson, the participant will be able to: • Define a configuration of the SAP LT Replication Server

Lesson: Data Replication at a Glance

(14)

Lesson: SLT based Transformation Concepts and

Advanced Replication Settings

After completing this lesson, the participant will be able to: • Explain the basics of the SLT based transformation concepts • Leverage the data processing and transformation process

• Explain how to change advanced replication settings for certain configurations of SAP LT Replication Server

Lesson: Transformation of Data

• Explain the different types of rules to change data within replication • Specify the parameter in advanced replication settings

Lesson: Extension of (target) table structure and Partitioning

After completing this lesson, the participant will be able to: • Explain the concept of extending a table

• Specify your own extended structures • Explain how to implement partitioning

Lesson: Filtering and Selective Data Replication

After completing this lesson, the participant will be able to: • Explain the benefit of filtering

(15)

• Understand the two different approaches to replicating data to a BW system using SLT.

Lesson: ODP (Operational Data Provisioning)

and the new Delta Queue

After completing this lesson, the participant will be able to: • Understand the new Operational Data Provider functionality

(16)

Unit 6

Additional Enhancements in BW 7.4

Unit Overview

In this unit we cover additional important enhancements to BW 7.4

Lesson: Automatic Generation of HANA

Mod-els (Mixed Scenarios)

• Understand the HANA Import Method to establish a HANA Infor-mation View from a BW InfoProvider

• Utilize the newest "automatic generation" feature for creating a HANA Information View from a BW InfoProvider

• Understand how Analysis Authorization can auto sync between HANA and BW • Published data from SAP HANA into the BW-System (data replication

methods as well as virtual access methods)

• Published data from SAP BW into the SAP HANA-System (data replication methods as well as virtual access methods)

Lesson: SAP BW Workspace

(17)

Lesson: BW optimized content for HANA (New

Business Content)

After completing this lesson, the participant will be able to: • Describe the new SAP HANA optimized BI Content.

• Understand the difference to non-HANA optimized SAP standard BI Content. • Understand the basics of Business Content.

• Understand how to find and use newer. • HANA Optimized Business Content.

Lesson: InfoObject Enhancements

After completing this lesson, the participant will be able to: • Utilize the new features of BW InfoObjects.

Lesson: HANA Analysis Process

After completing this lesson, the participant will be able to: • Describe the HANA Analysis Process

• Create a HANA Analysis Process

Lesson: BW Integrated Planning

• Understand the new features of BW Integrated Planning with SAP HANA

Lesson: Enhanced Mobile Enablement

• Understand the new mobile enhancement features for BW Queries. • Understand what Odata Providers and ODATA based serices are. • Understand how to deploy a query as an ODATA service in a UI.

(18)

Lesson: Authorization

After completing this lesson, the participant will be able to: • know the new Authorization Objects for BW on HANA