*Lifetime Access.
*Course completion certificate, Certification documents and materials, interview questions and job assistance included

SAP HANA SP09 Duration of Course:

30+ hours

SAP HANA SP09 Topics Covered are:

Unit 1: Introduction to SAP HANA

1. Introduction to SAP HANA
2. SAP In-Memory Strategy
3. HANA compare to BWA

Unit 2: Look & Feel

1. In-Memory Computing Studio
2. Administration view
3. Navigator View
4. System Monitor
5. Information Modeler

Unit 3: Architecture

1. Architecture Overview
2. IMCE and Surroundings
3. Row Store
4. Column Store
5. Loading data into HANA
6. Data Modelling
7. Reporting
8. Persistent Layer
9. Backup & Recovery

Unit 4: Data Provisioning

1. Method 1 – Data Provisioning using FLAT FILES
2. Method 2 – Data provisioning using BODS 4.2 (ETL Based Approach – Building AGILE Data Marts)
   a. Features of SAP Data Services solution for SAP HANA
   b. Process of loading data from ECC to SAP HANA using the ETL method
3. Method 3 – Data provisioning using SLT
   a. SAP Landscape Replication server for HANA
   b. Key benefits of SLT replication server
   c. Key benefits of Trigger-Based Approach
   d. Architecture for SAP source replication
   e. Architecture for Non-SAP source replication
   f. Configuration and monitoring Dashboard
   g. Creating new Configuration for SAP Sources
   h. Creating New Configuration for Non-SAP sources
   i. Result of Creating new Configuration
   j. Launching Data provisioning UI in HANA studio
   k. Start Load/Replication
   l. Stop/Suspend replication
   m. Status Monitoring in HANA Studio
   n. SLT based transformation Concept
   o. Advanced replication settings
   p. Change of table structuring and partitioning
   q. Filtering and selective data replication
4. Method 4 – Data provisioning using Direct Extractor Connection (DCX)
   a. Using SAP provided Business Content Extractor
   b. ABAP Data Flows for Table and Pool clusters
5. Method 5 – SAP HANA Smart Data Access
6. Method 6 – Remote DATA Sync
   a. Smart Data Streaming

Unit 5 : Modeling

1. Purpose of Information Modeler
2. Levels of Modeling in SAP HANA
3. Attribute Views
4. Analytic Views
5. Calculation Views
6. Explaining Predictive Modeling
7. Discovering SAP HANA Live
8. Creating Advanced Calculation Views using GUI and SCRIPT methods
9. Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
10. Creating Calculation Views with Dimension, Cube and STAR-Join
11. Creating Decision Tables and Analytic Privileges
12. Using Hierarchies (Level Based and Parent-Child Hierarchies)
13. Creating Restricted and Calculated Measures
14. Defining and using Filter Operations
15. Using Variables, input parameters
16. Explaining new aggregation function for measures
17. SAP HANA SQL Introduction
18. SQL Script and Procedures
19. Using Currency Conversions
20. Creating Hyperlinks
21. Persistency Considerations
22. SAP HANA Engine Overview
23. Choosing Views for HANA
24. Using SAP HANA Information Composer for Modeling
25. Processing Information Models
26. Validating Models
27. Comparing Versions of Information Objects
28. Checking Model References
29. Generate Auto Documentation
30. Understand Virtual Data Model
31. Discovering and consuming HANA Live views
32. Building a Virtual Data Model with CDS Views
33. Connecting Tables
    Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)
34. Managing Modelling Content
    a. Manage Schemas b. Import and Export data Models c. Copy Information Objects

Unit 6: Reporting

1. HANA, Reporting Layer
2. Connectivity options
3. SAP Business Objects BI 4.1
4. Designing Complex Universes in IDT based on HANA Tables and HANA Views
5. WEBi 4.0 on HANA
6. Crystal Report for Enterprise with HANA
7. Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
8. SAP Business Objects BI 4.1 Explorer
9. Designing Information Space based on SAP HANA Information Model using BO Explorer 4.1
10. Exploring the Data using BO 4.1 explorer based on Information Spaces created on HANA
11. Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
12. Analysis edition for Microsoft Excel, Microsoft Powerpoint
13. SAP Visual Intelligence on HANA
14. Crystal Reports via ODBC/JDBC Connections
15. Others & MS Excel 2010

Unit 7: User Management

1. Understand and Creation of Users
2. Creation of Roles and Privileges
3. Creation of Role Hierarchy
4. Generating SAP HANA Live Privileges
5. Assignment of Users to Roles
6. Authentication

Unit 8: Security and Authorizations

1. User Management and Security
2. Types of Privileges
3. Template Roles
4. Administrative

Unit 9: Concepts of SAP BW 7.4 ON HANA

1. BW 7.4 powered by SAP HANA
2. In-memory optimized Infocubes
3. In-memory optimized DSO’s
4. Migration concepts of BW 7.0 on traditional Database to BW 7.4 on SAP HANA
5. Migrating standard Infocubes to In memory optimized Infocubes using migration Tool
6. Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool

Unit 10: Text Search and Analysis

1. Implementing Full Text Search and Text analysis
2. Defining Data Types and Full Text Indexes
3. Using Full Text Search
4. Developing Predictive Models

Unit 11: SP12 new Features and Functionality

1. SAP HANA Smart Data Access (New and Changed)
2. SAP HANA Predictive Analysis Library
3. SAP HANA Graph
4. SAP HANA Client Interfaces
5. SAP HANA XS Advanced Development
6. SAP HANA Modeling (New and Changed)
7. SAP Web IDE for SAP HANA and SAP HANA Runtime Tools
8. SAP HANA Interactive Education (SHINE) for XS Advanced

Go to Courses Page – https://knowasap.com/courses/