NextLytics Blog

CASE in SAP HANA - Control flow for SQLScript Transformation Routines

In this article you will learn how to implement IF ELSE constructs in your SQLScript transformation routine. Actually, there are no IF ELSE statements in SQL SELECT ...
More

How to use text mining and NLP to increase your blog success

The potential of Machine Learning and advanced analytics is not limited to the structured data that can be easily extracted from a database or data warehouse. An even ...
More

How to flag incorrect data records with SQLScript in SAP BW

After we evaluated the possible alternatives in the article "Two options for error handling with SAP BW and SQLScript", we found out that the way via the error stack is ...
More

Apache Airflow ETL - Get inspired by the possibilities

Running ETL workflows with Apache Airflow means relying on state-of-the-art workflow management. It orchestrates recurring processes that organize, manage and move their ...
More

Automatically correct erroneous data records with SQLScript in SAP BW

In the earlier post "Two options for error handling with SAP BW and SQLScript" we looked in detail at the various error handling alternatives. We found out that the DTP ...
More

How to fill the DTP Error Stack with SQLScript in SAP BW

In the previous article, Two options for error handling with SAP BW and SQLScript, we presented the different scenarios of error handling within SAP BW on HANA and ...
More

Two options for error handling with SAP BW and SQLScript

SAP BW loading processes are often terminated due to incorrect data records. To avoid these terminations, appropriate error handling is useful. Basically, there are two ...
More

Apache Airflow Best Practices - Our tips for users

Getting started with the workflow management platform Apache Airflow is easy. Workflows are defined, scheduled and executed with simple Python scripts. The provided web ...
More

Automated Time Series Forecasting using Machine Learning

Forecasts and predictions of future values play an important role in various business areas to make better and more substantiated business decisions. For the ...
More

Success factors and pitfalls in a Machine Learning Project

With an incredible range of applications and rapidly developing frameworks, Machine Learning is a fascinating topic. More and more companies are incorporating this ...
More