In SAP HANA graphical calculation views, the UNION node combines the result sets of its data sources, behaving like a SQL UNION ALL operation. This means that if the same customer name exists in both source tables, it will appear twice in the output of the union node. To remove these duplicates and ensure each customer name appears only once, an AGGREGATION node must be placed above the UNION node. By grouping the data by the customer name column in the aggregation node, the result set is consolidated, effectively producing a distinct list of customer names.

A. Define a restricted column in a union node.

A restricted column is used to filter the data from a source before the union operation occurs, not to deduplicate the combined result set after.

B. Add an intersect node above the union node.

An INTERSECT node returns only the rows that are common to all data sources. This would incorrectly exclude customers that exist in only one of the two tables.

D. In the union node, map both source customer name columns to one target column.

This mapping is a required step to configure the UNION node itself. However, it only combines the data into a single column; it does not perform any deduplication.

1. SAP HANA Cloud

SAP HANA Database Modeling Guide for SAP Business Application Studio

"Create Union Nodes": This guide explains that the union node is used to combine result sets. The standard behavior is to append results

not to automatically remove duplicates. The subsequent step for deduplication is aggregation. (Reference: The concept is foundational to the tool's operation

described in the section on Union nodes).

2. SAP HANA Cloud

SAP HANA Database Modeling Guide for SAP Business Application Studio

"Create Aggregation Nodes": This section details how aggregation nodes are used to summarize or group data. It states

"You can use the aggregation node to summarize data for a group of rows by calculating values in a column." Grouping by the customer name column without applying a specific aggregate function (or using MIN/MAX) on it results in a distinct list. (Reference: Section on Aggregation Node functionality).

3. HA300 - SAP HANA 2.0 SPS07 - Modeling

Unit 4: Calculation Views

Lesson: Using Union Nodes and Lesson: Using Aggregation Nodes. The official SAP courseware demonstrates that a UNION node combines data sources and an AGGREGATION node is subsequently used to group data

which is the standard method for achieving a DISTINCT result on specific columns within the graphical editor.