This relationship is defined through another referenced relationship. Defining chains of referenced relationships requires ...

This relationship is defined through another referenced relationship. Defining chains of referenced relationships requires that all participating relationships be marked as materialized.  In order to create a valid relationship, check the Materialize option.