SAP HANA Integrated Online Training

1
IT COURSESONLINE LIVE CLASSESWWW.IMAGINELIFE.IN

• SAP HANA INTEGRATED

• PH8499068708 8341832707

• EMAILSUPORT_at_IMAGINELIFE.IN

2
SAP HANA INTIGRATED Information
explosion Consumerization of IT
IT cannot deliver
Reality which SAP HANA Sap
in-,Memory APPLIANCE HANA Proof
points Sap naming update-sap HANA
Hardware innovations
Bottlenecks Understanding columner
data storage When to use column store
When to user Row store Avoid
Bottlenecks --Data transfer
3

• --partitioning
• --parallel processing
• SAP HANA Datadase 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 which SAP HANA
• Applications on top of HANA
• SAP BW powered by HANA
• SAP HANA cloud

4
Sap HANA STUDIO Look and Feel
Different perspectives Administration
console Modeler Application
Development Catalog Security SAP HANA
Licensing SAP HANA Versions SAP
HANA platform Edition SAP HANA
Enterprice Edition SAP HANA Enterprice
Extended Edition
5
SAP HANA Implement landscape HANA
Database HANA client HANA
stoudio 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
6
DATA PROVISIONING Data Replicition-Definit
ion Data Repliction methods Uploding 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 Uploding files
Composing views
7
SAP BO-Data services Introduction to BODS
Data services one stop soluction 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
8
Implementation scenarios Scenario-1
Loading Data from excel file to
HANA Database table Loading Data from
Flat File to HANA Data base
table using Template tables scenario-2 lo
ading Data from Oracle Database to HANA
Database scenario-3 Loading Data from SAP ECC
to HANA Database scenario-4
Loading Data from SAP ECC To
HANA Database With ABAP Datalow
9
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 SAO source replication
Configuration and monitoring Dashboard for
HANA(LTR) Creating new configuration for
SAP Sources Creating New Configuraton for
Non-SAP sources
10
Creating New Configuraton for Non-SAP
sources Result of creating new
configurations Launching Data Provisioning
UI in HANA studio Start load/Replication
Stop/suspend replication Stats
monitoring in HAPA Studio SLT based
transformation concept Advanced
replication settings Change of table
structuring and partitioning Filtering
and selecting data replication Data Provisioning
using SAP Direct Extractor connection(DXC)
Overview DXC Concept
Challenges DXC benefits
11
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
Monitroring Data loads Comparing
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
12

• Attribute views
• TIME Dimension Attribute Views
• Derived Attribute Views
• Shared Attribute Views
• Calculated columns
• Hidden Attributes
• Using Hierarchies
• Implementing Leveled Hierarchies
• Analytic Views
• Parent child Hierarchies
• Applying Filters
• Multi Dimensional model with Analytic views
• Calculated Measures
• Calculated attributes
• Restricted Measure
• Concept Variables and input
  parameters

13
Calculation views Graphical
calculation views Using
Union,join, projection ,aggregation
Scripted calculation views
Approaching HANA modeling
Choosing Views for Modeling
Choosing views for the Information Model
Connecting Tables
Using Inner join,left outer join,Right Outer
join SAP HANA SQL
Introduction SQL Elements
Comments and codepage
Fuctions SQL Statements
Create table, Drop
Insert, Update, Delete Select
Statement Sql script and
procedures Creating procedures
Creating Table types
14
Using CE-Functions Control
Statements Using Currency
conversions Understanding Cuuency
conversions in SAO HANA Applying
currency conversions Full Text
Search Processing Information
Objects Validate Models
Compare Versions of Information Objects
Cheking model references
Generate Auto Documentation Manage
Model content Manage schemas
ImportExport models
Developer mode Delivery unit mode
Support mode Translating
Metadata
15
Security and Authorizations
HANA privileges Creating users
Assigning privileges and Roles to
Users Reporting SAP HANA Database
connectivity options Relational
connection which HANA DB OLEP
Connection which HANA Db Microsoft
Excel Lumira (visual intelligence)
SAP BO Analysis for pffice Using IDT
Creating connection,Datafoundation,
Business layer Creating Webi Documents
Dash borads Crystal reports for
Enterprise Crystal Reports for
Enterprise