Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics /

Mostrar otras versiones (2)

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-...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Singh, Vinay (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing, 2015.
Colección:Professional expertise distilled.
Temas:
SAP HANA (Electronic resource)
Real-time data processing.
Database management.
Business enterprises > Data processing.
Temps réel (Informatique)
Bases de données > Gestion.
Entreprises > Informatique.
BUSINESS & ECONOMICS > Industrial Management.
BUSINESS & ECONOMICS > Management.
BUSINESS & ECONOMICS > Management Science.
BUSINESS & ECONOMICS > Organizational Behavior.
Business enterprises > Data processing
Database management
Real-time data processing
Acceso en línea:Texto completo
Texto completo
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.

Ejemplares similares