· Parent child hierarchies are naturally ragged, so which should you choose?
· Depends on the data structures you are reporting on. --> If each hierarchy level is distinct and named, go for level-based with ragged hierarchy option. --> If hierarchy levels are not named or data is stored in RDBMS recursively. Go for parent-child hierarchy.
· Parent child takes more maintenance, so only use if necessary.