pathstring attributes

I recently read an article on pathstring attributes in a dimensional table.

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


I have four levels in my organization.Level 1 ,LEvel2,Level 3,Level 4{in a hierarchy}

Employees charge their amount at any level.Say one charges at level1 and other at level2.

I have been asked to get the total amount charged at each level.{or any level}

How will my Dimensional and fact table would be incorporating the Pathstring attributes.

ANy help would be highly appreciated.

Thanks in advance

You can have 4 different measures per level in the fact table and assign the correct amount to its corresponding level.

Sorry can u explain it with an example?
how di i get the pathstring column in Dimension and how would it be?

You can handle this with a hierarchy bridge table. You create an 'organization unit' dimension which contains all the entities at each level with mutually exclusive primary keys. The fact would contain a FK to the appropriate organization unit. The hierarchy bridge would contain all parent/child relationships at all levels. You query through the bridge to whatever level desired for the query. It's covered in Kimball's DW Toolkit.