“Dimension relationship” refers to the direct or indirect relationships between dimension and its measure groups in a Cube.
|Regular||Refers to a standard relationship, when a Key column in the dimension is directly joined to fact table.|
|Reference||When a Key column in the dimension is indirectly joined to fact table by referencing another dimension.|
|Fact / Degenerate||Dimensions constructed from attribute columns in fact tables than from attribute columns in dimension tables.|
|Many-to-Many||One dimension is associated with multiple facts|
Note: My study notes