Creating a Simple Ragged Hierarchy and Org Chart (Video Tip)

Ragged Hierarchies are pretty cool but often need a bit of effort to structure the data correctly to use them. Here is a video where I show the necessary structure to both set up and use these hierarchies in Dundas BI. Once it’s created, I’ll build an Organization Chart to display employees and their reports.

Also, I don’t think I did a perfect job describing the difference between a standard and ragged hierarchy, as I was trying to be brief.

Here is a better description:
A ragged hierarchy is a user-defined hierarchy with an uneven number of levels, or the depth of the hierarchy varies. For example, if you think of the United States, you have special districts like DC. Your hierarchy might be Country to State to District to City, but others would just be Country to State to City. This is uneven and ragged. A standard or balanced hierarchy would be comprised of nodes and children of equal depth.

If you’d like to learn more, I’d recommend you go to my learning channel - Off the Charts (with Jeff).