Skip to Content
0
Former Member
May 29, 2007 at 11:04 AM

MDM modeling

16 Views

Hi,

I want to create a repository of an organizational structure. My main table will probably be the units in the organizations. There are links between the organizations and I was wondering what would be the best way to do this. The main issues I have are:

1. The units are linked to each other

2. There is a hierarchy between the units

3. The units are not necessarily linked through the lowest level in the hierarchy, meaning that a unit can have children and yet the unit itself needs to be connected to another unit.

4. I tried to build this using relationships but for some reason when I build a relationship that one of its tables is a hierarchy table then when I open the data manager in hierarchy mode and I try to open the hierarchy table the import manager crashes.

I would like to hear ideas what will be the best way to model this situation.

Thanks,

Tal Alon