SAP Enterprise HANA

SAP Enterprise HANA Syllabus

Introduction on HANA

• 1. Business need of HANA
• 2. Classic databases vs HANA
• 3. Column & Row Store Tables
• 4. HANA architecture
• 5. HANA Studio

Information Views (Information Models)

• 1. Standard Attribute View
• 2. Derived attribute view
• 3. Time Attribute View
• 4. Limitations of attribute view
• 5. Attribute view with Hierarchy
• 6. Level Hierarchy
• 7. Parent child Hierarchy
• 8. Analytic View
• 9. Input parameter with Direct, Column, Derived from Table, Static List
• 10. Restricted Column
• 11. Calculated Column
• 12. Before aggregation Calculated Column
• 13. Expression
• 14. Currency Conversion
• 15. Variables
• 16. Variables Vs Input Parameter
• 17. Aggregate functions like Sum, Max, Min, Avg
• 18. Rank Node
• 19. Union Node
• 20. Aggregation Node
• 21. Projection Node
• 22. Decision Tables
• 23. Analytic Privileges

SQL & Procedures

• 1. Introduction to SQL
• 2. Schema
• 3. Table creation with Graphical and SQL
• 4. Database View with Graphical and SQL
• 5. Triggers
• 6. Functions
• 7. Synonyms
• 8. Sequences
• 9. Procedures
• 10. Indexes
• 11. Loading flat file to HANA table
• 12. Table Type
• 13. Calculation Views with SQL Script
• 14. Calculation view consuming procedure
• 15. Calculation View with CE funtions

BODS

• 1. Introduction to BODS
• 2. Database creation
• 3. Repository Creation
• 4. Job Server
• 5. Project
• 6. Job
• 7. Dataflow
• 8. Query transformation
• 9. Case Transformation
• 10. Merger Transformation
• 11. Row Generation Transformation
• 12. Date Generation Transformation
• 13. Pivot Transformation
• 14. Reverse Pivot Transformation
• 15. SQL Transformation
• 16. File Formats
• 17. Source Based CDC
• 18. Tables and Template Tables
• 19. Loading Data from Flat file to HANA template Table
• 20. Loading Data from flat file to HANA Table
• 21. Loading data from ECC Table to HANA
• 22. Loading Data from ECC Extractor to HANA
• 23. Loading Data from BW Table to HANA
• 24. Loading Data from SQL to HANA

SAP Landscape Transformation

• 1. Introduction to SLT
• 2. SLT Configuration
• 3. Replicating tables from SAP ECC
• 4. Load
• 5. Replicate
• 6. Stop Replication
• 7. Suspend
• 8. Resume
• 9. SLT Monitoring
• 10. Advance SLT settings

Quick View options

• 1. Delivery Units
• 2. Generate Time Data
• 3. Auto documentation
• 4. Version
• 5. History
• 6. Data preview
• 7. Redeploy
• 8. Activate
• 9. User used list for Tables and Views
• 10. Refactor Move
• 11. Refactor rename
• 12. Schema Mapping
• 13. Change Authoring Schema
• 14. Switch Ownership
• 15. Masscopy
• 16. Migrate
• 17. Delta Merge
• 18. Data Archiving Process

HANA Live

• 1. Private Views
• 2. Reuse Views
• 3. Query Views

Reporting

• 1. WEBI
• 2. Design Studio
• 3. Lumira

BW on HANA Syllabus

• 1. HANA Migration
• 2. HANA optimized Infocube
• 3. Virtual Infocube on HANA Model
• 4. Master Infoobject on HANA Model
• 5. Transient Inforprovider
• 6. Transportation of transient infoprovider
• 7. Consuming BW Models into HANA
• 8. SPO
• 9. Advanced DSO
• 10. Composite Provider
• 11. Open ODS view with Table, Data Source, SDA with virtual Table,transformation ADSO
• 12. BW Query