SAP HANA Administration

HANA Administration — The Engine Behind the Analytics

SAP HANA has, over time, become the heart of the digital enterprise. It is the central database where transactional data flows in, where static, unstructured data is stored and accessed, and where web, mobile, and IoT (Internet of Things) devices connect for delivering superlative customer experience.

Managing such a vital technology solution is increasingly complex. HANA administrators have a critical role to play across the lifecycle of SAP HANA — from the initial setup for optimal storage and access to regular administration for backups and monitoring to periodic performance tuning to finally, on-demand configuration to meet business needs.

HANA Administration — The Engine Behind the Analytics

With the rapid application roadmaps of today, including the move to SAP S/4HANA and the development of cloud applications for analytics, there is increased pressure on HANA administrators to “run like a factory,” as SAP calls it. While keeping up with the speed of execution with efficient change management, HANA administrators need to ensure security and performance.

HANA administrators use the HANA Studio to perform the following activities:

System monitoring
Load distribution
Exceptions
Database monitoring for performance and memory consumption
Performance monitoring
Backup and disaster recovery monitoring
Alerting
Housekeeping

SAP HANA can be deployed in a variety of approaches. This interview with experts from Protiviti discusses choosing the right SAP HANA deployment option and other best practices with SAP HANA administration.

Multiple databases can be set up in a single SAP HANA system. The SAP HANA system itself can be deployed either on a single system or multiple host systems. HANA administrators can assess the performance needs of their organization to balance the load and enable scalability and decide to deploy on a single or multiple systems.

This SAP HANA guide to performance analysis, optimization, and administration techniques provides a deep dive into advanced SAP HANA administration and master techniques and tools for effective analysis of issues, monitoring the workload, and overall management of SAP HANA systems, including multi-tenant databases.

SAP provides many tools to administer SAP HANA.

SAP HANA Cockpit is based on SAP Fiori Launchpad and helps access a long range of HANA applications through a web interface.
SAP HANA Studio helps perform system administration and monitoring activities in a distributed environment. Different administrators can be assigned different access privileges to handle various tasks.
SAP HANA Lifecycle Manager helps to manage SAP HANA components after installation. You can add/remove hosts or rename using the Lifecycle Manager.
SAP Solution Manager helps to integrate your SAP HANA platform with other business solutions.
SAP HANA HW Configuration Check helps to check the interoperability of the SAP HANA system with enterprise storage.

Many vendors such as NetApp, AWS, Google Cloud, HPE, and Microsoft Azure bring significant expertise in deploying, monitoring, and administering SAP HANA so that it powers the modern enterprise.

- Premium
Are My A/R and A/P Figures in PCA Wrong?

Reading time: 19 mins

Discrepancies between FI and Profit Center Accounting (PCA) figures often confuse even the most experienced controllers. The author shows how the transfer of balance sheet A/P and A/R accounts from FI to PCA can produce unexpected and bewildering results. He also explains the logic used to obtain PCA data. In numerous projects, I have been...…
- Premium
Ask the FI/CO Expert: Use a Simple Workaround to Automatically Release Credit-Hold Blocked Sales Orders After the Error Condition Improves

Reading time: 5 mins

Once a credit block on a sales order is active, what will cause the block to be automatically removed? The author, an SAP consultant from the Netherlands, explains how to set up a “semiautomatic” update to credit management. Key Concept The response to this month’s question is courtesy of guest expert Dr. Stef Cornelissen,...…
- Premium
Prepare Your R/3 System Now for the International Accounting Standards Deadline

Reading time: 14 mins

Impending deadlines for compliance with the International Accounting Standards (IAS) will require hard work on the part of many accountants and R/3 specialists. The problem posed by IAS is that, in most cases, two or more sets of figures have to be managed because of the differences among IAS, US GAAP, and national fiscal reporting....…
- Premium
When You Need a Report They Did Not Build, Consider QuickViewer

Reading time: 7 mins

To quote from a recent experience: “Can you show me how to list manually entered exchange rates and the amounts involved? I want to do a sanity check on possible typos.” To quote from a recent experience: “Can you show me how to list manually entered exchange rates and the amounts involved? I want to...…
- Premium
What You Need to Know About Textbook vs. SAP R/3 Activity-Based Costing

Reading time: 17 mins

The case for Activity-Based Costing (ABC) goes something like this: Traditional accounting methods do a good job of calculating product costs for the purposes of inventory valuation for financial statements, but a poor job of allowing a cost accountant to validate the cause-and-effect relationship assumptions on which managers base their daily decisions. The case for...…
- Premium
New IDoc Helps with Looming SEPA Deadline

Reading time: 14 mins

Become familiar with the structure and application of the recently introduced Intermediate Document (IDoc) type PEXR2003. Understand why SAP developed this IDoc type and how you can use it for your SAP In-House Cash (SAP IHC) implementation. Key Concept SAP In-House Cash allows corporate cash and treasury management departments to set up a payment factory...…
- Premium
Tips for Debugging ABAP for Functional Teams

Reading time: 22 mins

/IT Some basic tips shed light on debugging ABAP. Learn how to trigger debugging, discover what the main differences between the classic and new debuggers are, and follow some scenarios in which debugging ABAP helps improve the processing of various transactions. Key Concept Debugging is the way to find the root cause of certain SAP...…
- Premium
Use Authorization Trace to Track Checked Authorization Objects

Reading time: 8 mins

The authorization trace feature in transaction ST01 can help you trace all authorization objects being checked at different levels. See an example showing how to use it and how it affects compliance issues in your system. Key Concept An authorization object is the key component in the SAP security process. Each authorization object defines what...…
- Premium
Real-Time, Outbound Interfaces to Non-R/3 Systems Made Simple with Change Pointers, Message Control, and Workflow

Reading time: 1 mins

Developers often struggle with custom ABAP/4 code or database logging to devise ways to track changes to data and then to trigger output of that changed data across outbound interfaces to non-R/3 systems. The onus of creating a way to track changes as they occur rests squarely on the shoulders of these developers, but it...…
- Premium
Leveraging the R/3 Warehouse Management Structure with the MM-MOB and WM-LSR Interfaces

Reading time: 2 mins

/Project ManagementIntegrating the R/3 Warehouse Management (WM) module with mobile data entry devices and external warehouse management systems is made possible by two interfaces — Mobile Data Entry (MM-MOB), which enables mobile entry and transfer of data to and from SAP, and Warehouse Control Unit (WM-LSR), which enables the sending and receiving of information between...…