This course will prepare you to:
Understand and compare the different data modeling / data transformation possibilities of
Native SAP HANA modeling
SAP HANA Live
SAP HANA CDS
ABAP CDS Views
SAP BW/4HANA
SAP Data Warehouse Cloud
Application Consultant
Business Analyst
Business Process Owner / Team Lead / Power User
Program / Project Manager
Technology Consultant
User
- Essential
- Basic knowledge of Modeling/ Reporting
- Recommended
- BW310, SAPBI, Basic knowledge of SAP ERP as in SAP01
- Native SAP HANA Modeling (SAP HANA 1.0) Prepare your SAP HANA System
- Native SAP HANA Modeling (SAP HANA 2.0) Launch SAP 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
- Launch SAP HANA Studio and create a connection
- Create Calculation Views of type Dimension and Cube with Star Join
- 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
- SAP HANA for SQL data warehousing
- Define a persistence layer with HDBTABLE
- Create a dataflow via flowgraph
- SAP 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
- Start ABAP Eclipse, create a new ABAP Project, and add a development package
- Create a Custom ABAP CDS View with Fiori
- Create a simple ABAP CDS View with ABAP Eclipse
- Create a ABAP CDS View with Association with ABAP Eclipse
- SAP BW powered by SAP HANA and SAP BW/4HANA
- Create an Open ODS View
- Create a Composite Provider
- Create an ADSO
- Create a BW Query
- Optional: Transform and Load data from different sources
- SAP Data Warehouse Cloud
- See how to create a simple model in the Data Builder
- The course is mainly targeted to participants with basic 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 HANA 2.0 SPS 5 (for native SAP HANA modeling)
SAP S/4HANA Version 1909 (with SAP HANA 2.0, SP 04)
SAP BW/4HANA 2.0 SP 7 (with SAP HANA 2.0, SP 04)
SAP HANA Studio 2.3.59 or higher (with ABAP Development Tools 3.18; SAP BW Modeling Tools 1.23.21)
SAP Fiori Frontend Server 6.0
SAP BusinessObjects Analysis for MS Excel 2.8 or higher
SAP Analytics Cloud currently available release
SAP Data Warehouse Cloud currently available release
Course notes and announcements:
In this course, participants will gain an overview over SAP’s main modeling backend systems from native SAP HANA modeling and SAP S/4HANA modeling with ABAP CDS Views to SAP BW/4HANA and SAP Data Warehouse Cloud. Participants will get a comparison of these modeling possibilities and information concerning SAP’s future modeling and data warehouse strategy. Different backend tools will be used in exercises and demos such as SAP WEB IDE for SAP HANA, ABAP Eclipse, SAP BW Modeling tool. Different frontend tools will be used as well to represent the frontend layer (SAP Analytics Cloud, SAP Fiori, SAP Analysis for Office, SAP HANA Live Browser, SAP BW modeling tool Query Designer).
This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, and SAP Certified participant guides.
This 3 day instructor led course qualifies for 24 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.
With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.
Not finding any suitable dates? Contact us for additional available dates: training@dunnsolutions.com
