更新时间：2021-07-09 21:21:16
coverpage
Real Time Analytics with SAP HANA
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Kickoff – Before We Start
Introducing SAP HANA SQL
The SAP HANA SQLscript
When should we use SQLscript?
Procedures
JOINS in SAP HANA
Unions versus JOINS
Self-study questions
Summary
Chapter 2. SAP HANA Data Modeling Approach
Row and column storage in SAP HANA
Basic architecture of the SAP HANA engine
Different modeling artifacts in SAP HANA
SAP HANA Studio
Different schemas in SAP HANA
Creating package and delivery unit
Chapter 3. Different Ways of SAP HANA Data Load
Loading data from Flat file in SAP HANA
Real-time replication via SAP SLT (System Landscape Transformation) Replication Server
Loading data with SAP Direct Extractor
Application server configuration
Creating a DXC schema and user in SAP HANA
Loading data in SAP HANA with Data Services Workbench
SAP Replication Server
Smart Data Access
Chapter 4. Creating SAP HANA Artifacts Attribute Views and Analytical Views
Steps to adjust preferences
Creating attribute views
Defining attribute and key attribute
Creating time attribute views
Creating analytical views
Creating other elements
Chapter 5. Creating SAP HANA Artifacts – Analytical Privileges and Calculation Views
Creating a restricted measure and a calculated measure
Creating filters
Creating input parameters and variables
Creating calculation views
Analytical privileges
Chapter 6. Understanding Text Search and Hierarchies in SAP HANA
Creating and using Full Text Search
Creating hierarchies
Chapter 7. Using Decision Tables and Transporting SAP HANA Content
What is a decision table?
Transport management in SAP HANA
SAP HANA application lifecycle manager
Transporting a delivery unit with HALM
Export and import – moving SAP HANA content manually
Currency conversion in SAP HANA
Chapter 8. Consuming SAP HANA Data Models
Connecting to the SAP HANA database
Reporting tools for SAP HANA
Analysis for Office
SAP Business Objects Analysis for OLAP
Using Microsoft Excel as a reporting tool
Chapter 9. An Introduction to Application Function Library
Application Function Library
Predictive Analysis Library
Calling PAL functions
Business Function Library
Index
