SAP HANA SP09
$135.00
Introduction
*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
- Introduction to SAP HANA
- SAP In-Memory Strategy
- HANA compare to BWA
Unit 2: Look & Feel
- In-Memory Computing Studio
- Administration view
- Navigator View
- System Monitor
- Information Modeler
Unit 3: Architecture
- Architecture Overview
- IMCE and Surroundings
- Row Store
- Column Store
- Loading data into HANA
- Data Modelling
- Reporting
- Persistent Layer
- Backup & Recovery
Unit 4: Data Provisioning
- Method 1 – Data Provisioning using FLAT FILES
- 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 - 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 - 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 - Method 5 – SAP HANA Smart Data Access
- Method 6 – Remote DATA Sync
a. Smart Data Streaming
Unit 5 : Modeling
- Purpose of Information Modeler
- Levels of Modeling in SAP HANA
- Attribute Views
- Analytic Views
- Calculation Views
- Explaining Predictive Modeling
- Discovering SAP HANA Live
- Creating Advanced Calculation Views using GUI and SCRIPT methods
- Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
- Creating Calculation Views with Dimension, Cube and STAR-Join
- Creating Decision Tables and Analytic Privileges
- Using Hierarchies (Level Based and Parent-Child Hierarchies)
- Creating Restricted and Calculated Measures
- Defining and using Filter Operations
- Using Variables, input parameters
- Explaining new aggregation function for measures
- SAP HANA SQL Introduction
- SQL Script and Procedures
- Using Currency Conversions
- Creating Hyperlinks
- Persistency Considerations
- SAP HANA Engine Overview
- Choosing Views for HANA
- Using SAP HANA Information Composer for Modeling
- Processing Information Models
- Validating Models
- Comparing Versions of Information Objects
- Checking Model References
- Generate Auto Documentation
- Understand Virtual Data Model
- Discovering and consuming HANA Live views
- Building a Virtual Data Model with CDS Views
- Connecting Tables
Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union) - Managing Modelling Content
a. Manage Schemas b. Import and Export data Models c. Copy Information Objects
Unit 6: Reporting
- HANA, Reporting Layer
- Connectivity options
- SAP Business Objects BI 4.1
- Designing Complex Universes in IDT based on HANA Tables and HANA Views
- WEBi 4.0 on HANA
- Crystal Report for Enterprise with HANA
- Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
- SAP Business Objects BI 4.1 Explorer
- Designing Information Space based on SAP HANA Information Model using BO Explorer 4.1
- Exploring the Data using BO 4.1 explorer based on Information Spaces created on HANA
- Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
- Analysis edition for Microsoft Excel, Microsoft Powerpoint
- SAP Visual Intelligence on HANA
- Crystal Reports via ODBC/JDBC Connections
- Others & MS Excel 2010
Unit 7: User Management
- Understand and Creation of Users
- Creation of Roles and Privileges
- Creation of Role Hierarchy
- Generating SAP HANA Live Privileges
- Assignment of Users to Roles
- Authentication
Unit 8: Security and Authorizations
- User Management and Security
- Types of Privileges
- Template Roles
- Administrative
Unit 9: Concepts of SAP BW 7.4 ON HANA
- BW 7.4 powered by SAP HANA
- In-memory optimized Infocubes
- In-memory optimized DSO’s
- Migration concepts of BW 7.0 on traditional Database to BW 7.4 on SAP HANA
- Migrating standard Infocubes to In memory optimized Infocubes using migration Tool
- Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool
Unit 10: Text Search and Analysis
- Implementing Full Text Search and Text analysis
- Defining Data Types and Full Text Indexes
- Using Full Text Search
- Developing Predictive Models
Unit 11: SP12 new Features and Functionality
- SAP HANA Smart Data Access (New and Changed)
- SAP HANA Predictive Analysis Library
- SAP HANA Graph
- SAP HANA Client Interfaces
- SAP HANA XS Advanced Development
- SAP HANA Modeling (New and Changed)
- SAP Web IDE for SAP HANA and SAP HANA Runtime Tools
- SAP HANA Interactive Education (SHINE) for XS Advanced
Go to Courses Page –Â https://knowasap.com/courses/
Ratings and Reviews
5.0
Avg. Rating
1 Ratings
5
1
4
0
3
0
2
0
1
0
What's your experience? We'd love to know!
Login to Review
What's your experience? We'd love to know!
Login to Review
best course available, worth the money, started getting calls from know asap referrals...love you team.