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 […]
In a separate blog post, we have discussed the problem of outlier detection using statistical tests. Generally speaking, statistical tests are suitable for detecting outliers that have extreme values in some numerical features. However, outliers are many and varied, and not all kind of outliers can be characterized by extreme values. In many cases for […]
In datasets with multiple features, one typical type of outliers are those corresponding to extreme values in numerical features. In this blog post, we will show how to use statistical tests algorithms in Python machine learning client for SAP HANA(i.e. hana_ml) to detect such outliers. In this blog post, you will learn: Introduction Outliers are […]
High Availability for SAP HANA High Availability is of the utmost importance mostly for production environments. In the case of a potential failure it will ensure that the systems remain accessible and the operations will continue while the issue is being resolved. If an outage occurs, there must be a robust system in place allowing […]
Introduction: With Innovation of new technology and introduction of new tools by different Cloud Providers, I am trying to create a Blog on one of the most critical testing requirement for any SAP Landscape which is System Refresh or System Copy with minimum (zero) downtime with no Business Impact, by using AWS own native tool […]
A new Replication Service is now available in SAP HANA Cockpit as a Service. You can find this application as part of the monitoring view which allows creation and monitoring of replication jobs using Smart Data Integration. You can easily setup a new remote source and database object replication as the UI is a step-by-step […]
This Blog post explains how to automate/integrate HANA snapshot with google cloud storage snapshot. Due to volume data , HANA database size is keep on increasing and traditional online backups i.e. full , differential , incremental takes longer time. Longer running backups use heavy disk io and it impacts HANA operations i.e thread locking , […]
SAP HANA (In fact Any DB which implies with SAP), SAP’s in-memory database system is extremely rich in features and has the capacity to process several terabytes of data without a sweat. As data volumes and size is growing exponentially, customers/corporate ITs are now in various stages of considering migrating to SAP on HANA. While […]
One of the key changes for the Bank Account Management in SAP S/4 HANA has been that Bank Accounts are no longer configured; and are actually treated as master data. This, in turn provides complete lifecycle management and change control for the Bank Accounts to the business user. In this blog post I would talk […]
Why do we need to partition tables in HANA? As HANA can not hold more than 2 billion records per column store table or per partition, any table which has crossed more than 1.5 billion rows are valid candidates of partitioning. It also helps in parallel procession of queries, if they are distributed across nodes […]
