pathstring attributes

View previous topic View next topic Go down

pathstring attributes

Post  SathyJaanu on Thu Nov 12, 2015 10:53 am

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

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: pathstring attributes

Post  zoom on Thu Nov 12, 2015 11:13 am

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

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: pathstring attributes

Post  SathyJaanu on Thu Nov 12, 2015 12:21 pm

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

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: pathstring attributes

Post  ngalemmo on Thu Nov 12, 2015 1:44 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: pathstring attributes

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum