Defining Analysis Services Dimensions - SQL Server Analysis Services 2012 Cube Development - page 24

3. The Add Related Tables button automatically adds any tables that have for-
eign key relationships with the tables already in the Included objects list.
4. It is not uncommon to see the Analysis Services project built on top of a rela-
tional database that includes primary and foreign keys. However, referential
integrity adds an overhead while loading data. If you load data from various
sources into fact and dimension tables, you might not want to define table
relationships in SQL Server but rather specify such relationships in the DSV.
5. For this example, select the DimDate (dbo) table from the available objects
list, and click on the right arrow button ( > ) to move it to the included objects
list.
6. Next click on the Add Related Tables button, and you'll see several fact
tables added to the list.