Tag Archives: SAP HANA Training

SAP HANA Online Training

Our Institute offers Online SAP HANA Training with SAP HANA 2.0 certification material, enroll free demo for SAP HANA course  ✓Best Institute for SAP HANA online training ✓live tutorial videos ✓job support. You will find spiritsofts is the best institute within reasonable fee.

We Provides the best learning Environment. Obtain all the training by our expert professionals which is having working experience from Top IT companies.

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse ContentFAQs
  45 hours of Instructor Training Classes                            24/7 Support

 Lifetime Access to Recorded Sessions                              Practical Approach

 Real World use cases and Scenarios                                 Expert & Certified Trainers

SAP HANA Training Course Content.

1.SAP HANA Introduction

  • In-Memory Computing
  • Evolution of In-Memory computing at SAP
  • History HANA
  • HANA Hardware Sizing
  • Product Availability Matrix
  • HANA compare to BWA

 

2.SAP HANA Overview

  • Architectural overview
  • Row Store
  • Column Store
  • Persistency Layer

 

3. SAP HANA Versions and Studio overview

  • SAP HANA Version
  • History of Service pack details
  • Studio Overview
  • HANA Studio Preferences
  • HANA Studio Prospective

 

4. SAP HANA Engines

  • Column Store Engine
  • Row Store Engine
  • Join Engine
  • OLAP Engines
  • Calculation Engine
  • Calculation Engine’s Non-RelationalBehavior
  • SAP HANA General Modeling Principles

 

SAP HANA Modeling
Attribute View

  • How to connect tables using
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Text Join
  • Referential Join
  • Union
  • Filter
  • Calculated Column

 

Analytic View

  • Structural Overview
  • Data Foundation
  • Logical View
  • Define View Semantics
  • Left Outer Join – Attribute View
  • Inner Join – Analytical View
  • Right Outer Join – Analytical View
  • Referential Join – Analytical View
  • run-time object: column view
  • Calculated Attribute
  • Calculated Measure
  • Restricted Measure
  • Filter
  • Input Parameter

 

Tables in HANA

  • Column Store Table
  • Row Store Table
  • Table type

 

SQL in HANA

  • Basic SQL Knowledge
  • Select Statement
  • From Clause
  • Where Clause
  • Group By clause
  • Having Clause
  • Order by Clause
  • Top N clause

 

SQL Procedure in HANA

  • How to create Procedure
  • Elements of the Procedure
  • Procedures using Column Store Views
  • IF-ELSE Logic
  • For Loop Logic
  • Cursor in HANA
  • Dynamic Filter

 

CE based Script in HANA

  • CE_COLUMN_TABLE
  • CE_JOIN_VIEW
  • CE_OLAP_VIEW
  • CE_CALC_VIEW
  • CE_JOIN
  • CE_LEFT_OUTER_JOIN
  • CE_RIGHT_OUTER_JOIN
  • CE_FULL_OUTER_JOIN
  • CE_PROJECTION
  • CE_CALC
  • CE_AGGREGATION
  • CE_UNION_ALL

 

Calculation View

  • Graphical Calculation View
  • Calculation SQL Script method
  • GraphicalCalculation View Working with Nodes
  • Graphical Calculation View Define View Result Set
  • Graphical Calculation View Define View Semantics
  • How to call Calculation view using SQL into Calculation Views
  • Script-based CV: output column structure import
  • Scenario redesign: replace node / replace data sources
  • Extract semantics from data sources
  • Table function as data sources
  • Debugging Views with drill-down analysis
  • Calculation View limitations in Designing and performance issues
  • Select count (*) statement on top of a HANA graphical Calculation View leads to unexpected number ofrecords in the result set.

 

Miscellaneous

  • Delivery Units
  • Transport Individual HANA Models
  • How to load Excel data into HANA using Studio
  • Export/Import
  • How to create Sequence
  • How to create Synonym
  • How to create Trigger
  • How to create View

 

Performance Tuning

  • Index creation
  • Partitioning
  • Hash Partition
  • Merge Partition
  • Round Robin Partition
  • Multi-Level Partition
  • Table Redistribution

 

Security & User Management

  • Creating Users
  • Creating Roles
  • Privileges
  • Authorization challenges
  • User Administration
  • Backup & Recovery
  • Collecting traces

 

Data Provisioning

  • SAP Data Services extraction
  • SAP SLT Replication
  • Smart Data Access
  • AP HANA-Direct Extractor Connection (DXC)

 

SAP Data Services Overview

  • What is SAP Data Services
  • SAP Data Services Architecture
  • SAP Data Services objects (Job, Data Flow, Work Flow, Transformations)

 

SAP Data Services Extraction

  • Loading Data from SAP ECC to SAP HANA DB
  • Loading Data from SAP BW to SAP HANA DB
  • Loading Data from MSSQL Server DB to SAP HANA DB
  • Loading Data from Excel to SAP HANA DB
  • How to load data from HANA Information Models to MSSQL DB

 

SAP SLT Data provisioning overview

  • What is SAP SLT
  • SAP SLT License options
  • SAP SLT system sizing
  • SAP SLT system landscape preparation

 

SAP SLT Schema configuration

  • How to configure SLT Schema for SAP Source system
  • How to configure SLT Schema for Non-SAP Source system
  • No.of Data transfer Jobs configuration
  • How to improve Initial data loading
  • Tables configuration in SLT using Data Provisioning

 

SAP SLT Performance tuning technics

  • Monitoring Replication in SLT
  • Access Plan
  • Reading Types
  • Adding Entry in the table IUUC_PRECALC_OBJ
  • Adding Entry in the table IUUC_PERF_OPTION
  • MWBMON
  • How to do Partition in SLT
  • How to restrict the tables that are allowed for replication
  • HANA Supported Data Types
  • How to change the standard mapping

 

HANA Advanced Analytics

HANA Reporting BO Tools

    • How to Connect with IDT
    • How to create Universe using HANA Tables
    • How to create Webi Reports
    • Webi Functions
    • How to schedule Webi reports
    • How to assign the WebI reports to the End users

 

HANA Reporting with Crystal Reports 2013

  • Report Designer
  • Report creation wizard
  • Sections
  • Sorting and Grouping
  • Chart expert
  • Formulas
  • Sub reports

 

HANA Reporting with Crystal Reports for Enterprise

  • How to Connect HANA with Crystal Reports for Enterprise
  • How to create reports

 

HANA Reporting with SAP Dashboards

  • How to Connect HANA with Dashboards
  • How to create Dashboard Reports

 

HANA Reporting with SAP Lumira

  • How to Connect HANA with SAP Lumira
  • How to Explore HANA Data with Lumira
  • Publish Lumira report

 

HANA Reporting with SAP Design Studio

  • SAP Design Studio Overview
  • How to create reports

 

HANA Reporting with SAP Predictive Analysis

  • SAP Predictive Analysis Overview
  • How to Explore data with Predictive Analysis

 

BW 7.3 powered by HANA Overview

    • BW 7.3 powered by HANA Overview
    • BW7.30-HANA Optimized Info Cube
    • BW7.30-HANA Optimized Info DSO
    • Importing SAP BW7.30 Models into HANA Modeling environment
    • Publish Standalone HANA Models into SAP BW 7.30 on HANA
    • BW on HANA Migration activities

 

SAP HANA as Secondary Database

  • Architectural Concept

 

SAP HANA End to End Mock Implementation Project

  • How configure SAP 150 ECC tables using SLT Replication
  • How to configure Data loads using SAP Data Services from Oracle DB
  • How Create HANA Information models based on Business Requirement
  • Creating HANA Models using Combination of multiple Sources
  • How to generate SAP BO reports and Assign to End User
  • Creating 3 HANA Implementation projects Proof of Concepts
  • Guidance to Create HANA models Architecture for Implementation project

 

SAP HANA Certification Guidance

  • SAP HANA Exam Code C_HANAIMP141
  • HA100 and HA300 Documents can be provide for certification preparation purpose.
  • SAP HANA Exam Dumps can be provided, to clear certification exam.
Who Are The Trainers?
Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Spiritsofts verifies their technical background and expertise.
What If I Miss A Class?
We record each LIVE class session you undergo through and we will share the recordings of each session/class.
How Will I Execute The Practical?
Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.
If I Cancel My Enrollment, Will I Get The Refund?
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.
Will I Be Working On A Project?
The Training itself is Real-time Project Oriented.
Are These Classes Conducted Via Live Online Streaming?
Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.
Is There Any Offer / Discount I Can Avail?
There are some Group discounts available if the participants are more than 2.
Who Are Our Customers?
As we are one of the leading providers of Live Instructor LED training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, Sydney, France, Finland, Sweden, Spain, Russia Moscow, Denmark, London, England, South Africa, Switzerland, Kenya, Philippines, Japan, Indonesia, Pakistan, Saudi Arabia,  Qatar, Kuwait, Germany, Frankfurt Berlin Munich, Poland, Belarus, Belgium Brussels Netherlands Amsterdam, India and other parts of the world.

We are located in USA. Offering Online Training in Cities like New York, New jersey, Dallas, Seattle, Baltimore, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa Clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert.

Hyderabad (Ameerpet), Kukatpally, Vizag, Nellore, Lucknow, Coimbatore, Marathahalli, Electronic city , Silk board, Kakinada, Goa, Vijayawada, Bangalore, Noida, Chennai, Kolkata, Pune, Whitefield, Mumbai, Delhi NCR, Dubai, Doha, Melbourne, Brisbane, Perth, Wellington, Leeds, Manchester, Liverpool, Ireland Dublin, Oxford, Cambridge, Brighton, Cardiff, Bristol, Lithuania,  Latvia, Italy, San Marion, China Beijing, Auckland etc…

Keywords: Best Institute for SAP HANA Training, SAP HANA Course Material, SAP HANA,SAP HANA Software, SAP HANA Documentation, SAP HANA Material PDF, ISAP HANA Jobs for Freshers,  SAP HANA Training in Hyderabad, SAP HANA Institute in Bangalore, SAP HANA 2.0 Interview Questions, SAP HANA Tutorial Videos, SAP HANA Training institutes in Hyderabad. SAP HANA Certification Cost, SAP HANA 2.0 Certification Dumps, SAP HANA Developer Training for Beginners

SAP HANA Training

Enrol for SAP HANA Training by Experts with Certification Material SAP HANA Online Training Course  Free Demo Pay Fee in Instalments Project Scenarios Job Support.

Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professionals which is having working experience from Top IT companies.

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse ContentFAQs
 45 hours of Instructor Training Classes                            24/7 Support

 Lifetime Access to Recorded Sessions                              Practical Approach

 Real World use cases and Scenarios                                 Expert & Certified Trainers

SAP HANA 2.0  Training Course Content.

1.SAP HANA Introduction

  • In-Memory Computing
  • Evolution of In-Memory computing at SAP
  • History HANA
  • HANA Hardware Sizing
  • Product Availability Matrix
  • HANA compare to BWA

 

2.SAP HANA Overview

  • Architectural overview
  • Row Store
  • Column Store
  • Persistency Layer

 

3. SAP HANA Versions and Studio overview

  • SAP HANA Version
  • History of Service pack details
  • Studio Overview
  • HANA Studio Preferences
  • HANA Studio Prospective

 

4. SAP HANA Engines

  • Column Store Engine
  • Row Store Engine
  • Join Engine
  • OLAP Engines
  • Calculation Engine
  • Calculation Engine’s Non-RelationalBehavior
  • SAP HANA General Modeling Principles

 

SAP HANA Modeling
Attribute View

  • How to connect tables using
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Text Join
  • Referential Join
  • Union
  • Filter
  • Calculated Column

 

Analytic View

  • Structural Overview
  • Data Foundation
  • Logical View
  • Define View Semantics
  • Left Outer Join – Attribute View
  • Inner Join – Analytical View
  • Right Outer Join – Analytical View
  • Referential Join – Analytical View
  • run-time object: column view
  • Calculated Attribute
  • Calculated Measure
  • Restricted Measure
  • Filter
  • Input Parameter

 

Tables in HANA

  • Column Store Table
  • Row Store Table
  • Table type

 

SQL in HANA

  • Basic SQL Knowledge
  • Select Statement
  • From Clause
  • Where Clause
  • Group By clause
  • Having Clause
  • Order by Clause
  • Top N clause

 

SQL Procedure in HANA

  • How to create Procedure
  • Elements of the Procedure
  • Procedures using Column Store Views
  • IF-ELSE Logic
  • For Loop Logic
  • Cursor in HANA
  • Dynamic Filter

 

CE based Script in HANA

  • CE_COLUMN_TABLE
  • CE_JOIN_VIEW
  • CE_OLAP_VIEW
  • CE_CALC_VIEW
  • CE_JOIN
  • CE_LEFT_OUTER_JOIN
  • CE_RIGHT_OUTER_JOIN
  • CE_FULL_OUTER_JOIN
  • CE_PROJECTION
  • CE_CALC
  • CE_AGGREGATION
  • CE_UNION_ALL

 

Calculation View

  • Graphical Calculation View
  • Calculation SQL Script method
  • GraphicalCalculation View Working with Nodes
  • Graphical Calculation View Define View Result Set
  • Graphical Calculation View Define View Semantics
  • How to call Calculation view using SQL into Calculation Views
  • Script-based CV: output column structure import
  • Scenario redesign: replace node / replace data sources
  • Extract semantics from data sources
  • Table function as data sources
  • Debugging Views with drill-down analysis
  • Calculation View limitations in Designing and performance issues
  • Select count (*) statement on top of a HANA graphical Calculation View leads to unexpected number ofrecords in the result set.

 

Miscellaneous

  • Delivery Units
  • Transport Individual HANA Models
  • How to load Excel data into HANA using Studio
  • Export/Import
  • How to create Sequence
  • How to create Synonym
  • How to create Trigger
  • How to create View

 

Performance Tuning

  • Index creation
  • Partitioning
  • Hash Partition
  • Merge Partition
  • Round Robin Partition
  • Multi-Level Partition
  • Table Redistribution

Security & User Management

  • Creating Users
  • Creating Roles
  • Privileges
  • Authorization challenges
  • User Administration
  • Backup & Recovery
  • Collecting traces

 

Data Provisioning

  • SAP Data Services extraction
  • SAP SLT Replication
  • Smart Data Access
  • AP HANA-Direct Extractor Connection (DXC)

 

SAP Data Services Overview

  • What is SAP Data Services
  • SAP Data Services Architecture
  • SAP Data Services objects (Job, Data Flow, Work Flow, Transformations)

 

SAP Data Services Extraction

  • Loading Data from SAP ECC to SAP HANA DB
  • Loading Data from SAP BW to SAP HANA DB
  • Loading Data from MSSQL Server DB to SAP HANA DB
  • Loading Data from Excel to SAP HANA DB
  • How to load data from HANA Information Models to MSSQL DB

 

SAP SLT Data provisioning overview

  • What is SAP SLT
  • SAP SLT License options
  • SAP SLT system sizing
  • SAP SLT system landscape preparation

 

SAP SLT Schema configuration

  • How to configure SLT Schema for SAP Source system
  • How to configure SLT Schema for Non-SAP Source system
  • No.of Data transfer Jobs configuration
  • How to improve Initial data loading
  • Tables configuration in SLT using Data Provisioning

 

SAP SLT Performance tuning technics

  • Monitoring Replication in SLT
  • Access Plan
  • Reading Types
  • Adding Entry in the table IUUC_PRECALC_OBJ
  • Adding Entry in the table IUUC_PERF_OPTION
  • MWBMON
  • How to do Partition in SLT
  • How to restrict the tables that are allowed for replication
  • HANA Supported Data Types
  • How to change the standard mapping

 

HANA Advanced Analytics

HANA Reporting BO Tools

    • How to Connect with IDT
    • How to create Universe using HANA Tables
    • How to create Webi Reports
    • Webi Functions
    • How to schedule Webi reports
    • How to assign the WebI reports to the End users

 

HANA Reporting with Crystal Reports 2013

  • Report Designer
  • Report creation wizard
  • Sections
  • Sorting and Grouping
  • Chart expert
  • Formulas
  • Sub reports

 

HANA Reporting with Crystal Reports for Enterprise

  • How to Connect HANA with Crystal Reports for Enterprise
  • How to create reports

 

HANA Reporting with SAP Dashboards

  • How to Connect HANA with Dashboards
  • How to create Dashboard Reports

 

HANA Reporting with SAP Lumira

  • How to Connect HANA with SAP Lumira
  • How to Explore HANA Data with Lumira
  • Publish Lumira report

 

HANA Reporting with SAP Design Studio

  • SAP Design Studio Overview
  • How to create reports

 

HANA Reporting with SAP Predictive Analysis

  • SAP Predictive Analysis Overview
  • How to Explore data with Predictive Analysis

 

BW 7.3 powered by HANA Overview

    • BW 7.3 powered by HANA Overview
    • BW7.30-HANA Optimized Info Cube
    • BW7.30-HANA Optimized Info DSO
    • Importing SAP BW7.30 Models into HANA Modeling environment
    • Publish Standalone HANA Models into SAP BW 7.30 on HANA
    • BW on HANA Migration activities

 

SAP HANA as Secondary Database

  • Architectural Concept

 

SAP HANA End to End Mock Implementation Project

  • How configure SAP 150 ECC tables using SLT Replication
  • How to configure Data loads using SAP Data Services from Oracle DB
  • How Create HANA Information models based on Business Requirement
  • Creating HANA Models using Combination of multiple Sources
  • How to generate SAP BO reports and Assign to End User
  • Creating 3 HANA Implementation projects Proof of Concepts
  • Guidance to Create HANA models Architecture for Implementation project

 

SAP HANA Certification Guidance

  • SAP HANA Exam Code C_HANAIMP141
  • HA100 and HA300 Documents can be provide for certification preparation purpose.
  • SAP HANA Exam Dumps can be provided, to clear certification exam.
Who Are The Trainers?
Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Spiritsofts verifies their technical background and expertise.
What If I Miss A Class?
We record each LIVE class session you undergo through and we will share the recordings of each session/class.
How Will I Execute The Practical?
Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.
If I Cancel My Enrollment, Will I Get The Refund?
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.
Will I Be Working On A Project?
The Training itself is Real-time Project Oriented.
Are These Classes Conducted Via Live Online Streaming?
Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.
Is There Any Offer / Discount I Can Avail?
There are some Group discounts available if the participants are more than 2.
Who Are Our Customers?
As we are one of the leading providers of Live Instructor LED training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world.

We are located in USA. Offering Online Training in Cities like New York, New jersey, Dallas, Seattle, Baltimore, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa Clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert.

Hyderabad (Ameerpet), Vizag, Vijayawada, Bangalore, Noida, Chennai, Kolkata, Pune, Mumbai, Delhi NCR, Dubai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland etc…

SAP HANA Certifications?
SAP HANA Certification Pathways, C_HANAIMP142, SAP HANA Cloud Platform (Edition 2016), C_HANADEV_13 – SAP Certified Development Associate – SAP HANA 2.0, C_HCP_10 – SAP Certified Development Associate – SAP HANA Cloud Platform (Edition 2016),
C_HANADEV_13 – SAP Certified Development Associate – SAP HANA 2.0, C_HCP_10 – SAP Certified Development Associate – SAP HANA Cloud Platform (Edition 2016)

HANA Training

HANA Training Course Content.

1. SAP HANA Introduction

  • In-Memory Computing
  • Evolution of In-Memory computing at SAP
  • History HANA
  • HANA Hardware Sizing
  • Product Availability Matrix
  • HANA compare to BWA

 

2.SAP HANA Overview

  • Architectural overview
  • Row Store
  • Column Store
  • Persistency Layer

 

3. SAP HANA Versions and Studio overview

  • SAP HANA Version
  • History of Service pack details
  • Studio Overview
  • HANA Studio Preferenc
  • es
  • HANA Studio Prospective

 

4. SAP HANA Engines

  • Column Store Engine
  • Row Store Engine
  • Join Engine
  • OLAP Engines
  • Calculation Engine
  • Calculation Engine’s Non-RelationalBehavior
  • SAP HANA General Modeling Principles

 

SAP HANA Modeling
Attribute View

  • How to connect tables using
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Text Join
  • Referential Join
  • Union
  • Filter
  • Calculated Column

 

Analytic View

  • Structural Overview
  • Data Foundation
  • Logical View
  • Define View Semantics
  • Left Outer Join – Attribute View
  • Inner Join – Analytical View
  • Right Outer Join – Analytical View
  • Referential Join – Analytical View
  • run-time object: column view
  • Calculated Attribute
  • Calculated Measure
  • Restricted Measure
  • Filter
  • Input Parameter

 

Tables in HANA

  • Column Store Table
  • Row Store Table
  • Table type

 

SQL in HANA

  • Basic SQL Knowledge
  • Select Statement
  • From Clause
  • Where Clause
  • Group By clause
  • Having Clause
  • Order by Clause
  • Top N clause

 

SQL Procedure in HANA

  • How to create Procedure
  • Elements of the Procedure
  • Procedures using Column Store Views
  • IF-ELSE Logic
  • For Loop Logic
  • Cursor in HANA
  • Dynamic Filter

 

CE based Script in HANA

  • CE_COLUMN_TABLE
  • CE_JOIN_VIEW
  • CE_OLAP_VIEW
  • CE_CALC_VIEW
  • CE_JOIN
  • CE_LEFT_OUTER_JOIN
  • CE_RIGHT_OUTER_JOIN
  • CE_FULL_OUTER_JOIN
  • CE_PROJECTION
  • CE_CALC
  • CE_AGGREGATION
  • CE_UNION_ALL

 

Calculation View

  • Graphical Calculation View
  • Calculation SQL Script method
  • GraphicalCalculation View Working with Nodes
  • Graphical Calculation View Define View Result Set
  • Graphical Calculation View Define View Semantics
  • How to call Calculation view using SQL into Calculation Views
  • Script-based CV: output column structure import
  • Scenario redesign: replace node / replace data sources
  • Extract semantics from data sources
  • Table function as data sources
  • Debugging Views with drill-down analysis
  • Calculation View limitations in Designing and performance issues
  • Select count (*) statement on top of a HANA graphical Calculation View leads to unexpected number ofrecords in the result set.

 

Miscellaneous

  • Delivery Units
  • Transport Individual HANA Models
  • How to load Excel data into HANA using Studio
  • Export/Import
  • How to create Sequence
  • How to create Synonym
  • How to create Trigger
  • How to create View

 

Performance Tuning

  • Index creation
  • Partitioning
  • Hash Partition
  • Merge Partition
  • Round Robin Partition
  • Multi-Level Partition
  • Table Redistribution

 

Security & User Management

  • Creating Users
  • Creating Roles
  • Privileges
  • Authorization challenges
  • User Administration
  • Backup & Recovery
  • Collecting traces

 

Data Provisioning

  • SAP Data Services extraction
  • SAP SLT Replication
  • Smart Data Access
  • AP HANA-Direct Extractor Connection (DXC)

 

SAP Data Services Overview

  • What is SAP Data Services
  • SAP Data Services Architecture
  • SAP Data Services objects (Job, Data Flow, Work Flow, Transformations)

 

SAP Data Services Extraction

  • Loading Data from SAP ECC to SAP HANA DB
  • Loading Data from SAP BW to SAP HANA DB
  • Loading Data from MSSQL Server DB to SAP HANA DB
  • Loading Data from Excel to SAP HANA DB
  • How to load data from HANA Information Models to MSSQL DB

 

SAP SLT Data provisioning overview

  • What is SAP SLT
  • SAP SLT License options
  • SAP SLT system sizing
  • SAP SLT system landscape preparation

 

SAP SLT Schema configuration

  • How to configure SLT Schema for SAP Source system
  • How to configure SLT Schema for Non-SAP Source system
  • No.of Data transfer Jobs configuration
  • How to improve Initial data loading
  • Tables configuration in SLT using Data Provisioning

 

SAP SLT Performance tuning technics

  • Monitoring Replication in SLT
  • Access Plan
  • Reading Types
  • Adding Entry in the table IUUC_PRECALC_OBJ
  • Adding Entry in the table IUUC_PERF_OPTION
  • MWBMON
  • How to do Partition in SLT
  • How to restrict the tables that are allowed for replication
  • HANA Supported Data Types
  • How to change the standard mapping

 

HANA Advanced Analytics

HANA Reporting BO Tools

    • How to Connect with IDT
    • How to create Universe using HANA Tables
    • How to create Webi Reports
    • Webi Functions
    • How to schedule Webi reports
    • How to assign the WebI reports to the End users

 

HANA Reporting with Crystal Reports 2013

  • Report Designer
  • Report creation wizard
  • Sections
  • Sorting and Grouping
  • Chart expert
  • Formulas
  • Sub reports

 

HANA Reporting with Crystal Reports for Enterprise

  • How to Connect HANA with Crystal Reports for Enterprise
  • How to create reports

 

HANA Reporting with SAP Dashboards

  • How to Connect HANA with Dashboards
  • How to create Dashboard Reports

 

HANA Reporting with SAP Lumira

  • How to Connect HANA with SAP Lumira
  • How to Explore HANA Data with Lumira
  • Publish Lumira report

 

HANA Reporting with SAP Design Studio

  • SAP Design Studio Overview
  • How to create reports

 

HANA Reporting with SAP Predictive Analysis

  • SAP Predictive Analysis Overview
  • How to Explore data with Predictive Analysis

 

BW 7.3 powered by HANA Overview

    • BW 7.3 powered by HANA Overview
    • BW7.30-HANA Optimized Info Cube
    • BW7.30-HANA Optimized Info DSO
    • Importing SAP BW7.30 Models into HANA Modeling environment
    • Publish Standalone HANA Models into SAP BW 7.30 on HANA
    • BW on HANA Migration activities

 

SAP HANA as Secondary Database

  • Architectural Concept

 

SAP HANA End to End Mock Implementation Project

  • How configure SAP 150 ECC tables using SLT Replication
  • How to configure Data loads using SAP Data Services from Oracle DB
  • How Create HANA Information models based on Business Requirement
  • Creating HANA Models using Combination of multiple Sources
  • How to generate SAP BO reports and Assign to End User
  • Creating 3 HANA Implementation projects Proof of Concepts
  • Guidance to Create HANA models Architecture for Implementation project

 

SAP HANA Certification Guidance

  • SAP HANA Exam Code C_HANAIMP141
  • HA100 and HA300 Documents can be provide for certification preparation purpose.
  • SAP HANA Exam Dumps can be provided, to clear certification exam.

SAP BASIS Training USA

SAP BASIS Training USA

SAP BASIS Online Training COURSE CONTENT

ERP

Introduction to ERP
ERP Comparison

Architecture

R/3 Architecture
R/2 Architecture
Architecture comparison
SAP Instance
Work process Services

SAP Landscape

Multi system Landscape
3 System Landscape
2 System Landscape
1 System Landscape

Implementation Phases

Project preparation
Blue print
Realization
Testing
Go live and support

Installation (Windows)

Pre Installation activities
Installation
Post Installation
Installation of SAP ECC with EHP5 on Oracle 10G
Starting and stopping of SAP System

SAP Licensing

Overview of applying SAP license from SAP AG
Install / Edit /Delete / License

SAP Directories
User Administration

User master records
User creation, deletion, lock, unlock, copy
Mass user creation / deletion

Client Administration

Local client copy
Remote client copy
Client export / import

SAP securities

Roles
Profiles
Authorizations
Single sign on

TMS (Transport Management System)

Landscape design
Transport domain
Transport group
Transport routes
Transport layers
Transporting at OS level and SAP level

CCMS (Computing Central Management System)

Health check
Profile parameters
Operation modes
Background Jobs
Standard Jobs

Spool Administration

Local printing
Remote Printing
Access method
Temp Se Administration

Patch Management

Knowledge about OSS (Online Support Services)
Adding patches and plug ins
Kernel patches

Database Administration

Oracle database administration

SAPDBA

Table space administration
Starting and stopping instances
Reorganization
Exporting database
Database backup
Restoring database backup
Archive logs
Database file system

Advanced topics

Live demonstration of SAP market place
Solution Manager Maintenance optimizer
Solution Manager Early watch alerts
System copy
Knowledge of DB refresh
Knowledge of upgrades

SAP BASIS Training UK

SAP BASIS Training UK

SAP BASIS Online Training COURSE CONTENT

ERP
  • Introduction to ERP
  • ERP Comparison
Architecture
  • R/3 Architecture
  • R/2 Architecture
  • Architecture comparison
  • SAP Instance
  • Work process Services
SAP Landscape
  • Multi system Landscape
  • 3 System Landscape
  • 2 System Landscape
  • 1 System Landscape
Implementation Phases
  • Project preparation
  • Blue print
  • Realization
  • Testing
  • Go live and support
Installation (Windows)
  • Pre Installation activities
  • Installation
  • Post Installation
  • Installation of SAP ECC with EHP5 on Oracle 10G
  • Starting and stopping of SAP System
SAP Licensing
  • Overview of applying SAP license from SAP AG
  • Install / Edit /Delete / License
SAP Directories
User Administration
  • User master records
  • User creation, deletion, lock, unlock, copy
  • Mass user creation / deletion
Client Administration
  • Local client copy
  • Remote client copy
  • Client export / import
SAP securities
  • Roles
  • Profiles
  • Authorizations
  • Single sign on
TMS (Transport Management System)
  • Landscape design
  • Transport domain
  • Transport group
  • Transport routes
  • Transport layers
  • Transporting at OS level and SAP level
CCMS (Computing Central Management System)
  • Health check
  • Profile parameters
  • Operation modes
  • Background Jobs
  • Standard Jobs
Spool Administration
  • Local printing
  • Remote Printing
  • Access method
  • Temp Se Administration
Patch Management
  • Knowledge about OSS (Online Support Services)
  • Adding patches and plug ins
  • Kernel patches
Database Administration
  • Oracle database administration
SAPDBA
  • Table space administration
  • Starting and stopping instances
  • Reorganization
  • Exporting database
  • Database backup
  • Restoring database backup
  • Archive logs
  • Database file system
Advanced topics
  • Live demonstration of SAP market place
  • Solution Manager Maintenance optimizer
  • Solution Manager Early watch alerts
  • System copy
  • Knowledge of DB refresh
  • Knowledge of upgrades

SAP BASIS Training singapore

SAP BASIS Training singapore

SAP BASIS Online Training COURSE CONTENT

ERP
  • Introduction to ERP
  • ERP Comparison
Architecture
  • R/3 Architecture
  • R/2 Architecture
  • Architecture comparison
  • SAP Instance
  • Work process Services
SAP Landscape
  • Multi system Landscape
  • 3 System Landscape
  • 2 System Landscape
  • 1 System Landscape
Implementation Phases
  • Project preparation
  • Blue print
  • Realization
  • Testing
  • Go live and support
Installation (Windows)
  • Pre Installation activities
  • Installation
  • Post Installation
  • Installation of SAP ECC with EHP5 on Oracle 10G
  • Starting and stopping of SAP System
SAP Licensing
  • Overview of applying SAP license from SAP AG
  • Install / Edit /Delete / License
SAP Directories
User Administration
  • User master records
  • User creation, deletion, lock, unlock, copy
  • Mass user creation / deletion
Client Administration
  • Local client copy
  • Remote client copy
  • Client export / import
SAP securities
  • Roles
  • Profiles
  • Authorizations
  • Single sign on
TMS (Transport Management System)
  • Landscape design
  • Transport domain
  • Transport group
  • Transport routes
  • Transport layers
  • Transporting at OS level and SAP level
CCMS (Computing Central Management System)
  • Health check
  • Profile parameters
  • Operation modes
  • Background Jobs
  • Standard Jobs
Spool Administration
  • Local printing
  • Remote Printing
  • Access method
  • Temp Se Administration
Patch Management
  • Knowledge about OSS (Online Support Services)
  • Adding patches and plug ins
  • Kernel patches
Database Administration
  • Oracle database administration
SAPDBA
  • Table space administration
  • Starting and stopping instances
  • Reorganization
  • Exporting database
  • Database backup
  • Restoring database backup
  • Archive logs
  • Database file system
Advanced topics
  • Live demonstration of SAP market place
  • Solution Manager Maintenance optimizer
  • Solution Manager Early watch alerts
  • System copy
  • Knowledge of DB refresh
  • Knowledge of upgrades

SAP BASIS Training Australia

SAP BASIS Training Australia

SAP BASIS Online Training COURSE CONTENT

ERP
  • Introduction to ERP
  • ERP Comparison
Architecture
  • R/3 Architecture
  • R/2 Architecture
  • Architecture comparison
  • SAP Instance
  • Work process Services
SAP Landscape
  • Multi system Landscape
  • 3 System Landscape
  • 2 System Landscape
  • 1 System Landscape
Implementation Phases
  • Project preparation
  • Blue print
  • Realization
  • Testing
  • Go live and support
Installation (Windows)
  • Pre Installation activities
  • Installation
  • Post Installation
  • Installation of SAP ECC with EHP5 on Oracle 10G
  • Starting and stopping of SAP System
SAP Licensing
  • Overview of applying SAP license from SAP AG
  • Install / Edit /Delete / License
SAP Directories
User Administration
  • User master records
  • User creation, deletion, lock, unlock, copy
  • Mass user creation / deletion
Client Administration
  • Local client copy
  • Remote client copy
  • Client export / import
SAP securities
  • Roles
  • Profiles
  • Authorizations
  • Single sign on
TMS (Transport Management System)
  • Landscape design
  • Transport domain
  • Transport group
  • Transport routes
  • Transport layers
  • Transporting at OS level and SAP level
CCMS (Computing Central Management System)
  • Health check
  • Profile parameters
  • Operation modes
  • Background Jobs
  • Standard Jobs
Spool Administration
  • Local printing
  • Remote Printing
  • Access method
  • Temp Se Administration
Patch Management
  • Knowledge about OSS (Online Support Services)
  • Adding patches and plug ins
  • Kernel patches
Database Administration
  • Oracle database administration
SAPDBA
  • Table space administration
  • Starting and stopping instances
  • Reorganization
  • Exporting database
  • Database backup
  • Restoring database backup
  • Archive logs
  • Database file system
Advanced topics
  • Live demonstration of SAP market place
  • Solution Manager Maintenance optimizer
  • Solution Manager Early watch alerts
  • System copy
  • Knowledge of DB refresh
  • Knowledge of upgrades

SAP Administrator Training Australia

SAP Administrator Training Australia COURSE CONTENT

ERP
  • Introduction to ERP
  • ERP Comparison
Architecture
  • R/3 Architecture
  • R/2 Architecture
  • Architecture comparison
  • SAP Instance
  • Work process Services
SAP Landscape
  • Multi system Landscape
  • 3 System Landscape
  • 2 System Landscape
  • 1 System Landscape
Implementation Phases
  • Project preparation
  • Blue print
  • Realization
  • Testing
  • Go live and support
Installation (Windows)
  • Pre Installation activities
  • Installation
  • Post Installation
  • Installation of SAP ECC with EHP5 on Oracle 10G
  • Starting and stopping of SAP System
SAP Licensing
  • Overview of applying SAP license from SAP AG
  • Install / Edit /Delete / License
SAP Directories
User Administration
  • User master records
  • User creation, deletion, lock, unlock, copy
  • Mass user creation / deletion
Client Administration
  • Local client copy
  • Remote client copy
  • Client export / import
SAP securities
  • Roles
  • Profiles
  • Authorizations
  • Single sign on
TMS (Transport Management System)
  • Landscape design
  • Transport domain
  • Transport group
  • Transport routes
  • Transport layers
  • Transporting at OS level and SAP level
CCMS (Computing Central Management System)
  • Health check
  • Profile parameters
  • Operation modes
  • Background Jobs
  • Standard Jobs
Spool Administration
  • Local printing
  • Remote Printing
  • Access method
  • Temp Se Administration
Patch Management
  • Knowledge about OSS (Online Support Services)
  • Adding patches and plug ins
  • Kernel patches
Database Administration
  • Oracle database administration
SAPDBA
  • Table space administration
  • Starting and stopping instances
  • Reorganization
  • Exporting database
  • Database backup
  • Restoring database backup
  • Archive logs
  • Database file system
Advanced topics
  • Live demonstration of SAP market place
  • Solution Manager Maintenance optimizer
  • Solution Manager Early watch alerts
  • System copy
  • Knowledge of DB refresh
  • Knowledge of upgrades

SAP Administrator Training Singapore

SAP Administrator Training Singapore COURSE CONTENT

ERP
  • Introduction to ERP
  • ERP Comparison
Architecture
  • R/3 Architecture
  • R/2 Architecture
  • Architecture comparison
  • SAP Instance
  • Work process Services
SAP Landscape
  • Multi system Landscape
  • 3 System Landscape
  • 2 System Landscape
  • 1 System Landscape
Implementation Phases
  • Project preparation
  • Blue print
  • Realization
  • Testing
  • Go live and support
Installation (Windows)
  • Pre Installation activities
  • Installation
  • Post Installation
  • Installation of SAP ECC with EHP5 on Oracle 10G
  • Starting and stopping of SAP System
SAP Licensing
  • Overview of applying SAP license from SAP AG
  • Install / Edit /Delete / License
SAP Directories
User Administration
  • User master records
  • User creation, deletion, lock, unlock, copy
  • Mass user creation / deletion
Client Administration
  • Local client copy
  • Remote client copy
  • Client export / import
SAP securities
  • Roles
  • Profiles
  • Authorizations
  • Single sign on
TMS (Transport Management System)
  • Landscape design
  • Transport domain
  • Transport group
  • Transport routes
  • Transport layers
  • Transporting at OS level and SAP level
CCMS (Computing Central Management System)
  • Health check
  • Profile parameters
  • Operation modes
  • Background Jobs
  • Standard Jobs
Spool Administration
  • Local printing
  • Remote Printing
  • Access method
  • Temp Se Administration
Patch Management
  • Knowledge about OSS (Online Support Services)
  • Adding patches and plug ins
  • Kernel patches
Database Administration
  • Oracle database administration
SAPDBA
  • Table space administration
  • Starting and stopping instances
  • Reorganization
  • Exporting database
  • Database backup
  • Restoring database backup
  • Archive logs
  • Database file system
Advanced topics
  • Live demonstration of SAP market place
  • Solution Manager Maintenance optimizer
  • Solution Manager Early watch alerts
  • System copy
  • Knowledge of DB refresh
  • Knowledge of upgrades

SAP Administrator Training UK

SAP Administrator Training UK COURSE CONTENT

ERP
  • Introduction to ERP
  • ERP Comparison
Architecture
  • R/3 Architecture
  • R/2 Architecture
  • Architecture comparison
  • SAP Instance
  • Work process Services
SAP Landscape
  • Multi system Landscape
  • 3 System Landscape
  • 2 System Landscape
  • 1 System Landscape
Implementation Phases
  • Project preparation
  • Blue print
  • Realization
  • Testing
  • Go live and support
Installation (Windows)
  • Pre Installation activities
  • Installation
  • Post Installation
  • Installation of SAP ECC with EHP5 on Oracle 10G
  • Starting and stopping of SAP System
SAP Licensing
  • Overview of applying SAP license from SAP AG
  • Install / Edit /Delete / License
SAP Directories
User Administration
  • User master records
  • User creation, deletion, lock, unlock, copy
  • Mass user creation / deletion
Client Administration
  • Local client copy
  • Remote client copy
  • Client export / import
SAP securities
  • Roles
  • Profiles
  • Authorizations
  • Single sign on
TMS (Transport Management System)
  • Landscape design
  • Transport domain
  • Transport group
  • Transport routes
  • Transport layers
  • Transporting at OS level and SAP level
CCMS (Computing Central Management System)
  • Health check
  • Profile parameters
  • Operation modes
  • Background Jobs
  • Standard Jobs
Spool Administration
  • Local printing
  • Remote Printing
  • Access method
  • Temp Se Administration
Patch Management
  • Knowledge about OSS (Online Support Services)
  • Adding patches and plug ins
  • Kernel patches
Database Administration
  • Oracle database administration
SAPDBA
  • Table space administration
  • Starting and stopping instances
  • Reorganization
  • Exporting database
  • Database backup
  • Restoring database backup
  • Archive logs
  • Database file system
Advanced topics
  • Live demonstration of SAP market place
  • Solution Manager Maintenance optimizer
  • Solution Manager Early watch alerts
  • System copy
  • Knowledge of DB refresh
  • Knowledge of upgrades
Top ↑