Introduction It’s been almost two years since my last post about XSUAA and therefore I thought it might be the right time to write about another topic that is happening in a lot of our applications within SAP IES (also known as SAP IT): distributed data. Just as a disclaimer. The content you see here is approximately one....
In many organizations there is a requirement in reports related to data extraction of text from text views. Like material purchase order text view, many organizations are using frequently these text views to save important information. In this blog I am sharing abap report from which users can easily extract this data. Also it provides....
Recently got tasked with a repetitive need to compare 2(n) HANA schemas. Comparison was on the lines Do the same number of tables exist in both schemas? Extensible to other database objects viz. procedures, views etc Is there a difference in the row count of tables between the 2 schemas? Output a list of missing....
Let’s say that as a Modeler, you have successfully uploaded your data into SAP Profitability and Performance Management Cloud (SAP PaPM Cloud) and utilized SAP PaPM Cloud’s extensive modeling functions for enrichment and calculation. And as a result of your Modeling efforts, you now have the desired output that you would like to download from the solution. The question is: Depending on the number of records,....
In this blog I will discuss one issue which I face after S/4 HANA conversion in SWIA (WI Administration Report). In SWIA when assigning workitem to another user agent. System was giving following error. “Exception condition “PACKAGE_DOES_NOT_EXIST” triggered”. Although the error was clear as it shows that package does not exist. But the error was coming....
It was almost a year since my last Geospatial Tuesday post. That time it was how-to Import zipped shapefiles into SAP HANA Cloud using Database Explorer. But I still used an external tool called DBeaver to visualize data imported into SAP HANA Cloud. (And before that I even used ASCII to display spatial shapes from SAP HANA!) This time, I....
Hi, One problem which usually face by fiori users in My Inbox fiori app is that by default only 100 items are visible. If users have a list of workitems more than 100 then total number of workitems are not visible. 100 Workitems in my inbox In this blog I will share simple steps....
last updated: 2022-06-22 16:30 CEST Ok, large objects aka LOBs (no not Line of Business) are nothing special and well known from other database systems. LOBs are unstructured data like a picture, a PDF or a message XML content. The shared properties of this kind of data is that they can be quite large. There....
In this blog, you will learn how to troubleshoot HANA DB authorizations / privileges errors using SQL Script procedure GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS OVERVIEW SAP introduced a procedure GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS with HANA 2.0 SP04 to simplify troubleshooting HANA related privileges and access issues Earlier security administrators had to troubleshoot privileges and access issue using User-specific trace. This trace generates a log, and the security....
In S4 HANA when we implement my inbox fiori app. It shows some action tasks buttons by default like “Suspend”, “Claim”, “Show Log” etc. as follows: My inbox fiori app buttons In this blog we will discuss how to hide these buttons In order to hide these buttons we will use the standard BADI “WF_TASK_SUPPORT”. Go....
In this blog, we will describe the process of identifying and adjusting the correct pieces from SAP BTP in order to solve a specific customer request. This process starts from fully understanding the business needs. Then, how this translates to different SAP BTP components, in order not only to answer the current requirement but also....
Introduction When working with HANA Repository, you may be used to query the table “_SYS_REPO”.”ACTIVE_OBJECT” to get details about design-time objects. With HDI, the same information is now split by containers and you have to query 2 objects: the view M_OBJECTS the procedure READ_DEPLOYED For some use cases, it would be convenient to be able to query....
This blog is intended to provide some more understanding about SAP HANA NSE and its configuration. Design Principles of NSE SAP HANA NSE adds a seamlessly integrated disk-based processing extension to SAP HANA’s in-memory column store by offering a large spectrum of data sizes for an improved cost-to-performance ratio. It manages data without fully loading....
When you install SAP HANA 2.0, SSL certificate in PSE store is self-signed. In order to allow for signed SSL HTTP connections with SAP HANA, we need to replace default self-signed certificate with a new one signed by a CA of your choice. Steps Go to below URL https://FQDN:4300/sap/hana/xs/wdisp/admin/public/default.html Open the tree of SSL and....
SAP HANA application and services are being consumed in different other applications such as sap analytics cloud, business objects, other reporting tools etc. To access these services seamlessly, SSO plays important role. SAP HANA applications can use single sign-on (SSO) authentication with SAML assertions to confirm the logon credentials of a user calling an application service.....
Last week I switch from using Intel-based MacBook laptop (x86 architecture) to the one with Apple M1 (ARM64 architecture). Recently Mathias Kemeter shared one approach of running hdbcli on an Apple M1 Chip: creating a copy of a terminal app that starts using Rosetta. A look at arch command I tried an alternative approach, that I would like to share here. It does....
This article is intended to help customers using external identity provider to configure SAML SSO for SAP Analytics Cloud. By default, SAP Cloud Platform Identity Authentication is used by SAP Analytics Cloud. however, if required SAP Analytics Cloud can also be configured with single sign-on (SSO) using your identity provider (IdP). Pre-Requisite to Configure SSO with External Identity....
In HANA XS classic, to get access on all analytical privileges(classic AP) in the system _SYS_BI_CP_ALL can be granted to an user(directly or via a role), generally for developers/ HANA Admin. But in HANA cloud or XS advanced using HDI container there is no such analytical privilege exists for developers. Even though Developer has got the....
The latest release of the Automated Predictive Library (APL) introduces the capability to build several time series models at once from a segmented measure like Sales by Store for example or Profit by Product. No need any more to define a loop in your SQL code or Python code. Just tell APL what column represents....
(Jana Subramanian is APJ Principal Cybersecurity Advisor for Cloud Security and Fellow of Information Privacy (FIP) awarded by International Association of Privacy Professional (IAPP). Jana supports strategic customer engagements on cybersecurity, data privacy, multi-cloud security architecture, contractual assurance, audit, and compliance domains.) Introduction Transitioning to RISE with SAP cloud services, SAP customers have a choice of opting for....
The events of the last few years, months, and weeks have touched every aspect of our lives, and each day seems to reveal new challenges, new consequences, and new opportunities arising in the wake of massive global disruption – from pandemics, to inflation, to stock market volatility, even to hostile invasions. As organizations across every....
SAP PP Long Term Planning (LTP) Overview Long-term planning (LTP) Is SAP PP procedure in which the simulative MRP run is used by production planners to compare various production scenarios concerning material requirement, vendor availability, and capacity planning for all materials listed in the Bill Of Materials (BOM). Using LTP, planners are able to establish the impact....
As you are all aware now, you cannot connect DS directly to the SAP BW4HANA system, Hance needs to connect DS DB with the HANA database via SDA and create a source system. Based on customer requirements set up HANA DB connection with MS SQL DB and set up source system. Contributor Abhishek Sinha DISCLAIMER....
In this blog we will discuss about LO Data source enhancement using SAPI. The scenario is same. For a Particular Order we need to have material Status and other fields in our data flow for which Material Number is available in our datasource 2LIS_04_P_MATNR. But before going to the implementation I want to discuss about....
You are working on a migration scenario to SAP HANA database using Software Update Manager (SUM) with its Database Migration Option (DMO). You wonder which SAP HANA log mode the tool is using during the migration. The available log modes of SAP HANA database are explained in the documentation, for example using the following link https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.05/en-US/c486a0a3bb571014ab46c0633224f02f.html. Relevant statements....
Building deep learning model within SAP BTP Dear readers, This is a blog series from the Meter Reading project and we attempted to discover the possibilities for ML models in a web browser. This long journey has provided many lessons learned in terms of deep learning and deployment in web browsers. As a beginner in....
This blog post will describe the sizing of virtual machines running SAP HANA on Red Hat Virtualization. The blog is organized into two parts. Part 1 provides some sizing background and virtual concepts. Part 2 will cover an example of sizing a SAP HANA virtual machine with respect to CPU and memory. Thanks to the following Red....
TensorFlow Lite deployment in browser using WebAssembly Dear readers, I am a software developer, and this is my very first blog post. I would like to thank Gunter Albrecht for inspiring me to research on the topic of WebAssembly. There have been several attempts to run inferencing for ML models on the web browser using TensorFlow.js, ONNX....
This blog post is on usage of two powerful Nodes namely Hierarchy function and Minus Node in HANA Calculation view. Both Nodes are available in SAP HANA 2.0 XSA and HANA cloud. Minus and Hierarchy function Node are available starting SAP HANA 2.0 SPS01 and SPS03 respectively for on premise and available in SAP HANA....
In last session I have discussed about the normal exception handing using EXIT HANDLER . In today’s session I will discuss about the explicit creation of exception handling using Signal and Condition. Using our HANA procedure we will check for valid Email ID. If email id is not valid we will signal an exception using condition.....
Common machine learning scenarios such as fraud detection, customer churn, employee flight risk, aim to predict Yes/No outcomes using binary classification models. But sometimes the target to predict has more than just two classes. This is the case of Delivery Timeliness that can have three categories: Early/On-time/Late. From this article you will learn how to....
In this blog I wish to bring out the difference involved with implementing RISE with SAP S/4HANA,private edition against RISE with SAP S/4HANA cloud(essential edition) This blog is intended for those who have basic understanding of RISE and wish to understand a detailed difference between the public and private edition while using SAP Activate methodology.....
If you are a JavaScript developer then you have multiple options and frameworks for connecting to and working with SAP HANA databases. It’s easy to be overwhelmed with too many options, some of which even seem to be overlapping in functionality. In this blog post series, I’d like to walk the reader through the assorted....
In this blog post I am going tp write about HANA Lead and Lag Functions. The functionality is same as SQL but I found it little weird while implementing this one 1 of the HANA Graphical calculation Views. Doing in scripted CVs it is pretty easy but while doing in Graphical HANA CVs these functions....
Security-Enhanced Linux is a Linux Security Model (LSM) that allows defining security policies to implement mandatory access controls (MAC), providing a very granular layer to strengthen the OS against attacks. Despite the obvious benefits of using SELinux, it has been historically advised not to use it on Enforcing mode (we will see what this is....
In the previous blog post in this series, we took a deep look at the two major different JavaScript modules that act as HANA Clients: @sap/hana-client and hdb. Architectural differences aside, let’s return to that sample usage of the @sap/hana-client we saw at the end of the previous blog post: import hanaClient from "@sap/hana-client" import * as xsenv from "@sap/xsenv" export....
Como vai TIME quanto tempo, mas afinal o que é a metodologia SAP Activate? Resumidamente o SAP Activate Methodology é composta, basicamente, por 4 fases. Prepare: Conduzir o planejamento e preparação inicial e definir governança do projeto para iniciar o projeto o com o pé direito. Explore: A equipe do cliente explora as capacidades da solução....
Going back to our discuss in the previous blog post in this series about @sap/hana-client and hdb, the situation is now even more complex. @sap/hana-client supports promises, but hdb doesn’t. That’s just one of several differences between the two modules. There are also other functions like connection pooling or calling stored procedures that can be done in both @sap/hana-client and hdb, but perhaps could be made even easier with....
The more we lean towards AMDP based HANA transformations compared to good old ABAP these days, the more we feel the need of having substitutes of reusable standard ABAP function modules & programs. One such instance is LAST_DAY_IN_PERIOD_GET. While we can hope for a readymade HANA function or procedure developed & delivered by SAP with the....
In this blog I wish to share my personnel experience in preparing for the beta exam ‘SAP on AWS – Specialty (PAS-C01)” . NOTE: This does not cover any new additions or modifications that AWS might bring in with the Standard version starting from 7th April 2022 As this is a brand new exam till today ,....
As promised, part2 is in continuation to my blog post https://blogs.sap.com/2022/03/25/soh-migration-sum-dmo-with-system-move-first-hand-experience-part-1 In this blog post we will cover the following. How to effectively use DURATIONS file (MIGRATE_DT_DUR.XML) to reduce downtime. An out of the box solution to fast forward the downtime stage. SUM parallel mode execution Let’s start with how MIGRATE_DT_DUR.XML file can contribute. Durations.xml When....
Introduction: This topic and the procedure discussed here may be useful in those situations where in we find it difficult to download required media may be due to the fact that it is discontinued or not available or something like that. some situations e.g. setting up a new instance for trial run or PoC (proof....
In this blog post series, we’ve explored several aspects of the HANA client tooling for JavaScript developers. In part one, we examined the differences between @sap/hana-client and hdb modules. In part two, we saw how to optimize our code using Promises / Async / Await. Then in part three, we looked at the value of additional wrapper modules like @sap/hdbext and....
Data preview on intermediate nodes of a calculation view is a regular task while using HANA studio as a development tool. it is useful for debugging/troubleshooting data output at each node level of a CV. But after migrating to HANA XSA(On-Premise) or HANA cloud(Cloud platform) then you will need to use Web IDE for HANA(On-Premise)....
As a common effort of the HDI team here are some findings we made and manifested in blogs so that you should get a page for information that maybe in the documentation as well but here in condensed form to get a quick start or leverage approaches we see as useful. How to move....
Summary of what we achieved: We have recently migrated and upgraded the BW/BI system from Netweaver 7.0 to Netweaver 7.5 using the SAP’s robust tool SUM 2.0’s DMO feature for one of our customer. The database size was nearly 3 terabyte and the resultant HANA database was around 250 Gigabyte. The existing infrastructure was having....
Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace. This version included the database connection list and a SQL console for executing queries against a database. What’s New? Today, version 1.5 of the extension has been released to the Visual Studio Code marketplace.....
I am writing this blog post about Anonymous Block Do..Begin in SAP HANA WEB IDE with an simple example. We can write complex DML statements too but below example will give an idea on how to formulate and write Anonymous Block Do..Begin in SAP HANA WEB IDE. So what are Anonymous Block Do..Begin in SAP....
Use case: You are a HANA system administrator/developer and got to work on an Authorization issue in SAC/BOBJ reporting live model based on HANA Calculation view for a business user. The CV has several transactional and dimensional CVs used and It is hard to identify which object has analytical privilege issue. Example: In the above....
Photo by Geio Tischler on Unsplash The SAP HANA Client for Python as of now is only available for x86 Macs. While the client team is planning to release universal binaries, you can continue your work in Python also on the M1 by using Apple’s Rosetta technology. There are many descriptions out there, which explain how to run x86 Python....
Abstract Innovate your IT landscape with SAP Data Warehouse Cloud, which is SAP’s strategic target solution for all data warehousing use cases in the puplic cloud, in line with SAP’s data-to-value portfolio strategy. This blog post provides SAP BW and SAP BW/4HANA customers an overview of how existing on-premises investments can be converted to the cloud. More importantly,....
SAP Startup Framework now natively supports systemd on Linux SAP applications have been available on Linux since 1999, and ever since SAP has used System-V startup scripts to start the applications automatically on all UNIX-like operating systems. This has been a big benefit in the past because SAP administrators could use the same knowledge for....
In this short blog, I wish to share my personnel learning experience for RISE with one of the best learning courses provided by SAP for its partners to jump start with RISE with SAP for a Partner Cloud Solution architect (PCA) . NOTE:Learning Hub access is mandatory for the same and you must be a....
Today we are pleased to announce that SUSEs project Trento is reaching the Ramp-Up phase today where we make the solution available to customers in a staged approach. In case you are hearing about Project Trento for the first time, please check the official Trento website or watch the first demo video to learn....
SAP Control validating error resolution doc during HANA Refresh via SWPM tool. This document is not necessarily having the strategy but also config information too some extent however content can be viewed and leveraged as appropriate. It gives an overview and resolution for sapcontrol validation issue using SWPM tool Keywords: GET_DEFAULT_DATA_BACKUP_LOCATION, SAP HANA, SYSTEM REFRESH, SWPM....
Starting with version 2203 of the Automated Predictive Library (APL) intermittent time series are given a special treatment. When the target value has many zeros, typically when the demand for a product or a service is sporadic, APL will no longer put in competition various forecasting models, but it will systematically use the Single Exponential....
Every HDI container in SAP HANA XSA comes with a predefined access_role that (you might have guessed it) grants access to the container’s schema. It only grants limited access, though – and sometimes you may need more. This post is about modifyingthe privileges included in this role. Before we get into the details, let’s first take a look at....
SAP Partner InfraBeat Technologies’ growth story leveraging their SAP-Qualified Partner-Packaged Solution “SHIFT” features in one of India’s top newspaper What an amazing journey! Read how an SAP Partner in India who started its business in a small apartment, evolved to a name to recon within the field of digital transformation. InfraBeat Technologies Private Limited is an....
SAP Introduced new functionality from BW 7.4 on HANA where we can generate HANA view directly from B4HANA and BW on HANA application during BW object activation, The external HANA view enables to create scenarios where data, which is modeled in the BW system, are merged with data modeled in SAP HANA with SAP HANA....
During support situations for SAP NetWeaver or S/4 HANA based systems, you might often be asked to upgrade the executables of your system (often called “SAP kernel”) to a current release. But which version is running in your system? Here are several methods to determine the version of an SAP executable: 1. Using SAPMMC 2.....
You might have seen that SAP just recently released the first version of SAP HANA Database Explorer as a Visual Studio Code Extension. You can get that extension here: SAP HANA Database Explorer – Visual Studio Marketplace SAP HANA DB Explorer in VSCode Marketplace For those of us that do a lot of local development in....
Each year the Business Application Research Center (BARC) is conducting The Data Management Survey: The new survey on data management tools (bi-survey.com) and is collecting the feedback from the end users and implementation or consulting partners of Data Management solutions to present their findings and their view on the overall solution offering and portfolio of the different....
ntroduction Salesforce provides APIs that enable external applications to receive events in near real time mode. In this blog, we provide a detailed configuration steps for two of these options: Platform Event and Change Data Capture (CDC). Platform Event is an excellent option when data from multiple objects are required as in the case of....
Simplification, automation and quick response to business needs is a requirement for most of our clients. Typically, customers run a number of SAP systems. Each system consists of one or more database instances (SAP HANA, IBM Db2, Oracle) and several SAP NetWeaver application servers. By using SAP Landscape Management software in combination with IBM PowerVC, clients gain....
Picture this – you are the manager of a supermarket and would like to forecast the sales in the next few weeks and have been provided with the historical daily sales data of hundreds of products. What kind of problem would you classify this as? Of course, time series modeling, such as ARIMA and exponential....
In this blog post you will get a clear, step-by-step process of how to install and run the ABAP Sizing Report (described in SAP Note 1872170), with screenshots accompanying each step. When dealing with sizing requests from the presales field, I typically ran into the problem of not having clear instructions to follow for running....
This post builds on top of the previous, but should help you as a reference without going through all previous posts hopefully too. In my SAP HANA database in the SAP HANA Cloud trial, I got four calculation views built: 3 dimensions Date_Dim, Item and Warehouse and 1 cube with the star join Inventory. In this post let’s see how to use the SAP....
Motivation As many of you I have on my SAP Business Technology Platform Trial account an instance of the SAP HANA Cloud Trial running. This trial instance is stopped everyday. Sometimes I am a little bit “angry” when I switch to my private workplace – enthusiastic to try out some stuff on SAP HANA Cloud Trial –....
16 Likes 1,940 View 3 Comments The SAP Web Dispatcher is a reverse proxy designed to work best with other SAP software solutions. While there exist many reverse proxy solutions from various software vendors out there, the SAP Web Dispatcher is maintained and supported by SAP, is available for multiple operating systems, follows the same configuration principles....
After getting an overview and understanding of how Virtual Data Models (VDM) and ABAP Core Data Services (ABAP CDS Views) work in SAP S/4HANA, and the requirements needed for a CDS View to be extractable in my colleague Michael Sanjongco’s blog post Part 1 – SAP S/4HANA Cloud Data Integration to power your Intelligence Enterprise. This blog will briefly explain the....
Intro This blog post continues a series of publications about the Installation of different SAP Systems in Hyperscalers In previous parts: SAP HANA EXPRESS EDITION in Yandex Cloud. Binary Installation. Step-by-step guide https://blogs.sap.com/2019/11/29/sap-hana-express-edition-in-yandex-cloud.-binary-installation.-step-by-step-guide/ SAP NetWeaver AS ABAP Developer Edition 7.52 SP04 in Yandex Cloud. Binary Installation. Step-by-step guide https://blogs.sap.com/2019/12/15/sap-netweaver-as-abap-developer-edition-7.52-sp04-in-yandex-cloud.-binary-installation.-step-by-step-guide/ Installation of SAP HANA Database with Extended Application Service....
What goes beyond the code push down? It is the filter push down! For a better understanding of code push down please refer to my below blog post on code pushdown. https://blogs.sap.com/2021/04/14/sql-script-for-abap-managed-database-proceduresamdp-code-pushdown-for-a-better-performance/ As I have already discussed in my previous blog post, greater the number of records, more the time taken by the application. We....
These are some notes about studying for the eponymous Microsoft AZ-120 certification in Azure for SAP Workloads. Be aware that the content of AZ-120 exam (and of the AZ-104 exam) evolves over time – as indeed will the set of useful study materials – so this document can only be a fairly subjective snapshot, taken....
Machine Learning capabilities have been part of SAP HANA since the earliest version and have continuously evolved over time. These days, Machine Learning embedded in SAP HANA comes in two flavors: the Automated Predictive Library (APL) and the Predictive Analysis Library (PAL). While the automated Machine Learning of the APL targets especially developers and business analysts, the expert Machine....
Digital disruption is happening everywhere and changing everything. Disruption drives new business models, new ways of working, and new methods of collaborating and communicating. Today, overcoming disruption is often the top goal when a business transforms into an intelligent enterprise. That’s because digital transformation enables businesses to create a scalable, reliable, and flexible IT infrastructure....
My first hands-on experience with SAP HANA was in the early days of its development back in 2011. I was a student at the time, and in one of the practical phases of my dual studies, I was working in a department that did application development on top of SAP HANA. Working with the in-memory technology was so innovative and exciting, which is why I was so happy when, after graduating in 2012, I got my very first job in the SAP HANA team. In that role, I worked as a developer in the team responsible....
This post is part of Transformational Tuesdays: A Series on SAP HANA Business Value from the SAP HANA Solution Management team celebrating 10 years of SAP HANA in 2020. Data is everywhere and is growing faster than ever. The bigger data grows, however, the harder it is to make data-driven decisions. Why is this a challenge? ....
SAP continues to update their offerings to further improve the user experience. While this is great to ensure our ERP systems have the greatest capabilities possible, it can be hard to keep track that our own systems are up to date. That’s why we put together a list of the SAP versions and how your business can learn more about....
Dear All Readers, This blog is about what is DP Agent and how we can connected DP Agent with our HANA cloud data ware house. We have below phases as part of this blog to cover DP agent installation and connectivity with cloud. Overview Installation of DP Agent Connectivity with cloud Register the adapter Conclusion....
Purpose This blog post is created to use SAP HANA express edition using Azure. Primary purpose of this blog post is to get familiarized with SAP HANA. This post is targeted for system administrators. Credit – Images/URLs used in this document are from Microsoft Azure portal available in public domain. Create your Azure Account You need....
Executive Summary: Every Organization has the biggest challenge to reduce the TCO (Total cost of ownership). One of the major contributor in that is the cost of Hardware on which ERP applications are running. With evolution of new technology and presence of Cloud services, the availability of these Hardware has been made very easy, but....
Like many of my colleagues who have also shared their stories, I have now been working with SAP HANA for close to ten years. My story takes a bit of a different turn though – starting as a customer leading a strong team of early adopters to an early go-live in 2011 (the fourth in the world if I recall....
One of the greatest challenges that our SAP training participants face again and again is the limited time when it comes to training and certification in a new area. The main problem is to prepare for a certain certification as best as possible without your day-to-day business suffering as a result . It is precisely for this purpose....
Dear All Readers, This blog is about what is HANA DB Backup Catalog and how we can check the size of Backup Catalog and how we can automate the old backup catalog cleanup using backup retention policy in HANA cockpit. We have below phases as part of this blog to cover Backup catalog cleanup using....
Dear SAP Community, my name is Kathrin Henkel and I’m part of the SAP HANA Product Management team at SAP. I studied Computer Science, Business Administration and Information Management and joined the SAP Family in 2005. I’m happy to announce that we will run an exclusive virtual event for experienced SAP HANA customers , the....
Introduction:This article speaks about the patching of SAPIQ server starting from the need, scope , pre-requisites, actual activity and post steps in brief documentation. Why patching of SAPIQ server is required?To patch SAPIQDB server whenever the corresponding HANA DB SPS version is upgraded. For better performance always recommended to update to the latest version as....