SAPANS Analytics with SAP Solutions

Course version: 010

Goals
This course will prepare you to:
Understand and compare the different data modeling / data transformation possibilities of
- SAP HANA native modeling
- HANA CDS views
- ABAP CDS views
- BW/4HANA
- SAC

Audience
Application Consultant
Business Analyst
Business Process Owner / Team Lead / Power User
Program / Project Manager
Technology Consultant

Prerequisites
Essential
None

Recommended
BW310, SAPBI, Basic knowledge of SAP ERP as in SAP01

Course based on software release

• SAP BW75 powered by SAP HANA, SP04
• SAP HANA 1.0 SPS12
• SAP HANA Studio 2.3.8 or higher
• SAP BW/4HANA Modeling Tools 1.1 or higher
• SAP BusinessObjects Analysis for MS Excel 2.2 or higher
• SAP Analytics Cloud currently available release
• SAP HANA 2.0 SP 02
• S/4HANA Version 1805
• ECC Netweaver 7.4, SPS 04, with DMIS 2011 SPS 08

Content

• Native SAP HANA Modeling
  - Prepare your SAP HANA System
  - Launch SAP HANA Studio and create a connection
  - Create Calculation Views of Type Dimension
  - Create a Calculation View of Type Cube with Star Join
  - Create a Calculation View with a Union Node via
• SAP HANA Studio
  - Launch Web IDE for SAP HANA and set up your development environment
  - Create a Calculation View of Type Dimension in SAP Web IDE for SAP HANA
  - Create a Calculation View and implement a Parent-Child Hierarchy via SAP Web IDE for SAP HANA
  - Create a Calculation View and use Filter via SAP Web IDE for SAP HANA
  - Create a Calculation View and use Variable and Input Parameter via SAP Web IDE for SAP HANA
• SAP HANA Live
  - Explore SAP HANA Live Calculation Views using SAP HANA Studio
  - Use SAP HANA LIVE Browser
  - Explore Data with the SAP Analytics Cloud
• Native SAP HANA CDS
  - Define a Persistence Layer with CDS
• S/4HANA and Embedded Analytics
  - Prepare your S/4HANA System and explore SAP ABAP CDS views using SAP Logon and ABAP Eclipse
  - Explore VDM ABAP CDS views using the View Browser
• Lesson: Customer-Defined ABAP CDS Views
  - Examine the Tables used in the VDM
  - Start SAP HANA Studio, create a New ABAP Project, and add a Development Package
  - Create a Simple DDL Source for the Table SAIRPORT
  - Review the code of Interface and Composite Views
• SAP BW on HANA and BW/4HANA
  - Log in to SAP BW and Navigate in the Data Warehousing Workbench
  - Explore an Existing Data Flow
  - Create a CompositeProvider Containing Two Open ODS Views from Different Sources
  - Create a Simple Query
  - Load data via ODP Type SAP HANA Information Views
  - Create an ABAP CDS View DataSource and Load Data
  - Stream Data in Real Time with ODP – SLT
  - Work with SAP HANA-Optimized Transformation Rules
• Summary

Notes
The course is mainly targeted to participants with few or no prior knowledge of the modeling areas and even for those who are familiar with one of the modeling areas, optional exercises exist to deepen their knowledge.