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

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

SAP Enterprise HANA

Average Rating

0

0 ratings

5 1

Details

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content