I think we some how missed the requirement completly. Here the requirement is to show all the dependents not only the child of Owner but also its Supervisor and so on.
@UMAMAHESH I think its a flat file import that we are getting from external system. My suggestion would be get this flat upload into Data Hub and then create hierarchies meaning Owner(L1), Manager(L2), Supervisor(L3) and so on with required attributes.
If you go with this approach then the synchronization will happen automatically. Put your attributes filter at top level and then publish the same to dashboards.
Let me know if you neeed more clarification on the above methodology :).