Help with ragged multiple hierarchy design
2 posters
Page 1 of 1
Help with ragged multiple hierarchy design
I am trying to design a Telecom Network hierarchy. The elements of hierarchy are Market -> Zip -> Switch -> Tower -> Sector. In some cases a tower can be served by more than 1 switch max 2-3. Also, there are multiple hierarchies in the dimension for e.g. Owing Sector Hierarchy, Coverage Sector Hierarchy basically where the tower sits and where the sector/antennas are beaming. There could be more hierarchies for e.g Finance might want to see the aggregated data in different way. How should I build a hierarchy like this?
1) Should I flatten the hierarchy and include multiple hierarchies using role-plays?
2) Should I use the bridge table? If yes, is it going to be difficult to roll up and could the metrics be double counted in this case? Also, do I need have parent/child name columns for each parent/child realionship in the bridge tables?
3) Should I create multiple tables one for each level and stamp the business keys for each table depending upon what level the data came in. For e.g. Table1: Market/Zip, Table2: Zip/Switch, Table3:Switch/Tower, Table4: Tower/Sector. If the data comes at Secotor level I will stamp business keys for Table1, Table2, Table3 and Table4.
Thanks in advance for you help?
1) Should I flatten the hierarchy and include multiple hierarchies using role-plays?
2) Should I use the bridge table? If yes, is it going to be difficult to roll up and could the metrics be double counted in this case? Also, do I need have parent/child name columns for each parent/child realionship in the bridge tables?
3) Should I create multiple tables one for each level and stamp the business keys for each table depending upon what level the data came in. For e.g. Table1: Market/Zip, Table2: Zip/Switch, Table3:Switch/Tower, Table4: Tower/Sector. If the data comes at Secotor level I will stamp business keys for Table1, Table2, Table3 and Table4.
Thanks in advance for you help?
mahajas- Posts : 5
Join date : 2010-08-14
A Split Percentage??
I believe if we can have the granularity of the fact at the Splitt percentage factor of these combinations while loading fact, we can multiply the factor with fact values to obtain the actual values.
PrasannaGanduri- Posts : 2
Join date : 2013-06-10
Similar topics
» Need help with Bridge Table Design for: 1) Ragged-Hierarchy 2) Parent Nodes can be used more than once.
» Ragged Product Category Hierarchy and Bridge table
» Barely a ragged hierarchy
» Asset Hierarchy in Transmission Utiltiy
» Ragged Hierarchy with Bridge table
» Ragged Product Category Hierarchy and Bridge table
» Barely a ragged hierarchy
» Asset Hierarchy in Transmission Utiltiy
» Ragged Hierarchy with Bridge table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum