All Forums Data Modeling
SathyJaanu 1 post Joined 11/15
12 Nov 2015

I recently read an article on pathstring attributes in a dimensional table. 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 must sign in to leave a comment.