This course will prepare you to:
Develop information models following SAP best practices for maximum performance and flexibility
Get started with SQL and SQL-Script based modeling
Manage projects and modeling content in the SAP Web IDE for SAP HANA
Implement security and data access controls around SAP HANA data models
Application consultant
Data Consultant / Manager
Database Administrator
Application Developer
BI specialist
- Essential
- HA100 SAP HANA - 360° Introduction
- Recommended
- HA150 SAP HANA 2.0 SPS06 - SQLScript for SAP HANA
- Calculation Views
- Introducing Calculation Views
- Understanding the Different Types of Views
- Working with Common View Design Features
- Using Nodes in Calculation Views
- Using Projection Nodes
- Using Join Nodes
- Working with Data Sets
- Aggregating Data
- Creating CUBE with Star Join Calculation Views
- Extracting Top Values with Rank Nodes
- Modeling Functions
- Create Restricted and Calculated Columns
- Filtering Data
- Using Variables and Input Parameters
- Implementing Hierarchies
- Implement Currency Conversion
- Defining Time-Based Dimension Calculation Views
- Using SQL in Models
- Introducing SAP HANA SQL
- Query a Modeled Hierarchy Using SQLScript
- Working with SQLScript
- Creating and Using Functions
- Creating and Using Procedures
- Persistence Layer
- Defining the Persistence Layer
- Loading Data into Tables
- Accessing Remote Data
- Optimization of Models
- Implementing Good Modeling Practices
- Implementing Static Cache
- Controlling Parallelization
- Implementing Union Pruning
- Using Tools to Check Model Performance
- Developing a Data Management Architecture
- Management and administration of Models
- Working with Modeling Content in a Project
- Creating and Managing Projects
- Enabling Access to External Data
- Working with GIT Within the SAP Web IDE
- Migrating Modeling Content
- Security in SAP HANA Modeling
- Understanding Roles and Privileges
- Defining Analytic Privileges
- Defining Roles
- Masking Sensitive Data
- Anonymizing Data
Course based on software release:
SAP HANA 2.0 SPS06
Course notes and announcements:
This course is also available in a self-paced e-learning format with an active subscription to the SAP Learning Hub, as HA300E.
This course teaches the core capabilities of SAP HANA for calculation view modeling, and covers mainly graphical modeling, as well as SQL- based modeling (table functions and procedures) with a focus on performance. It also introduces Core Data Services as a flexible method to model a persistence layer.
The participants will gain knowledge about the management of modeling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modeling context.
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.
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
