Learning Outcomes

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 SAP Web IDE for SAP HANA
• Implement security and data access controls around SAP HANA data models

Content

• Preparing the Modeling Environment
• Getting Started with SAP Web IDE for SAP HANA
• Importing an Existing Project in SAP Web IDE
• Creating Calculation Views
• Understanding Basic Concepts and Terminology
• Checking the Output of a Calculation View
• Creating Dimension and Cube Calculation Views
• Creating SQL Access Only Calculation Views
• Working with Projection, Aggregation, Join, Union, Minus, Intersect, and Rank Nodes
• Embedding Functions, Calculated Columns, Filtering, Currency Conversion, Variables, Input Parameters, and Hierarchies
• Developing Custom Logic using SQL and SQLScript
• Applying Best Practices for Modeling
• Validating Calculation Views with Performance Analysis Mode
• Debugging with the Debug Query Mode and SQL Analyzer
• Implementing Features to Improve Performance (Union Pruning, Parallelization, Partitioning, Static Cache, Snapshots)
• Using Additional Modeling Productivity Tools
• Working with Modeling Content in a Project (Project Structure, Lifecycle Management, Git, Deployment, Migration)
• Implementing Security in SAP HANA Modeling (Analytic Privileges, Roles, Masking, Anonymization)

Target Audience

• Application Consultant
• Data Consultant / Manager
• Database Administrator
• Application Developer
• BI Specialist