Introduction In this post, I would like to share one of my project experience on performance tuning for Customer developed ABAP program from 38% improvement to 260%+ improvement after implemented SAP HANA SLT side car. I will share some of the techniques for using sap transactions (SCI, SE30, etc) to analyze the performance bottleneck for […]
sap hana
Part 2: SAP Cloud Platform Integration for Data Services (CPI-DS)
This is the second blog post on CPI-DS after the Introduction post. Refer to the Part 1 for configuring Data Services Agent, creation of Datastore and importing Metadata objects. Tasks, Processes, and Projects: Follow the integration development workflow to set up and test moving data to the cloud. Task: A task is a collection of […]
Part 1: SAP Cloud Platform Integration for Data Services (CPI-DS)
Introduction: SAP Cloud Platform Integration for data services allows you to efficiently and securely use ETL (extract, transform, load) tasks to move data between on premise systems and the cloud. SAP Cloud Platform Integration interacts with your local SAP landscape via the SAP Data Services Agent and secure HTTPS and RFC connections. SAP ERP Systems […]
SAP HANA 2.0 on Neo: Database administration using on-premises SAP HANA Cockpit
Objective This blog aims to outline and demonstrate the procedure to connect SAP HANA 2.0 databases running on the SAP Business Technology Platform, Neo environment to an SAP HANA Cockpit 2.0, installed on-premise. The release of this version will also help existing SAP HANA 1.0 databases to be upgraded before the End of Maintenance timeline […]
Implementing attribute view with customer
In this blog, I am sharing basic overview of Implementing attribute view with customer Attribute view: Attribute views are dimensions Attribute views are used to join to a dimension or attribute view. In most cases used to model master data like entities (like product, employee, business partner) Highly re-used and shared in analytic- and calculation […]
What characterises the HANA SQL Data Warehouse?
Introduction As known from many articles and publications, SAP offers three solutions for data warehousing. The SAP Business Warehouse (BW) was first published in 1997 and has therefore been a constant figure in the SAP Data Warehouse range for more than two decades. BW / 4 HANA as a HANA-optimized variant integrates the old ABAP […]
Install ABAP Platform Developer Edition 1909 using VM and SUSE
This post is a guide to install “ABAP Platform Developer Edition 1909” from a VMWare virtual machine and using the LINUX SUSE distribution. Requirements System 4 CPUs 16GB RAM 150GB Disk Tools Environment preparation Preparing the virtual machine We access the VMWare program and go to the option “Create a new virtual machine” We select […]
Anomaly Detection in Time-Series using Seasonal Decomposition in Python Machine Learning Client for SAP HANA
Introduction The detection of anomalies from a given time-series is usually not an easy task. The natural association with time brings many unique features to time-series that regular 1D datasets, like time-dependency(via lagging), trend, seasonality, holiday effects, etc. Because of this, traditional statististical tests or clustering-based methods for anomaly/outlier usually will fail for time-series data, […]
SAP Analytics Cloud Story with HANA Live Connection ABAP Cache Warmer
Next to most current and correct data, performance is another very important factor in analytics. In the blog “How to trace widgets in SAP Analytics Cloud stories connected via HANA Live Data Connection“ ( https://www.erpqna.com/how-to-trace-widgets-in-sap-analytics-cloud-stories-connected-via-hana-live-data-connection/ ) it was already described how to grep performance data and link them to a widget in a SAP Analytics […]
HCL Workload Automation and SAP best performance together
When we need operational efficiency and orchestration in an IT and Business workflows, Workload Automation is the best approach for Enterprise Resource Planning. We see day by day our customers, especially those using SAP to run their critical jobs with specific time constraints and committed deadline. Business jobs must run and must take less time […]