HANA Developer

                                                                           SAP HANA Pune, SAP HANA training in Pune, SAP HANA Training, Institute for SAP HANA, SAP HANA, SAP Training Pune, SAP ABAP training                                in Pune, SAP Webdynpro Training in Pune, SAP institute, SAP Coaching Center, Best SAP 
Training Center  , Top SAP Training Center, SAP HANA Trainer, SAP Freelancer, SAP HANA Freelancer.     SAP HANA Training, Pune, Maharashtr
aIndia, 411

ANA is used as a DATABASE to improve the performance of the Business Applications ( i.e Business Transactions & Transactional Reports ) or to speed up Existing Analytic Reports.
So, a good HANA consultant Would understand NOT just the database but also the Analytic applications that can work with HANA to make it  a perfect combination.
Business Objects Powered by HANA is the best choice for any large organization looking for faster analytic Reporting.  SOH offers you a well designed course to cover all the skills that you require to work independently not only on the Database but also in the reporting front.
At the end of the course, we will be working on 2 LIVE SCENARIOS i.e BW on HANA & ABAP on HANA to understand the system much better.


                          • History and Fundamentals of Data-warehousing in Depth.
                          • Star Schema And Extended Star Schema Techniques.
                          • Clear picture on OLTP and OLAP systems.


                          • Introduction to SAP-ABAP
                          • ABAP programming Basics & Fundamentals of DDIC
                          • Understanding the ABAP Function modules and BAPIs
                          • Creating RFC Destinations & Remote Function Calls


                          • Introduction to SAP BW 
                          • InfoObjects 
                          • Non-Cumulative Key figures
                          • Navigational Attributes
                          • Master data Load ( Attributes, Texts and Hierarchies)
                          • InfoCubes & DSOs
                          • Infosets, Multi Providers & Virtual Providers
                          • Generic Extraction ( Using DB Views & Function Modules)
                          • Generic Delta
                          • LOC Extraction
                          • Clear insight on V1,V2 & V3 Updates
                          • Delta Queue Monitoring
                          • Datasource Enhancement using BADI and User Exits
                          • Job Scheduling In Detail & Job monitoring in ECC
                          • Job Triggering Techniques
                          • Process Chain Creation
                          • Scheduling & Monitoring Process Chains
                          • Error Handling in Process Chains
                          • Compression & Aggregation
                          • BEx Query Designer
                          • Calculated & Restricted Key Figures
                          • Formulas ,Variables & Exceptions
                          • Filters and Conditions
                          • BEx Analyzer & BEx Web analyzer.
                          • BEx reporting In depth.
                          • Roles & Authorizations

Introduction to SAP HANA

                          • SAP In-Memory Strategy
                          • HANA compare to BW 
                          • Architecture 
                          • Architecture Overview 
                          • IMCE and Surroundings (In memory Computing Engine)
                          • Row Store & Column Store 
                          • Installation and deployment scenarios 


                          • Introduction to HANA Studio
                          • HANA Administration Prospective
                          • Modeler Prospective
                          • System monitoring.

LT (Landscape Transformation) OR Trigger Based Replication

                          • Remote Function Calls
                          • Creating RFC Destinations in SAP ABAP
                          • Replicating SAP tables from OLTP Server using Trigger based Replication
                          • Real time Replication
                          • Job Scheduling and monitoring.
                          • Parallel and Multi-Thread processing.

SQL Scripts

                          • Data Types
                          • Table Creation, Modification, Updating and Deletion operations.
                          • SQL Select Statements
                          • Joins and Unions 
                          • String Operations
                          • Stored procedures
                          • CE (Calculation Engine) Functions.
                          • Aggregations and lot more.


                          • Applying star schema technique in SAP HANA
                          • Attribute Views 
                            • Calculated Columns
                            • Hierarchies 
                            • Time Data Generation 
                          • Analytic Views
                            • Variables & Input Parameters
                            • Calculated & Restricted Columns
                            • Currency & Quantity Conversions
                          • Calculation Views
                            • Star Joins, Cubes & Dimensions
                            • SQL Script based Views
                          • Calculation Engine Functions Depth.

HANA -ETL Replication Methodology

                          • BODS (Business Object Data services)
                          • HANA As a Central Repository
                          • JDBC & ODBC connectivity.
                          • Replicating data from SAP OLTP Server Using BODS
                          • Replicating data from Flat File Source systems
                          • Replicating data from BI System
                          • Backward replication technique.
                          • Bulk Load & Scheduling 
                          • Extracting ECC data using BW Extractors
                          • Scheduling Stored Procedures

Working with HANA on BW Platform

                          • BI and BODS connectivity
                          • Data Extraction form SAP BW into Hana-Server using BODS
                          • Reporting on BW Infocubes using Dashboards

Transformations using BODS 

                          • Merge Transform
                          • Pivot & Reverse Pivot Transformations
                          • SQL Transformation
                          • Key Generation Transform
                          • Validation Transform
                          • Case Transform

Business Objects CMC & Information Design Tool

                          • Creating Repository
                          • Relational Database & OLAP Connections
                          • Working with Universes
                          • Creation of Project & Data Foundation to Build the Universe
                          • Creating Data Services Repository User

Xcelsius / SAP BO Dashboards

                          • Consuming BEx Query
                          • Consuming an Universe to Design a Dashboard
                          • Working With TABs
                          • Working with Workbook
                          • Visualizing the data in Charts
                          • Using Selectors

SAP HANA Reporting Using MS Excel

                          • SAP HANA MDX Provider
                          • Creating ODBC Connection
                          • Reporting Fundamentals
                          • Using Filters and Hierarchies
                          • Graphical Reporting
                          • Advanced Reporting Techniques.

Reporting Using Business Object Explorer 4.0

                          • Creating HANA Source Systems
                          • Managing Info-Spaces
                          • Geographical Reporting
                          • Time based reporting
                          • Hierarchical Reporting
                          • Configuring & Indexing the Views
                          • Creating Exploration Viewset
                          • Creating URLs for Web-based Reporting
                          • Reporting with BOEx in Depth

Crystal Reports with SAP HANA

                          • Creating Relational Database Connection
                          • Reporting on HANA tables
                          • Reporting on HANA Views
                          • Reporting on Stored Procedures


                          • End – To –End implementation Scenario
                          • Introduction to SAP HANA DXC (Direct Extractor Connection)
                          • HANA as a Source System Via DB connect
                          • Concept of HANA optimized DSOs
                          • HANA optimized InfoCubes
                          • Migrating DSOs & Info Cubes to HDB
                          • Authorizations
                          • Backup and Recovery 


                          • End – To – End  Implementation Scenario
                          • The ADBC connection
                          • Creating External Views on HANA
                          • Working & consuming  Stored procedures on ABAP
                          • SAP ABAP for HANA
                          • Creating Interfaces and & Proxy Classes to Communicate with SPs
                          • Optimizing ABAP reports Using HANA (Live Scenario)

Software Development on SAP HANA

                          • SAP HANA XS engine
                          • Deploying Java Script based Application on HANA
                          • SAP HANA with Odata Services
                          • SAP HANA UI5 based Development

HANA Administration

                          • Creating Users
                          • Assigning Roles 
                          • Authorizations
                          • Backup and Recovery