Online Tutorials & Training Materials | STechies.com
Register Login
SAP Institute in Hyderabad
Add Institute / Course


Ripplesinfo, Hyderabad

Ripplesinfo

Ripplesinfo, Hyderabad

Door No. 7-1-619/A/33, Gayathri Nagar, Behind Huda Maitrivanam, Ameerpet, Hyderabad, Telangana 500038 Hyderabad
Andhra Pradesh India(IN)500038

500038
: 087901 36839 ,+91-9177665392
: Institute

Write a Review Claim Your Ownership

INFO

Ripples Info serves its clients in complex technology, enterprise systems integration and business process outsourcing. Enabling clients to achieve high quality, cost effective outcomes through highly experienced associates in a multi-shore delivery model, Ripples Info provides solutions across commercial and public sector enterprises in Human Resources, Retail & Supply Chain, Business Intelligence and Customer Relationship Management. Ripples is privately held and continues to grow rapidly as it has since the company's founding in 2003.

We also focus on strategic partnerships with Business Intelligence and IT providers, who share our commitment to quality, to ensure that we always provide a best in class BI service to our customers.

Ripples Info was built on the foundation of a clear vision and the firm's history is a story of exponential growth with clients at the forefront. Our Executive Team is focused on client service, excellence and innovation, bringing our clients thought leadership and expertise gained through their roles across some of the world's largest services firms and through collaborating with large and mid-sized companies globally.

The expertise in strategic consulting, combined with products and practices, enables us to be an end-to-end IT solutions provider for meeting customer needs. Ripples Info pioneered the adoption of the flexible global business practices that today enable companies to operate more efficiently and produce more value.

Through a uniquely integrated consulting and solution delivery model, Ripples Info offers its clients the flexibility and scalability to support a broad scope of technologies, client needs and project requirements.

COURSES

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course Syllabus

SAP HANA INTRODUCTION

Information Explosion 
Consumerization of ‘IT’ 
‘IT’ cannot deliver 
Reality with SAP HANA 
SAP In-Memory Appliance 
SAP HANA proof Points 
New business reality and Challenges 
SAP Naming Update—SAP HANA 
Hardware Innovations 
Bottlenecks 
Understanding Columnar Data Storage 
When to use Column store 
When to user Row Store 
Avoid Bottlenecks 
--Data Transfer 
--Partitioning 
--Parallel Processing 

SAP HANA DATABASE PERFORMANCE REASONS

Classic EDW 
Current—SAP HANA 
Planned—SAP HANA 
SAP HANA Compared to BWA 
SAP HANA Database 
SAP HANA RDS 

SAP HANA SCENARIOS

Application serve ABAP based Scenarios 
HANA as secondary database 
HANA as primary database 
Datamarts with SAP HANA 
Applications on top of HANA 
SAP BW powered by HANA 
SAP HANA Cloud 

SAP HANA STUDIO

Look and Feel 
Different Perspectives 
Administration Console 
Modeler 
Application Development 
Catalog 
Content 
Security 

SAP HANA LICENSING

SAP HANA Versions 
SAP HANA Platform Edition 
SAP HANA Enterprise Edition 
SAP HANA Enterprise Extended Edition 

SAP HANA IMPLEMENT LANDSCAPE

HANA Database 
HANA Client 
HANA Studio 
Data sources 
Replication Technologies 
BO-Data services 
SLT Replication server 
DXC 
Sybase Replication server 
Admin workstation 
End-user Workstation 
SAP HANA Architecture 
SAP HANA Persistence layer 
SAP HANA Backup and recovery 

DATA PROVISIONING

Data Replication –Definition 
Data Replication Methods 

UPLOADING DATA FROM FLAT FILES

When to use Flat file upload Functionality 
How to load data from Flat file in Workstation 
How to load data from Flat File in server 
Using Information Composer 
Uploading Files 
Composing Views 

SAP BO-DATA SERVICES

Introduction to BODS 
Data services –One stop solution 
Data Integration ,Data Quality , Data Profiling, 
Metadata management and Text data analysis 
Working with BODS 
BODS server 
Repository 
Job server 
Management Console 
Data services Designer 
Creating Formats 
Creating Datastores 
Creating projects 
Creating batch jobs 
Scheduling and monitoring Batch jobs 
Creating Dataflows 
Creating Connection to HANA Db 

IMPLEMENTATION SCENARIOS

SCENARIO-1

Loading Data from Excel File to HANA Database table 
Loading Data from Flat File to HANA Database table 
Using Template tablesj

SCENARIO-2

Loading Data from Oracle Database to HANA Database

SCENARIO-3

Loading Data from SAP ECC to HANA Database with Dataflow

 

SCENARIO-4

Loading Data from SAP ECC to HANA Database With ABAP Datalow 

SCENARIO-5

Loading Data from SAP BW to SAP HANA Database

SCENARIO-6

Loading Metadata from SAP ECC to HANA Database

DATA PROVISIONING USING SLT

SAP Landscape Replication server for HANA 
Key benefits of SLT replication server 
Key benefits of Trigger-Based Approach 
Architecture for SAP source replication 
Architecture for Non-SAP source replication 
Configuration and monitoring Dashboard for HANA(LTR) 
Creating new Configuration for SAP Sources 
Creating New Configuration for Non-SAP sources 
Result of Creating new Configurations 
Launching Data provisioning UI in HANA studio 
Start Load/Replication 
Stop/Suspend replication 
Status Monitoring in HANA Studio 
SLT based transformation Concept 
Advanced replication settings 
Change of table structuring and partitioning 
Filtering and selective data replication 

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview 
DXC Concept 
Challenges 
DXC benefits 
Activation mechanism for handling Delta Processing 
Data source Extractor Concept 
SAP Business Content Data source Extractors 
SAP HANA DXC Connection setup and Configuration 
Activating Data sources in Source system 
Understanding the tables of IMDSO 
Creating info package and Scheduling data load 
Monitoring Data loads 
Comparisons with other data acquisition techniques 
DXC sidecar approach. 

SAP HANA MODELLING

General DWH concepts 
Importance of Data Modeling 
ER model 
Multi Dimensional Model 
Star Schema 
Implementing Data models in BW 
Implementing Data models in HANA 
Introduction to Modeler 
Levels of Modeling 
Attribute Views 
Time Dimension Attribute Views 
Derived Attribute Views 
Shared Attribute Views 
Calculated Columns 
Hidden Attributes 
Using Hierarchies 
Implementing Leveled Hierarchies 
Parent Child Hierarchies 
Applying Filters 
Analytic Views 
Multi Dimensional Model with Analytic views 
Calculated Measures 
Calculated Attributes 
Restricted Measure 
Concept Variables and Input parameters 
Calculation views 
Graphical Calculation views 
Using Union,Join,Projection,Aggregation 
Scripted Calculation views 
Approaching HANA modeling 
Choosing Views for the Information Model 
Connecting Tables 
Using Inner Join,Left outer Join , Right Outer Join, 
Full Outer Join ,Text Join ,Referential Join, Union 

SAP HANA SQL

Introduction 
SQL Elements 
Comment and Codepage 
Fuctions 
SQL Statements 
Create table,Alter,Drop 
Insert ,Update,Delete 
Select Statement 
SQL script and procedures 
Creating procedures 
Creating Table types 
Calling Procedures 
Using CE-Functions 
Control Statements 

USING CURRENCY CONVERSIONS

Understanding Currency Conversions in SAP HANA 
Applying Currency Conversions 
Full Text Search 
Fuzzy Search 

PROCESSING INFORMATION OBJECTS

Validate Models 
Compare Versions of Information objects 
Checking Model references 
Generate Auto Documentation 

MANAGING MODEL CONTENT

Manage Schemas 
Import & Export Models 
Developer Mode 
Delivery unit mode 
Support mode 
Translating Metadata Text 

SECURITY AND AUTHORIZATIONS

HANA privileges 
Creating users 
Creating Roles 
Assigning privileges and Roles to users 

REPORTING

SAP HANA Database Connectivity options 
Relational Connection with HANA Db 
OLAP Connection with HANA Db 

MICROSOFT EXCEL

Lumira (Visual Intelligence) 
SAP BO Analysis for Office 
Using IDT 
Creating Connection,Datafoundation,Business layer 
Creating Webi Documents 
Dashborads 
Crystal Reports for Enterprise 
Crystal Reports 2011 
Publishing HANA Models to SAP BW 
Creating BEx Reports 

ENQUIRY

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

PHOTOS
COMMENTS

    No Comments Posted

Other institutes in Hyderabad