SAP BW 7.5 on HANA

HANA Topics

Motivation for SAP-HANA

• Enterprise Data Characteristics
• Big Data
• Hardware Innovations
• Software Innovations
• Limitations of Traditional  Databases
• need of Converging OLTP and OLAP
• Text Analysis
• Data Mining and Predictive Analytics

Introduction to SAP-HANA   

• Column Store
• Dictionary Encoding
• Compression Techniques
• Partition ing Methods
• Delta Merge

BW Topics

BW

• Field Based Modeling
• Open ODS View
• Advanced DSO
• HANA optimized  Info Cubes
• Analytic Indexes, Transient Providers
• Virtual Providers
• Virtual Master Data Info Objects
• Composite Providers
• HANA Expert Script Routine
• HANA Analysis Process (HAP)

ABAP

• New ABAP( 5)
• ABAP CDS Views
• ABAP Managed Data base Procedures (AMDPs)
• ABAP Managed Database Functions (Table Functions)

HANA Native Topics

HANA Modeling

• Modeling Objects
• Attribute Views
• M_TIME_DIMENSION
• Analytic Views
• Calculation Views-Graphical
• Calculation Views-Scripting
• Column Views
• Hierarchies
• Filters, Formulas and Parameters
• Restricted & Calculated Measures
• Currency Calculations- Graphical
• Analytic Privileges
• Decision Tables

       HANA SQL

• Catalog Objects
• Creating Tables with several options
• Column Tables and Row Tables
• CRUD operations
• Primary Keys and Foreign Keys
• ALTER and DROP commands
• Sub Queries
• Library Functions
• Summary/Aggregate    Functions
• SET operators
• Views, Visual SQL
• Indexes
• Sequences
• Synonyms, Various System Views

HANA SQL Script

• Functional vs Imperative Processing
• Table Types
• Stored Functions
• Stored Procedures – SQL Script
• Stored Procedures – R language
• Column Views
• Dynamic SQL
• Arrays
• Exception Handling
• Triggers
• All 14 CE Functions

Data Provisioning & Reporting

Data Provisioning to HANA

• with Sub Queries
• with Flat Files – Local Client
• Data Replication Methods

1. BODS or ETL Replication
2. ODP
3. SLT with ABAP Transformations
4. DXC

• Import and Export – Delivery Units

Reporting Tool

• SAP- Lumira
• SAP- Design Studio
• SAP- BOBI ( optional)