Unions versus JOINS in SAP HANA

v  Unions are used to combine the result set of two or more SELECT statements.

v  It's always tempting to JOIN two analytic views when measures from more than

v  one table are required. This should, however, be avoided for performance reasons.

v  It is more beneficial to use a Union in a calculation view. Technically, a Union is not

v  a JOIN types.

Temporal Join in SAP HANA

     A temporal join lets you set time intervals for which you want to fetch records. It indicates the time interval mapping between the master data and the transaction data.

     The temporal join is based on the date field from the fact table and the time interval (to and from fields) from the master data view. The date field from the fact table is called temporal column.

TEXT JOIN in SAP HANA

Text Join is used in order to get language-specific data.

Text Join is used to fetch the description based on user's session language. Once we implement the text join in SAP HANA, it automatically finds out user's language and gives a description in that language.

EXAMPLES:

SCENARIO:

        Create the Material Dimension Calculation View. Use the MARA and MAKT Tables. Bring the Material description and language field along with all fields in MARA table.