HANA Tutorial
Looking External SAP HANA view for a BW Query
Activation of external SAP HANA view for a BW Query fails. Error message: "Return code/argument: 40117. Message: Internal deployment of object fa ...
SAP HANA T-Codes for Administration and Monitoring in DBA Cockpit
List of SAP HANA T-Codes (Transaction Codes) for Administration and Monitoring of applications in DBA Cockpit are following:DB01: Analyze Exclusive Lo ...
HANA Alert 5 'Host CPU Usage'
How to handle "Host CPU Usage"?How to determine that the HANA system has become unresponsive?When in the Alerts tab, the alert “suse-h ...- SAP HANA db: Connection timeout if there are more than 1000 connections opened.
A connection timeout occurs when connection to the SAP HANA database if there are more than 1000 connections opened. Due to a to tight connection t ... 
SAP HANA Security- Types and Features
Security is required to safeguard the firm’s confidential data from illegal entree and usage and also to make sure that the Compliance and princ ...- 'Error on Open Administration Editor' HANA Studio Reports
HANA Studio: You are not able to open the Administration Editor. HANA Studio reports "Error on open Administration Editor" with reason " ... 
How does a Typical Crash Dump Analysis look like in SAP HANA?
Please have a look at the following CRASH_SHORTINFO and CRASH_STACK section of a crash dump for exampleBased on the information marked yellow we can a ...
Installing SCM on SAP HANA with integrated liveCache
How to Install SCM on SAP HANA with integrated liveCache? I want to install SAP Enhancement Package 2 for SAP Supply Chain Management 7.0, version ...- Revealing HANA Data Size
HANA Studio and ST04 share similar information but HANA is too new to evaluate the actual database size. The confusion is in the following context&hel ... 
Difference between SAP HANA and Hadoop
SAP HANA vs. Hadoop SAP HANA is referred to as the in-memory technology, whereas Hadoop from Cloudera is known as a big data solution. SAP HANA is ...- What is the use of HDB Table in SAP-HANA?
What is the use of HDB Table in SAP-HANA? ... 
Restart-time Row Store reorganization Procedure
How to Restart-time Row Store Reorganization?What to do if Row store memory size is a lot bigger than the actual data size in row store and shows high ...
Time difference between user adm and root in HANA
user <sid>adm time vs root timeWhy we are getting the time of user "root" and "<SID>adm" different in HANA server.Solu ...
How to write SQL Stored Procedure Script in SAP HANA
This tutorial is about how to write SQL script in SAP HANA stored procedure in order to create a complex calculation on the fly to generate a report f ...- SAP HANA db: "COUNT DISTINCT" does not return correct value for CalcView
You model "COUNT DISTINCT" in a Calculation View and the result of a statement does not return the correct result for "COUNT DISTINCT&q ... - Transporting SAP HANA content with Enhanced CTS (CTS+)
What is Enhanced CTS (CTS+) Transport LandscapeIn this scenario, the SAP HANA content is transported as another non-ABAP content. This typical ba ... 
Keyboard Shortcuts for SAP HANA Cloud Platform in SAP Web IDE
This tutorial explains Microsoft Windows and Mac OS keyboard shortcuts for SAP HANA Cloud Platform in SAP Web IDE.Microsoft Windows Keyboard Shortcut ...- SAP HANA DB: Partitioning and Distribution of Large Tables
The partitioning feature of the SAP HANA database is used to solve the problems of handling of very large data sets. Using the partitioning feature of ... - SAP HANA Replication Modes
Which modes of SAP HANA system replication are available?The following SAP HANA system replication modes exist: Mode Details ... 
Performance Optimizations for FI-CA on SAP HANA
How to do the Performance optimizations for FI-CA on SAP HANA?As of SAP Enhancement Package 7 for SAP ERP 6.0, SP 02, and SP 03, you can improve the p ...
Generate a Diagnostic Dump for the HANA Database
How to Generate Diagnostic Dump for the HANA database? SAP HANA Appliance Crashes We need to troubleshoot log files because SAP HANA Appliance c ...- SAP HANA db: Indexserver runs out of memory during startup
During startup the indexserver consumes to much memory and crashes due to out of memory.Reason:If you drop a table the allocated space will be release ... 
Persistence Layer in SAP HANA Database
Persistence layer in SAP HANA manages logging of all the transactions in order to offer standard backup and reinstate functions. In built feature Disa ...
Create HANA DB Schema and assign CONTENT_ADMIN Authorization
How HANA DB schema should be created and authorization should be assigned?We have connected to SAP HANA System with database. The database user i ...- Cannot insert NULL or update to NULL - Error 287 & Loading Process Fail
Why? loading processes fail with error 287 - cannot insert NULL or update to NULLIn indexserver alert trace you see that table update failed with func ... - Tuning Expensive SQL Statements
What are typical approaches to tune expensive SQL statements? Depending on the results of the analysis of an SQL statement the following op ... - Find location of the SAP HANA Studio log
How to find the location of the SAP HANA Studio log? SOLUTION To find the location of the SAP HANA Studio log please follow the steps below: ... 
Data Provisioning Overview
Data Provisioning ToolsWhat is Data Provisioning?Data provisioning is the way to get DATA from SAP sources such as SAP ERP, SAP BW or non-SAP source s ...
SAP HANA Content Lifecycle Management
What is SAP HANA contentSAP HANA content also called as SAP objects or artefacts is not a part of SAP HANA Database itself it is either delivered by S ...
SQL Operators in SAP HANA
SQL Operators specify conditions in an SQL statementIn SAP HANA, the importance of SQL operators is something that cannot be expressed in words. The S ...
×