SAP HANA studio

last updated: 2023-01-16 Introduction There is huge knowledge available about SAP HANA reclaim / shrink / defragmentation topic, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make... Read More »

This Blog explain the restore steps of using backint from Dell EMC netwoker software Expample: Source machine name: s4hhdb1 Source Bakup pool: S4HPRD Source tenant DB: SH1 Target machine name: testdbr2 Backup media server name: emcbackup137 Target... Read More »

last updated: 2023-01-11 Introduction There is huge knowledge available about SAP HANA partitioning, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I... Read More »

With the new evolving modern methodologies around many SAP applications and database technology, i am trying to contribute with some idea that can be helpful or spark a new idea for others. The thought is … What if we can create HANA docker... Read More »

Hello SAP Community Members, My Name is Zeshan Shafaqat Expert in SAP BI/BW and SAP Analytics Cloud. I found many peoples that having trouble that how can we install Eclipse and HANA Tools on their PC. In this Blog, I show you screenshots of how can... Read More »

Requirement – One of most common requirement in Hana is to move user defined table from one Hana environment to another (Ex: Dev > QA > Prod). Here is one of the method i.e. Export & Import we can use. Solution – Will migrate the... Read More »

HANA SPS upgrade from HANA 2.0 Rev 37 to HANA 2.0 Rev 59 on the DR server when primary and secondary server setup as replication are present There are many environments and larger landscapes where we have cluster environment.But in this environment... Read More »

Through SAP ADT or Hana Studio, we can load the CSV\Flat file without the need to use SAP S/4, facilitating the process and gaining speed in execution. Let’s see how to do this procedure. Imagine performing the following task: Import some... Read More »

last changed: 24th of January 2023 Apple M1 and real SAP Basis Support Inspired by  the long history in the Apple Device usage (going back to the first Apple PowerBook 170 in 1993) and the recently purchase of an Apple MacBook Air with the new M1... Read More »

Requirement – Sometime we have to divide two numbers in Hana Sql or in Hana views. If denominator comes as 0 there is no logic implemented handle 0 in denominator then Hana will throw Divide by 0 error during Query execution. Also this is good... Read More »