HANA Tutorial
- Different Types of Views in SAP HANA
SAP HANA offers two kinds of works which is mainly known to be as plain SQL views and COLUMN views. Basically SQl views are being generated using the ... 
Importance of HANA and Hadoop in SAP
HANA and Hadoop are known to be very friendly however there are quite a few differences between the two of them. While on one hand one can use HANA fo ...
Recovery of SAP HANA Database Fails
How to do the Recovery of SAP HANA Database Fails?Entries of the following type appear in the file backup.log because a recovery of SAP HANA database ...- SAP HANA SPS04 Numeric overflow for SUM aggregation
SUM aggregation with decimal fails with a numeric overflowSAP HANA does not behave the same as other RDBMS, which automatically upconvert the data typ ... - Important Hints related to SAP HANA
Answered
What are important hints related to SAP HANA?The most important hints of SAP HANA are:HintSUBSTITUTE VALUESTypeABAPDetailsUse of literals instead of b ... 
The Key Perspectives of SAP HANA Studio
The SAP HANA is a management tool for working with HANA. It helps users to cope with the SAP HANA database, to create innovative data models or transf ...- Perform SQL Statement in SQL Console in HANA Studio
How to perform SQL Statements in SQL console in SAP HANA studio?If you want to perform an sql statement, you ought to have the required rights to comp ... - RECLAIM DATAVOLUME command fails when System replication is Active
Answered
How can RECLAIM DATAVOLUME be executed when system replication is active?With ALTER SYSTEM RECLAIM DATAVOLUME DEFRAGMENT you can reduce fragmentation ... - Tuning the performance of INSERTs and Data loads
INSERTs and data loads write new data, while other operations like SELECT, UPDATE or DELETE have to work on existing data.Therefore typical performanc ... 
Using SQL for Looping and Input Variables in SAP HANA
How to make a procedure using SQL Script.In this tutorial, we will learn to use SQL for Looping and Input Variables. In the output of the procedure, w ...- Important Timeouts on SAP HANA Side
Which important timeouts exist on SAP HANA side?The most important timeouts on SAP HANA side are: Parameter Default Unit Description ... 
New Features of SAP HANA Platform 2.0
What are the new features in the SAP HANA Platform 2.0SAP HANA Platform 2.0 contains a central entry point for all of the information around SAP HANA ...- How can Logs and Traces of HANA be Purged?
The parameters maxfiles (default: 10 files) and maxfilesize (default: 10 MB) in the [trace] section of global.ini or a specific service control the tr ... 
Uninstall SAP HANA XS Advanced
How to uninstall SAP HANA XS advanced?1. Login as <SID>adm.2. Run /hana/shared/<SID>/xs/installation-scripts/installation/uninstall.In cas ...
SAP HANA Hardware Check
Beginning with SAP HANA Revision 18 a new Hardware check is mandatory when executing the SAP HANA Installer. Beginning with Revision 26 it is also exe ...
Tips for a Successful SAP Business Suite on HANA Migration
To reduce risk larger organisations are breaking their journey into several steps to SAP S/4HANA. Upgrade of the core ERP system onto the SAP HANA dat ...
Delta Merges in SAP HANA Environments
What are delta merges in SAP HANA environments?Changes (INSERT, UPDATE, DELETE) to SAP HANA column store tables are not directly updated in the main s ...
Difference between HANA, S/4HANA and Hana Cloud platform
Answered
HANA is an in-memory data platform in SAP that can be deployed as an on-premise appliance, or in the cloud. SAP S/4HANA is an exclusively new generati ...- Error 'Inserted value too large for column'
We are getting an error : "Inserted value too large for column". While using the migration tool for SAP Business One, version for SAP HANA to migrate ... 
Difference between Data Archiving and Data Aging in SAP S/4HANA
Data Archiving vs Data AgingData Aging is quite different as compared to Archiving because cold data is saved within the SAP HANA Database and is inac ...- Installing LT Replication Server Using DMIS
As soon as you are going to install LT Replication Server you would have to look after the following contents: First of all you have to check the corr ... - Auto Commit Options Exist for SAP HANA
What kind of Auto Commit options exist for SAP HANA?SAP HANA provides the following Auto Commit options: Auto Commit Type Description ... 
Add New HANA System in HANA Studio
The SAP HANA Studio can be further enhanced by connecting the SAP HANA system.Get the Instance Number and the Server Host ID if you are planning to co ...
Difference between SAP Cloud Platform and HANA
SAP Web IDESAP Web IDE is a web-based integrated development which simplifies the devlopment of end-to-end applications. It helps user to build, test, ...
Error Installing drivers for SAP Smart Data Access in HANA
SAP DBTech JDBC: [403]: internal error: Cannot get remote source objectsFollowing error is displayed when we are installing database drivers for SAP S ...
SAP HANA Modeling Scenarios
SAP HANA Information Modeling or the SAP HANA Data Modeling is the core of HANA application development. To create a meaningful report, one can develo ...
HANA In-Memory Database and Its Advantages
With advancement of technology, the data load has been increasing three dimension-ally in terms of velocity, volume as well as variety. Managing as we ...
License Key Types in SAP HANA
Importance of Licenses to utilize SAP HANA DatabaseBy means of the SAP HANA HDBSQL, HANA SQL Query Editor and SAP HANA Studio one can install and dele ...- Changing log mode for SAP HANA DB after SPS2 to SPS3 upgrade
Support for backup and recovery of the SAP HANA database has been significantly improved in Support Package Stack 3. Support Package Stack 3 suppor ... - SAP HANA DB: Crash of the indexserver due RTT issue
The indexserver of the SAP HANA database crashes in the method PersistenceManagerImpl::writeRestartData. In normal case, the rollback transaction tab ...
×