SAP HANA

When we are facing any Hana database related issue, we need to check all log files, diagnosis file and trace files to troubleshoot issues. We need to read Hana diagnosis/log/trace files from various different location. If we SAP Hana is installed on multiple host (Distributed installation), then we need to …

Introduction Recently, we have recorded a number of new videos for the SAP HANA Academy about SAP HANA installation and update. The full playlist can be accessed here: SAP HANA Installation and Update – SAP HANA 2.0 SPS 02   The previous blog about this topic (migrated from the previous SAP Community …

One of the advantages of SAP HANA Spatial is that it includes a map client and other content at no additional cost. This is an example of a spatial application created using the HERE map provided with SAP HANA. Further down the road, when you license HANA Spatial, you also …

The advent of SAP HANA in early 2010 marked a disruption in enterprise data management and data processing. Combining in-memory technology, parallel processing on a massive scale and column-wise storage – to name at least the most important ones – SAP HANA leveraged innovations in both hardware and software technology. …

Introduction   Recently, we have recorded a number of new videos for the SAP HANA Academy to help you get started with SAP HANA on the Microsoft Azure public cloud environment. The full playlist can be accessed here: Getting Started with SAP HANA on Microsoft Azure   This blog will be part …

Introduction The objective of this SAP HANA Under The Hood series is to provide some insights on particular SAP HANA topics. Like a mechanic, look under the hood and take apart a piece to examine its functioning. Last month, I posted the first blog about SAPInit and SAPStartSrv or the mechanism used …

The SAP HANA Innovation Award honors and celebrates SAP’s most forward-thinking customer and partner successes, and promotes these amazing accomplishments to a wider audience. From Accenture to Fitch Ratings to Zappos, from Automotive to Public Sector to Wholesale Distribution, across 5 continents, companies and organizations of all sizes and industries …

SAP HANA System Replication on SLES for SAP Applications You like directly to start with? If you like to know, how to implement the solution including SUSE Linux Enterprise for SAP Applications, please read our setup guide available at: https://www.suse.com/products/sles-for-sap/resource-library/sap-best-practices/ What is this solution about? The solution created by SUSE …

Python support scripts of the HANA Database as HANA 1.0 SPS12 The python support can be found in /usr/sap/<SID>/HDB<XX>/exe/python_support. Usually you can use the option ‘–help’ and ‘–helpGeneral’ on each scripts. Be carefeful before you execute one, these scripts can impact the system. You can use HDBSettins.sh combined with the …

Introduction In the upcoming weeks, we will be posting new tutorial videos to the SAP HANA Academy to help you get started with SAP HANA cockpit 2.0. Topics covered are how to install and update cockpit, how to setup cockpit with cockpit manager, how to secure cockpit and how to …

Since Sapphire this year SAP and Intel have announced some new details regarding Skylake and NVM (non-volatile memory). With the new processors it should be possible to gain ~60% more performance when running HANA workload on it. Additionally new DIMMs based on 3D XPoint technology (NVM) help overcome the traditional …

Big thanks to Fabian Herschel and Peter Schinagl from SUSE for proof-reading the blog. First part of this blog is located here: Be Prepared for Using Pacemaker Cluster for SAP HANA – Part 1: Basics Be Prepared for Using Pacemaker Cluster for SAP HANA – Part 2: Failure of Both …

Be Prepared for Using Pacemaker Cluster for SAP HANA – Main Part Introduction I am probably stating obvious when saying that every infrastructure deployment option needs to be properly tested before it can be used to host productive workloads. This is even more important for High Availability clusters, as poorly …

Have you been using the ISNUMERIC() function of MySQL, MS SQL Server or PostgreSQL and wondered what to use in SAP HANA instead? If so, this is the blog for you. Just recently I’ve seen a customer using my old workaround (first published here) and then a few days later …

Quick link: bit.ly/hanaspatial Spatial Enthusiasts! The purpose of this page is to provide you with the one-stop-shop for helpful resources for your journey with SAP HANA Spatial. The page will be updated as needed. If you have a recommendation which is missing from here, by all means, please comment. We also …

If you’ve watched “Mad Max Beyond Thunderdome”  then “… You know the law: Two men enter, one man leaves …“. Watch out, he’s coming for you! — pic from www.imdb.com. HANA, of course, reverses, sorry, disrupts this law by making two (or more) values get out of functions, even when only …

As the SAP Leonardo Live satellite event was coming to a close in Palo Alto on November 2, Sam Yen, SAP’s Chief Design Officer, opened the floor for audience Q&A. The first question from a customer in the audience was: “So, what IS SAP Leonardo – is it a product, …

Error: You face an error in HANA Studio/HDBSQL “License key could not be installed” on SAP HANA DB while installing license on existing DB already running with permanent license. Error in detail: =========================================================================== Error while installing license key on  systemId: <xxx> SAP DBTech JDBC: [436]: could not set system license: …

Introduction This blog provides an overview of all What’s New material published about SAP HANA cockpit by the SAP HANA Academy together with other related information. SAP HANA Cockpit 2.0 SP 04 What’s New SAP HANA 2.0 SPS 02 What’s New: SAP HANA Cockpit SP 03 SAP HANA 2.0 SPS 01 …

Introduction Earlier this week (October 31, 2017), the latest support pack for SAP HANA cockpit 2.0 SP 04 was released-to-customer (RTC). Support pack 04 introduces some nice new functionality to make administering SAP HANA systems easier, more secure, and more manageable for large scale deployments. With a new home page on …

I know there is already very good blogs on this topic, The purpose of this blog is to explain the process of performing  a simple homogeneous system copy of a HANA (MDC-multi tenant database container) based system using the recovery of the source backup on the target HANA DB using …

And here by “extreme points” we mean “the geographical points that are farther north, south, east or west than any other location in Europe” [Wikipedia]. Sorry if you expected to find locations for some extreme sports in this blog 🙂 In my previous blog I used geospatial functions ST_Xmin() and ST_XMax() in SAP HANA …

Spoiler Alert! In this blog, you can find the answers to question 5 of the SAP HANA Academy XS Exam Quiz. If you want to try and test your XS knowledge and know-how first, see XS Exam Quiz – by the SAP HANA Academy     Service Available   Answers …

Spoiler Alert! In this blog, you can find the answers to question 4 of the SAP HANA Academy XS Exam Quiz. If you want to try and test your XS knowledge and know-how first, see XS Exam Quiz – by the SAP HANA Academy   Migrating to the cloud   …

Spoiler Alert! In this blog, you can find the answers to question 3 of the SAP HANA Academy XS Exam Quiz. If you want to try and test your XS knowledge and know-how first, see XS Exam Quiz – by the SAP HANA Academy   Forbidden   Answers Answer 1 …

Spoiler Alert! In this blog, you can find the answers to question 2 of the SAP HANA Academy XS Exam Quiz. If you want to try and test your XS knowledge and know-how first, see XS Exam Quiz – by the SAP HANA Academy   Up and Running   Answers …

Spoiler Alert! In this blog, you can find the answers to question 1 of the SAP HANA Academy XS Exam Quiz. If you want to try and test your XS knowledge and know-how first, see XS Exam Quiz – by the SAP HANA Academy   Toolkit   Answers Answer 1 …

Introduction Most of you will have heard by now that the classic model of SAP HANA Extended Application Services (XS classic) has been deprecated with the latest release of SAP HANA, 2.0 SPS 02, July 2017. We covered this in our What’s New blog What’s New in SAP HANA 2.0 SPS …

Mechanism of join cardinality setting “cardinality” is a setting that can be applied to joins in calculation views. It specifies how many matching entries for entries of one table exist in the other table of a join. It consist of two numbers, the left number describes the number of matching …

This example is referenced in my other post about the usage of the join cardinality settings in SAP HANA Calculation Views. Please have a look at the other post to get a better understanding of the context for this example   The following three examples will illustrate that the resulting values of measures …