Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 90

Clicking on the ellipsis button opens the Define Relationship dialog where you spe-
cify a dimension's relationship with the measure group. The following table summar-
izes the types of relationships you can define:

Relationship
Type Explanation and examples

No relation-
ship

This relationship type indicates that the dimension is not related to
the measure group. For example, the Employee dimension is not
related to the Internet sales measure group because customers do
not interact with salespeople while shopping online. If you do at-
tempt querying Internet sales measures based on the Employee di-
mension, you can expect one of two outcomes:

1. Analysis Services will return the same measure values for each
members of the Employee dimension;

2. Analysis Services will return null values for each employee.

Ignore Unrelated Dimensions measure group property controls the
way SSAS treats dimensions with no relationship to the current
measure group. The default value of this property is TRUE , which
produces results outlined with the outcome 1. The other value is
FALSE , which results in the outcome of 2.