About This Book
- This book will help you to process analytical and transactional data in real time with the help of SAP HANA.
- Walk through the steps of the data modeling process and build various data models and artifacts in SAP HANA Studio.
- Packed with rich examples and use cases that are closely focused on developing real-time applications.
Who This Book Is For
If you are a SAP HANA data modeler, developer, implementation/migration consultant, project manager, or architect who is responsible for implementing/migrating to SAP HANA, then this book is for you.
What You Will Learn
- Get to grips with the basic building blocks of Analytics/Data models in the SAP HANA environment.
- Discover various schemas, modeling principles, Joins, and the architecture of the SAP HANA engine.
- Build data models and artifacts in Sap HANA Studio.
- Design decision tables and understand the concept of transport management in the SAP HANA landscape.
- Work with the different views in SAP HANA Studio.
- Explore full-text search and fuzzy search in SAP HANA.
- Create your own scenarios and use cases using sample data and code.
SAP HANA is an in-memory database created by SAP. SAP HANA breaks traditional database barriers to simplify IT landscapes, eliminating data preparation, pre-aggregation, and tuning. SAP HANA and in-memory computing allow you to instantly access huge volumes of structured and unstructured data, including text data, from different sources.
Starting with data modeling, this fast-paced guide shows you how to add a system to SAP HANA Studio, create a schema, packages, and delivery unit. Moving on, you'll get an understanding of real-time replication via SLT and learn how to use SAP HANA Studio to perform this. We'll also have a quick look at SAP Business Object DATA service and SAP Direct Extractor for Data Load. After that, you will learn to create HANA artifacts―Analytical Privileges and Calculation View. At the end of the book, we will explore the SMART DATA access option and AFL library, and finally deliver pre-packaged functionality that can be used to build information models faster and easier.
Style and approach
This is an easy-to-follow, step-by-step, rapid guide to help you learn analytics in SAP HANA through ample hands-on exercises and use case scenarios.
Table of Contents
Chapter 1: Kickoff – Before SQLscript Start
Chapter 2: The SAP HANA Data Modeling Approach
Chapter 3: Different Ways of SAP HANA Data Load
Chapter 4: Creating SAP HANA Artifacts Attribute Views and Analytical Views
Chapter 5: Creating SAP HANA Artifacts – Analytical Privileges and Calculation Views
Chapter 6: Understanding Text Search and Hierarchies in SAP HANA
Chapter 7: Using Decision Tables and Transporting SAP HANA Content
Chapter 8: Consuming SAP HANA Data Models
Chapter 9: An Introduction to Application Function Library