Course Content : SAP HANA Unit 1- Introduction
1.1 Overview Of SAP HANA 1.0 1.2 Components
1.3 Hardware Vendors Unit 2- Architecture
2.1 Appliance Architecture Overview 2.2 Database Engine View
2.3 Dat-Loading View 2.4 Dat- Modeling View 2.5 Reporting View 2.6 Administration View 2.7 Persistence Layer Unit 3- SAP HANA Setup 3.1 System Landscaping 3.2 Sizing Guidelines Unit 4- Data Provisioning 4.1 Via Data services 4.2 Via Sybase replicator
4.3 SLT Repllication Transformation 4.4 DXC
Unit 5- SAP HANA Studio Introduction 5.1 Administration Console
5.2 Information Modeler 5.3 Life Cycle Management Unit 6- SAP HANA Modeling 6.1 Attribute View
6.2 Analytic View 6.3 Calculation View 6.4 Export & Import 6.5 Other functions Unit 7- Reporting
7.1 Client Connectivity options 7.2 SAP BO BI 4.0
7.3 MS-Excel
7.4 SAP BO Analysis 7.5 SAP BO Explorer
7.6 Semantic Layer (Universe)
7.7 SAP Crystal Reports (Enterprise,Dashboards & WebI) 7.8 SAP Crystal Reports 2011
Unit 8- User Management & Backup 8.1 Managing Users & Roles
8.2 BI/BO 4.0 Integration & SSO 8.3 Security & Authorization 8.4 Backup & Recovery
Unit 9- Other Topics 9.1 SAP BW on HANA
9.2 Role of Solution Manager in SAP HANA 9.3 COPA Business case
9.4 Rapid Deployment Solution
9.5 IMDB Client Installation overview 9.6 Appliance Enterprise Server 9.7 Scale Up/Out Configuration
9.8 Distributed system Landscape & handling 9.9 Port numbers-Distributed transaction handling 9.10 MVCC
---
SAP HANA MODELLING & IMPLEMENTATION
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
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 tables
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
SAP HANA training course content and Syllabus in
Bangalore
SAP HANA Introduction and Architecture
SAP HANA Overview
SAP In-Memory Computing Overview
SAP HANA Features
Look and feel of SAP HANA
SAP HANA Architecture
SAP HANA Landscape
Structure of SAP in-memory Computing studio
Multi Version Currency Control ( MVCC )
Persistence Layer in In-memory Computing Engine
Back up &Recovery
High-Availability
Distributed System
Data Provisioning options in SAP HANA
Reporting options on SAP HANA
Security options in HANA
SAP HANA Appliance Model
How SAP HANA Appliance is delivered
Sizing Considerations
SAP HANA - Licensing Options
SAP HANA Project Implementation
Overview: Key Activities
Key Roles
Key Points to keep in mind
Administration
Basic Modeling
Modeling Overview
Terminology
SAP HANA Studio Features
Information Modeler Overview
Installation and Configuration of HANA Studio
Prerequisites for Modeling
Modeling Considerations
Levels of Modeling
Attribute Views
Analytic Views
Modeling Considerations
Joins: Different types and when to use what.
Where Class Vs Constraint Filters
HANA Studio Preview(use with Caution)
Impact of Query Execution
Demo
Modeling Suggestions
Troubleshooting Modeling Issues
Export and Import Models
Reporting on HANA with BI 4.0
HANA Reporting Layer & Connectivity Options
Reporting on HANA Clients
Reporting on HANA Open Interfaces
IMDB client installation
Setting up new connection
SAP Business Objects BI4.0:Overview & tool comparison
Analytical Reporting on HANA
Relational Reporting on HANA
Reporting on HANA Demo Included
Native Excel Interface via ODBO
SAP Business Object Analysis(Office Edition)
SAP Business Object Explorer
Semantic Layer Approach
IDT Vs Universe Designer
SAP BOBJ Web I
SAP BOBJ Xcelsius
SAP Crystal Reports
Enterprise Vs 2011
Front end tool reporting considerations on top of HANA
Troubleshooting common reporting issues
Advanced Data Modeling with SQL Script
Modeling Overview
Calculation View :Overview & Types
SQL Script :Motivation
SQL Script: Overview
SQL Script Processing
Data Type Extensions
Scalar Data type
Table type
Functional Extension
Concept
Procedure
Procedure Calls
Implementing Functional logic
Operators
SQL Script/Built in Function
Debugging and troubleshooting SQL Script
Restrictions for SQL Statement
Data Provisioning: Data Services
Data Provisioning :Overview
Data Provision Options
Trigger Based Replication
ETL-Based Replication
Log-Based Replication
ODP enabled Extractor Support in Data Services 4.0
HANA and Data Service Process flow for SAP and non-SAP data
How it works for SAP System
How it works for Non-SAP System
Advanced Data Service options
Column tables creation
Bulk loader options & config
Bulk extracting options & config
Log based replication overview
Technical system landscape
User administration
Authorization
Installing log based replication
Updating the SAP host agent on source system
Installing Sybase components
Deploying the SAP HANA load controller and related components
Configuring log based replication
Configure SAP HANA load controller on SAP HANA system
Initializing replication using SAP HANA system
Initializing replication using SAP HANA load controller
SAP HANA 6: DATA PROVISIONING: SAP LANDSCAPE
TRANSFORMATION (SLT)
Data provisioning overview
SAP landscape transformation set-up
Options for SLT landscape installation
Post installation stem
Concept of SLT replication
Architecture and key building block
Technical requirement and system set-up information for LT replication server
Key benefits of LT replicating server
Transformational capabilities
Operations
Security and user management in HANA
Creation of users
Creation of roles
Assignment privileges to roles
Assignment of users to roles
SAP HANA Contents
1. SAP HANA Overview & Roadmap (What is SAP HANA?)
1.1. SAP HANA in a Nutshell
1.1.1. Evolution of In Memory computing at SAP
1.1.2. History HANA
1.1.2.2. 2005 Genesis
1.2. Business Impact of new architecture
1.2.1. Not about IT, its about running a real--‐time business
1.2.2. Increasing data volumes
1.2.3. Increasing number of users (mobile)
1.2.4. Need for Flexibility
1.2.4.1. Business needs driving changes in existing systems
1.2.4.1.1. Ad--‐hoc addition of new requirements
1.2.5. Operational Non--‐Disruption with a Disruptive Innovation
1.2.6. ―Impedance Mismatch‖
1.2.6.1. Load performance
1.2.6.2. Query Performance
1.3. In Memory Computing Basics
1.3.1. Faster, Better, Cheaper
1.3.1.1. Risk & Maturity of disk vs memory dbms
1.3.1.2. Platform for the future
1.3.1.3. iPod example
1.3.1.4. Moore‘s law
1.3.1.5. What happens when the power goes out?
1.3.2. Cost x GB x Second calculation
1.3.3. Row Store, Column Store, Persistency Layer, Architectural Concept
1.4. SAP HANA Architecture Overview
1.4.1. Engines
1.4.2. Tools
1.4.3. Data Provisioning
1.4.4. Data Modeling
1.5. SAP HANA 1.0 Use Cases
1.5.1. Agile Data Mart
1.5.1.1. HANA in Action stories
1.5.2. ERP Turbo Charging
1.5.2.1. Accelerators
1.5.3. BW on HANA
1.5.4. Application Platform (Apps powered by HANA)
1.5.4.1. SAP Built apps
1.5.4.2. Partner built apps
1.5.4.3. Custom apps (JAVA/ABAP/ETC)
1.6. SAP HANA Roadmap
1.6.1. HANA today
1.6.2. HANA 2.0 (Suite)
2. SAP HANA Architecture
2.1. Introduction
2.2. General Architecture Overview
2.3. Hybrid Row & Column store engine
2.3.1. Describe Row store
2.3.2. Describe Column store
2.3.3.1. Many scenarios need both transactional/metadata and it needs to be calculated/aggregated.
2.4. Compression
2.4.1. Optimized for fast access to data
2.4.2. Partial indexing
2.5. Partitioning (memory allocation)
2.6. Delta updates
2.7. Insert Only
2.7.1. Time Traveling
2.8. MDX Engine
2.9. Calculation Engine
2.10. Business Content/Semantic Functions
2.10.1. Business Function Library
2.10.1.1. Currency Conversion
2.10.1.2. Consumable pre--‐built functions
2.10.2. Predictive Function Libraries
2.11. HANA Studio 2.12. Client Connectivity 2.12.1. Interfaces (ODBC, JDBC, SQL, MDX) 2.13. High Availability 2.13.1. Persistency 2.13.2. Disaster Tolerance 2.14. Multi--‐tenancy 2.15. HANA Cloud
3. SAP HANA Business Cases & ROI Model
3.1. Introduction
3.1.1. Leverage multiple scenarios, not just one specific use case
3.1.2. Focus on things you CAN‘T do today
3.1.3. Involve the business up front and along the way, not a typical IT business case
3.1.4. Think big, start small with a quick win to build momentum in business
3.1.4.1. Users will generate many new possibilities once they see something tangible
3.2. Identify Business Scenario
3.2.1. Value Discovery Workshops
3.2.2. Operational
3.2.3. Strategic
3.2.4. Transactional
3.2.5. Analytic
3.3. Building a business case for SAP HANA
3.3.1. The real tools come into play after the real--‐time business scenario and app have been Identified
3.3.2. Map Value Drivers for scenario
3.3.3. Identify KPIS and map to value drivers
3.3.4. Describe Benchmarking Database
3.3.5. Map results of benchmarking to create reference model for scenario improvement
3.4. Build ROI Model
4.1. Application Introduction
4.1.1. How are these new apps made possible with HANA
4.2. SAP NetWeaver Business Warehouse on SAP HANA
4.3. SAP Trade Promotion Management
4.4. Sales and Operations Planning
4.5. Business Planning and Consolidation
4.6. Smart meter analytics
4.7. Predictive Text
4.8. Dynamic cash management
4.9. SAP BusinessObjects Sales Analysis for Retail powered by SAP HANA
4.10. Profitability analysis accelerator for SAP ERP (CO--‐PA)
4.11. SAP Finance and Controlling Accelerator.
4.12. SAP Sales Pipeline Analysis powered by SAP HANA
5. Accelerated SAP Business Suite
5.1. Overview
5.1.1. Philosophy
5.1.1.1. Single Applications
5.1.1.2. Whole Suite
5.1.2. Side car architecture
5.1.3. Table replication
5.1.4. Two options
5.1.5. Write--‐back scenario
5.2. Current Offering
5.3. Roadmap
6. SAP BW on SAP HANA
6.1. Introduction
6.1.1. Why BW on HANA is so freaking cool
6.1.2. 7.30 background
6.2. SAP HANA--‐specific enhancements
6.2.1. Cubes
6.2.2. DSO
6.2.3. Data Loading
6.2.4. Integrated Planning
6.2.5. Agile Data Modeling
6.2.6. Columnar compression
6.2.7. Landscape Simplification/Lower TCO.
6.3. Implementation
6.3.1. Things to consider
6.3.1.1. Clean up and migrate
6.3.1.2. Migrate as--‐is
6.3.2. Big Bang
6.3.3. Incremental/Parallel
6.3.4. Prerequisites & Limitations
6.3.5. Scoping/Sizing
6.3.5.1. Source database (size & vendor)
6.3.6. Link to outside info or OSS NOTE
6.3.7. Link to Sizing calculator
6.3.8. Landscape Options
6.3.8.1. Things to consider
6.3.8.2. Single--‐node (2--‐tier) (dev/prod) 6.3.8.3. Multi--‐node (3--‐tier) (dev/qa/prod
6.3.8.3.1. Start with copy of productive system
6.3.8.4. Set up Greenfield position
6.3.9. Near Line Storage w/IQ
6.3.9.1. Hot vs cold data concept
6.3.10. Connect one ERP to 2 BW systems
6.3.10.1. Post copy automation (PCA)
6.4. Database Migration
6.4.1. SAPINST tools for DB export
6.4.2. Exports flat files to temp storage
6.4.3. SAPINST tools for DB import
6.4.4. Import flat files from temp storage to HANA
6.4.5. Unicode conversion is possible as part of process
6.4.6. Key Problems: Production downtime
6.4.7. Performance details (query, data load to info cubes, DSO, remodeling)
6.4.8. Query Performance
6.4.8.1. Simple/Standard
6.4.8.2. Complex/Custom
6.4.8.2.1. Power user granular detail, millions of rows
6.4.9. DSO activation
6.4.10. Data Loading
6.4.10.1. Extract from ERP system activate and load into Cube
6.4.10.2. Large flat file (POS) import into BW (smart meter demo) 6.4.11. Remodeling
6.5. Administration & Operations
6.6. Future Roadmap
7. Data Provisioning with SAP HANA
7.1. Introduction to Data Sources
7.1.1. SAP, non--‐SAP (custom apps or 3rd party apps)
7.1.2. Replication approaches
7.1.2.1. Real time, batch.
7.2. Provisioning & Replication Scenarios
7.2.1. How do you extract data from source system and get it into HANA?
7.2.1.1. What tools are available?
7.2.1.1.1. DS, SLT, DEC,
7.2.1.1.2. When to use which tool
7.2.1.1.3. Semantics and differences
7.2.1.2. What are the steps?
7.2.1.3. Real time or Batch?
7.2.2. SAP real time
7.2.3. SAP batch
7.2.5. Non--‐SAP batch
7.3. Event Streaming
7.3.1. Sybase ESP to HANA
7.3.2. Event Insight to HANA
7.4. BOBJ Data Services
7.4.1. Supportability Matrix for source system
7.4.2. Complex data scenarios with transformations
7.4.3. Batch ETL tool for non--‐SAP
7.4.4. Not real time
7.4.5. ODBC connection
7.5. SAP Landscape Transformation (SLT)
7.5.1. Process overview
7.5.2. SLT Plug In listings (supportability matrix)
7.5.3. Real time for SAP and non--‐SAP
7.5.4. Trigger Based
7.5.5. Fully integrated with HANA studio (screenshot)
7.5.6. Transformation capabilities via R in ABAP
7.6. Direct Extractor Connection (DEC)
7.6.1. NO ETL
7.6.2. Native BW extraction capability to connect to HANA
7.6.3. ICM Framework
8. Data Modeling with SAP HANA
8.1. Key Concepts in Data Modeling for HANA
8.1.1. Components of HANA data model
8.1.1.1. Views 8.1.1.1.1. Analytical Views 8.1.1.1.2. Calculation Views 8.1.1.1.3. Attribute Views 8.1.1.2. Tables 8.1.1.3. Measures 8.1.1.4. Filters 8.1.1.5. Dimensions 8.1.2. Common Scenarios 8.1.2.1. Calculations 8.1.2.2. Filtering 8.1.2.3. Aggregations
8.2. SAP HANA Modeling Environment
8.3. SAP HANA Information Composer
8.4. SQL Scripting
9. Application Development & Data Consumption with SAP HANA
9.1. App Development Basic Concepts
9.1.1. Re--‐thinking assumptions used for app logic
9.1.1.1. Living in a world without constraints/penalties
9.1.1.2. Assume super--‐computer capabilities for everything
9.1.1.3. The CRUD dilemma
9.1.3. Native development or extension
9.1.3.1. Zprograms
9.1.4. Data sources and pre--‐calculations
9.1.5. New assumptions about data capabilities
9.1.6. HANA artifacts
9.1.7. DBSL
9.1.8. Platform options
9.1.8.1. ABAP, NGAP, etc
9.2. ABAP Apps 9.3. JAVA Apps 9.4. Analytic Apps 9.4.1. Explorer 9.4.2. Dashboards (excelcius) 9.4.3. Microsoft Excel 9.4.4. Crystal Reports 9.4.5. Webi 9.4.6. BOBJ SDK 9.5. Mobile Apps
9.6. Full Text search and text analysis
9.7. Partner Apps
9.8. (Predictive) R & L scripting languages
10. SAP HANA Administration, Operations & Security
10.1. SAP HANA Admin Console
10.1.1. Walk thru of views in HANA Studio
10.1.1.1. Different sections
10.1.1.2. Common Admin & Operations Tasks
10.1.1.2.1. Backup Restore 10.1.1.2.2. Monitoring 10.1.1.2.3. Memory allocation 10.1.1.2.4. User Management 10.1.1.2.5. License Key 10.1.1.2.6. Alerting Infrastructure 10.1.1.2.7. Statistics Server 10.1.1.2.8. Performance Tuning 10.2. DBA Cockpit 10.2.1. Backup Scheduling
10.2.2. Solution Manager 7.1 SP4 Integration
10.3. Integration and Monitoring Infrastructure
10.3.1. CCMS alerts
10.3.2. Maintenance Optimization
10.4. Data Archiving
10.4.1. Outside of HANA
10.4.2. Integration with Tivoli, etc.
10.5. Security
10.6. Lifecycle Management
10.6.1.1. Content LCM
10.6.1.2. Software LCM
11. SAP HANA Hardware
11.1. Overview of General Hardware Requirements
11.1.1. Intel E7 processors
11.1.1.1. Intel HANA story
11.1.2. SUSE Linux 11 sp1
11.1.3. SSD or Disk backup
11.1.4. T--‐Shirt Sizing
11.1.5. Validated by SAP
11.1.6. Additional Infrastructure
11.2. Scale Out/Multi--‐node options
11.3. Official HANA PAM
11.4. Listing and descriptions of all Certified SAP HANA Hardware by Vendor
11.4.1. Overview of HANA solutions provided
11.4.1.1. What‘s the unique value prop?
11.4.1.2. Product family
11.4.1.3. T--‐Shirt sizes offered
11.4.1.4. Scale--‐out offering
11.4.1.5. High Availability
11.4.1.6. Support infrastructure (SAN, etc)
11.4.1.7. Additional software needed
11.4.1.8. Support Services
11.4.2. Additional HANA services
11.4.2.1. Implementation, etc
11.4.3. Customer success stories (short)
11.4.4. Contact information for inquiries
12. SAP HANA Projects & Implementation
12.1. Different Use cases (BW vs other use cases)
12.2. Project Scoping and Documentation
12.3. Timelines and Key Activities
12.4. Project Team Members (Skillsets/activities)
12.5. Examples of stellar projects
12.6. SAP RDS packages
12.7. ―Top Ten‖ Advice for HANA Projects
13. SAP HANA Resources
13.1. Experience HANA site
13.2. Key Resources for Sample Projects
13.3. SAP Support Organization
13.4. Training and skills resources
13.5. SDN
13.6. Benchmarking database