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 …
Read More »SAP HANA 2.0 Installation and Update – by the SAP HANA Academy
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 …
Read More »Importing spatial map client included with SAP HANA Spatial
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 …
Read More »SAP HANA Innovation Survey
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. …
Read More »Getting Started with Microsoft Azure – by the SAP HANA Academy
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 …
Read More »SAP HANA Under The Hood: HDB – by the SAP HANA Academy
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 …
Read More »SAP HANA Innovation Award 2017 – meet the winners running on SUSE
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 …
Read More »Automate SAP HANA System Replication with SLES for SAP Applications
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 …
Read More »10 Useful Python script for HANA
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 …
Read More »Getting Started with SAP HANA Cockpit 2.0 – by the SAP HANA Academy
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 …
Read More »HANA: First adaption with NVM
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 …
Read More »Be Prepared for Using Pacemaker Cluster for SAP HANA – Part 2: Failure of Both Nodes
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 …
Read More »Be Prepared for Using Pacemaker Cluster for SAP HANA – Part 1: Basics
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 …
Read More »What’s your number?
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 …
Read More »SAP HANA Spatial Resources
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 …
Read More »HANA inverts the Thunderdome law
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 …
Read More »So, What IS SAP Leonardo? Reactions to SAP Leonardo Live’s Satellite Event in Palo Alto
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, …
Read More »Error “License key could not be installed” on SAP HANA DB
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: …
Read More »What’s New in the SAP HANA Cockpit 2.0 – by the SAP HANA Academy
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 …
Read More »SAP HANA Cockpit 2.0 SP 04 What’s New – by the SAP HANA Academy
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 …
Read More »SAP HANA System Copy- Homogeneous On Multi Tenant Database
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 …
Read More »Finding extreme points of Europe with SAP HANA
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 …
Read More »XS Exam Quiz: Question 5 – by the SAP HANA Academy
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 …
Read More »XS Exam Quiz: Question 4 – by the SAP HANA Academy
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 …
Read More »XS Exam Quiz: Question 3 – by the SAP HANA Academy
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 …
Read More »XS Exam Quiz: Question 2 – by the SAP HANA Academy
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 …
Read More »XS Exam Quiz: Question 1 – by the SAP HANA Academy
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 …
Read More »XS Exam Quiz – by the SAP HANA Academy
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 …
Read More »Join cardinality setting in Calculation Views
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 …
Read More »Join cardinality setting in Calculation Views: Influence of wrong cardinality settings
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 …
Read More »