Anomaly Detection in Time-Series using Seasonal Decomposition in Python Machine Learning Client for SAP HANA

SAP HANA, Machine Learning

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, […]

Continue reading


Merchandise Distribution and ABAP

ABAP Development, MM (Materials Management)

I recently was requested to implement a feature for merchandise distribution in SAP for putaway and cross-docking methods. There are other methods like stock-placement, flow-through, and others however I will concentrate only on the mentioned ones. Merchandise distribution consists in to group the storage transfer orders from plants to the distribution centers and create purchase […]

Continue reading


SAP Cloud Platform Integration- Connecting Microsoft SQL Sever

SAP Cloud Platform Integration Suite, SAP Cloud Platform Integration tools, SAP Process Orchestration

Introduction: JDBC connectivity to On Prem Database Systems-it was long awaited feature in SAP Cloud Platform Integration space. Latest release finally have option to work on it. Lets see how to work on the same. Scenario: Lets consider 3 most used concepts from integration perspective. Setup your SAP Cloud Connector: Follow below tutorial to install […]

Continue reading


SAP Analytics Cloud Story with HANA Live Connection ABAP Cache Warmer

SAP Analytics Cloud, BW (SAP Business Warehouse), SAP HANA

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 […]

Continue reading


HCL Workload Automation and SAP best performance together

SAP HANA, SAP ERP, SAP S/4HANA

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 […]

Continue reading


Identification of Seasonality in Time Series with Python Machine Learning Client for SAP HANA

SAP HANA, SAP HANA Cloud

1. Introduction Seasonality is an important characteristic of a time series and our Python Machine Learning Client for SAP HANA (hana_ml) offers a time series function called seasonal_decompose() which provides a seasonality test and the decomposition the time series into three components: seasonal, trend, and random noise. In this blog post, you will learn: The […]

Continue reading