Powered by Blogger.

Friday, 26 September 2014

SAP HANA (High-Performance Analytic Appliance) is another initiative from SAP for high performance realtime databse data processing. See the PDF Training materials. In SAP HANA data resides in RAM than the traditional physical disk storage. So the time taken to process data and all are extremly low. This technology is known as in-memory computing ( data reside in memory for computing ). Here I have collected some good HANA PDF training materials from their official website. It will take tome to go through all these documents. So you can bookmark or download the files to your system for your later reference.

PDF Tutorials

This 70 page training material covers about
  • How to start with SAP HANA
  • HANA Architecture
  • How to do the deployment, implemenation and operation etc
The training material intend for developers and it covers most of the topics that a SAP HANA developer should know. This PDF contains about 786 pages. Its absouletly a worth material for reference.
This 594 page material covers the details about SAP HANA administration. It contains about system and security administration, how start and stop Hana, backup and monitoring etc.
This 168 page document contains all about how to do the modeling and data analysis from HANA data.It covers everything from HANA architecture to managing object versions.

SAP HANA (High-Performance Analytic Appliance) is another initiative from SAP for high performance realtime databse data processing. See the PDF Training materials. In SAP HANA data resides in RAM than the traditional physical disk storage. So the time taken to process data and all are extremly low. This technology is known as in-memory computing ( data reside in memory for computing ). Here I have collected some good HANA PDF training materials from their official website. It will take tome to go through all these documents. So you can bookmark or download the files to your system for your later reference.

PDF Tutorials

  • SAP HANA master Guide in PDF
    This 70 page training material covers about
    • how to start with SAP HANA
    • HANA Architecture
    • How to do the deployment, implemenation and operation etc
  • HANA Developer Guide in PDF
    The training material intend for developers and it covers most of the topics that a SAP HANA developer should know. This PDF contains about 786 pages. Its absouletly a worth material for reference.
  • How to do HANA Administration Training in PDF
    This 594 page material covers the details about SAP HANA administration. It contains about system and security administration, how start and stop Hana, backup and monitoring etc.
  • Data Analysis in SAP HANA training material in PDF
    This 168 page document contains all about how to do the modeling and data analysis from HANA data.It covers everything from HANA architecture to managing object versions.
- See more at: http://sapbrainsonline.com/help/sap-hana-tutorial.html#sthash.EHD4NGNS.dpuf

Saturday, 20 September 2014

SAP HANA

HANA stands for high-performance analytic appliance. SAP HANA is an application that uses in-memory database technology that allows the processing of massive amounts of real-time data in a short time. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk. This allows the application to provide instantaneous results from customer transactions and data analyses.

SAP HANA is designed to process structured data from relational databases, both SAP and non-SAP, and applications and other systems rapidly. It is capable of using three styles of data replication depending on the source of the data - log-based, ETL-based and trigger-based. The relocated structured data is stored directly in memory. Because of this, data can be accessed quickly in real time by the applications that use HANA.
                                   
SAP HANA supports various use cases for real-time analytics. Few examples are:
  • Monitoring and optimization of telecommunications network
  • Supply chain and retail optimization
  • Fraud detection and security
  • Forecasting and profitability reporting
  • Energy use optimization and monitoring
SAP HANA is a data warehouse appliance for processing high volumes of operational and transactional data in real-time. HANA uses in-memory analytics, an approach that queries data stored in random access memory (RAM) instead of on hard disk or flash storage.

A HANA appliance uses an SAP Sybase replication server to copy and synchronize data from an SAP data warehouse or enterprise resource planning (ERP) application in real-time.  By running in parallel to the source SAP ERP application, HANA allows business users to query large volumes of data in real-time without having to wait for scheduled reports to run.

HANA supports industry standards such as structured query language (SQL) and multi-dimensional eXpressions (MDX).  It also includes a programming component that allows a company's IT department to create and run customized applications on top of HANA.  According to SAP, HANA has the ability to scan 500 billion point of sale (POS) records in seconds. SAP HANA was previously called SAP High-Performance Analytic Appliance.


What is SAP HANA
SAP HANA combines database, data processing, and application platform capabilities in-memory and the platform provides libraries for predictive, planning, text processing, spatial, and business analytics.

While eliminating data redundancy and latency, the new architecture enables converged OLTP and OLAP data processing within a single in-memory column-based data store with ACID compliance. SAP HANA has become the most suitable platform for building and deploying next-generation, realtime applications and analytics. It provides advanced capabilities, such as predictive text analytics, spatial processing, data virtualization, on the same architecture, besides simplifying application development and processing across big data sources and structures.

At its core, it is an innovative in-memory relational database management system that makes full sense of the capabilities of current hardware to increase application performance, to reduce cost of ownership, and to enable new scenarios and applications that were not possible before.

Components
  • SAP HANA is the introduction of SAP AG, in-memory database technology. There are five components in the Software Group
  • SAP HANA DB (or HANA DB) refers to the technology of the database
  • SAP HANA studio refers to a set of tools provided by SAP for modeling
  • SAP HANA Appliance relates to HANA DB supplied as a partner of certified equipment as a unit. It also includes tools for modeling of HANA studio, as well as replication tools and data conversion to move the data into the database HANA
  • SAP HANA Application Cloud refers to a cloud infrastructure for application delivery (usually existing SAP applications rewritten to run on HANA).
The SAP HANA Senior Consultant has the primary responsibility for the rollout of technical and functional aspects of the HANA solution.

Required Skills

 * Excellent verbal and written communication skills.
* Ability to interact with both business and technical stakeholders of client companies.
* Designing and implementing SAP HANA Solutions.
* Must be a team player as well as be able to work independently and manage development resources.
* Technical Architecture expertise: SAP HANA Data provisioning technology including SAP LT Replication Server, Data Services, Sybase replication server
* Technically proficient in Databases (DB2, Oracle, SQL server, MaxDB). Shoul have experience with SAP ECC table data model and analysis.


 Tasks

* Technical planning, installation, upgrade, Operating Systems DB migration and Unicode Conversion with technically proficient in Operating Systems (Unix/Windows/Linux)
* Plan for implementation including sizing, scoping, high availability and disaster recovery strategy.
* Data Management
* Design data models and analytical apps
* Definition, design and implementation of SAP SLT replication schemas in SAP HANA
* SAP HANA data modeling using Attribute View, Analytic View, and Calculation View o Experience with SAP HANA programming including SQL, SQL Script, and CEScript
* Reporting and handling complex scenarios using joins, ABAP and SQL. SAP HANA Data Administration including managing schemas, data model objects, import/export content.
* SAP reporting for different functional areas such as Finance, Supply Chain, and Sales o Experience handling integration between multiple systems for reporting – SAP ECC, SAP BW, BOBJ integration, etc.

To take up a career in HANA there are several areas one can specialize in such as SLT, which is the data replication tool which replicates source system tables into HANA, HANA modeling to build the basic models which reports sit on, Data Services, Security, etc.

Required certifications

SAP offer two main certification paths.
  • Path is for administration and operations and is considered more technical
  • Path is for implementation and modeling.

Job Outlook

Given SAP’s grasp on the market for high-end ERP installations, the slice of this market for certified SAP professionals will continue to grow.  Although Foote Partners’ research indicates that some SAP consultants can earn high-paying jobs without certification, targeted technical training and project management experience helped the industry’s top earners avoid salary erosion through the economic downturn.
According to government research packages for many SAP consultants in the early stages of their careers are similar to those of computer support specialists who often earn between $33,000 and $55,000 per year.
SAP consultants with specialized certifications and industry experience play a variety of roles including project planning, deployment, and analysis. Based on an employer’s industry and location, these jobs often pay between $58,000 and $96,000 annually.

Friday, 19 September 2014

  • 1. Define Five-minute rule ?
It is a rule of thumb for deciding whether a data item should be kept in memory, or stored on disk and read back into memory when required. The rule is “randomly accessed disk pages of cache are re-used every 5 minutes”.
  • 2. Define multi-core CPU ?
Multiple CPU’s on one chip or in one package is called multi-core CPU. 
  • 3. Define Stall ?
Waiting for data to be loaded from main memory into the CPU cache is called as Stall.
  • 4. What is SAP In-Memory Appliance (SAP HANA) ?
HANA is an in-memory technique to store data that is particularly suited for handling very large amounts of tabular, or relational, data with extra ordinary performance. Common databases store tabular data row-wise. Reorganizing the data in memory column-wise brings a tremendous speed increase when accessing a subset of the data in each table row.

  • 5. What are the components or products of HANA ?
SAP HANA contains the following components.
 1. SAP HANA DATABASE
2. SAP HANA Studio SAP HANA CLIENT
3. SAP HANA INFORMATION COMPOSER
4. DIAGNOSTIC AGENT 7.3
5. SAP HANA client package for MS excel
6. SAP HANA UI for Information Access (INA)
7. SAP HANA AFL 1.0
8. Software Update Manager for SAP HANA
9. SAP LT Replication Add On
10. SAP LT Replication Server
11. SAP HANA Direct Extractor Connection (DXC)
12. SAP Data Services 4.0

  • 6. What are the different editions available in HANA appliance software ?
Platform Edition:
Platform edition is intended for customers who want to use ETL-based replication and already have a license for SAP BO Data Services.
Enterprise Edition:
Enterprise edition is intended for customers who want to use either trigger-based replication or ETL-based replication and do not already have all of the necessary licenses for SAP BO Data Services.
  • 7. What is columnar and Row-Based Data Storage ?
A database table contains data in the form of rows and columns. However Computer memory is organized as a linear structure. To store a table in linear memory, there are two options. A row-based storage stores a table as a sequence of records, each of which contains the fields of one row.  In a columnar storage the entries of a column are stored in contiguous memory locations. The SAP HANA database allows specifying whether a table is to be stored column-wise or row-wise. It is also possible to alter an existing table from columnar to row-based and vice versa. Search operations in tabular data can be accelerated by organizing data in columns instead in rows.

  • 8. What are the advantages of Column based tables ?
The advantages of column based tables are: 
    1. Calculations are typically executed on single or a few columns only.
    2. The table is searched based on values of a few columns.
    3. The table has a large number of columns.
    4. The table has a large number of rows and columnar operations are required (aggregate, scan, etc.).
    5. High compression rates can be achieved because the majority of the columns contain only few distinct values (compared to number of rows). 
  • 9. What are the advantages of Row-based tables ?
The advantages of Row based tables are:
    1. The application needs to only process a single record at one time (many selects and/or updates of single records).
    2. The application typically needs to access a complete record (or row).
    3. The columns contain mainly distinct values so that the compression rate would be low.
    4. Neither aggregations nor fast searching are required.
    5. The table has a small number of rows (e. g. configuration tables). 
  • 10. Which case the data to be stored in columnar storage ?
To enable fast on-the-fly aggregations, ad-hoc reporting, and to benefit from compression mechanisms it is recommended that transaction data to be stored in a column-based table.

  • 11. What is paralelization ?
Column-based storage makes it easy to execute operations in parallel using multiple processor cores. In a column store data is already vertically partitioned means that operations on different columns can easily be processed in parallel. If multiple columns need to be searched or aggregated, each of these operations can be assigned to a different processor core. In addition operations on one column can be parallelized by partitioning the column into multiple sections that can be processed by different processor cores
  • 12. What are the different Compression Techniques ?
The compression techniques are:
1. Run-length encoding
2. Cluster encoding
3. Dictionary encoding


  • 13. Why materialized aggregates are not required ?
With a scanning speed of several gigabytes per millisecond, in-memory column stores, make it possible to calculate aggregates on large amounts of data on the fly with high performance. This is expected to eliminate the need for materialized aggregates in many cases.

  • 14. What are the advantages of Eliminating materialized aggregates ?
The advantages are:
    1. Simplified data model
    2. Simplified application logic
    3. Higher level of concurrency and With the fly Aggregation we have aggregated values up to date
  • 15. What are the different types of replication techniques ?
The replication techniques are:
1. ETL based replication using BODS
2. Trigger based replication using SLT
3. Extractor based data acquisition using DXC

  • 16. Define SLT ?
SLT stands for SAP Landscape Transformation which is a trigger based replication. SLT replication server is the replication technology to pass data from source system to the target system. The source can be either SAP or non-SAP. Target system is SAP HANA system which contains HANA database.
  • 17. What is Configuration in SLT ?
The information to create the connection between the source system, SLT system, and the SAP HANA system is specified within the SLT system as a Configuration. You can define a new configuration in Configuration & Monitoring Dashboard (transaction LTR).
  • 18. What is Configuration and Monitoring Dashboard ?
It is an application that runs on SLT replication server to specify configuration information (such as source system, target system, and relevant connections) so that data can be replicated. It can also use it to monitor the replication status (transaction LTR).
Status Yellow: It may occur due to triggers which are not yet created successfully.
Status Red: It may occur if master job is aborted (manually in transaction SM37).
  • 19. What is advanced replication settings ?
A transaction that runs on SLT replication server to specify advanced replication settings like
    1. Modifying target table structures,
    2. Specifying performance optimization settings
    3. Define transformation rules

  • 20. Define Latency ?
It is the length of time to replicate data (a table entry) from the source system to the target system.
  • 21. Define logging table ?
A table in the source system that records any changes to a table that is being replicated. This ensures that SLT replication server can replicate these changes to the target system.

  • 22. What are Transformation rules ?
A rule specified in the Advanced Replication settings transaction for source tables such that data is transformed during the replication process. Example you can specify rule to
    1. Convert fields
    2. Fill empty fields
    3. Skip records
  • 23. When to change the number of Data Transfer job ?
If the speed of the initial load/replication latency time is not satisfactory If SLT replication server has more resources than initially available, we can increase the number of data transfer and/or initial load jobs. After the completion of the initial load, we may want to reduce the number of initial load jobs.

  • 24. What are the jobs involved in replication process ?
The replication process is consist following jobs:
1. Master Job (IUUC_MONITOR_)
2. Master Controlling Job (IUUC_REPLIC_CNTR_)
3. Data Load Job (DTL_MT_DATA_LOAD__<2digits>)
4. Migration Object Definition Job (IUUC_DEF_MIG_OBJ_<2digits>)
5. Access Plan Calculation Job (ACC_PLAN_CALC__<2digits>)
  • 25. When to go for table partitioning ?
If the table size in HANA database exceeds 2 billion records, split the table by using portioning features by using “Advanced replication settings” (transaction IUUC_REPL_CONT, tab page IUUC_REPL_TABSTG).

Name : Mr. ABC                                                                              Email : BC.ITLM@gmail.com
Ph: xxxxxxxxxx                                                             Current Job: SAP HANA Developer in ITLM,IND

PROFESSIONAL PROFILE
• Total 7.9 years of experience in IT Projects & Operation Management
• Holds excellent interpersonal, communication and analytical skills with demonstrated abilities in
customer relationship management
• Strong problem solving & Technical Skills coupled with confident decision making for enabling effective
solutions leading to high customer satisfaction as well as low operational costs.
• Currently working with Angel Broking as Sr. Manager

AREA OF EXPERTISE
• Well verse with SAP HANA Administration, Performance Optimization, Modeling using Different types of views, SQL, SQL Script topics
• SAP HANA Data provisioning using SAP Landscape Transformation and SAP Dataservices, DXC, Flat File Uploader, SAP HANA Architecture.
• Worked on BO 4.0 like Information Design Tool, Interactive Analysis Desktop and Launch Pad.
• Expert in data modelling and provision & Well verse with semantic layer
• Expertise in SAP BW (Business Warehousing, BW Administration, BW Extractors, ODS, InfoCubes, InfoSources, InfoObjects,and BEx Reporting), SAP Applications Integration with non SAP systems.
• Expertise in Back end Business Warehouse Components Extractors (LO Cockpit, Generic Extraction with in BW System, LIS and non R/3 extraction), Performance (Aggregates, BW Stats, Partitioning), Production Support (Process Chains,info package groups) Front end Business Warehouse Components Queries, Calculated keyFigures, restricted keyFigures, Structures, Variables, RRI (Report to Report Interface), BEx Analyzer, BEx browser.
• BW configuration, ETL background and InfoCubes design, Performance and tuning, strong on End to End BW Configurations and Customizations from Extraction, Staging, Loading, Transport, and Reporting through BEx Analyzer, and Performance.
• Extensively worked in Business Information Warehouse Info cube, ODS Objects, Infosources, Info objects, Transfer rules, update rules, Extractors, Infosources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Characteristics and Key figures, Business Content, Data Marts, Process Chains Technical

KEY COMPETENCIES & SKILLS
 SAP HANA SP04, SAP BI 7.0, SAP BO 4.0, SAP BODS
Software Products : SAP HANA Studio, SAP HANA Information Composer
Admin Tools : SLT, SAP Data Services, Direct Extractor Connection, Flat file Uploader
Data Provision: Excel, SAP BO Analysis for Office, SAP BO office, SAP BO Analysis for OLAP, Business
Reporting Object Explore, Information Design tool : HANA SQL scripting, Javascript
Language Tools : SAP HANA Database, SQL 2005 and 2008

Database Tools 
Employer : ANGEL BROKING (POC HANA Project)
Period : From Oct 2012 to Till Date
Angel Broking want to implement SAP HANA for Risk Management application to get instant overview of Stock Market condition. It will help to risk management analysis to square off the client position as well as the portfolio Manager to instant decision
Environment: SAP HANA 1.0, SAP BO 4.0, MS SQL 2008, Asp.net

Responsibilities
• Involved in information gather phase
• Migrated MS SQL Database into SAP HANA
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to
reflect exchange live rates application
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Developed Web Services for SAP HANA database and deliver to ASP.NET developers to consume data in .net based applications
Employer : ANGEL BROKING
Period : From April 2008 to Sep 2012 
Environment: SAP BI 7.0, SAP ABAP/4, SAP R3 ECC 6.0, CRM, SD,, PL/SQL, Net Weaver, Oracle 10g

Responsibilities
• Understood and converted Technical Specifications from Functional Specifications
• Modeled and built Infocubes, DSO, Infosets, and Multiprovider according to reporting requirements
• Loading of master/transactional data from flat file as well as from R/3 system
• Installed, modified and managed Business Content DATASOURCES (Extract Structures) using RSA5 and RSA6 transactions
• Prepared Technical Specifications from Functional Specifications
• Wrote test conditions from the functional specification
• Prepared and uploaded Allegro and PNC Lockbox files using FTP and validation through SAP Background Batch jobs
• Developed LO customization, extracted structures and data sources in Sales Order management to facilitate the data extraction
to BI enhanced the extract structures by adding new fields and populating them with the user/function exits in CMOD
• Set up periodic jobs for delta data uploads, statistics, aggregate and indices rebuild, and event chains to notify end user of report availability
• Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Data source, Transformation, and DTP
• Created Virtual Provider (Remote SAP Cube) using Direct Access DTP and developed quick reports from Datasource directly
• Used BEx Query Designer as a Front End Tool to build Queries and Reports
• Loading of master and transactional data from R/3 system worked extensively on the transaction data and master data user exits on R/3 by using RSAP0001
• Generated and analyzed reports using BEx Analyzer, Report Designer, and WAD designed and developed Process chains, Meta chain (RSPC) for master data load and transaction data load rocess chains were scheduled for periodic loads
• Extensive usage of administration workbench (RSA1)
• Data loading was monitored and failed data packets were analyzed if possible, manually edited in PSA and reloaded to DSO.
• Scheduled SAP background Batch Jobs using REDWOOD. REDWOOD is a batch job scheduling tool from SAP
• Daily monitoring of Info Cubes, DS objects requests, and back ground Batch Jobs (SM37)
Angel Broking ltd, Mumbai (Jun’05 – March ’08) as Asst. Manager Ecommerce Worked on .net technology from classic asp to .net 4.0. Developed lots of asp.net related projects which were web based and desktop based applications. If require then produce separately.
Name : Mr. ABC                                                                              Email : ABC.ITLM@gmail.com
Ph: xxxxxxxxxx                                                                            Current Job: SAP HANA Developer

 Professional Summary
● 6+ years of information management and development experience with focus on Business Intelligence and Data warehousing using SAP Technologies
● Expert in business analysis, metadata management, reporting and dashboards with SAP NetWeaver BW 3.5 and 7.x and SAP BusinessObjects 4.0 Product suites
● Seasoned technical consultant with strong development, administration and lifecycle management
skills.
● Expert in requirement gathering, documentations and creating POC's to better meet the business  requirements.
● SAP Business Intelligence Certified (SAP BI – NetWeaver 7.0)
● Sound knowledge on SAP HANA 1.0, completed HA100 & HA300.
● Has a very strong technical foundation with excellent interactive and communication skills.

Technical & Business Skills
● SAP Business Objects 4.0
Web Intelligence 4.0 Dashboard Design Crystal Reports 2008
BW NetWeaver 7.x and Information Design Tool Analysis for OLAP and Office
BICS OLAP (Universe)
SAP and BO Integration BI Architecture and Security Live Office 4.0
● SAP Business Warehouse 7.x
SAP BEx Query Designer Web Application Designer
SAP BEx Analyzer
DTP, DSO InfoPackages MultiProvider
Authorization and Security Transformations InfoCubes Design
● Programming Excel Macro SQL HTML
● Database, Data Warehouse, ETL & OLAP Technologies Oracle 10g MS SQL Server 2005/2008 MySQL
SAP HANA 1.0 DB2
● OS Platforms
Linux Windows Server 2003, 2008
Page 1 of 5
Project Experience
Client : Sedgwick County – Wichita,Kansas
SAP BusinessObjects Developer Feb 2012 – Nov
SAP NetWeaver BW 7.x, SAP BusinessObjects 2012
4.0,
Role & Responsibilities
• Gathered User requirements, Analyzed reporting requirements and created technical specifications.
• Created five complex Xcelsius dashboards connecting with SAP BW BEx query for budgeting and long term financial planning
• Created Scenario Builder using WebI and LiveOffice with additional Macro Programming in Excel
• Create complex WEBI reports using multiple queries, merged dimensions, filters, variables.
• Extensively developed reports using Live Office using WEBI as the data source as per the client requirement.
• Worked closely with the client in all phases to design, build, test and deploy SAP BI 4.0 solutions Key Accomplishments
• Completed complex reports including revisions within time and under budget from extensive experience with BOBJusing BEx connecting with the BW backend.
• Effective communication and training  of client users for their daily usage of WEBI and Live Office reports and department customizations

Key Accomplishments
• Developed reusable training assets for business users and super users for new BusinessObjects
platform
• Significant cost savings through clean-up strategy
• Environment was healthier and helped reducing support workload and increased server uptime

Training
• HA100 SAP-HANA Introduction
• HA 300 SAP-HANA Implementation and Modeling

Education
● Awarded a Bachelor of Electrical and Electronics Engineering degree from Kakatiya
University, India