Currently impossible to get a view of data beyond 1 connection. This is forcing me to consider soul crushing hacks thru the API. The amount of heavy lifting required to workaround this limitation is approaching the threshold of building a custom solution.
It is described here in more detail:
http://helpdesk.knackhq.com/support/discussions/topics/5000019100