Pathstring

Data Modeling

Pathstring

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

Tags (1)