A relationship links two tables through a common column, generally a dimension key and the corresponding column of the fact table. It lets a filter placed on the dimension propagate to the facts, without merging the tables.
Example
Relationship Produit[IdProduit] -> Ventes[IdProduit]