Union Node in SAP HANA Calculation Views

A Union Calculation View in SAP HANA is a type of calculation view that combines rows from two or more data sources — such as in-memory and extended (data lake) tables — into a single unified result set. Developers use it to merge datasets that share the same structure, enabling queries to span across different storage tiers or data models transparently. It can also be incorporated into broader data models, as shown in Adding Our Union Calculation View into the Converted Data Model, to serve as a reusable building block within more complex analytical scenarios.

Tutorials that teach this

Prerequisites

Concept SAP HANA Calculation Views A **Calculation View** is a type of SAP HANA data model that allows developers to define complex analytical queries by combining and transforming data from multiple sources, such as tables or other views. Developers use Calculation Views to expose business logic and aggregated data for reporting and analytics, supporting types such as [Dimension and Cube](https://developers.sap.com/tutorials/hana-cloud-calculation-view-cube.html). They can be created graphically in the SAP HANA Modeler perspective and consumed by applications or services, including CAP-based projects and Hibernate-based apps running on SAP HANA.

Union Node in SAP HANA Calculation Views

Tutorials that teach this

Prerequisites

Concepts that build on this

Joule

AI Notice