Contact Us
Company Name
Contact Person
Email Address or Phone
Detail

Course Code: IVC/SHM
Course Name: Workshop for SAP HANA Modeling (HA300)
Time: 0930 - 1700
Duration: 3 days
Course Fee: HKD 15,000
Location: Lai Chi Kok

Goals

This course will prepare you to:

  • Develop information models following SAP best practices for maximum performance and flexibility
  • Get started with SQL and SQLScript based modeling
  • Manage projects and modeling content in the Web IDE
  • Implement security and data access controls around SAP HANA data models
  • Get started with advanced data processing such as text, spatial, predictive and graph

Audience

  • Business application consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application developer
  • BI specialist

Course based on software release

  • SAP HANA 2.0 SPS01

Content

  • Information Views
    • Connect Tables
    • Create Dimension and Cube Calculation Views
  • Modeling Functions
    • Create Hierarchies
    • Create Calculated and Restricted Columns
    • Filter Data
    • Use Variables and Input Parameters
    • Implement Currency Conversion
  • SAP HANA Studio Modeling
  • Virtual Data Models in SAP HANA
    • Use SAP HANA Live
    • Overview of Virtual Data Models built with Core Data Services (CDS)
  • SQL Script and Procedures
    • Introduce SQL and SQLScript
    • Create a Persistence Layer Using CDS
    • Create Table Functions and Procedures
  • Management and administration of Models
    • Work with Modeling Content
    • Create and Manage Projects
    • Overview of classical models migration to Web IDE
  • Security in SAP HANA Modeling
    • Understand the Key Concepts of SAP HANA Security
    • Define Data Access Security
    • Define Roles
  • Optimization of Models
    • Apply Best Practices to Model Design
    • Introduction to Performance and Analysis Tools
  • Overview of Text, Spatial, Predictive and Graph Modeling

Notes

  • Most of the activities of this course rely on the SAP Web IDE for SAP HANA, but graphical modeling in SAP HANA Studio is also covered with a dedicated unit.