Real time analytics with SAP HANA
Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics 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 an...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, England ; Mumbai :
Packt Publishing
[2015]
|
| Edición: | 1st edition |
| Colección: | Professional expertise distilled.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630029506719 |
Tabla de Contenidos:
- Cover
- Copyright
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Table of Contents
- Preface
- Chapter 1: Kickoff - Before SQLscript Start
- Introducing SAP HANA SQL
- Classical SQL
- The SAP HANA SQLscript
- Why SQLscript?
- How different is an SQLscript in SAP HANA from classical SQL queries?
- When should we use SQLScript?
- Procedures
- Creating with the SQL editor (in SAP HANA Studio)
- Procedure creation using the wizard
- JOINS in SAP HANA
- Unions versus JOINS
- Self-study questions
- Summary
- Chapter 2: The SAP HANA Data Modeling Approach
- Row and column storage in SAP HANA
- Choosing the right table
- A basic architecture of the SAP HANA engine
- Different modeling artifacts in SAP HANA
- Modeling principles
- The SAP HANA Studio
- Perspectives in SAP HANA Studio
- Adding our system to SAP HANA Studio
- The system view
- Different schemas in SAP HANA
- Creating package and delivery unit
- Deleting packages
- Delivery units
- Self-study questions
- Summary
- 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
- Self-study questions
- Summary
- 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
- Calculated attribute
- Calculated measures
- Calculated columns
- Creating variables
- Self-study questions.
- Summary
- Chapter 5: Creating SAP HANA Artifacts - Analytical Privileges and Calculation Views
- Creating a restricted measure and a calculated measure
- Creating filters
- Steps for creating a filter
- Creating input parameters and variables
- Creating calculation views
- Analytical privileges
- Self-study questions
- Summary
- Chapter 6: Understanding Text Search and Hierarchies in SAP HANA
- Creating and using Full Text Search
- Enabling the search option
- Creating hierarchies
- Creating a level hierarchy
- Creating a parent-child hierarchy
- Self-study questions
- Summary
- Chapter 7: Using Decision Tables and Transporting SAP HANA Content
- What is a decision table?
- Why use decision tables?
- 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
- Self-study questions
- Summary
- 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
- Summary
- Chapter 9: An Introduction to Application Function Library
- Application Function Library
- Predictive Analysis Library
- Calling PAL functions
- Business Function Library
- Self-study questions
- Summary
- Index.
