Background:
In almost every project, some form of data transformation is required. Most of these transformations are some combination of Aggregation, Projection, Union or Join steps and these transformation can be easily done in the HANA models.
Where possible, It may be a good idea to push the complex transformation to the data acquisition layer using ETL tools like data services.
