Hi all,
I am submitting this Community Post Enhancement Request as this is a feature that many customers have expressed interest in.
It would be very useful to have the ability to bring in an Object Lookup Field (Company, Relationship, User, etc) into a Data Design and be able to report on them as you do in a standard Report Builder based on any other object.
Example:
Selecting Lookup Field from Source in Data Design:

What we would like to see:

What we actually see when we run the Data Design:

Currently, it is not even possible to add the Lookup and Mapping in Data Management to these fields after the Data Design is run because they are created as System fields.
There is currently a workaround for this by adding a Custom Field to the Data Designer object and manually adding the Lookup and Mapping, but that just adds extra work for our admins.
Thanks!