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

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on PragimTech.com, you can subscribe by providing your valid email.