Skip to Content
Author's profile photo Vivek Singh Bhoj

HANA Reference for Developers – Links and SAP Notes(Part-1) – Updated 04.12.2013

Hi Everyone,

We all have read awesome blogs from Andy Silvey–  The SAP Hana Reference for NetWeaver Basis Administrators and Bill RamosThe ultimate set of HANA related links from SAP. These blogs are very helpful to everyone of us.

What i observed from these blogs was “As Andy’s blog title said its mainly for Basis Administrators and has very huge list of SAP Notes – some of these Notes are useful even for HANA Developers but these notes are very hard to find while Bill’s blog had huge list of links that has been categorized very well but it has not been updated in a while due to which few topics are missing lot of information and many new topics are not present there.”

While working with HANA and its new functionalities, i had to look for information and it used to take a lot of time to get the correct information, so i tried to create a list of SAP Notes and a list of links to the documents that i have followed and want to follow so that i don’t have to go through the pain of searching this information again.

The above two blogs helped me a lot in getting this blog ready – got few SAP Notes and links from these, so i am very thankful to both Andy and Bill for their efforts.

I hope this blog will be helpful to everyone.

Last time I also wrote a blog Want to learn SAP HANA?Where to Start?Certification? but was not fully satisfied with it and thought something was missing, tried  editing it but it would have made the blog too long.

So I thought of creating a new blog and adding everything in one blog but this blog became very long so i have decided to divide it into two parts.

This part of blog covers all the topics related to HANA.

Second part covers advanced topics related to HANA – HANA Reference for Developers – Links and SAP Notes(Part-2)

Deleted all obsolete SAPHANA website links and added new ones

HANA SPS8 Guides and videos are now available:

Check the below document to know What’s New in HANA with links to many other documents and videos on new features:

Blog: What’s New in SAP HANA SPS 08 | SAP HANA

Before starting the blog I would like to post links from where we can download Study Materials for HANA:

Download all the HANA Guides updated to SPS7

http://help.sap.com/hana_appliance/

Technical Documents – SAP HANA – This contains all the documents related to Architecture, Modeling, Data Provisioning and XS.

http://www.saphana.com/docs/DOC-2171

OpenSAP HANA Learning Materials

http://scn.sap.com/community/developer-center/hana/blog/2013/08/14/opensap-hana-learning-materials

In-Memory Data Management Course – starting from August 26

https://openhpi.de/course/imdb2013

SAP HANA ELEARNING CATALOG

http://www.sdn.sap.com/irj/scn/elearn?rid=/webcontent/uuid/e04da73b-3a72-2e10-969a-b032c46e7509

SAP HANA Videos:

http://www.saphana.com/community/implement/hana-academy

Contents of this blog:

  1. Introduction to HANA
  2. HANA Studio – Look and Feel
  3. HANA Architecture
    • Backup & Recovery
  4. HANA Administration
    • HANA Performance
  5. Data Provisioning
    • Flat File
    • SLT
    • Data Services
    • DXC
  6. Modeling
  7. Reporting
    • Using Excel
    • Using Business Objects
    • Using Lumira
  8. Security and Authorization
  9. HANA Native Development
  10. New Features in HANA SPS6
    • HANA Lifecycle Management
    • Spatial Processing
    • Smart Data Access
  11. Big Data and Hadoop
  12. HANA On Cloud
    • HANA One
    • HANA One Premium
    • HANA Enterprise Cloud
  13. RDS
    • Information on RDS
    • COPA Accelerator
    • Finance and Controlling Accelerator
    • Operational Reporting
    • Rapid Marts
    • Supply Chain RDS
    • SAP CRM RDS
    • SAP Analytics RDS
    • SAP HANA Sentimental Intelligence RDS
  14. BW on HANA
    • Introduction
    • Migration
    • Modeling
    • Reporting
    • Other Aspects
    • Customer Testimonials
  15. ABAP on HANA
  16. Business Suite on HANA
  17. SCM on HANA
  18. CRM on HANA

1. Introduction to HANA

What is SAP HANA?

http://www.saphana.com/docs/DOC-2272

Whitepaper – Technical Overview SAP HANA

http://www.saphana.com/docs/DOC-1506

SAP HANA™ for Next-Generation Business Applications and Real-Time Analytics

http://www.saphana.com/docs/DOC-1507

SAP HANA Data Sheet

http://www.saphana.com/docs/DOC-3894

OLAP & OLTP in a single database – SAP Real Time Data Platform

http://www.saphana.com/docs/DOC-2939

Efficient Transaction Processing in SAP HANA Database

http://www.saphana.com/docs/DOC-2119

The Real Reason for HANA

http://www.saphana.com/community/blogs/blog/2013/07/27/the-real-reason-for-hana

The HANA Difference – SAP HANA’s Defining Capabilities

http://www.saphana.com/community/blogs/blog/2013/08/02/the-hana-difference-sap-hana-s-defining-capabilities

The Top 10 SAP HANA Myths Spread by Other Vendors

http://www.saphana.com/community/blogs/blog/2013/07/18/the-top-10-sap-hana-myths-spread-by-other-vendors

Product Road Map – SAP HANA

http://www.saphana.com/docs/DOC-1636

SAP HANA Hardware Specifications & Product Availability Matrix (PAM)

http://www.saphana.com/docs/DOC-2382

Solution Brief – SAP HANA – An In-Memory Data Platform for Real-Time Business

http://www.saphana.com/docs/DOC-2857

How do I get started with HANA

http://www.saphana.com/docs/DOC-2111

System Ordering – SAP HANA

http://www.saphana.com/docs/DOC-1213

SAP HANA Do’s and Don’ts

http://www.saphana.com/docs/DOC-1151

HANA Use Cases:

http://www.saphana.com/community/implement/use-cases

Customer & Startups Stories on SAP HANA

http://www.saphana.com/community/learn/customer-stories

2. HANA Studio – Look and Feel

Overview – SAP HANA Studio

http://www.saphana.com/docs/DOC-1217

SAP HANA Database – Studio Installation and Update Guide

http://www.saphana.com/docs/DOC-1808

Installing Hana Studio and Client

http://www.saphana.com/docs/DOC-2275

Download hana studio and client

https://hanadeveditionsapicl.hana.ondemand.com/hanadevedition/

How to add system in Hana Studio

http://scn.sap.com/docs/DOC-25922

3. HANA Architecture

Architecture – SAP HANA

http://www.saphana.com/docs/DOC-1219

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70d16119-ad21-2e10-de8b-eaaedf86b9cd?overridelayout=true

HANA Architecture Bluebook

http://www.saphana.com/docs/DOC-3191

Massively Parallel Processing on HANA

http://www.saphana.com/community/blogs/blog/2013/04/22/massively-parallel-processing-on-hana

Introduction to High Availability for SAP HANA

http://www.saphana.com/docs/DOC-2775

SAP HANA – High-Availability Features – Webinar Replay

http://scn.sap.com/docs/DOC-40662

  • Backup & Recovery:

Backup and Recovery – SAP HANA

http://www.saphana.com/docs/DOC-1220

http://www.saphana.com/docs/DOC-3131

SAP Notes related to Backup and Recovery:

1844468 – Homogeneous system copy on SAP HANA

1703435 – Creating a copy of a running instance using snapshots

1642148 – FAQ: SAP HANA Database Backup & Recovery

1852242 – Confusion about file-based backup catalog naming

1880503 – SAP HANA studio compatibility error for recovery

1835075 – Analyze backup and recovery performance issues

1820553 – Incompatibility of data backup and DB configuration

1820529 – Unsuitable network file systems for backup and recovery

1781540 – Recovery of SAP HANA database through the Admin Console does not work

1817703 – Archiving file system-based backups

1730932 – Using backup tools with Backint for HANA

Backup/recovery API for the SAP HANA database (Backint for SAP HANA (HANA-BRINT 1.1))

http://scn.sap.com/docs/DOC-34483

“Backint for SAP HANA” Certification Available Now

http://www.saphana.com/community/blogs/blog/2012/12/19/backint-for-sap-hana-certification-available-now

1730928 – Using external software in a HANA appliance

1716418 – Data backup hangs when writing to NFS server

1705945 – Determining required restoration files

1842096 – HANA Backup & Restore Performance

1651055 – Scheduling SAP HANA Database Backups in Linux

1812057 – Reconstruction of the backup catalog with hdbbackupdiag

1816483 – Restore when log backups are missing

4. HANA Administration

SAP HANA Administration Guide

http://www.saphana.com/docs/DOC-1073

SAP HANA – Administration & Monitoring – What´s new with SPS6

http://www.saphana.com/docs/DOC-1215

Overall Installation Guide – SAP HANA 1.0

http://www.saphana.com/docs/DOC-1040

Server Installation and Update Guide – SAP In-Memory Database

http://www.saphana.com/docs/DOC-1031

Manual Update Guide – SAP HANA 1.0

http://www.saphana.com/docs/DOC-1051

Update & Patching – SAP HANA

http://www.saphana.com/docs/DOC-1212

Readiness Guide – SAP HANA

http://www.saphana.com/docs/DOC-1810

Introduction – SAP HANA in Data Centers

http://www.saphana.com/docs/DOC-2010

Scalability – SAP HANA

http://www.saphana.com/docs/DOC-2022

Upgrading SAP HANA with SUM for HANA – Webinar Replay

http://scn.sap.com/docs/DOC-41434

  • HANA Performance

Whitepaper – SAP HANA Performance

http://www.saphana.com/docs/DOC-1647

SAP HANA Memory Usage Explained

http://www.saphana.com/docs/DOC-2299

For real: Performance of the same SQL comparing Hana and another RDBMS

http://www.saphana.com/docs/DOC-2321

Performance Test Report – SAP HANA

http://www.saphana.com/docs/DOC-1755

Performance in SAP HANA Databases – Webinar Presentation

http://scn.sap.com/docs/DOC-43543

Performance in SAP HANA Databases – Webinar Replay

http://scn.sap.com/docs/DOC-43713

Testing HANA

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/609decf2-9963-2f10-c5ae-9812c8191a33?QuickLink=index&overridelayout=true&54395760816167

Show me the timelines, baby!:

http://scn.sap.com/community/hana-in-memory/blog/2012/12/20/show-me-the-timelines-baby

SAP Notes related to HANA Administration

1514967 – SAP HANA: Central Note

1698281 – Assess the memory consumption of a SAP HANA System

1768949 – HANA Overall Health Statistics

1787489 – SAP HANA Database: Performance Trace

1786918 – SAP HANA Database: Provide Information with hdbcons

1800175 – Performance Improvement with hybrid database

1749467 – Copying SAP HANA From a Multiple- to a Single-Host System

1789828 – HANA Studio Activation errors

1800631 – SAP HANA: Limitations for HANA-based Analytics

1809199 – SAP HANA DB: Debugging user authorization errors

1786384 – Missing secondary indexes for HANA DB

1840954 – Alerts related to HANA memory consumption

1849775 – SAP HANA XS ENGINE poor database access performance

1835200 – Stand-by Statistics Server and XS Engine do not start when Master server goes down

1780484 – HANA upgrade fails with ‘ERR: Cannot open install registry’

1803291 – SAP HANA update guides

1894285 – SAP HANA appliance: Revision 62 of SAP HANA database

1891354 – SAP HANA DB: Duplicate entries in column store table

1877480 – Incorrect CODE_SIZE

1848976 – SAP HANA Platform SPS 06 Release Note

1779803 – Current Restrictions: XS / Development Perspective

1514966 – SAP HANA 1.0: Sizing SAP In-Memory Database

1545815 – SAP Release Note for SUM for SAP HANA 1.0

1867324 – SAP HANA Database: Deactivating the Script Server

1603671 – SAP HANA 1.0: Software Components and Software Download

1592925 – SAP HANA Studio service connection

1627904 – SAP HANA Information Composer: Central Note

1641210 – SAP HANA datebase: Checking for suspected problems

1598623 – SAP HANA appliance software: Central Security Note

1870605 – Privilege escalation in SAP HANA

1837331 – HOWTO HANA DB SSO Kerberos/ Active Directory

1813724 – HANA SSO/Kerberos: create keytab and validate conf

1767687 – HANA issues with Kerberos SSO, error while parsing protocol

1666976 – uniqueChecker usage description – The uniqueChecker is used to do a consistency check on column store database tables. It can identify problems related to primary keys and unique constraints.

5. Data Provisioning

Data Provisioning – SAP HANA

http://www.saphana.com/docs/DOC-1210

http://help.sap.com/download/multimedia/ebooks/ec/SAPHANAOverviewofDataProvisioning/story_content/external_files/03_SAP_HANA_Data_Provisioning.pdf

Data Provisioning Options – Introduction and news

http://www.saphana.com/docs/DOC-2859

Best Practices for SAP HANA Data Loads

http://www.saphana.com/community/blogs/blog/2013/04/07/best-practices-for-sap-hana-data-loads

Semantic Analysis with SAP HANA

http://www.saphana.com/docs/DOC-3326

Case Study how to collect Social Media Data with SAP HANA

http://www.saphana.com/docs/DOC-3871

Unstructured Data

http://www.saphana.com/docs/DOC-2118

SAP Notes related to Data Replication

1772131 – Data Replication into HANA: improvements

1791620 – Data Replication into SAP HANA: usability corrections

1797074 – HANA Replication: Incorrect check of navigation attributes

1771582 – Lock issues in data replication

  • Flat File

Loading data from flat file into SAP HANA

http://scn.sap.com/docs/DOC-27960

Importing a Flat File into SAP HANA

http://www.saphana.com/docs/DOC-2362

Loading data from CSV file

http://www.saphana.com/docs/DOC-2191

Modeler Unplugged Episode 4: Flat file upload via HANA Modeler

http://www.saphana.com/community/blogs/blog/2013/01/23/modeler-unplugged-episode-4-flat-file-upload-via-hana-modeler

  • SLT

Overview Presentation – SAP LT Replication Server for SAP HANA

http://www.saphana.com/docs/DOC-1811

SLT

http://www.saphana.com/docs/DOC-2116

http://www.saphana.com/docs/DOC-2926

SLT & Excel

Video: http://www.saphana.com/community/implement/hana-academy#working-with-data-hana-studio

Starter Blog  for SAP LT Replication Server

http://scn.sap.com/community/replication-server/blog/2013/06/10/starter-blog-for-sap-lt-replication-server

SLT for non-SAP – Considerations

http://scn.sap.com/docs/DOC-41786

How SLT is mapping data types

http://scn.sap.com/community/replication-server/blog/2013/05/14/how-slt-is-mapping-data-types

SLT Community

http://scn.sap.com/community/replication-server

SAP Notes related to SLT:

List of all SLT Notes

http://scn.sap.com/community/replication-server/blog/2013/02/27/list-of-all-slt-notes

1605140 – SAP HANA 1.0: Central Note – SAP LT Replication Server

1882433 – Installation/Upgrade SLT – DMIS 2011 SP5

1603754 – Correction for SLT Replicator for HANA 1.0

1652039 – Archiving: Replicating archived data in SAP HANA

1880224 – Replication of archived data: TABLE_INVALID_INDEX

1663138 – HANA data replication fails due to incorrect DB triggers

1645517 – HANA Replication: Trigger creation fails, if  triggers exist

1646371 – HANA replication fails for sender systems with release 4.6C

1733714 – Guide for HANA Advanced Replication Settings

1769956 – HANA LTR: Avoid locks in DB2 during data replication

1768103 – HANA LTR: NON SAP – Timestamp mapping and SYBASE replication

1749824 – Treatment of SLT triggers during transpor

1778880 – SAP LT Replication Server: Using DB6 as non-SAP source

1768805 – SAP LT Replication Server: Collective Note – non-SAP Sources

1801462 – ‘Errors in setting connections’ when saving an SLT configuration

1800901 – SLT: 500 Connection timed out after logging into WebDynpro via transaction LTR

1771460 – SAP LT Replication Server: Using ORACLE as non-SAP source – checkout attached pdf

1778971 – SAP LT Replication Server: Using MS SQL as non-SAP source – checkout attached pdf

1778975 – SAP LT Replication Server: Using DB2 as non-SAP source – checkout attached pdf

1778880 – SAP LT Replication Server: Using DB6 as non-SAP source – checkout attached pdf

1828028 – Creating a new configuration in transaction LTR fails with ‘Error ocurred on when opening db connection’

1818180 – Unable to find certain tables in the Data Provisioning tool

1837877 – Tables are not getting replicated from SLT server to HANA

1791921 – Conversion of pool tables to transp.during migr. to SAP HANA

  • Data Services

Installation Guide – SAP BusinessObjects Data Services XI 4.0

http://www.saphana.com/docs/DOC-1038

How To load SAP Business Suite data into SAP HANA using SAP BusinessObjects Data Services

http://www.saphana.com/docs/DOC-1354

How to invoke SAP HANA stored procedures from Data Services

http://www.saphana.com/docs/DOC-2289

SAP HANA: Data provisioning using BI 4.0 Data services

http://scn.sap.com/docs/DOC-26311

Optimizing HANA with Data Services and Information Steward

http://scn.sap.com/community/enterprise-information-management/blog/2013/06/11/optimizing-hana-with-data-services-and-information-steward

Data Services 4.2 What’s New Overview

http://scn.sap.com/community/data-services/blog/2013/06/02/data-services-42-whats-new-overview

HOWTO – Create a SAP BusinessObjects Data Services Repository on SAP HANA

http://scn.sap.com/docs/DOC-42792

SAP Notes related to Data Services

1792597 – Is SAP HANA available as a database repository for SAP Data Services 4.0

1811961 – Connection to HANA test failed in Data Services Workbench

1817513 – SAP Business Objects Data Services crashes without error when HANA Data Store is accessed

  • DXC

SAP HANA-Direct Extractor Connection (DXC)-Overview

http://www.saphana.com/docs/DOC-3779

Using the Direct Extractor Connection (DXC)

http://www.saphana.com/docs/DOC-2420

SAP Notes related to DXC:

1583403 – Direct extractor connection to SAP HANA

1670518 – SAP HANA Direct Extractor Connection

1688750 – DataSource: Reading a property in the source system

1701750 – DataSource: Secondary Index on the PSA

1677278 – DataSource: Changing the Key Definition

1710236 – SAP HANA DXC: DataSource Restrictions

1714852 – Troubleshooting SAP HANA DXC issues

1665602 – Setup & Config: SAP HANA Direct Extractor Connection (DXC)

1583403 – Direct extractor connection to SAP HANA

1665553 – Handling issues with IMDSO activation – SAP HANA DXC

1714933 – DXC: partitioning In-Memory DSO tables

6. Modeling

SAP HANA Modeling

http://www.saphana.com/docs/DOC-3213

Modeling Basics

https://saptechedhandson.sap.com/demo.sap.com~vi~web/content/EIM161.pdf

Modeling Fundamentals

http://events.asug.com/2012AC/4211_SAP_HANA_Data_Modeling_Fundamentals_and_New_Functionality.pdf

Modeling Features – SAP HANA

http://www.saphana.com/docs/DOC-1216

SAP HANA Modeling Guide

http://www.saphana.com/docs/DOC-1074

Analytic Views – What they are and how are they used?

http://www.saphana.com/docs/DOC-1256

Implementing Calculation Views – SAP HANA Modeling

http://www.saphana.com/docs/DOC-1922

SAP HANA – Modeling Content Migration

http://scn.sap.com/blogs/krojzl/2011/10/24/sap-hana–modeling-content-migration–part-1-preparations-security-requirements-export

http://scn.sap.com/blogs/krojzl/2011/10/24/sap-hana–modeling-content-migration–part-2-import-post-migration-activities

Calc Enginer Introduction

https://websmp202.sap-ag.de/~sapidb/012003146900000463252012E/HanaCalcEngineIntroduction.pdf

HANA Calculation Engine Instantiation Process

https://service.sap.com/~sapidb/012003146900000488272012E/HanaCEInstantiationProcess.pdf

Cardinality Optimization of join by CalcEngine

https://websmp210.sap-ag.de/~sapidb/012003146900000214282013E/HANACECardinalityOptimization.pdf

Implementing Calculation Views – SAP HANA Modeling

http://www.saphana.com/docs/DOC-1922

Building Advanced Data Models with SAP HANA – Webinar Presentation

http://scn.sap.com/docs/DOC-13267

Best Practices for optimal data models in SAP HANA and analytics in SAP BusinessObjects 4.0

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/1052f8d7-4b2a-2f10-6b9d-da8fbdc964af?overridelayout=true&53468047977244

Best Modeling practices:

http://events.asug.com/2012AC/4219_SAP_HANA_Data_Modeling_Best_Practices_.pdf

ABC CLASSIFICATION & C4.5 DECISION TREE

http://www.saphana.com/docs/DOC-1283

SAP Notes related to Modeling:

1718854 – SAP HANA Modeler: Error when opening Analytic privilege

1791464 – Select count(*) on graphical Calculation Views

1764658 – HANA Calculation Engine Instantiation Process

1811804 – Deadlock caused by Queries on Olap Views

1825549 – Performance degradation for query on CalcView

1840663 – Workaround for Cardinality Optimization of CalcEngine

1765642 – SAP HANA Modeler – Activating Objects

1710712 – How to export and import Hana Models for support purposes

1639568 – SAP HANA studio displays system status as yellow

1822186 – Cannot use “SELECT DISTINCT” in an attribute view

1876879 – Calculated Attribute of Calculaton View missing (rev 60)

1852300 – SAP HANA: Filters on SQL CalcViews are not being pushed down

1648962 – SAP HANA: Prerequisites for Data Modeling

1739779 – Activation of procedures might fail

1753944 – Revalidation of procedures/views using R script

7. Reporting


  • Using Excel

Connecting to SAP HANA with Microsoft Excel 2007 PivotTables and ODBO

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e03fef5e-d82f-2f10-8898-859c4ed57e62?quicklink=index&overridelayout=true

Learn Excel Functions:

http://www.simple-excel.com/

  • Using Business Objects

Official Product Tutorials – BI for SAP HANA:

http://scn.sap.com/docs/DOC-34403

Best Practices – Creating a universe on SAP HANA

http://www.saphana.com/docs/DOC-1682

Best Practices – Creating a universe on SAP HANA

http://www.saphana.com/docs/DOC-1682

How to Realize Cross System Reporting  Using SAP HANA Live Content

http://www.saphana.com/docs/DOC-3885

Setting up end to end security for SAP HANA and BI4.0

http://www.saphana.com/docs/DOC-2416

What’s New Guide – SAP BusinessObjects Analysis, edition for Microsoft Office 1.3 SP6

http://www.saphana.com/docs/DOC-1684

What’s New Guide – SAP BusinessObjects Business Intelligence platform 4.1

http://www.saphana.com/docs/DOC-1685

FAQ for IT – SAP BusinessObjects Explorer

http://www.saphana.com/docs/DOC-1756

Official Product Tutorials – SAP BI Suite

http://scn.sap.com/docs/DOC-7725

Connecting SAP BusinessObjects BI4.0 client tools on SAP HANA

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20d62593-fdff-2f10-548d-fdcb9157217c?QuickLink=index&overridelayout=true&57458072525289

SAP Notes related to Business Objects:

245178 – krb5.ini rules of configuration with Business Objects java AD

1811398 – How to setup BI components to login to hana via AD kerberos SSO

1779252 – How do you resolve BI 4.0 Analysis for OLAP error message “Failed to get connections for connection […] using session locale [English]” connecting to SAP HANA?

1714374 – The JDBC connection from Crystal Reports to SAP HANA database is timed out

1714328 – The JDBC connection from Crystal Reports to SAP HANA database is refused

1714320 – The JDBC connection from Crystal Reports to SAP HANA database cannot be made successfully

  • Using SAP Lumira(Formerly Visual Intelligence)

SAP Lumira

http://www.saphana.com/community/learn/solutions/sap-lumira/sap-lumira-desktop

SAP Lumira Cloud FAQ

http://scn.sap.com/docs/DOC-41354

Ofiicial Product Tutorials: SAP Lumira :

http://scn.sap.com/docs/DOC-26507

SAP Notes related to Lumira

1823771 – SAP Visual Intelligence – Unable to connect to HANA due to insufficient rights

1798899 – SAP Visual Intelligence: Are HANA Variables or Input Parameters supported?

8. Security & Authorization


SAP HANA Security: An Overview

http://www.saphana.com/docs/DOC-3751

SAP HANA Security Overview

http://events.asug.com/2013AC/Business%20Integration%20Technology%20&%20%20Infrastructure/3909%20SAP%20HANA%20Security%20-%20What%20You%20Need%20to%20Know.pdf

SAP HANA Security Guide

http://www.saphana.com/docs/DOC-1067

SAP HANA – Security Concept and Data Architecture

http://scn.sap.com/blogs/krojzl/2011/10/24/sap-hana–security-concept-and-data-architecture-part-1

http://scn.sap.com/blogs/krojzl/2011/10/24/sap-hana–security-concept-and-data-architecture-part-2

9. HANA Native Development


Introducing SAP HANA Extended Application Services (XS)

http://www.saphana.com/docs/DOC-3789

XS engine – SAP HANA native development

http://www.saphana.com/docs/DOC-3212

HANA Native Development

http://www.saphana.com/docs/DOC-3017

SAP HANA Extended Application Services

http://scn.sap.com/community/developer-center/hana/blog/2012/11/29/sap-hana-extended-application-services

10. New Features in HANA SPS6

What’s New in HANA SPS6

http://help.sap.com/hana/Whats_New_SAP_HANA_Platform_Release_Notes_en.pdf

New in SPS6:

http://www.saphana.com/docs/DOC-3790

New SQLScript Features in SAP HANA 1.0 SP6

http://scn.sap.com/docs/DOC-44062

SAP HANA SPS6 – Various New Developer Features

http://scn.sap.com/community/developer-center/hana/blog/2013/07/01/sap-hana-sps6–various-new-developer-features

Core Data Services

http://www.saphana.com/docs/DOC-3773

Preview the SAP HANA IDE Lite on SAP HANA One

http://www.saphana.com/community/blogs/blog/2013/05/23/preview-the-sap-hana-ide-lite-on-sap-hana-one

  • HANA Lifecycle Management

Lifecycle Management – Introduction

http://www.saphana.com/docs/DOC-3796

How to upgrade to SAP HANA Lifecycle Management

http://scn.sap.com/people/man-ted.chan/blog/2013/07/05/sap-hana-lifecycle-management

SAP HANA Lifecycle Manager – how to launch, start and install.

http://scn.sap.com/community/hana-in-memory/blog/2013/07/11/sap-hana-lifecycle-manager–how-to-launch-start-and-install

SAP Notes related to HLM

1836498 – SAP HANA Lifecycle Manager

  • Spatial Processing

Spatial Processing powered by SAP HANA

http://www.saphana.com/community/learn/solutions/spatial-processing/

Spatial Processing with HANA FAQ

http://www.saphana.com/docs/DOC-3804

Spatial Processing

http://www36.sap.com/corporate-en/news.epx?PressID=20900

SAP Notes related to Spatial Processing

1872108 – Current Restrictions:SAP HANA Spatial processing

  • Smart Data Access

SAP HANA smart data access enables remote data to be accessed as if they are local tables in SAP HANA, without copying the data into SAP HANA.

Smart Data Access (Data Virtualization) with SAP HANA

http://www.saphana.com/community/blogs/blog/2013/07/22/smart-data-access-data-virtualization-with-sap-hana

HANA Curious – SPS 06 Deployment: Smart Data Access, XS Workbench and more

http://www.saphana.com/community/learn/startups/blog/2013/07/24/hana-curious–sps-06-deployment-smart-data-access-xs-workbench-and-more

SAP Notes related to Smart Data Access

1868209 – SAP HANA Smart Data Access: Central Note

1868702 – SAP HANA Smart Data Access: Remote Datasource Drivers

1879294 – SAP HANA smart data access SP1

1872652 – SAP HANA Smart Data Access: Statistics for Virtual Tables

SAP River:

Introducing RDL – The River Definition Language:

http://www.saphana.com/community/blogs/blog/2012/11/15/introducing-rdl-the-river-definition-language

Introducing SAP River!!:

http://scn.sap.com/docs/DOC-47587

A first look at “River”:

http://scn.sap.com/community/developer-center/hana/blog/2013/11/22/a-first-look-at-river

SAP River Tutorials:

http://scn.sap.com/docs/DOC-49281

Regards,

Vivek

Assigned Tags

      59 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Raman Korrapati
      Raman Korrapati

      Its wonderful blog to get into HANA. Whole content at one place.

      Thanks for your effort and sharing.

      Raman

      Author's profile photo Former Member
      Former Member

      केवल इतना? 😉

      Thanks,

      KS

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      hahaha

      check second part also, its even more longer 😉

      Regards,

      Vivek

      Author's profile photo Baskar Gopalakrishnan
      Baskar Gopalakrishnan

      You deserve for the greatest award from this space community.. I really appreciate your hard efforts...  Thanks a lot...

      Author's profile photo Former Member
      Former Member

      Hi Vivek,

      It is great work and effort, thank you very much.

      Regards,

      Jerry

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Jerry,

      Regards,

      Vivek

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Hi Vivek,

      1 place having almost all the information needed.

      Thanks for your efforts.

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Kamal,

      Regards,

      Vivek

      Author's profile photo Praveen Kumar
      Praveen Kumar

      Thanks vivek.

      I really appreciate your effort that you have given to this blog.

      It will be very helpful for the Hana aspirants .

      Regards

      praveen

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Praveen

      Regards,

      Vivek

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Lets call this the HA100V and HA300V 😆

      Good work mate...appreciate it!

      Benedict

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      hahaha

      You can call it that too, I guess i will call 2nd part as HA600V 😉

      Thanks Benedict

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member

      Great Post. Thanks a lot Vivek.

      Regards,

      Anoop

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Anoop

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member

      good Post.Waiting for the next release.

      Regards

      Sayi

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Naga,

      You can check second part here"

      HANA Reference for Developers - Links and SAP Notes(Part-2)

      Regards,

      Vivek

      Author's profile photo flavio ciotola
      flavio ciotola

      Thank you Vivek,

      Just bookmaked both blogs, really useful references.

      Flavio

      Author's profile photo Former Member
      Former Member

      Hi Vivek,

      Nice document.

      Author's profile photo Former Member
      Former Member

      Awesome Consolidation! Great Job. Keep it up.

      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Vivek,

      this is a very organised catalogue of documentation and a great effort.

      What I would like to see if I were a Developer would be more of sections containing quick introductions to common tasks and with examples of common tasks and quick tips for getting started, on top of the catalogue of documentation.

      This is precisely what my goal was with the Hana Reference for Basis Administrators, a guide where Basis Administrators can come and get the founding information to do their jobs without so much having to click around and read more related documentation, hence why the Hana Reference for Basis Administrators contains so many examples for the task sections.

      I suggest you to take what you have done to the next level and include sections on common Developer Tasks and with quick examples and tips.

      All the best and good job,

      Andy.

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks for the feedback Andy.

      I will try doing that

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member

      HANA at One place...Many Thanks for your hard work.

      Best Regards,

      Naresh K.

      Author's profile photo Denys van Kempen
      Denys van Kempen

      Hi Vivek,

      That's an impressive list. Thanks for referencing the SAP HANA Academy http://academy.saphana.com

      Let us know should you find any topic missing.

      Thank you

      Denys (SAP HANA Academy)

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Denys,

      SAP HANA Academy is a great resource to learn HANA.

      Thanks for creating dedicated HANA site with wonderful videos and documents

      Surely, I will let you know if i find any missing topic.

      Regards,

      Vivek

      Author's profile photo Abdullah Qureshi
      Abdullah Qureshi

      Wonderful blog Vivek. Thanks for Sharing..

      Regards,

      Abdullah

      Author's profile photo Umashankar Poojar
      Umashankar Poojar

      Thanks for your effort and time. Nice to have all in one place.

      Cheers!

      Umashankar

      Author's profile photo Former Member
      Former Member

      Excellent.....

         " Quick links for HANA "

      Time saving one for every one...

       

      Cheers..

      Subbarao

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Nice job..Great work...much appreciated.

      Thanks a lot .....

      Regards

      Krishna Chaitanya.

      Author's profile photo Former Member
      Former Member

      Excellent work Vivek.

      Thank you for coming out with such an organized post.

      This will be of great use to SAP HANA new joiners.

      Regards,

      Irfan

      Author's profile photo Former Member
      Former Member

      Thanks for Sharing!

      Regards,

      Hema

      Author's profile photo Rama Shankar
      Rama Shankar

      Good collection of reference material ! thanks! 🙂

      Author's profile photo Former Member
      Former Member

      good work, really helpful.

      Author's profile photo Former Member
      Former Member

      Thanks for sharing.  its really helpful

      Author's profile photo Former Member
      Former Member

      Good one Vivek.. 🙂

      Really informative and useful for most of us... 🙂

      Keep sharing like this and Keep it up.. 🙂

      Regards

      Kiran N

      Author's profile photo Marko Espig
      Marko Espig

      Crazy man but many thank's for this 🙂 .

      Author's profile photo Former Member
      Former Member

      Good one

      Author's profile photo Former Member
      Former Member

      Hi,

      great work ..........vivek 🙂

      Author's profile photo Rama Shankar
      Rama Shankar

      You are so well organized - thanks for sharing! 🙂

      Regards,

      Rama

      Author's profile photo Former Member
      Former Member

      Hi Vivek,

      Wonderful! Great Work! I really appreciate your efforts.

      Very useful document for Hana lovers! 🙂

      Regards,

      Hari Suseelan

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks a lot for your appreciation Hari

      Regards,

      Vivek

      Author's profile photo NAGA SATISH
      NAGA SATISH

      Hi Vivek,

      Thanks for updating HANA SP7 full details, good to get all information at single screen.

      Really good work Vivek....

      BR,

      Naga.

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Thanks Naga

      Author's profile photo Srinu S
      Srinu S

      Vivek,

      Wonderful effort. Thanks for sharing. 🙂

      Srinu.

      Author's profile photo Hammou Essakhi
      Hammou Essakhi

      Great work Vivek. Thank you very much.

      Hammou

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice help Vivek 🙂 Thanks for help 🙂

      Author's profile photo Former Member
      Former Member

      Hi Vivek,

      really a great info on HANA and you organised the content vey well.

      Keep up the good work 🙂

      Author's profile photo Former Member
      Former Member

      Hi Vivek Singh Bhoj can we add How to install SAP HANA Studio for Mac OS X - and build your first XS app in HANA SP07   to your blog as advice from my mentor we really thought it was helpful for Developers.

      Thank you

      Author's profile photo Former Member
      Former Member

      Thanks Vivek. Brilliant Effort. One stop HANA station.

      Regards,

      Imran

      Author's profile photo Former Member
      Former Member

      Hi Vivek,

      Can you advise, how to view the KB articles, it is prompting for User name and Password.

      Regards,

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Hi,

      You need SAP S-User ID and password to view those. Ask your BASIS Administrator to provide you an S_User ID

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member

      Hi Vivek,

      Could you also share some links on SRM on HANA?

      Thanks & Best Rgds,

      Anil

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj
      Blog Post Author

      Hi Vicky,

      For downloading these delivery units, you will have to login to SAP Service Marketplace. Go to Service Marketplace -> Software Download Center -> Installation and Upgrades -> Browse Our Download Catalog -> SAP In Memory(SAP HANA) -> SAP HANA Addons -> download the delivery units that you need

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member

      Hi Vivek,

      Thank you very much.

      Regards,

      Vicky.

      Author's profile photo Former Member
      Former Member

      Thanks a lot.. Huge collection..

      Author's profile photo Former Member
      Former Member

      Thanks Vivek. your collection save huge time of everyone!!

      Author's profile photo Surya Vadupu
      Surya Vadupu

      Hi Vivek,

      Thank you very much for your great job and saved lots of time too.

      Author's profile photo Former Member
      Former Member

      Vivek,

      This is a lot of great reference material. Thanks for sharing!

      Would you also know where we could find some sample SQL procedures - for example for creating an SQL script based calculation views?

      Or for creating different table joins using SQL when HANA views are not enough.

      Thanks..

      Author's profile photo Former Member
      Former Member

      Thanks for outlining the whole information about SAP HANA

      Author's profile photo Former Member
      Former Member

      Hi Vivek,

      Great effort and Thank you so much for your effort.

      Regards,

      Varaprasad.