Analytics with SAP Solutions

Course Details
Code: SAPANS-v010
Tuition (USD): $2,454.00 • Virtual (3 days)
$2,454.00 • Classroom (3 days)

Skills Gained

  • This course will prepare you to:
  • Understand and compare the different data modeling / data transformation possibilities of
       -Native SAP HANA modeling
       -SAP HANA CDS
       -ABAP CDS views
       -SAP BW powered by SAP HANA und SAP BW/4HANA

Who Can Benefit

  • 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 Details

Course Content

  • Native SAP HANA Modeling (SAP HANA 1.0)
       -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
       -Native SAP HANA Modeling (SAP HANA 2.0) 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
  • Native SAP HANA CDS
       -Define a persistence layer with HANA CDS DDL
  • 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
       -Explore data with SAP Analytics Cloud
  • 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 powered by SAP HANA and SAP BW/4HANA
       -Log in to SAP BW and navigate in the Data Warehousing Workbench
       -Explore an existing Data Flow
       -Create a Composite Provider containing two Open ODS Views from different sources
       -Create a simple query
       -Load data via ODP using 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
       -Wrap up and comparison of the modeling systems

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.

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