Hi,
The related entity can only be added to the View if there exists a N:1 relationship between your main entity and the related entity; meaning which a lookup field will be there for the related entity.
To add that related entity to the View, you'll need to go to Settings > Customizations > Customize the System > Expand your main entity > Click on Views > Double click the View (in your case being "active sops_homepages") > Click on Add
Columns in the right pane > Select the lookup field for which you want the "hyperlink" to appear.
Once done, save the View and Publish customization.
Admin QuikView Solution for CRM 2013