How should we optimally structure "family tree" data?
We have "family tree" style data, for organizations that looks like this.
Parent Company: Chevron Corp
Direct Subsdiaries: Chevron USA, A, B, C, D
Subsidiaries: A1, A2, B1, B2, B3, B4, C1, C2, D
This data is currently in a flat file table. Generally once you hit 5 levels deep we are done. Other data, such as site locations and financial information, can be associated at any level.
We have some flexibility, today, to structure the data in a way that will optimally work with Qlik.
Has anyone encountered this use case before? Are you aware of best practices in terms of the supporting database structure that optimally support connection to BI?
I'm sure we can use drill-down dimensions, but the tricky thing is, we don't always have the same levels of depth as we do in the case of country - state - city. Some organizations will have 1 level, others will have 5.