ORG HIERARCHY-TYPE 2

THis is how my Org Dimension table looks like.This table keeps getting updated like once in two months.As the levels keep changing in an organization or so.I am pretty new to DM and been asked to develop  a ORg Hierarchy Dimension table SO i am lil confused as in where and how to start.Any suggestions will be highly appreciated.

Organization Code
Organization Name
Level 1 Code
Level 1 Description
Level 2 Code
Level 2 Description
Level 3 Code
Level 3 Description
Level 4 Code
Level 4 Description
Level 5 Code
Level 5 Description
Level 6 Code
Level 6 Description
Level 7 Code
Level 7 Description
Level 8 Code
Level 8 Description
Level 9 Code
Level 9 Description
Level 10 Code
Level 10 Description

Thnx

A table design should allow to traversing a hierarchy from higher levels to lower levels of detail. You have a hierarchies of known depth.

The table design you described is an another way to model hierarchy, so why it is not working? You have other options to design hierarchy as self referenced table or use a bridge table. You can read more for those design techniques using below links.

http://www.kimballgroup.com/2009/08/five-alternatives-for-better-employee-dimension-modeling/

http://www.kimballgroup.com/wp-content/uploads/2014/11/Building-the-Hierarchy-Bridge-Table.pdf

Thanks for the inputs.
i went thru the links i am pretty much understanding the concept of Hierarchy.
My question here is say when a new level comes or a When a org change happens where will i handle it.
Would that be in my Dim or Bridge table.
that part is really confusing me.Can you please help me in understanding the same

Thanks

Both. When the hierarchy changes you update the dimensions and re-generate the bridge.

Thanks for all your inputs.I will try to use your thoughts while designing my dim and bridge tables for Org Hierarchy .